Install a DataSource in the Java 2 Enterprise Manager (J2EE) Version 1.3

  • Copy the driver archive into the directory $J2EE_HOME/lib/system.
  • Add the driver archive Opta.jar to the classpath of the J2EE. The classpath of J2EE is set with the environment variable J2EE_CLASSPATH (please note: not with CLASSPATH). However, we recommend that you set J2EE_CLASSPATH in the user configuration script. On UNIX the user configuration script is in bin/userconfig.sh, and on Windows it is in binuserconfig.bat.
  • Add the driver (for XA DataSource and non XA DataSource) (for all MS SQL Server drivers)
    • via command line: j2eeadmin -addJdbcDriver com.inet.tds.TdsDriver
    • or add the following lines to your config file resource.properties:
      jdbcDriver.1.name=com.inet.tds.TdsDriver

      (replace 1 with the next free number)

  • Add a XA DataSource (only with i-net OPTA and i-net MERLIA)
    • via command line: j2eeadmin -addJdbcXADataSource {jdbc/XASqlServer} com.inet.tds.DTCDataSource {sa} “{}” -props serverName={YourSQLServerHost} databaseName={YourDatabase}
    • or add the following lines to your config file resource.properties:
      xadatasource.1.name={jdbc/XASqlServer}
      xadatasource.1.classname=com.inet.tds.DTCDataSource
      xadatasource.1.dbuser={sa}
      xadatasource.1.dbpassword={}
      xadatasource.1.prop.databaseName={YourDatabase}
      xadatasource.1.prop.serverName={YourSQLServerHost}

      (replace 1 with the next free number). You will find a list of the properties in the API doc of TdsDataSource, the parent of XDataSource. The setter/getter methods are properties that can be set. (everything within {} is to be replaced by your value including the {}): *** If you can't install the Resource Manager Proxy in the SQL Server then you can use com.inet.tds.XDataSource instead of com.inet.tds.DTCDataSource.

  • Add a DataSource without XA (named JDBC 1 DataSource) (for all our MS SQL Server drivers)
    • via command line: j2eeadmin -addJdbcDataSource {jdbc/SqlServer} jdbc:inetdae7:{YourSQLServerHost}?database={YourDatabase}&user={sa}&password={}
    • or add the following lines to your config file resource.properties:
      jdbcDataSource.5.name={jdbc/SqlServer}
      jdbcDataSource.5.url=jdbc:inetdae7:{YourSQLServerHost}?
      database={YourDatabase}&user={sa}&password={}

      (replace 5 with the next free number)

 

© Copyright 1996 - 2017, i-net software; All Rights Reserved.