package org.eclipse.scout.rt.services.common.jdbc;

import org.eclipse.scout.rt.server.services.common.jdbc.AbstractSqlService;
import org.eclipse.scout.rt.server.services.common.jdbc.style.ISqlStyle;
import org.eclipse.scout.rt.services.common.jdbc.style.JtdsSqlStyle;

public class AbstractJtdsSqlService  extends AbstractSqlService {
	  @Override
	  protected String getConfiguredJdbcDriverName() {
	    return "net.sourceforge.jtds.jdbc.Driver";
	  }
	 
	  @Override
	  protected String getConfiguredJdbcMappingName() {
	    return "jdbc:jtds:<server_type>://<server>[:<port>][/<database>]";
	  }
	  
	  @Override
	  protected Class<? extends ISqlStyle> getConfiguredSqlStyle() {
	    return JtdsSqlStyle.class;
	  }
}

package org.eclipse.scout.rt.services.common.jdbc.style;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import org.eclipse.scout.rt.server.services.common.jdbc.style.AbstractSqlStyle;

public class JtdsSqlStyle extends AbstractSqlStyle {

	/**
	 * 
	 */
	private static final long serialVersionUID = -6139827987362401678L;

	@Override
	public String getConcatOp() {
		return "+";
	}

	@Override
	public String getLikeWildcard() {
		return "%";
	}

	@Override
	protected int getMaxListSize() {
		return 1000;
	}

	@Override
	public boolean isLargeString(String s) {
		return (s.length() > 4000);
	}

	@Override
	public boolean isBlobEnabled() {
		return true;
	}

	@Override
	public boolean isClobEnabled() {
		return true;
	}

	@Override
	public String createDateTimeIsNow(String attribute) {
		return "TRUNC(" + attribute + ", 'MI')=TRUNC(SYSDATE, 'MI')";
	}

	@Override
	public String createDateTimeIsNotNow(String attribute) {
		return "TRUNC(" + attribute + ", 'MI')!=TRUNC(SYSDATE, 'MI')";
	}

	@Override
	public void testConnection(Connection conn) throws SQLException {
		Statement testStatement = null;
		try {
			testStatement = conn.createStatement();
			testStatement.execute("SELECT count(1) FROM dbo.sysobjects");
		} finally {
			if (testStatement != null)
				try {
					testStatement.close();
				} catch (Throwable t) {
				}
		}
	}

}

Manifest-Version: 1.0
Bundle-ManifestVersion: 2
Bundle-Name: Jtds125
Bundle-SymbolicName: org.eclipse.scout.rt.jdbc.jtds125;singleton:=true
Bundle-Version: 1.0.0.qualifier
Bundle-Vendor: Diogo Duarte
Bundle-RequiredExecutionEnvironment: JavaSE-1.6
Bundle-ClassPath: lib/jtds-1.2.5.jar
Require-Bundle: org.eclipse.scout.rt.server;bundle-version="3.7.0",
 org.eclipse.core.runtime;bundle-version="3.5.0"
Eclipse-RegisterBuddy: org.eclipse.scout.rt.server,pt.diogoduarte.wforce.server
Export-Package: net.sourceforge.jtds.jdbc,
 net.sourceforge.jtds.jdbc.cache,
 net.sourceforge.jtds.jdbcx,
 net.sourceforge.jtds.jdbcx.proxy,
 net.sourceforge.jtds.ssl,
 net.sourceforge.jtds.util,
 org.eclipse.scout.rt.services.common.jdbc,
 org.eclipse.scout.rt.services.common.jdbc.style
Bundle-Activator: org.eclipse.scout.jdbc.jtds125.Activator
Bundle-ActivationPolicy: lazy

Require-Bundle: org.eclipse.core.runtime,
 pt.diogoduarte.wforce.shared,
 org.eclipse.scout.rt.server,
 org.eclipse.scout.http.servletfilter,
 org.eclipse.equinox.http.registry,
 org.eclipse.scout.rt.jdbc.jtds125

package pt.diogoduarte.wforce.server.services.common.sql;

import java.sql.Connection;

import org.eclipse.scout.commons.annotations.ConfigOperation;
import org.eclipse.scout.commons.annotations.Order;
import org.eclipse.scout.commons.exception.ProcessingException;
import org.eclipse.scout.rt.server.services.common.jdbc.style.ISqlStyle;
import org.eclipse.scout.rt.services.common.jdbc.AbstractJtdsSqlService;
import org.eclipse.scout.rt.services.common.jdbc.style.JtdsSqlStyle;
import org.eclipse.scout.service.IService2;

public class TesteSqlService extends AbstractJtdsSqlService implements IService2 {

  @Override
  protected String getConfiguredJdbcDriverName() {
    return "net.sourceforge.jtds.jdbc.Driver";
  }

  @Override
  protected String getConfiguredJdbcMappingName() {
    return "jdbc:jtds:sqlserver://sqlserver.scoprolumba.pt:1433/erpscopro";
  }

  @Override
  protected String getConfiguredPassword() {
    return "xxxx";
  }

  @Override
  protected Class<? extends ISqlStyle> getConfiguredSqlStyle() {
    return JtdsSqlStyle.class;
  }

  @Override
  protected String getConfiguredUsername() {
    return "sa";
  }

}