MQSeries.net :: View topic - ICS Ver4.4 and JDBC Adapter 2.6 to iSeries Erros

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » ICS Ver4.4 and JDBC Adapter 2.6 to iSeries Erros

ICS Ver4.4 and JDBC Adapter 2.6 to iSeries Erros

« View previous topic :: View next topic »

Author

Message

nathanw

Posted: Wed Aug 08, 2007 7:21 am Post subject: ICS Ver4.4 and JDBC Adapter 2.6 to iSeries Erros

Knight

Joined: 14 Jul 2004
Posts: 550

We have a ICS implementation

The JDBC Adapter polls the appropriate events table for initialisation

It finds the objects entered therein

It then errors with the following

Code:

com.crossworlds.connectors.JDBC.exceptions.JDBCEventMonitorException:
at com.crossworlds.connectors.JDBC.JDBCEventMonitor.archiveEvent(JDBCEventMonitor.java:576)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.handleEventStatus(JDBCConnectorAgent.java:1491)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConnectorAgent.java:1443)
at AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:584)
at AppSide_Connector.AppCalls.poll(AppCalls.java:192)
at AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObjectManager.java:717)
at AppSide_Connector.AppPolling.poll(AppPolling.java:310)
at AppSide_Connector.AppPolling.doPollingContinuousWait(AppPolling.java:574)
at AppSide_Connector.AppPolling.run(AppPolling.java:137)

Now I know the connection to the iSeries is valid as the ODA works fine and also the fact that the poll for events works correctly so I am assuming when the JDBC Adapter tries to then extract the data associated with the event from the appropriate table, it is failing.

Any help would be appreciated
_________________
Who is General Failure and why is he reading my hard drive?

Artificial Intelligence stands no chance against Natural Stupidity.

Only the User Trace Speaks The Truth

peirod

Posted: Wed Sep 12, 2007 5:08 am Post subject: Access rights to AS/400 file?

Newbie

Joined: 12 Sep 2007
Posts: 2

Hi Nathan,

It looks like the JDBC adapter is detecting the event but it fails when retrieving data from the ASBO-related file, I would start checking the following:
-Access rights to AS/400 file associated to ASBO (can you perform the select using the same JDBC driver and account from plain java class? was it journalled?)
-Check the datatypes for ASBO keys, ODA is not very good detecting the right datatypes from the AS/400 files.

Hope this helps,

David

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » ICS Ver4.4 and JDBC Adapter 2.6 to iSeries Erros

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP