Java Code Examples for net.sourceforge.jtds.jdbcx.JtdsDataSource

The following examples show how to use net.sourceforge.jtds.jdbcx.JtdsDataSource. These examples are extracted from open source projects. 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
/**
 * 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 Project: jTDS   Source File: XaTest.java    License: GNU Lesser General Public License v2.1 5 votes vote down vote up
/**
 * 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
@Override
public Class<? extends DataSource> dataSourceClassName() {
	return JtdsDataSource.class;
}
 
Example 4
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
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 Project: hibernate-master-class   Source File: AbstractTest.java    License: Apache License 2.0 4 votes vote down vote up
@Override
public Class<? extends DataSource> dataSourceClassName() {
    return JtdsDataSource.class;
}
 
Example 7
/**
 * Tests that the public constructor works.
 * <p/>
 * Needed so that this class has at least one test.
 */
public void testPublicConstructor() {
    assertNotNull(new JtdsDataSource());
}