info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Accessing Db2 data on Mainframes
1 view
Skip to first unread message
Suresh.P
Dec 19, 2002, 1:07:57 AM12/19/02
to
Hi,
We need to access the DB2 data on mainframe(MVS) from Weblogic Application
Server (WinNT).
Is it possible using any JDBC drivers? I mean, just by a using single JDBC
driver can we achieve this?
As both platforms are different(WinNT and MVS), don't we need any Gateway in
between apart from
JDBC driver(Like DB2Connect)?
Someone please clarify whether we need DB2Connect or not. Is it possible
with out DB2Connect.
If so, please tell me which JDBC driver would solve our problem.
Thankyou
Suresh.P
Mauro Calendi
Dec 19, 2002, 4:38:15 AM12/19/02
to
I use IBM DB2 JDBC driver upon a Db2 client configuration based on tcp
protocol and it works...
I hope it will work for you too.
Mauro
"Suresh.P" <sures...@yahoo.com> ha scritto nel messaggio
news:atrn8s$4gja$1...@news.boulder.ibm.com...
protocol and it works...
I hope it will work for you too.
Mauro
"Suresh.P" <sures...@yahoo.com> ha scritto nel messaggio
news:atrn8s$4gja$1...@news.boulder.ibm.com...
TURKMAN Bernard (Soft LB)
Dec 19, 2002, 12:35:02 PM12/19/02
to
Hi
I ‘am testing Web Sphere App Server 5.0 trial and I’am using Application Assembly Tool but I have a big problem.
I ' am not working with websphere studio.
I’ am using Oracle9i Enterprise Edition.
I created a web application (jsp + ejb)
I created a DataSource and I tested in a jsp page (using lookup and getConnection ()) and it is working normally.
In my session bean, there is function, which calls an entity finder and it returns the following exception.
70283ccd DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
[12/17/02 17:48:33:449 GMT+02:00] 70283ccd DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(EJSRemoteStatelessWfmOperationFacade_924533cd.java:74)
at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)
at org.apache.jsp._Welcome._jspService(_Welcome.java:101)
---- Begin backtrace for nested exception
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3507)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:456)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.FindAll_LocalForUpdate(Unknown Source)
at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.execute(Unknown Source)
12/18/02 9:48:06:887 GMT+02:00] 2a777b2e ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "findAll". Exception data: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@5f443b3d
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@5f443b3d
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(Unknown Source)
at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)
at org.apache.jsp._Welcome._jspService(_Welcome.java:101)
Where findAll is finder name, WfmOperationHome is entity home interface, WfmOperationFacade is the session remote interface and returnAllOperation (belongs to the session home interface) is the function that I called from the JSP file.
If there is someone who is working on finder method on entity bean (with Oracle 9i), it will be great if he helps me.
Thanks
Bernard.T
Software Engineer
SoftSolutions
I ‘am testing Web Sphere App Server 5.0 trial and I’am using Application Assembly Tool but I have a big problem.
I ' am not working with websphere studio.
I’ am using Oracle9i Enterprise Edition.
I created a web application (jsp + ejb)
I created a DataSource and I tested in a jsp page (using lookup and getConnection ()) and it is working normally.
In my session bean, there is function, which calls an entity finder and it returns the following exception.
70283ccd DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
[12/17/02 17:48:33:449 GMT+02:00] 70283ccd DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@30063cc5
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(EJSRemoteStatelessWfmOperationFacade_924533cd.java:74)
at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)
at org.apache.jsp._Welcome._jspService(_Welcome.java:101)
---- Begin backtrace for nested exception
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3507)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:456)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.FindAll_LocalForUpdate(Unknown Source)
at softsolutions.wfm.operation.entity.websphere_deploy.ORACLE_V8_1.WfmOperationBeanFunctionSet_d5798005.execute(Unknown Source)
12/18/02 9:48:06:887 GMT+02:00] 2a777b2e ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "findAll". Exception data: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@5f443b3d
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@5f443b3d
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at softsolutions.wfm.operation.entity.ConcreteWfmOperation_d5798005.ejbFindAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSCMPWfmOperationHomeBean_d5798005.findAll_Local(Unknown Source)
at softsolutions.wfm.operation.entity.EJSLocalCMPWfmOperationHome_d5798005.findAll(Unknown Source)
at softsolutions.wfm.operation.facade.WfmOperationFacadeBean.returnAllOperation(WfmOperationFacadeBean.java:79)
at softsolutions.wfm.operation.facade.EJSRemoteStatelessWfmOperationFacade_924533cd.returnAllOperation(Unknown Source)
at softsolutions.wfm.operation.facade._WfmOperationFacade_Stub.returnAllOperation(_WfmOperationFacade_Stub.java:335)
at org.apache.jsp._Welcome._jspService(_Welcome.java:101)
Where findAll is finder name, WfmOperationHome is entity home interface, WfmOperationFacade is the session remote interface and returnAllOperation (belongs to the session home interface) is the function that I called from the JSP file.
If there is someone who is working on finder method on entity bean (with Oracle 9i), it will be great if he helps me.
Thanks
Bernard.T
Software Engineer
SoftSolutions
0 new messages