net.sourceforge.jtds.jdbcx.JtdsDataSource Java Examples
The following examples show how to use
net.sourceforge.jtds.jdbcx.JtdsDataSource.
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
| Source File: JtdsDataSourceTest.java From jTDS with GNU Lesser General Public License v2.1 | 6 votes |
|
/**
* 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 ) ) );
}
Example #2
| Source File: XaTest.java From jTDS with GNU Lesser General Public License v2.1 | 5 votes |
|
/**
* 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;
}
Example #3
| Source File: JTDSDataSourceProvider.java From high-performance-java-persistence with Apache License 2.0 | 4 votes |
|
@Override
public Class<? extends DataSource> dataSourceClassName() {
return JtdsDataSource.class;
}
Example #4
| Source File: JtdsObjectFactoryTest.java From jTDS with GNU Lesser General Public License v2.1 | 4 votes |
|
public void testGetterSetter()
throws Exception
{
HashMap defaults = new HashMap();
defaults.put( "description" , "DESCRIPTION" );
defaults.put( Driver.APPNAME , DefaultProperties.APP_NAME );
defaults.put( Driver.AUTOCOMMIT , DefaultProperties.AUTO_COMMIT );
defaults.put( Driver.BATCHSIZE , DefaultProperties.BATCH_SIZE_SQLSERVER );
defaults.put( Driver.BINDADDRESS , DefaultProperties.BIND_ADDRESS );
defaults.put( Driver.BUFFERDIR , DefaultProperties.BUFFER_DIR );
defaults.put( Driver.BUFFERMAXMEMORY , DefaultProperties.BUFFER_MAX_MEMORY );
defaults.put( Driver.BUFFERMINPACKETS , DefaultProperties.BUFFER_MIN_PACKETS );
defaults.put( Driver.CACHEMETA , DefaultProperties.CACHEMETA );
defaults.put( Driver.CHARSET , DefaultProperties.CHARSET );
defaults.put( Driver.DATABASENAME , DefaultProperties.DATABASE_NAME );
defaults.put( Driver.DOMAIN , DefaultProperties.DOMAIN );
defaults.put( Driver.INSTANCE , DefaultProperties.INSTANCE );
defaults.put( Driver.LANGUAGE , DefaultProperties.LANGUAGE );
defaults.put( Driver.LASTUPDATECOUNT , DefaultProperties.LAST_UPDATE_COUNT );
defaults.put( Driver.LOBBUFFER , DefaultProperties.LOB_BUFFER_SIZE );
defaults.put( Driver.LOGFILE , DefaultProperties.LOGFILE );
defaults.put( Driver.LOGINTIMEOUT , DefaultProperties.LOGIN_TIMEOUT );
defaults.put( Driver.MACADDRESS , DefaultProperties.MAC_ADDRESS );
defaults.put( Driver.MAXSTATEMENTS , DefaultProperties.MAX_STATEMENTS );
defaults.put( Driver.NAMEDPIPE , DefaultProperties.NAMED_PIPE );
defaults.put( Driver.PACKETSIZE , DefaultProperties.PACKET_SIZE_42 );
defaults.put( Driver.PASSWORD , DefaultProperties.PASSWORD );
defaults.put( Driver.PORTNUMBER , DefaultProperties.PORT_NUMBER_SQLSERVER );
defaults.put( Driver.PREPARESQL , DefaultProperties.PREPARE_SQLSERVER );
defaults.put( Driver.PROCESSID , DefaultProperties.PROCESS_ID );
defaults.put( Driver.PROGNAME , DefaultProperties.PROG_NAME );
defaults.put( Driver.SENDSTRINGPARAMETERSASUNICODE, DefaultProperties.USE_UNICODE );
defaults.put( Driver.SERVERNAME , "SERVERNAME" );
defaults.put( Driver.SERVERTYPE , String.valueOf( Driver.SQLSERVER ) );
defaults.put( Driver.SOKEEPALIVE , DefaultProperties.SOCKET_KEEPALIVE );
defaults.put( Driver.SOTIMEOUT , DefaultProperties.SOCKET_TIMEOUT );
defaults.put( Driver.SSL , DefaultProperties.SSL );
defaults.put( Driver.TCPNODELAY , DefaultProperties.TCP_NODELAY );
defaults.put( Driver.TDS , DefaultProperties.TDS_VERSION_42 );
defaults.put( Driver.USECURSORS , DefaultProperties.USECURSORS );
defaults.put( Driver.USEJCIFS , DefaultProperties.USEJCIFS );
defaults.put( Driver.USELOBS , DefaultProperties.USELOBS );
defaults.put( Driver.USENTLMV2 , DefaultProperties.USENTLMV2 );
defaults.put( Driver.USEKERBEROS , DefaultProperties.USEKERBEROS );
defaults.put( Driver.USER , DefaultProperties.USER );
defaults.put( Driver.WSID , DefaultProperties.WSID );
defaults.put( Driver.XAEMULATION , DefaultProperties.XAEMULATION );
JtdsObjectFactory jtdsObjectFactory = new JtdsObjectFactory();
// create datasource using default values and check values
JtdsDataSource ds = new JtdsDataSource( defaults );
checkDefaults( ds );
// create datasource from reference and check values
checkDefaults( (JtdsDataSource) jtdsObjectFactory.getObjectInstance( ds.getReference(), null, null, null ) );
// now us setters for modifying all properties and check via getter whether changes are applied
ds.setDescription ( "TEST" ); assertEquals( "TEST", ds.getDescription() );
ds.setAppName ( "TEST" ); assertEquals( "TEST", ds.getAppName() );
ds.setAutoCommit ( false ); assertEquals( false , ds.getAutoCommit() );
ds.setBatchSize ( 123456 ); assertEquals( 123456, ds.getBatchSize() );
ds.setBindAddress ( "1234" ); assertEquals( "1234", ds.getBindAddress() );
ds.setBufferMaxMemory ( 123456 ); assertEquals( 123456, ds.getBufferMaxMemory() );
ds.setBufferMinPackets ( 123456 ); assertEquals( 123456, ds.getBufferMinPackets() );
ds.setCacheMetaData ( true ); assertEquals( true , ds.getCacheMetaData() );
ds.setCharset ( "1234" ); assertEquals( "1234", ds.getCharset() );
ds.setDatabaseName ( "1234" ); assertEquals( "1234", ds.getDatabaseName() );
ds.setDomain ( "1234" ); assertEquals( "1234", ds.getDomain() );
ds.setInstance ( "1234" ); assertEquals( "1234", ds.getInstance() );
ds.setLanguage ( "1234" ); assertEquals( "1234", ds.getLanguage() );
ds.setLastUpdateCount ( false ); assertEquals( false , ds.getLastUpdateCount() );
ds.setLobBuffer ( 123456 ); assertEquals( 123456, ds.getLobBuffer() );
ds.setLogFile ( "1234" ); assertEquals( "1234", ds.getLogFile() );
ds.setLoginTimeout ( 123456 ); assertEquals( 123456, ds.getLoginTimeout() );
ds.setMacAddress ( "1234" ); assertEquals( "1234", ds.getMacAddress() );
ds.setMaxStatements ( 123456 ); assertEquals( 123456, ds.getMaxStatements() );
ds.setNamedPipe ( true ); assertEquals( true , ds.getNamedPipe() );
ds.setPacketSize ( 123456 ); assertEquals( 123456, ds.getPacketSize() );
ds.setPassword ( "1234" ); assertEquals( "1234", ds.getPassword() );
ds.setPortNumber ( 123456 ); assertEquals( 123456, ds.getPortNumber() );
ds.setPrepareSql ( 123456 ); assertEquals( 123456, ds.getPrepareSql() );
ds.setProcessId ( "1234" ); assertEquals( "1234", ds.getProcessId() );
ds.setProgName ( "1234" ); assertEquals( "1234", ds.getProgName() );
ds.setSendStringParametersAsUnicode( false ); assertEquals( false , ds.getSendStringParametersAsUnicode() );
ds.setServerName ( "1234" ); assertEquals( "1234", ds.getServerName() );
ds.setServerType ( 123456 ); assertEquals( 123456, ds.getServerType() );
ds.setSocketKeepAlive ( true ); assertEquals( true , ds.getSocketKeepAlive() );
ds.setSocketTimeout ( 123456 ); assertEquals( 123456, ds.getSocketTimeout() );
ds.setSsl ( "1234" ); assertEquals( "1234", ds.getSsl() );
ds.setTcpNoDelay ( false ); assertEquals( false , ds.getTcpNoDelay() );
ds.setTds ( "1234" ); assertEquals( "1234", ds.getTds() );
ds.setUseCursors ( true ); assertEquals( true , ds.getUseCursors() );
ds.setUseJCIFS ( true ); assertEquals( true , ds.getUseJCIFS() );
ds.setUseLOBs ( false ); assertEquals( false , ds.getUseLOBs() );
ds.setUseNTLMV2 ( true ); assertEquals( true , ds.getUseNTLMV2() );
ds.setUser ( "1234" ); assertEquals( "1234", ds.getUser() );
ds.setWsid ( "1234" ); assertEquals( "1234", ds.getWsid() );
ds.setXaEmulation ( false ); assertEquals( false , ds.getXaEmulation() );
}
Example #5
| Source File: JtdsObjectFactoryTest.java From jTDS with GNU Lesser General Public License v2.1 | 4 votes |
|
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() ) );
}
Example #6
| Source File: AbstractTest.java From hibernate-master-class with Apache License 2.0 | 4 votes |
|
@Override
public Class<? extends DataSource> dataSourceClassName() {
return JtdsDataSource.class;
}
Example #7
| Source File: JtdsDataSourceTest.java From jTDS with GNU Lesser General Public License v2.1 | 2 votes |
|
/**
* Tests that the public constructor works.
* <p/>
* Needed so that this class has at least one test.
*/
public void testPublicConstructor() {
assertNotNull(new JtdsDataSource());
}
