ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Problem in starting JDBC Connector (WAS, DB is Oracle)

Post new topic  Reply to topic
 Problem in starting JDBC Connector (WAS, DB is Oracle) « View previous topic :: View next topic » 
Author Message
shafi
PostPosted: Sun Mar 19, 2006 9:35 pm    Post subject: Problem in starting JDBC Connector (WAS, DB is Oracle) Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38
Hi All,

The errors are as follows. Could anybody help me in resolving it?

62273022)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of confi
guration properties] ]
[Time: 2006/03/20 11:02:13.997] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :UseDefaultsWhenPolling=True]
[Time: 2006/03/20 11:02:13.997] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :QueryTimeOut=False]
[Time: 2006/03/20 11:02:13.997] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :SelectiveCommitForPoll=null]
[Time: 2006/03/20 11:02:13.997] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting Initialization of confi
guration properties] ]
[Time: 2006/03/20 11:02:13.997] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering fetchConnection] ]
[Time: 2006/03/20 11:02:16.221] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Error] [MsgID: 36007] [Mesg: Could not get the connection. Reason java.sql.SQLExce
ption: Io exception: Got minus one from a read call.]
[Time: 2006/03/20 11:02:16.231] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Error] [MsgID: 90006] [Mesg: Problem with the Connection Pool]
[Time: 2006/03/20 11:02:16.231] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2006/03/20 11:02:16.231] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Fatal Error] [MsgID: 17050] [Mesg: The call to method init() in the application co
nnector failed.]
[Time: 2006/03/20 11:02:16.231] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Trace] [Mesg: :getTypeForDeliveryTransport = JMS]
[Time: 2006/03/20 11:02:16.231] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: wbia_main (#12
62273022)] [Type: Fatal Error] [MsgID: 17518] [Mesg: Exhausted the configured number of 3 restart re
tries for serial connector agent JDBCConnector. Shutting down.]
Press any key to continue . . .

Regards,
Shafi

Last edited by shafi on Tue Apr 04, 2006 12:58 am; edited 1 time in total
Back to top
View user's profile Send private message
vk
PostPosted: Mon Mar 20, 2006 7:56 am    Post subject: Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston
Quote:
[Type: Error] [MsgID: 36007] [Mesg: Could not get the connection. Reason java.sql.SQLExce
ption: Io exception: Got minus one from a read call.]


The above error should mean that there are no free database connections available for the connector to connect to the database. The database pool is full. Release existing connections and try again.

Regards,
VK.
Back to top
View user's profile Send private message
shafi
PostPosted: Fri Mar 24, 2006 3:54 am    Post subject: JMS Exception (JDBC adapter, Oracle as DB & WAS as Int b Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38
Hi VK,

thnx for ur suggestions. now that conflict is resolved but the error now I am getting while trying to use VTC is as follows:

"[Time: 2006/03/24 17:13:16.733] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQ
UEUEJmsThreadPool.thread1 (#1268543670)] [Type: Error] [MsgID: 84017] [Mesg: Una
ble to deliver the message to the Queue. Reason: java.lang.ClassCastException: c
om.ibm.jms.JMSBytesMessage]
[Time: 2006/03/24 17:13:16.733] [System: ConnectorAgent] [SS: JDBC] [Thread: JDB
CCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1268543670)] [Type: Trace] [Mesg:
:Fatal error! The fault queue is not available or valid.]
[Time: 2006/03/24 17:13:16.743] [System: ConnectorAgent] [SS: JDBC] [Thread: JDB
CCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1268543670)] [Type: Trace] [Mesg:
:javax.jms.JMSException: java.lang.ClassCastException: com.ibm.jms.JMSBytesMess
age
at CxCommon.Messaging.jms.SecurityProxy.SendProxy.send(SendProxy.java:10
4)
at CxCommon.Messaging.jms.Receiver.processFaultMsg(Receiver.java:1583)
at CxCommon.Messaging.jms.Receiver.access$700(Receiver.java:66)
at CxCommon.Messaging.jms.Receiver$ThreadCallBackImp.callback(Receiver.j
ava:223)
at CxCommon.ThreadingServices.ThreadPoolThread.run(ThreadPoolThread.java
:175)
]
[Time: 2006/03/24 17:13:16.804] [System: ConnectorAgent] [SS: JDBC] [Thread: JDB
CCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1268543670)] [Type: Error] [MsgID
: 9061] [Mesg: Caught JMS error. Reason: javax.jms.JMSException: java.lang.Class
CastException: com.ibm.jms.JMSBytesMessage.]
[Time: 2006/03/24 17:13:16.804] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQ
UEUEJmsThreadPool.thread1 (#1268543670)] [Mesg: [Type: Fatal Error] [MsgID: 1705
6] [Mesg: Failed to establish connection to messaging system.] ]
[Time: 2006/03/24 17:13:16.824] [System: ConnectorAgent] [SS: JDBC] [Thread: JDB
CCONNECTOR/REQUESTQUEUEJmsThreadPool.thread3 (#1269788854)] [Type: Trace] [Mesg:
:Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652e300c214420000501
JMSTimestamp: 1143175366010
JMSCorrelationID:null
JMSDestination: null
JMSReplyTo: null
JMSRedelivered: true
status:-1
resubmitTo:null
description:JMS Message was not of the type (Text, Object) expected. Writing
it to the fault queue.
keys:null
Integer encoding: 2, Floating point encoding 512
3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0d0a

3c51313a666574636820786d6c6e733a51313d22687474703a2f2f7777772e69626d2e636f6d2f77

65627370686572652f63726f7373776f726c64732f323030322f424f536368656d612f6e65777370

222076657273696f6e3d22332e302e302220766572623d2243726561746522206c6f63616c653d22

656e222064656c74613d2266616c7365223e0d0a203c51313a454d505f49443e3c2f51313a454d50

5f49443e0d0a203c51313a454d505f4e414d453e3c2f51313a454d505f4e414d453e0d0a203c5131

3a454d505f53545f414444523e3c2f51313a454d505f53545f414444523e0d0a203c51313a454d50

5f434954593e3c2f51313a454d505f434954593e0d0a203c51313a454d505f53543e3c2f51313a45

4d505f53543e0d0a203c51313a454d505f434f554e5452593e3c2f51313a454d505f434f554e5452

593e0d0a203c51313a454d505f5a49503e3c2f51313a454d505f5a49503e0d0a203c51313a454d50

...
]

C:\IBM\WebSphereAdapters>endlocal

C:\IBM\WebSphereAdapters>pause
Press any key to continue . . ."

Note that I could succesfully run the start connector bat file independently.While using VTC, & when trying thru RFHUtil, I am getting this error.If anybody has come across this error, pls lemme know the actions required.

Regards,
Shafi.
Back to top
View user's profile Send private message
RocknRambo
PostPosted: Fri Mar 24, 2006 9:45 am    Post subject: Reply with quote

Partisan

Joined: 24 Sep 2003
Posts: 355
MsgID: 84017] [Mesg: Unable to deliver the message to the Queue. Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage]

[Time: 2006/03/24 17:13:16.733] [System: ConnectorAgent] [SS: JDBC] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.thread1 (#1268543670)] [Type: Trace] [Mesg:
:Fatal error! The fault queue is not available or valid.]

Thread: JDBCCONNECTOR/REQUESTQ
UEUEJmsThreadPool.thread1 (#1268543670)] [Mesg: [Type: Fatal Error] [MsgID: 1705
6] [Mesg: Failed to establish connection to messaging system.] ]

to which broker are u trying to configure (wmqi/ics/was) ??

-RR
Back to top
View user's profile Send private message
shafi
PostPosted: Sat Mar 25, 2006 2:27 am    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38
RR,

the broker is WAS
Back to top
View user's profile Send private message
goodfellows
PostPosted: Tue Mar 28, 2006 2:36 pm    Post subject: Reply with quote

Newbie

Joined: 22 Sep 2005
Posts: 1
shafi,

if you are using jms as tranportation mode, make sure fault queue is created and set up right
Back to top
View user's profile Send private message
lehare
PostPosted: Wed Apr 05, 2006 5:14 am    Post subject: Reply with quote

Apprentice

Joined: 25 Jul 2005
Posts: 48
shafi,
explain what u trying to impliment then u'l get help quicker,

if you sending message from WBI/WMB to the adapter u must include the RFH2 header in the message e.g for wbi
Code:
SET OutputRoot.MQMD.MsgType = 8;
SET OutputRoot.MQMD.ReplyToQ = 'YOU.RESPONSEQUEUE';
SET OutputRoot.MQRFH2.(MQRFH2.Field)Version = 2;
SET OutputRoot.MQRFH2.(MQRFH2.Field)Format = 'MQSTR ';
SET OutputRoot.MQRFH2.(MQRFH2.Field)NameValueCCSID = 1208;
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Problem in starting JDBC Connector (WAS, DB is Oracle)
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.