|   | 
	 
  
    | 
RSS Feed - WebSphere MQ Support
 | 
RSS Feed - Message Broker Support
 |   
 
  
	     | 
	 | 
   
 
  
	|  JDBC Adapter: The java class is not found | 
	« View previous topic :: View next topic »  | 
   
  
  	
	  
		
		
		  | Author | 
		  Message
		 |  
		
		  | lehare | 
		  
		    
			  
				 Posted: Thu Feb 16, 2006 6:21 am    Post subject: JDBC Adapter: The java class is not found | 
				     | 
			   
			 
		   | 
		 
		
		    Apprentice
 
 Joined: 25 Jul 2005 Posts: 48
  
  | 
		  
		    
			  
				Hi Guys,
 
 
i'm configuring Jdbc adapter but i can't get the start_Fochini.bat to start.
 
 
below is the trace from dos console.
 
 
C:\IBM\WebSphereAdapters>REM @echo off
 
 
C:\IBM\WebSphereAdapters>REM set the name to be the application connector that s
 
tarts
 
 
C:\IBM\WebSphereAdapters>set CONNAME=Fochini
 
 
C:\IBM\WebSphereAdapters>set CONNPACKAGENAME=com.crossworlds.connectors.JDBC.JDB
 
CConnectorAgent
 
 
C:\IBM\WebSphereAdapters>REM Set Connector JAR Name
 
 
C:\IBM\WebSphereAdapters>set CONNJAR=CWFochini.jar
 
 
C:\IBM\WebSphereAdapters>REM set the server name to be the interchange that is b
 
eing targeted
 
 
C:\IBM\WebSphereAdapters>set SERVER=WMQI
 
 
C:\IBM\WebSphereAdapters>REM Set JVMArgs variable
 
 
C:\IBM\WebSphereAdapters>set JVMArgs=
 
 
C:\IBM\WebSphereAdapters>REM if WBIA_RUNTIME is set use start_adapter launcher t
 
o run adapter.
 
 
C:\IBM\WebSphereAdapters>if "C:\IBM\WebSphereAdapters" == "" goto CROSSWORLDS
 
 
C:\IBM\WebSphereAdapters>REM call CWConnEnv
 
 
C:\IBM\WebSphereAdapters>call "C:\IBM\WebSphereAdapters"\bin\CWConnEnv
 
 
C:\IBM\WebSphereAdapters>REM if WBIA_RUNTIME exists, do things the new way, othe
 
rwise use the old way
 
 
C:\IBM\WebSphereAdapters>if "C:\IBM\WebSphereAdapters" == "" goto CROSSWORLDS
 
 
C:\IBM\WebSphereAdapters>REM By default, use the  WBIA.jar under lib. This is th
 
e jar built with the most
 
 
C:\IBM\WebSphereAdapters>REM recent WBIA adapter framework.
 
 
C:\IBM\WebSphereAdapters>set WBIA="C:\IBM\WebSphereAdapters"\lib\WBIA.jar
 
 
C:\IBM\WebSphereAdapters>set JCLASSES=;"C:\IBM\WebSphereAdapters"\lib\WBIA.jar
 
 
C:\IBM\WebSphereAdapters>goto END
 
 
C:\IBM\WebSphereAdapters>REM set the directory where the JText adapter resides.
 
 
 
C:\IBM\WebSphereAdapters>set CONNDIR="C:\IBM\WebSphereAdapters"\connectors\Fochi
 
ni
 
 
C:\IBM\WebSphereAdapters>REM goto the connector specific directory
 
 
C:\IBM\WebSphereAdapters>cd /d "C:\IBM\WebSphereAdapters"\connectors\Fochini
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>REM set the variables that are requi
 
red for the start_adapter callee
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>SET JDBCDRIVERPATH= "C:\IBM\WebSpher
 
eAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\msbase.j
 
ar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\mssqlserver.jar;"C:\IBM\WebSphereAda
 
pters"\lib\mssqljdbc\msutil.jar;"C:\IBM\WebSphereAdapters"\lib\db2java.zip;"C:\I
 
BM\WebSphereAdapters"\lib\db2jcc.jar
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>set DATADIRECT="C:\IBM\WebSphereAdap
 
ters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\IBM\WebSphere
 
Adapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar;"C:
 
\IBM\WebSphereAdapters"\lib\xworacle.jar
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>set JCLASSES=;"C:\IBM\WebSphereAdapt
 
ers"\lib\WBIA.jar; "C:\IBM\WebSphereAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSph
 
ereAdapters"\lib\mssqljdbc\msbase.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\m
 
ssqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\msutil.jar;"C:\IBM\WebSp
 
hereAdapters"\lib\db2java.zip;"C:\IBM\WebSphereAdapters"\lib\db2jcc.jar;"C:\IBM\
 
WebSphereAdapters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\
 
IBM\WebSphereAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\spy\li
 
b\spy.jar;"C:\IBM\WebSphereAdapters"\lib\xworacle.jar;"C:\IBM\WebSphereAdapters"
 
\connectors\Fochini\CWFochini.jar;
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>call "C:\IBM\WebSphereAdapters\bin\s
 
tart_adapter" -nFochiniConnector -sWMQI -lcom.crossworlds.connectors.JDBC.JDBCCo
 
nnectorAgent -cC:\IBM\WebSphereAdapters\connectors\FochiniConnector.cfg
 
The java class is not found:  C:\IBM\WebSphereAdapters\lib\xwsqlserver/jar;C:\IB
 
M\WebSphereAdapters\lib\mssqljdbc\msbase/jar;C:\IBM\WebSphereAdapters\lib\mssqlj
 
dbc\mssqlserver/jar;C:\IBM\WebSphereAdapters\lib\mssqljdbc\msutil/jar;C:\IBM\Web
 
SphereAdapters\lib\db2java/zip;C:\IBM\WebSphereAdapters\lib\db2jcc/jar;C:\IBM\We
 
bSphereAdapters\lib\xwutil/jar;C:\IBM\WebSphereAdapters\lib\xwbase/jar;C:\IBM\We
 
bSphereAdapters\lib\xwsqlserver/jar;C:\IBM\WebSphereAdapters\lib\spy\lib\spy/jar
 
;C:\IBM\WebSphereAdapters\lib\xworacle/jar;C:\IBM\WebSphereAdapters\connectors\F
 
ochini\CWFochini/jar;
 
Press any key to continue . . .
 
 
this is very confusing because the above jars where set as per documentation recommendations.
 
 
any help will be appreciated.
 
 
thanx, lehare. | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | vk | 
		  
		    
			  
				 Posted: Thu Feb 16, 2006 5:41 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   Partisan
 
 Joined: 20 Sep 2005 Posts: 302 Location: Houston 
  | 
		  
		    
			  
				Towards the end of your log, why is all .jar shown as /jar? Have you added the information correclty?
 
 
Regards,
 
VK. | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | lehare | 
		  
		    
			  
				 Posted: Thu Feb 16, 2006 11:22 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Apprentice
 
 Joined: 25 Jul 2005 Posts: 48
  
  | 
		  
		    
			  
				yes i think i have added all the jars correctly if you can check the values of 
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>SET JDBCDRIVERPATH= "C:\IBM\WebSpher
 
eAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\msbase.j
 
ar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\mssqlserver.jar;"C:\IBM\WebSphereAda
 
pters"\lib\mssqljdbc\msutil.jar;"C:\IBM\WebSphereAdapters"\lib\db2java.zip;"C:\I
 
BM\WebSphereAdapters"\lib\db2jcc.jar
 
 
 C:\IBM\WebSphereAdapters\connectors\Fochini>set DATADIRECT="C:\IBM\WebSphereAdap
 
ters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\IBM\WebSphere
 
Adapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar;"C:
 
\IBM\WebSphereAdapters"\lib\xworacle.jar
 
 
C:\IBM\WebSphereAdapters\connectors\Fochini>set JCLASSES=;"C:\IBM\WebSphereAdapt
 
ers"\lib\WBIA.jar; "C:\IBM\WebSphereAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSph
 
ereAdapters"\lib\mssqljdbc\msbase.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\m
 
ssqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\mssqljdbc\msutil.jar;"C:\IBM\WebSp
 
hereAdapters"\lib\db2java.zip;"C:\IBM\WebSphereAdapters"\lib\db2jcc.jar;"C:\IBM\
 
WebSphereAdapters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\
 
IBM\WebSphereAdapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\spy\li
 
b\spy.jar;"C:\IBM\WebSphereAdapters"\lib\xworacle.jar;"C:\IBM\WebSphereAdapters"
 
\connectors\Fochini\CWFochini.jar; 
 
 
the above variables seems to be properly filled out... as for the /jar near the end i think is part of the error message - i don't know if i'm wrong about this...   | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | vennela | 
		  
		    
			  
				 Posted: Fri Feb 17, 2006 12:08 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Jedi Knight
 
 Joined: 11 Aug 2002 Posts: 4055 Location: Hyderabad, India 
  | 
		  
		    
			  
				Somewhere a space is being introduced and that is what is causing the problem. 
 
For example:\Consider the following 2 statements. 
 
java -cp"C:\Program Files\abcd.jar" HelloWorld 
 
 
java -cp C:\Program Files\abcd.jar HelloWorld
 
 
The first one would be fine. 
 
The second one would say java cannot find Files\abcd.jar 
 
Hope this makes sense to you | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | 
		    
		   | 
		 
	   
	 | 
   
 
  
	     | 
	 | 
	Page 1 of 1 | 
   
 
 
 
  
  	
	  
		
		  
 
  | 
		  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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |