| Author |
Message
|
| mqmaniac |
 Posted: Sat Jun 03, 2006 1:15 pm Post subject: Cross Worlds BODesigner Error |
 |
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Hi I am using Crossworlds adapters.
i am using jdbc oda and jdbc conector to build AsBO's.
In the 6 step process of building an ASBO ,I am stuck at step 2 with the following properties..
1. usrname xxxx
2. pwd yyyy
3.Database URL: jdbc:db2://KIRE-RH8RNZ3/ DELTA
4.Database DRiver com.ibm.db2.jdbc.DB2Driver
5.DefaultBO Prefix DELTA
Even though the Buisness Object Designer is unable to connectto the Database for unknown reason..
The ODA Agent only says
"Unable to Establish Connection to Database :Reason "
I am using DB2 8.2 version and crossworlds 2.1 JDBC adapter.
Please help....Thanks in Advance |
|
| Back to top |
|
 |
| vk |
| Posted: Sun Jun 04, 2006 8:13 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
You need to specify the port number for the database along with the machine name and database name.
jdbc:db2://KIRE-RH8RNZ3:50000/DELTA
And I hope you dont have a space before the database name DELTA as seen in your post.
Regards,
VK. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Wed Jun 07, 2006 10:22 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thanks for the Reply Vk ,
Can you pls Guide me where to find the PORT NUMBER...
I did not find this information...
Pls Help ASAP |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Wed Jun 07, 2006 10:28 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Pls Ignore my Previous Message..
I found the Port Number in Step 1 of the Process and Still Its giving me the same Error!!!!!!!!!
The ODA Agent only says
"Unable to Establish Connection to Database :Reason "
1. usrname xxxx
2. pwd yyyy
3.Database URL: jdbc:db2://KIRE-RH8RNZ3:57037/DELTA
4.Database DRiver com.ibm.db2.jdbc.DB2Driver
5.DefaultBO Prefix DELTA
Is there any way to see If the Driver Paths are Correct..
where to look for them..
Pls Help |
|
| Back to top |
|
|
| vk |
| Posted: Wed Jun 07, 2006 8:26 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
The JDBC driver for DB2 8 and above is db2jcc.jar and the driver path is com.ibm.db2.jcc.DB2Driver
Also make sure that the driver location is given correctly in the ODA startup script.
Regards,
VK. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 6:31 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thanks Vk for the Reply...
I have checked the JDBCODAtrace and I get the following Message
" The Specified Driver Class com.ibm.db2.jdbc.DB2Driver could not be found"
Can you Please help me out here as where to look for this driver Class and to which part of the .Bat file to make changes..
This is the .bat file I have
REM set AGENTNAME=JDBCODA
REM set AGENT="%CROSSWORLDS%"\ODA\JDBC\JDBCODA.jar
REM set JCLASSES="%CROSSWORLDS%"\lib\rt.jar;"%CROSSWORLDS%"\lib\vbjorb.jar;"%CROSSWORLDS%"\lib\xwutil.jar;"%CROSSWORLDS%"\lib\xwbase.jar;"%CROSSWORLDS%"\lib\xwsqlserver.jar;"%CROSSWORLDS%"\lib\spy\lib\spy.jar;"%CROSSWORLDS%"\lib\xerces.jar;"%CROSSWORLDS%"\lib\jdom.jar;"%CROSSWORLDS%"\ODA\JDBCODA\JDBCODA.jar;"%CROSSWORLDS%"\lib\CwODK.jar;"%CROSSWORLDS%"\lib\classes12_01.zip;"%CROSSWORLDS%"\lib\CrossWorlds.jar
REM set AGENTCLASS=com.crossworlds.oda.jdbcoda.JDBCOda
setlocal
REM Invoke the CWODAENV.bat
call "%CROSSWORLDS%"\bin\CWODAEnv
set AGENTNAME=JDBCODA
set AGENT="%CROSSWORLDS%"\ODA\JDBC\JDBCODA.jar
set AGENTCLASS=com.crossworlds.oda.jdbcoda.JDBCOda
REM Modify this Driver path to point to the specific driver you want to use.
set DRIVERPATH="%CROSSWORLDS%"\lib\xwutil.jar;"%CROSSWORLDS%"\lib\xwbase.jar;"%CROSSWORLDS%"\lib\xwsqlserver.jar;"%CROSSWORLDS%"\lib\xworacle.jar;"%CROSSWORLDS%"\lib\spy\lib\spy.jar
REM Modify DRIVERLIB path to point to the specific driver dll libraries you want to use.
REM set DRIVERLIB=C:\IBM\WebSphereAdapters\bin\enu_usa
set DRIVERLIB=C:\IBM\WebSphereAdapters\bin\enu_usa
set JCLASSES=%JCLASSES%;%AGENT%;%DRIVERPATH%
set JLIBRARIES="%CROSSWORLDS%"\bin;%DRIVERLIB%
REM Start the Object Discovery Agent
%CWJAVA% -Duser.home="%CROSSWORLDS%" -Djava.library.path=%JLIBRARIES% -mx128m %ORB_DEP% -classpath %JCLASSES% com.crossworlds.ODKInfrastructure.%CONNECTION% -l%AGENTNAME% -c%AGENTCLASS%
endlocal
pause |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 9:26 am Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
I have some more Info. on this...
Even though the
"REM set JCLASSES="%CROSSWORLDS%"\lib\rt.jar;"%CROSSWORLDS%"\lib\vbjorb.jar;
"%CROSSWORLDS%"\lib\xwutil.jar;"%CROSSWORLDS%"\lib\xwbase.jar;"%CROSSWORLDS%"\lib\xwsqlserver.jar;"%CROSSWORLDS%"\lib\spy\lib\spy.jar;"%CROSSWORLDS%"\lib\xerces.jar;"%CROSSWORLDS%"\lib\jdom.jar;"%CROSSWORLDS%"\ODA\JDBCODA\JDBCODA.jar;"%CROSSWORLDS%"\lib\CwODK.jar;"%CROSSWORLDS%"\lib\classes12_01.zip;"%CROSSWORLDS%"\lib\CrossWorlds.jar
REM set AGENTCLASS=com.crossworlds.oda.jdbcoda.JDBCOda "
I do not see the folowing .jar files..Pls Guide Where can i get them..
1.lib\rt.jar
2.vbjorb.jar
3.spy.jar
4.jdom.jar
5.classes12_01.zip
And the Following errors and Trace:
Error 1.
The ODA Agent only says
"Unable to Establish Connection to Database :Reason "
Error 2.
I have checked the JDBCODAtrace and It says
" The Specified Driver Class com.ibm.db2.jdbc.DB2Driver could not be found"
Pls help.. |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Jun 08, 2006 12:55 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I thougth the JDBC driver class was COM.ibm.db2.jdbc.DB2Driver, unless it changed to "com.ibm.db2.jdbc.DB2Driver " with a new release.
_________________
-Ratan |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 3:33 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
hello Ratan..
Thaks for the reply
I have corrected it as
COM.ibm.db2.jdbc.net.DB2Driver
But Is see Javalang.RMI Errors..
Any Idea on what might have caused this.
Is there any website to look for details |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Jun 08, 2006 3:44 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Post your errors here and some body might be able to help.
_________________
-Ratan |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 4:22 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set AGENTNAME=JDBCODA
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set AGENT="C:\IBM\WebSphereAdapters"\ODA\JDBC\JDBCOda.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set JCLASSES="C:\IBM\WebSphereAdapters"\lib\rt.jar;"C:\IBM\WebSphereAdapters"\lib\vbjorb.jar;"C:\IBM\WebSphereAdapters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\IBM\WebSphereAda
pters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar;"C:\IBM\WebSphereAdapters"\lib\xerces.jar;"C:\IBM\WebSphereAdapters"\lib\jdom.jar;"C:\IBM\WebSphereAdapters"\ODA\JDBC\JDBCODA.jar;"C:\IBM\WebSphereAdapters"\lib\
CwODK.jar;"C:\IBM\WebSphereAdapters"\lib\classes12_01.zip;"C:\IBM\WebSphereAdapters"\lib\CrossWorlds.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set AGENTCLASS=com.crossworlds.oda.jdbcoda.JDBCOda
C:\IBM\WebSphereAdapters\ODA\JDBC>setlocal
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Invoke the CWODAENV.bat
C:\IBM\WebSphereAdapters\ODA\JDBC>call "C:\IBM\WebSphereAdapters"\bin\CWODAEnv
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Possible values for CWVERSION are 4.X, 4.1.X, 4.2..
C:\IBM\WebSphereAdapters\ODA\JDBC>set CWVERSION="4.2.2"
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.2.2" call "C:\IBM\WebSphereAdapters\bin\CWSharedEnv.bat
C:\IBM\WebSphereAdapters\ODA\JDBC>goto setenv
C:\IBM\WebSphereAdapters\ODA\JDBC>set ORB_PORT=14500
C:\IBM\WebSphereAdapters\ODA\JDBC>set ORB_HOST=localhost
C:\IBM\WebSphereAdapters\ODA\JDBC>set ORB_PROPERTY=-DORBNamingProvider=CosNaming -Dorg.omg.CORBA.ORBClass=com.ibm.CORBA.iiop.ORB -Dorg.omg.CORBA.ORBInitialPort=14500 -Dorg.omg.CORBA.ORBInitialHost=localhost -Dcom.ibm.CORBA.Debug.Output
=nul
C:\IBM\WebSphereAdapters\ODA\JDBC>set JRE_HOME="C:\IBM\WebSphereAdapters"\jre
C:\IBM\WebSphereAdapters\ODA\JDBC>set JRE_LIB="C:\IBM\WebSphereAdapters"\jre\lib
C:\IBM\WebSphereAdapters\ODA\JDBC>set JRE_BIN="C:\IBM\WebSphereAdapters"\jre\bin
C:\IBM\WebSphereAdapters\ODA\JDBC>set CWJAVA="C:\IBM\WebSphereAdapters\jre\bin\java" -Xbootclasspath/p:"C:\IBM\WebSphereAdapters"\jre\lib\ext\ibmorb.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set CWJAVAW="C:\IBM\WebSphereAdapters\jre\bin\javaw"
C:\IBM\WebSphereAdapters\ODA\JDBC>set JAVA="C:\IBM\WebSphereAdapters"\jre\lib\rt.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set jre part of java.ext.dirs
C:\IBM\WebSphereAdapters\ODA\JDBC>set JRE_EXT_DIRS="C:\IBM\WebSphereAdapters"\jre\lib\ext
C:\IBM\WebSphereAdapters\ODA\JDBC>set PATH="C:\IBM\WebSphereAdapters"\jre\bin;"C:\IBM\WebSphereAdapters"\bin;C:\IBM\WebSphereAdapters\jre\bin\classic;C:\IBM\WebSphereAdapters\bin;C:\IBM\WebSphereAdapters\connectors;C:\PROGRA~1\IBMWEB~1
\BIN\DB2;C:\PROGRA~1\IBMWEB~1\BIN\MQServer;C:\PROGRA~1\IBMWEB~1\BIN;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\Program Files\IBM\WebSphere MQ Integrator 2.1\nnsy\gui;C:\Program Files\IBM\WebSphere MQ Integrator 2.1\nnsy\bin;C:\WINDO
WS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Prog
ram Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\IBM\WebSphere MQ Integrator 2.1\bin;C:\Program Files\Java\jre1.5.0_06\bin
C:\IBM\WebSphereAdapters\ODA\JDBC>set PATH="C:\IBM\WebSphereAdapters"\bin;"C:\IBM\WebSphereAdapters"\jre\bin;"C:\IBM\WebSphereAdapters"\bin;C:\IBM\WebSphereAdapters\jre\bin\classic;C:\IBM\WebSphereAdapters\bin;C:\IBM\WebSphereAdapters\
connectors;C:\PROGRA~1\IBMWEB~1\BIN\DB2;C:\PROGRA~1\IBMWEB~1\BIN\MQServer;C:\PROGRA~1\IBMWEB~1\BIN;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\Program Files\IBM\WebSphere MQ Integrator 2.1\nnsy\gui;C:\Program Files\IBM\WebSphere MQ I
ntegrator 2.1\nnsy\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\QuickTime\QTSystem\;C:\Program Fil
es\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\IBM\WebSphere MQ Integrator 2.1\bin;C:\Progra
m Files\Java\jre1.5.0_06\bin
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set JAVA fore pre-4.2.2 releases.
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.X" set JAVA="C:\IBM\WebSphereAdapters"\lib\rt.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.1.X" set JAVA="C:\IBM\WebSphereAdapters"\lib\rt.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.2" set JAVA="C:\IBM\WebSphereAdapters"\lib\rt.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set CWJAVA for the pre-4.2.2 releases.
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.X" set CWJAVA="C:\IBM\WebSphereAdapters\bin\java"
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.1.X" set CWJAVA="C:\IBM\WebSphereAdapters\bin\java"
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.2" set CWJAVA="C:\IBM\WebSphereAdapters\bin\java"
C:\IBM\WebSphereAdapters\ODA\JDBC>set ODK_LIB="C:\IBM\WebSphereAdapters"\lib\CwODK.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set XML_LIB="C:\IBM\WebSphereAdapters"\lib\xerces.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set CONN_LIB="C:\IBM\WebSphereAdapters"\lib\vbjorb.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set CW_LIB=C:\IBM\WebSphereAdapters\lib\CrossWorlds.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set ORION_LIB=C:\IBM\WebSphereAdapters\lib\cworion.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set WBIA_JAR=C:\IBM\WebSphereAdapters\lib\WBIA.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set CONN_LIB="C:\IBM\WebSphereAdapters"\lib\xrmi.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.X" set CONN_LIB="C:\IBM\WebSphereAdapters"\lib\vbjorb.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.1.X" set CONN_LIB="C:\IBM\WebSphereAdapters"\lib\vbjorb.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Set the CONNECTION to XRmiAgent as the default.
C:\IBM\WebSphereAdapters\ODA\JDBC>REM The Corba connection is supported only for pre-4.2.0 releases.
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set CONNECTION="XRmiAgent"
C:\IBM\WebSphereAdapters\ODA\JDBC>set CONNECTION="XRmiAgent"
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.X" set CONNECTION="IdlAgentFactory"
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.1.X" set CONNECTION="IdlAgentFactory"
C:\IBM\WebSphereAdapters\ODA\JDBC>set SSLJ="C:\IBM\WebSphereAdapters"\lib\sslj.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set CERTJ="C:\IBM\WebSphereAdapters"\lib\certj.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set JSAFE="C:\IBM\WebSphereAdapters"\lib\jsafe.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set JAVA_SECURITY for pre-4.2.2 releases.
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.X" set JAVA_SECURITY="C:\IBM\WebSphereAdapters"\lib\ibmjcefw.jar;"C:\IBM\WebSphereAdapters"\lib\ibmjceprovider.jar;"C:\IBM\WebSphereAdapters"\lib\local_policy.jar;"C:\IBM\WebSphereAdap
ters"\lib\US_export_policy.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.1.X" set JAVA_SECURITY="C:\IBM\WebSphereAdapters"\lib\ibmjcefw.jar;"C:\IBM\WebSphereAdapters"\lib\ibmjceprovider.jar;"C:\IBM\WebSphereAdapters"\lib\local_policy.jar;"C:\IBM\WebSphereAd
apters"\lib\US_export_policy.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "4.2.2" == "4.2" set JAVA_SECURITY="C:\IBM\WebSphereAdapters"\lib\ibmjcefw.jar;"C:\IBM\WebSphereAdapters"\lib\ibmjceprovider.jar;"C:\IBM\WebSphereAdapters"\lib\local_policy.jar;"C:\IBM\WebSphereAdap
ters"\lib\US_export_policy.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set JCLASSES=.;"C:\IBM\WebSphereAdapters"\jre\lib\rt.jar;C:\IBM\WebSphereAdapters\lib\CrossWorlds.jar;"C:\IBM\WebSphereAdapters"\lib\xrmi.jar;"C:\IBM\WebSphereAdapters"\lib\CwODK.jar;"C:\IBM\WebSphereA
dapters"\lib\xerces.jar;"C:\IBM\WebSphereAdapters"\lib\sslj.jar;"C:\IBM\WebSphereAdapters"\lib\certj.jar;"C:\IBM\WebSphereAdapters"\lib\jsafe.jar;;C:\IBM\WebSphereAdapters\lib\cworion.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>if "XRmiAgent" == "IdlAgentFactory" set ORB_DEP=-DORBsyncGC=false -Dorg.omg.CORBA.ORBClass=com.inprise.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.inprise.vbroker.orb.ORBSingleton
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Start the Object Discovery Agent
C:\IBM\WebSphereAdapters\ODA\JDBC>set AGENTNAME=JDBCODA
C:\IBM\WebSphereAdapters\ODA\JDBC>set AGENT="C:\IBM\WebSphereAdapters"\ODA\JDBC\JDBCODA.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set AGENTCLASS=com.crossworlds.oda.jdbcoda.JDBCOda
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Modify this Driver path to point to the specific driver you want to use.
C:\IBM\WebSphereAdapters\ODA\JDBC>set DRIVERPATH="C:\IBM\WebSphereAdapters"\lib\db2java.zip;"C:\IBM\WebSphereAdapters"\lib\db2jcc.jar;"C:\IBM\WebSphereAdapters"\lib\xwutil.jar;"C:\IBM\WebSphereAdapters"\lib\xwbase.jar;"C:\IBM\WebSphere
Adapters"\lib\xwsqlserver.jar;"C:\IBM\WebSphereAdapters"\lib\xworacle.jar;"C:\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Modify DRIVERLIB path to point to the specific driver dll libraries you want to use.
C:\IBM\WebSphereAdapters\ODA\JDBC>REM set DRIVERLIB=C:\Program Files\SQLLIB\bin
C:\IBM\WebSphereAdapters\ODA\JDBC>set DRIVERLIB=
C:\IBM\WebSphereAdapters\ODA\JDBC>set JCLASSES=.;"C:\IBM\WebSphereAdapters"\jre\lib\rt.jar;C:\IBM\WebSphereAdapters\lib\CrossWorlds.jar;"C:\IBM\WebSphereAdapters"\lib\xrmi.jar;"C:\IBM\WebSphereAdapters"\lib\CwODK.jar;"C:\IBM\WebSphereA
dapters"\lib\xerces.jar;"C:\IBM\WebSphereAdapters"\lib\sslj.jar;"C:\IBM\WebSphereAdapters"\lib\certj.jar;"C:\IBM\WebSphereAdapters"\lib\jsafe.jar;;C:\IBM\WebSphereAdapters\lib\cworion.jar;"C:\IBM\WebSphereAdapters"\ODA\JDBC\JDBCODA.jar
;"C:\IBM\WebSphereAdapters"\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\WebSphereA
dapters"\lib\xworacle.jar;"C:\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar
C:\IBM\WebSphereAdapters\ODA\JDBC>set JLIBRARIES="C:\IBM\WebSphereAdapters"\bin;
C:\IBM\WebSphereAdapters\ODA\JDBC>REM Start the Object Discovery Agent
C:\IBM\WebSphereAdapters\ODA\JDBC>"C:\IBM\WebSphereAdapters\jre\bin\java" -Xbootclasspath/p:"C:\IBM\WebSphereAdapters"\jre\lib\ext\ibmorb.jar -Duser.home="C:\IBM\WebSphereAdapters" -Djava.library.path="C:\IBM\WebSphereAdapters"\bin; -m
x128m -classpath .;"C:\IBM\WebSphereAdapters"\jre\lib\rt.jar;C:\IBM\WebSphereAdapters\lib\CrossWorlds.jar;"C:\IBM\WebSphereAdapters"\lib\xrmi.jar;"C:\IBM\WebSphereAdapters"\lib\CwODK.jar;"C:\IBM\WebSphereAdapters"\lib\xerces.jar;"C:\I
BM\WebSphereAdapters"\lib\sslj.jar;"C:\IBM\WebSphereAdapters"\lib\certj.jar;"C:\IBM\WebSphereAdapters"\lib\jsafe.jar;;C:\IBM\WebSphereAdapters\lib\cworion.jar;"C:\IBM\WebSphereAdapters"\ODA\JDBC\JDBCODA.jar;"C:\IBM\WebSphereAdapters"\l
ib\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\xworacle.jar;"C:
\IBM\WebSphereAdapters"\lib\spy\lib\spy.jar com.crossworlds.ODKInfrastructure.XRmiAgent -lJDBCODA -ccom.crossworlds.oda.jdbcoda.JDBCOda
ODK 2.0 is servicing ODA of type "com.crossworlds.oda.jdbcoda.JDBCOda"
Running XRmi 1.0 server on port 57037
Servicing core object "JDBCODA" of type "com.crossworlds.ODKInfrastructure.XRmiAgent"
java.lang.NumberFormatException: ValidDb2jd
at java.lang.Integer.parseInt(Integer.java:423)
at java.lang.Integer.parseInt(Integer.java:472)
at com.ibm.btools.xrmi.XmlIO.readBytes(XmlIO.java:117)
at com.ibm.btools.xrmi.XmlIO.readXmlElement(XmlIO.java:164)
at com.ibm.btools.xrmi.XmlIO.readElement(XmlIO.java:170)
at com.ibm.btools.xrmi.RequestHandler.run(RequestHandler.java:127) |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 4:24 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Sorry for having such a big post..But I am working on it from last 30 hrs to get it done..
Now what I see are these Errors and The BOD is Hung and doing nothing.. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 4:26 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
This is the trace I see
[Time: 2006/06/08 20:21:18.219] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Trace] [Mesg: Entering method init.]
[Time: 2006/06/08 20:21:18.219] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Trace] [Mesg: Initializing JDBCOda version 2.5.0.]
[Time: 2006/06/08 20:21:18.219] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Trace] [Mesg: Entering method DBManager Init.]
[Time: 2006/06/08 20:21:18.219] [System: Object Discovery Agent] [SS: JDBCODA] [Type: Trace] [Mesg: Loading Driver Classes] |
|
| Back to top |
|
|
| vk |
| Posted: Thu Jun 08, 2006 5:41 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
What is the version of you DB2 database?
For version 8 and above, the JDBC driver is db2jcc.jar and the driverpath to be given in start_JDBCODA.sh is
com.ibm.db2.jcc.DB2Driver
I can see db2jcc.jar mention for DRIVERLIB in your trace. For that, the driver path is the one mentioned above.
Regards,
VK. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Jun 08, 2006 5:56 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
I am working on DB2 8.1
BUT...The db2java.zip which is "com.ibm.db2.jcc" does not have DB2Driver
ONLY ..The following have
com.ibm.db2.jdbc.net.DB2Driver com.ibm.db2.jdbc.app.DB2Driver
DB2Driver.class
I did not get this statement of yours
"I can see db2jcc.jar mention for DRIVERLIB in your trace. For that, the driver path is the one mentioned above."
What needs to be changed?? |
|
| Back to top |
|
|
|
|
