| Author | 
		  Message
		 | 
		
		  | shafi | 
		  
		    
			  
				 Posted: Fri Mar 24, 2006 4:17 am    Post subject: JMS Exception while starting JDBC Connector | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vk | 
		  
		    
			  
				 Posted: Fri Mar 24, 2006 5:58 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Kram | 
		  
		    
			  
				 Posted: Fri Mar 24, 2006 6:55 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Sun Mar 26, 2006 10:23 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vk | 
		  
		    
			  
				 Posted: Mon Mar 27, 2006 6:31 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Mon Mar 27, 2006 8:29 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vk | 
		  
		    
			  
				 Posted: Mon Mar 27, 2006 8:57 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Mon Mar 27, 2006 9:32 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Mon Mar 27, 2006 10:47 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vennela | 
		  
		    
			  
				 Posted: Tue Mar 28, 2006 1:53 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Tue Mar 28, 2006 1:59 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vennela | 
		  
		    
			  
				 Posted: Tue Mar 28, 2006 2:07 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | shafi | 
		  
		    
			  
				 Posted: Tue Mar 28, 2006 2:43 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   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 | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |