Hello,
I am trying to setup the data source to connect to an iSeries DB2 database in the WebSphere Development Studio Client (WDSC) v5. I have converted my
Servlets to v2.3 (
J2EE 1.3) and am trying to determine the proper data source settings for the v5
test environment server. My settings for WDSC v4 were:
JDBC driver List:
(Name) AS400JDBCDriver
(Desc) blanks
(Imple) com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
(URL) jdbc
b2
(Class) c:/ � /jt400.jar
Data Source:
(Name) AS400DataSource
(JNDI) jdbc/cmas400
(Desc) blanks
(Category) blanks
(Database) cmas400/cmas400
Resource Property
(Name) serverName
(Type) java.lang.String
(Value) cmas400
In my servlet the code to get the connection is:
Properties parms = new Properties();
parms.put(Context.INITIAL_CONTEXT_FACTORY,
"com.ibm.websphere.naming.WsnInitialContextFactory");
Context context = new InitialContext(parms);
DataSource ds = (DataSource) context.lookup("jdbc/cmas400");
connection = ds.getConnection("<userid>", "<password>");
In WDSC v4 this worked fine, but I can�t determine the proper settings in WDSC v5 to make it work. The execution of the below statement
DataSource ds = (DataSource) context.lookup("jdbc/cmas400");
Results in the below error in the server log: (HELP!)
[5/23/03 9:44:48:906 PDT] 144d8f38 ConnectionFac I J2CA0122I: Resource reference jdbc/cmas400 could not be located, so default values of the following are used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[5/23/03 9:44:49:375 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soTimeout'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'cursorSensitivity'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soLinger'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'behaviorOverride'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'receiveBufferSize'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'serverTraceCategories'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'savePasswordWhenSerialized'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'tcpNoDelay'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'sendBufferSize'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'keepAlive'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'loginTimeout'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'extendedMetaData'.
[5/23/03 9:44:49:516 PDT] 144d8f38 ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource AS400DataSource.
Thanks for your help in advance!
[ May 23, 2003: Message edited by: Reed Peters ]
[ May 27, 2003: Message edited by: Reed Peters ]
