File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes WSAD and data source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WSAD and data source" Watch "WSAD and data source" New topic
Author

WSAD and data source

saravanakumar sundaram
Greenhorn

Joined: May 16, 2001
Posts: 5
Hai,
I have downloaded the WSAD trial version and i created a sample project(EJB) which would use data source to talk to DB2(for the entity beans) which is running in a mainframe machine.
I have created the data source(dats) in the server( with the userid, password working in the db2cca).
I am getting the below exception when i start server(websphere administrative domain).
--------------------
[6/27/02 15:57:48:774 GMT+05:30] 3d7f36d9 Server U Version : 4.0.2
[6/27/02 15:57:48:784 GMT+05:30] 3d7f36d9 Server U Edition: Advanced Single Server Edition for Multiplatforms
[6/27/02 15:57:48:794 GMT+05:30] 3d7f36d9 Server U Build date: Tue Dec 18 00:00:00 GMT+05:30 2001
[6/27/02 15:57:48:794 GMT+05:30] 3d7f36d9 Server U Build number: a0150.05
[6/27/02 15:57:56:946 GMT+05:30] 3d7f36d9 DrAdminServer I WSVR0053I: DrAdmin available on port 7000
[6/27/02 15:57:57:386 GMT+05:30] 3d7f36d9 ResourceBinde I WSVR0049I: Binding Session Persistence datasource as jdbc/Session
[6/27/02 15:57:57:487 GMT+05:30] 3d7f36d9 ResourceBinde I WSVR0049I: Binding datas as jdbc/datas
[6/27/02 15:58:03:956 GMT+05:30] 3d7f36d9 EJBEngine I WSVR0037I: Starting EJB jar: PrototypeEJB
[6/27/02 15:58:12:899 GMT+05:30] 3d7f36d9 ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (datas).
[6/27/02 15:58:13:009 GMT+05:30] 3d7f36d9 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -30,082 and SQLState 08001, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "15" ("PROCESSING FAILURE"). SQLSTATE=08001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:174)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:431)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:432)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:351)
at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(DB2ReusableConnection.java:66)
at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.java:183)
at com.ibm.ejs.cm.pool.ConnectO.<init>(ConnectO.java:99)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:954)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:896)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:814)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:720)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:654)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:307)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
at com.ibm.ejs.persistence.EJSJDBCPersister.initialize(EJSJDBCPersister.java:189)
at com.ibm.ejs.persistence.EJSJDBCPersister.create(EJSJDBCPersister.java:140)
at com.ibm.ws.cpi.JDBCPersisterFactoryImpl.create(JDBCPersisterFactoryImpl.java:91)
at com.ibm.ejs.container.EJSContainer.loadBeanMetaData(EJSContainer.java:800)
at com.ibm.ejs.container.EJSContainer.getHomeInstance(EJSContainer.java:544)
at com.ibm.ejs.container.EJSContainer.startBean(EJSContainer.java:508)
at com.ibm.ws.runtime.BeanHelper.startBean(BeanHelper.java:154)
at com.ibm.ws.runtime.EJBEngine.addEjbModule(EJBEngine.java:437)
at com.ibm.ws.runtime.Server.startModule(Server.java:607)
at com.ibm.ws.runtime.StandardServer.initializeModules(StandardServer.java:321)
at com.ibm.ws.runtime.StandardServer.initializeRuntime0(StandardServer.java:349)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ws.runtime.StandardServer.main(StandardServer.java:519)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
at com.ibm.etools.websphere.tools.runner.api.ServerRunner$1.run(ServerRunner.java)
------------------------
To identify the source of prob,
I have created a sample application(with simple query) to check the data source(using IBM jdk). ALso I have created the data source(datas) from admin console.
It is running quite nicely.
I dont understand what could be the prob.
Can somebody help???
Thanks
Saran
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WSAD and data source