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 » JMS Exception while starting JDBC Connector

Post new topic  Reply to topic
 JMS Exception while starting JDBC Connector « View previous topic :: View next topic » 
Author Message
shafi
PostPosted: Fri Mar 24, 2006 4:17 am    Post subject: JMS Exception while starting JDBC Connector Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi,

I am getting the following error while trying to start JDBC Connector (Oracle is the DB & WAS is the integ broker)using VTC:

"[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 know the solution, pls lemme know the actions required.

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

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Quote:
[Mesg:
:Fatal error! The fault queue is not available or valid.]


Have all the required queues been created in the Queue Manager? Why is the Fault Queue named as JDBCCONNECTOR/REQUESTQUEUE? You need to have 2 separate queues for REQUEST and FAULT.

The connector expects requests from the broker to come in the Request Queue. If any errros are encountered during processing of a request, the message is moved to the Fault Queue.

Quote:
when trying thru RFHUtil, I am getting this error


How do you start the connector using RFHUtil?

Regards,
VK.
Back to top
View user's profile Send private message
Kram
PostPosted: Fri Mar 24, 2006 6:55 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87

Did you run the start connector bat file and VTC from the same box?
_________________
Regards,
Ram
Back to top
View user's profile Send private message
shafi
PostPosted: Sun Mar 26, 2006 10:23 pm    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

TO, VK & Ram

VK,

I've all the following Queues:

JDBCCONNECTOR/ADMININQUEUE
JDBCCONNECTOR/ADMINOUTQUEUE
JDBCCONNECTOR/DELIVERYQUEUE
JDBCCONNECTOR/FAULTQUEUE
JDBCCONNECTOR/REQUESTQUEUE
JDBCCONNECTOR/RESPONSEQUEUE
JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE
JDBCCONNECTOR/SYNCHRONOUSRESPONSEQUEUE
You could note that I've both fault & request queues.

& ofcourse as U've mentioned RFHUtil doesn't come into the picture.
After the successful start of the start connector bat file. While trying to start VTC, I am getting this error message.

& Ram,

I run the start connector bat file thru cmd prompt & start the VTC thru start, pgm, adater tool set, VTC.
Back to top
View user's profile Send private message
vk
PostPosted: Mon Mar 27, 2006 6:31 am    Post subject: Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Have all these queues been defined in the Queue Manager?

Can you send the standard and connector-specific properties from the configuration file?

Regards,
VK.
Back to top
View user's profile Send private message
shafi
PostPosted: Mon Mar 27, 2006 8:29 pm    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi VK,

STD PROPERTIES:

AdapterHelpName
AdminInQueue JDBCCONNECTOR/ADMININQUEUE
AdminOutQueue JDBCCONNECTOR/ADMINOUTQUEUE
AgentTraceLevel 5
ApplicationName JDBCConnector
BrokerType WAS
CharacterEncoding ascii7
CommonEventInfrastructure false
ContainerManagedEvents
DeliveryQueue JDBCCONNECTOR/DELIVERYQUEUE
DeliveryTransport JMS
DuplicateEventElimination false
FaultQueue JDBCCONNECTOR/FAULTQUEUE
jms.FactoryClassName CxCommon.Messaging.jms.IBMMQSeriesFactory
jms.MessageBrokerName WMQIB.Queue.Manager
jms.NumConcurrentRequests 10
jms.Password ********
jms.UserName
Locale en_US
MessageFileName C:\IBM\WebSphereAdapters\connectors\messages\JDBCConnector.txt
PollEndTime HH:MM
PollFrequency no
PollStartTime HH:MM
RepositoryDirectory C:\IBM\WebSphereAdapters\repository
RequestQueue JDBCCONNECTOR/REQUESTQUEUE
ResponseQueue JDBCCONNECTOR/RESPONSEQUEUE
RestartRetryCount 3
RestartRetryInterval 1
RFH2MessageDomain xml
SynchronousRequestQueue JDBCCONNECTOR/SYNCHRONOUSREQUESTQUEUE
SynchronousRequestTimeout 0
SynchronousResponseQueue JDBCCONNECTOR/SYNCHRONOUSRESPONSEQUEUE
TivoliMonitorTransactionPerformance false
WireFormat CwXML
WsifSynchronousRequestTimeout 0
XMLNameSpaceFormat short

SPECIFIC PROPERTIES:

ApplicationPassword admin123
ArchiveProcessed True
ArchiveTableName null
AutoCommit False
CheckForEventTableInInit False
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID NONE
DatabaseURL jdbc:oracle:thin:@9.124.18.87:1521:orcl1
DateFormat MM/dd/yyyy HH:mm:ss
DriverConnectionProperties
MaximumDatabaseConnections 5
PingQuery
PollQuantity 1
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession
RDBMSVendor Oracle
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName system
UniqueIDTableName xworlds_uid
UseDefaults False
UseDefaultsForCreatingChildBOs False
UseDefaultsWhenPolling True
UseDefaultsForRetrieve True
DriverSupportForLong True
EventKeyDel ;
EventOrderBy
EventQueryType Fixed
EventTableName null
JDBCDriverClass oracle.jdbc.driver.OracleDriver
ApplicationUserName system


Also the Queues are defined in the Queue Manager.


The following is the content of the bat file:

start_JDBC.bat JDBC WAS -cC:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg


The following is the content of the BO defn file:

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<xsd:schema elementFormDefault="qualified" targetNamespace="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/fetch" xmlns:bx="http://www.ibm.com/websphere/crossworlds/2002/BOSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><xsd:annotation><xsd:documentation>Tue Mar 28 09:43:42 IST 2006</xsd:documentation></xsd:annotation><xsd:element name="fetch"><xsd:annotation><xsd:appinfo><bx:boDefinition version="3.0.0" /></xsd:appinfo></xsd:annotation><xsd:complexType><xsd:sequence><xsd:element name="Emp_ID" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="true" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_NAME" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ST_ADDR" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_CITY" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ST" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_COUNTRY" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_ZIP" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_PHONE" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_DOB" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" textType="Date" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string" /></xsd:simpleType></xsd:element><xsd:element name="EMP_POSITION" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="EMP_NO" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="true" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="POSITION" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="DATE_HIRE" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" textType="Date" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string" /></xsd:simpleType></xsd:element><xsd:element name="PAY_RATE" type="xsd:int" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation></xsd:element><xsd:element name="EMP_BAND" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="RetrieveSP" minOccurs="0"><xsd:annotation><xsd:appinfo><bx:boAttribute><bx:appSpecificInfo>SPN=P_TEST_ALL;RS=True;IP=P_Emp_ID;P_EMP_NAME;P_EMP_ST_ADDR;P_EMP_CITY;P_EMP_ST; P_EMP_COUNTRY;P_EMP_ZI;P_EMP_PHONE;P_EMP_DOB;P_EMP_POSITION;P_Id;P_POSITION;P_DATE_HIRE;P_PAY_RATE;P_EMP_BAND;OP=RS;</bx:appSpecificInfo><bx:attributeInfo isForeignKey="false" isKey="false" /></bx:boAttribute></xsd:appinfo></xsd:annotation><xsd:simpleType><xsd:restriction base="xsd:string"><xsd:maxLength value="255" /></xsd:restriction></xsd:simpleType></xsd:element><xsd:element name="ObjectEventId" type="xsd:string" minOccurs="0" /></xsd:sequence><xsd:attribute name="version" type="xsd:token" default="0.0.0" /><xsd:attribute name="delta" type="xsd:boolean" default="false" /><xsd:attribute name="locale" type="xsd:string" default="" /><xsd:attribute name="verb" use="required"><xsd:simpleType><xsd:restriction base="xsd:NMTOKEN"><xsd:enumeration value="Create" /><xsd:enumeration value="Delete" /><xsd:enumeration value="Retrieve" /><xsd:enumeration value="Update" /></xsd:restriction></xsd:simpleType></xsd:attribute></xsd:complexType></xsd:element></xsd:schema>

Regards,
Shafi.
Back to top
View user's profile Send private message
vk
PostPosted: Mon Mar 27, 2006 8:57 pm    Post subject: Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

I dont see any issues in the configuration file. But it is better to specify a value for the property ConnectorID. You can set this to JDBCConnector. I think the issue is somewhere in the startup script.

Quote:
start_JDBC.bat JDBC WAS -cC:\IBM\WebSphereAdapters\connectors\JDBC\JDBCConnector.cfg


Aslo the syntax for starting the connector using start_JDBCConnector <ConnectorID> <MessageBrokerName> -c<ConfigFileName>

Change the ConnectorID from JDBC to JDBCConnector and MessageBrokerName from WAS to WMQIB.Queue.Manager. Make sure that the name of the Queue Manager is correct.

Do you have a separate startup script? Have you set the JDBCDRIVERLIB variable within the startup script? Also make sure that the path for the connector JAR file is correct in the startup script.

Check whether the startup script is fine. If you are still facing issues, post the contents of the startup script.

Regards,
VK.
Back to top
View user's profile Send private message
shafi
PostPosted: Mon Mar 27, 2006 9:32 pm    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi VK,

The following is the startup Script:

Please lemme know if any changes required.Meanwhile lemme try the changes with that bat file.
------------------------------------
REM @echo off

REM set the name to be the application connector that starts
set CONNAME=%1
set CONNPACKAGENAME=com.crossworlds.connectors.JDBC.JDBCConnectorAgent

REM Set Connector JAR Name
set CONNJAR=CW%CONNAME%.jar

REM set the server name to be the interchange that is being targeted
set SERVER=%2


REM Set JVMArgs variable
set JVMArgs=

REM if WBIA_RUNTIME is set use start_adapter launcher to run adapter.
if "%WBIA_RUNTIME%"=="" goto CROSSWORLDS



REM call CWConnEnv
call "%WBIA_RUNTIME%"\bin\CWConnEnv

REM set the directory where the JText adapter resides.
set CONNDIR="%WBIA_RUNTIME%"\connectors\%1

REM goto the connector specific directory
cd /d %CONNDIR%

REM set the variables that are required for the start_adapter callee
REM SET JDBCDRIVERPATH=

SET JDBCDRIVERPATH=C:\oracle\product\10.1.0\Db_1\jdbc\lib\classes12.zip
SET LIBPATH=C:\oracle\product\10.1.0\Db_1\BIN

set DATADIRECT="%WBIA_RUNTIME%"\lib\xwutil.jar;"%WBIA_RUNTIME%"\lib\xwbase.jar;"%WBIA_RUNTIME%"\lib\xwsqlserver.jar;"%WBIA_RUNTIME%"\lib\spy\lib\spy.jar;"%WBIA_RUNTIME%"\lib\xworacle.jar

set JCLASSES=%JCLASSES%;%JDBCDRIVERPATH%;%DATADIRECT%;%CONNDIR%\%CONNJAR%;

call "%WBIA_RUNTIME%\bin\start_adapter" -n%CONNAME%Connector -s%SERVER% -l%CONNPACKAGENAME% %3 %4 %5

pause
goto END

REM *****************************************************************************************

REM This is the previous version of starting the connector

:CROSSWORLDS


REM @echo off
call "%CROSSWORLDS%"\bin\CWConnEnv
REM set the directory where the specific connector resides
set CONNDIR="%CROSSWORLDS%"\connectors\%1

REM goto the connector specific drive & directory
cd /d %CONNDIR%

REM set the name to be the application connector that is starting

if exist %CONNDIR%\BIA_%CONNAME%.jar set CONNJAR=BIA_%CONNAME%.jar


REM SET JDBCDRIVERPATH=
set DATADIRECT="%CROSSWORLDS%"\lib\xwutil.jar;"%CROSSWORLDS%"\lib\xwbase.jar;"%CROSSWORLDS%"\lib\xwsqlserver.jar;"%CROSSWORLDS%"\lib\spy\lib\spy.jar;"%CROSSWORLDS%"\lib\xworacle.jar

set JCLASSES=%JCLASSES%;%JDBCDRIVERPATH%;%DATADIRECT%

REM config file location defaults to HOME\InterchangeSystem.cfg on the local machine

REM start the Java connector under the Java Application End

REM -Dbea.home=%CROSSWORLDS% has been removed as it is no longer required
%CWJAVA% -mx128m -ms64m -Djava.ext.dirs="%MQ_LIB%";%JRE_EXT_DIRS% -Djava.library.path="%CROSSWORLDS%"\bin;%CONNDIR%;"%MQ_LIB%";%JRE_EXT_DIRS% %ORB_PROPERTY% -Duser.home="%CROSSWORLDS%" -cp %JCLASSES%;%CONNDIR%\%CONNJAR%; AppEndWrapper -l%CONNPACKAGENAME% -n%CONNAME%Connector -s%SERVER% %3 %4 %5

:END

endlocal

pause

Thanks and Best Regards,
Shafi
Back to top
View user's profile Send private message
shafi
PostPosted: Mon Mar 27, 2006 10:47 pm    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

VK,


I tried the changes with the bat file & got the following error while running it :

[Time: 2006/03/28 12:04:29.054] [System: ConnectorAgent] [SS: JDBCConnectorConnector] [Thread: wbia_
main (#1262073674)] [Type: Error] [MsgID: 17100] [Mesg: Class com.crossworlds.connectors.JDBC.JDBCCo
nnectorAgent not found. Reason: java.lang.ClassNotFoundException: com.crossworlds.connectors.JDBC.JD
BCConnectorAgent]
Press any key to continue . . .

Also please note that even with the previous bat file, I could run successfully. The error comes only while using VTC, which is

"[Mesg: Failed to establish connection to messaging system"

Can the BO play a part in getting this error?

- Regards,
Shafi.
Back to top
View user's profile Send private message
vennela
PostPosted: Tue Mar 28, 2006 1:53 am    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

Have you installed the adapter framework
What do you get when you do
Quote:
echo %CROSSWORLDS%
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shafi
PostPosted: Tue Mar 28, 2006 1:59 am    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

Hi vennela,

I've installed Adapter framework. I use the tools like conn cfgrator, BO designer, vtc ect from it.

& when I executed the command :

C:\IBM\WebSphereAdapters\connectors\JDBC>echo %CROSSWORLDS%
C:\IBM\WebSphereAdapters

C:\IBM\WebSphereAdapters\connectors\JDBC>

the above happened.

Regards,
Shafi.
Back to top
View user's profile Send private message
vennela
PostPosted: Tue Mar 28, 2006 2:07 am    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

Quote:
Can the BO play a part in getting this error?

NO

NoClassDefFoundError is always CLASSPATH issue.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
shafi
PostPosted: Tue Mar 28, 2006 2:43 am    Post subject: Reply with quote

Apprentice

Joined: 19 Mar 2006
Posts: 38

But the error which I am getting looks like some issue with the MQ? The error is given below.

[Time: 2006/03/28 15:25:10.929] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1249074887)] [Type: Error] [MsgID: 9064] [Mesg: Message received
is not of the type (Text, Object) expected for the current encryption settings. Message ID: ID:414d
5120574d5149422e51756575652e23d4284420000301]
[Time: 2006/03/28 15:25:10.929] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1248616135)] [Type: Error] [MsgID: 9064] [Mesg: Message received
is not of the type (Text, Object) expected for the current encryption settings. Message ID: ID:414d
5120574d5149422e51756575652e23d4284420000401]
[Time: 2006/03/28 15:25:10.959] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1248616135)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652e23d4284420000401
JMSTimestamp: 1143528503600
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 queu
e.
keys:null
Integer encoding: 2, Floating point encoding 512
3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0d0a
3c51313a66657463682020786d6c6e733a51313d22687474703a2f2f7777772e69626d2e636f6d2f
7765627370686572652f63726f7373776f726c64732f323030322f424f536368656d612f66657463
68222076657273696f6e3d22332e302e302220766572623d2243726561746522206c6f63616c653d
22656e222064656c74613d2266616c7365223e0d0a203c51313a456d705f49443e3c2f51313a456d
705f49443e0d0a203c51313a454d505f4e414d453e3c2f51313a454d505f4e414d453e0d0a203c51
313a454d505f53545f414444523e3c2f51313a454d505f53545f414444523e0d0a203c51313a454d
505f434954593e3c2f51313a454d505f434954593e0d0a203c51313a454d505f53543e3c2f51313a
454d505f53543e0d0a203c51313a454d505f434f554e5452593e3c2f51313a454d505f434f554e54
52593e0d0a203c51313a454d505f5a49503e3c2f51313a454d505f5a49503e0d0a203c51313a454d
...
]
[Time: 2006/03/28 15:25:10.959] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read3 (#1248616135)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the message to the Queue.
Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage]
[Time: 2006/03/28 15:25:10.959] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1248616135)] [Type: Trace] [Mesg: :Fatal error! The fault queue
is not available or valid.]
[Time: 2006/03/28 15:25:10.969] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1248616135)] [Type: Trace] [Mesg: :javax.jms.JMSException: java.
lang.ClassCastException: com.ibm.jms.JMSBytesMessage
at CxCommon.Messaging.jms.SecurityProxy.SendProxy.send(SendProxy.java:104)
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.java:223)
at CxCommon.ThreadingServices.ThreadPoolThread.run(ThreadPoolThread.java:175)
]
[Time: 2006/03/28 15:25:10.969] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread3 (#1248616135)] [Type: Error] [MsgID: 9061] [Mesg: Caught JMS error
. Reason: javax.jms.JMSException: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage.]
[Time: 2006/03/28 15:25:10.969] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read3 (#1248616135)] [Mesg: [Type: Fatal Error] [MsgID: 17056] [Mesg: Failed to establish connection
to messaging system.] ]
[Time: 2006/03/28 15:25:10.979] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1249074887)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_bytes
JMSType: null
JMSDeliveryMode: 1
JMSExpiration: 0
JMSPriority: 0
JMSMessageID: ID:414d5120574d5149422e51756575652e23d4284420000301
JMSTimestamp: 1143527536830
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 queu
e.
keys:null
Integer encoding: 2, Floating point encoding 512
3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0d0a
3c51313a66657463682020786d6c6e733a51313d22687474703a2f2f7777772e69626d2e636f6d2f
7765627370686572652f63726f7373776f726c64732f323030322f424f536368656d612f66657463
68222076657273696f6e3d22332e302e302220766572623d2243726561746522206c6f63616c653d
22656e222064656c74613d2266616c7365223e0d0a203c51313a456d705f49443e3c2f51313a456d
705f49443e0d0a203c51313a454d505f4e414d453e3c2f51313a454d505f4e414d453e0d0a203c51
313a454d505f53545f414444523e3c2f51313a454d505f53545f414444523e0d0a203c51313a454d
505f434954593e3c2f51313a454d505f434954593e0d0a203c51313a454d505f53543e3c2f51313a
454d505f53543e0d0a203c51313a454d505f434f554e5452593e3c2f51313a454d505f434f554e54
52593e0d0a203c51313a454d505f5a49503e3c2f51313a454d505f5a49503e0d0a203c51313a454d
...
]
[Time: 2006/03/28 15:25:11.200] [System: Server] [Thread: JDBCCONNECTOR/REQUESTQUEUEJmsThreadPool.th
read1 (#1249074887)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the message to the Queue.
Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage]
[Time: 2006/03/28 15:25:11.200] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1249074887)] [Type: Trace] [Mesg: :Fatal error! The fault queue
is not available or valid.]
[Time: 2006/03/28 15:25:11.200] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1249074887)] [Type: Trace] [Mesg: :javax.jms.JMSException: java.
lang.ClassCastException: com.ibm.jms.JMSBytesMessage
at CxCommon.Messaging.jms.SecurityProxy.SendProxy.send(SendProxy.java:104)
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.java:223)
at CxCommon.ThreadingServices.ThreadPoolThread.run(ThreadPoolThread.java:175)
]
[Time: 2006/03/28 15:25:11.200] [System: ConnectorAgent] [SS: JDBCConnector] [Thread: JDBCCONNECTOR/
REQUESTQUEUEJmsThreadPool.thread1 (#1249074887)] [Type: Error] [MsgID: 9061] [Mesg: Caught JMS error
. Reason: javax.jms.JMSException: java.lang.ClassCastException: com.ibm.jms.JMSBytesMessage.]
Press any key to continue . . .
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 » JMS Exception while starting JDBC Connector
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.