本文整理汇总了Java中net.sourceforge.jtds.jdbcx.JtdsDataSource类的典型用法代码示例。如果您正苦于以下问题:Java JtdsDataSource类的具体用法?Java JtdsDataSource怎么用?Java JtdsDataSource使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
JtdsDataSource类属于net.sourceforge.jtds.jdbcx包,在下文中一共展示了JtdsDataSource类的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: testAddNonNullProperties
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* ensure only non-null properties are added
*/
public void testAddNonNullProperties()
throws Exception
{
JtdsDataSource dataSource = new JtdsDataSource();
dataSource.setServerName("non-null-value");
dataSource.setDescription( null );
dataSource.setCharset( null );
Properties props = new Properties();
Method m = JtdsDataSource.class.getDeclaredMethod( "addNonNullProperties", new Class[] {Properties.class, String.class, String.class} );
m.setAccessible( true );
m.invoke( dataSource, props, "user", null );
assertEquals( 2, props.size() );
assertEquals( "non-null-value", props.getProperty( Messages.get( Driver.SERVERNAME ) ) );
assertEquals( "user", props.getProperty( Messages.get( Driver.USER ) ) );
}
示例2: getDataSource
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* Obtain an XADataSource.
*
* @return the <code>XADataSource.
* @throws SQLException if an error condition occurs
*/
public XADataSource getDataSource() throws SQLException {
JtdsDataSource xaDS = new JtdsDataSource();
String user = props.getProperty(Messages.get(Driver.USER));
String pwd = props.getProperty(Messages.get(Driver.PASSWORD));
String host = props.getProperty(Messages.get(Driver.SERVERNAME));
String port = props.getProperty(Messages.get(Driver.PORTNUMBER));
String database = props.getProperty(Messages.get(Driver.DATABASENAME));
String xaMode = props.getProperty(Messages.get(Driver.XAEMULATION));
String tds = props.getProperty(Messages.get(Driver.TDS));
String serverType = props.getProperty(Messages.get(Driver.SERVERTYPE));
int portn;
try {
portn = Integer.parseInt(port);
} catch (NumberFormatException e) {
portn = 1433;
}
xaDS.setServerName(host);
xaDS.setPortNumber(portn);
xaDS.setUser(user);
xaDS.setPassword(pwd);
xaDS.setDatabaseName(database);
xaDS.setXaEmulation(xaMode.equalsIgnoreCase("true"));
xaDS.setTds(tds);
xaDS.setServerType("2".equals(serverType)? 2: 1);
return xaDS;
}
示例3: initialSetup
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
public void initialSetup(String rootUser, String rootPass, String rootDb)
{
// Set up the root data source
JtdsDataSource rootSource = new JtdsDataSource();
rootSource.setServerName(DatabaseProperties.getServerName());
rootSource.setPortNumber(DatabaseProperties.getPort());
rootSource.setDatabaseName(rootDb);
rootSource.setUser(rootUser);
rootSource.setPassword(rootPass);
this.rootDataSource = rootSource;
LinkedList<String> statements = new LinkedList<String>();
String dbName = DatabaseProperties.getDatabaseName();
this.dropUser();
this.dropDb();
this.createDb(rootDb);
this.createUser();
statements.clear();
statements.add("USE " + dbName);
statements.add("EXEC sp_dbcmptlevel "+dbName+", 80");
executeAsRoot(statements, true);
}
示例4: createJdbcDataSource
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* Instantiating a {@link JtdsDataSource} and setting its configuration.
*
* @param props
* The configuration of the datasource.
* @return The new datasource instance.
*/
protected JtdsDataSource createJdbcDataSource(final Properties props) {
JtdsDataSource dataSource = new JtdsDataSource();
String serverName = props.getProperty(JDBC_SERVER_NAME);
String portNumber = props.getProperty(JDBC_PORT_NUMBER);
String databaseName = props.getProperty(JDBC_DATABASE_NAME);
String user = props.getProperty(JDBC_USER);
String password = props.getProperty(JDBC_PASSWORD);
if (databaseName != null) {
dataSource.setDatabaseName(databaseName);
}
if (portNumber != null) {
Integer portNumberInt = Integer.parseInt(portNumber);
dataSource.setPortNumber(portNumberInt);
}
if (serverName != null) {
dataSource.setServerName(serverName);
}
if (user != null) {
dataSource.setUser(user);
}
if (password != null) {
dataSource.setPassword(password);
}
return dataSource;
}
示例5: dataSourceClassName
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
@Override
public Class<? extends DataSource> dataSourceClassName() {
return JtdsDataSource.class;
}
示例6: checkDefaults
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
private void checkDefaults( JtdsDataSource ds )
{
assertEquals( "DESCRIPTION" , String.valueOf( ds.getDescription() ) );
assertEquals( DefaultProperties.APP_NAME , String.valueOf( ds.getAppName() ) );
assertEquals( DefaultProperties.AUTO_COMMIT , String.valueOf( ds.getAutoCommit() ) );
assertEquals( DefaultProperties.BATCH_SIZE_SQLSERVER , String.valueOf( ds.getBatchSize() ) );
assertEquals( DefaultProperties.BIND_ADDRESS , String.valueOf( ds.getBindAddress() ) );
assertEquals( DefaultProperties.BUFFER_MAX_MEMORY , String.valueOf( ds.getBufferMaxMemory() ) );
assertEquals( DefaultProperties.BUFFER_MIN_PACKETS , String.valueOf( ds.getBufferMinPackets() ) );
assertEquals( DefaultProperties.CACHEMETA , String.valueOf( ds.getCacheMetaData() ) );
assertEquals( DefaultProperties.CHARSET , String.valueOf( ds.getCharset() ) );
assertEquals( DefaultProperties.DATABASE_NAME , String.valueOf( ds.getDatabaseName() ) );
assertEquals( DefaultProperties.DOMAIN , String.valueOf( ds.getDomain() ) );
assertEquals( DefaultProperties.INSTANCE , String.valueOf( ds.getInstance() ) );
assertEquals( DefaultProperties.LANGUAGE , String.valueOf( ds.getLanguage() ) );
assertEquals( DefaultProperties.LAST_UPDATE_COUNT , String.valueOf( ds.getLastUpdateCount() ) );
assertEquals( DefaultProperties.LOB_BUFFER_SIZE , String.valueOf( ds.getLobBuffer() ) );
assertEquals( DefaultProperties.LOGFILE , String.valueOf( ds.getLogFile() ) );
assertEquals( DefaultProperties.LOGIN_TIMEOUT , String.valueOf( ds.getLoginTimeout() ) );
assertEquals( DefaultProperties.MAC_ADDRESS , String.valueOf( ds.getMacAddress() ) );
assertEquals( DefaultProperties.MAX_STATEMENTS , String.valueOf( ds.getMaxStatements() ) );
assertEquals( DefaultProperties.NAMED_PIPE , String.valueOf( ds.getNamedPipe() ) );
assertEquals( DefaultProperties.PACKET_SIZE_42 , String.valueOf( ds.getPacketSize() ) );
assertEquals( DefaultProperties.PASSWORD , String.valueOf( ds.getPassword() ) );
assertEquals( DefaultProperties.PORT_NUMBER_SQLSERVER, String.valueOf( ds.getPortNumber() ) );
assertEquals( DefaultProperties.PREPARE_SQLSERVER , String.valueOf( ds.getPrepareSql() ) );
assertEquals( DefaultProperties.PROCESS_ID , String.valueOf( ds.getProcessId() ) );
assertEquals( DefaultProperties.PROG_NAME , String.valueOf( ds.getProgName() ) );
assertEquals( DefaultProperties.USE_UNICODE , String.valueOf( ds.getSendStringParametersAsUnicode() ) );
assertEquals( "SERVERNAME" , String.valueOf( ds.getServerName() ) );
assertEquals( String.valueOf( Driver.SQLSERVER ) , String.valueOf( ds.getServerType() ) );
assertEquals( DefaultProperties.SOCKET_KEEPALIVE , String.valueOf( ds.getSocketKeepAlive() ) );
assertEquals( DefaultProperties.SOCKET_TIMEOUT , String.valueOf( ds.getSocketTimeout() ) );
assertEquals( DefaultProperties.SSL , String.valueOf( ds.getSsl() ) );
assertEquals( DefaultProperties.TCP_NODELAY , String.valueOf( ds.getTcpNoDelay() ) );
assertEquals( DefaultProperties.TDS_VERSION_42 , String.valueOf( ds.getTds() ) );
assertEquals( DefaultProperties.USECURSORS , String.valueOf( ds.getUseCursors() ) );
assertEquals( DefaultProperties.USEJCIFS , String.valueOf( ds.getUseJCIFS() ) );
assertEquals( DefaultProperties.USELOBS , String.valueOf( ds.getUseLOBs() ) );
assertEquals( DefaultProperties.USENTLMV2 , String.valueOf( ds.getUseNTLMV2() ) );
assertEquals( DefaultProperties.USER , String.valueOf( ds.getUser() ) );
assertEquals( DefaultProperties.WSID , String.valueOf( ds.getWsid() ) );
assertEquals( DefaultProperties.XAEMULATION , String.valueOf( ds.getXaEmulation() ) );
}
示例7: dataSourceClassName
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
@Override
public Class<? extends DataSource> dataSourceClassName() {
return JtdsDataSource.class;
}
示例8: SQLServer
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* Initializes datasource to point to SQL Server
*/
@Inject
public SQLServer()
{
super();
this.nextSequenceNumberLock = new ReentrantLock();
this.objectSequenceTableName = "object_seq_table";
this.transactionSequenceTableName = "transaction_seq_table";
// The container is not providing a pooled datasource
if (this.dataSource == null)
{
JtdsDataSource serverDataSource = new JtdsDataSource();
serverDataSource.setServerName(DatabaseProperties.getServerName());
serverDataSource.setPortNumber(DatabaseProperties.getPort());
serverDataSource.setDatabaseName(DatabaseProperties.getDatabaseName());
serverDataSource.setUser(DatabaseProperties.getUser());
serverDataSource.setPassword(DatabaseProperties.getPassword());
int maxDbConnections = DatabaseProperties.getMaxConnections() - 1;
if (maxDbConnections < 2)
{
maxDbConnections = 2;
}
boolean pooling = DatabaseProperties.getConnectionPooling();
if (pooling)
{
SharedPoolDataSource sharedPoolDataSource = new SharedPoolDataSource();
sharedPoolDataSource.setConnectionPoolDataSource(serverDataSource);
sharedPoolDataSource.setMaxActive(maxDbConnections);
sharedPoolDataSource.setTestOnBorrow(true);
sharedPoolDataSource.setValidationQuery("SELECT 1");
this.dataSource = sharedPoolDataSource;
}
else
{
this.dataSource = serverDataSource;
}
}
}
示例9: testPublicConstructor
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* Tests that the public constructor works.
* <p/>
* Needed so that this class has at least one test.
*/
public void testPublicConstructor() {
assertNotNull(new JtdsDataSource());
}
示例10: createJDBCDataSource
import net.sourceforge.jtds.jdbcx.JtdsDataSource; //导入依赖的package包/类
/**
* createJDBCDataSource.
*
* @return datasource
*/
public final DataSource createJDBCDataSource() {
return new JtdsDataSource();
}