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/, 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

      (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{jdbc/XASqlServer}

      (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{jdbc/SqlServer}

      (replace 5 with the next free number)


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