• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

WSAD and data source

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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'm full of tinier men! And a tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic