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

  • Copy the driver archive into the directory $J2EE_HOME/lib.
  • Open the Admin Console
  • Select the node JDBC / Connection Pooling
  • Click on the new Button
  • In the wizard that pops up enter the following information and save it:
  DataSource XADataSource
Step 1) Enter connection pool NameName: SqlServer
Classname:* com.inet.tds.TdsDataSource
Name: SqlServer
Classname: com.inet.tds.DTCDataSource
Step 2) Enter resource type.Resource Type: javax.sql.DataSource
Description: Local MS SQL Server
Resource Type: javax.sql.XADataSource
Description: Local MS SQL Server
Step 3) Specify pool settings.default settingsdefault settings
Step 4) Specify general settings.default settingsdefault settings
Step 5) Add properties.ServerName: LocalHost
DatabaseName: master
User: any
Password: any
ServerName: LocalHost
DatabaseName: master
User: any
Password: any
  • Select the node JDBC / Connection Pooling / SqlServer (or the name that you use for the datasource) Click the “Ping” button to verify that your connection settings are valid.
    If an error occurs then look in the server.log for the underlying error. The ping command and the admin console does not work with an empty password. If you need an empty password then you can enter a password and change it to empty in the domain.xml file.
  • Add a new JDBC Resource
 

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