| Author |
Message
|
| mqmaniac |
 Posted: Thu Jun 08, 2006 5:59 pm Post subject: |
 |
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Where should i search for db2jcc.jar file and
Where should i include the Drier Path..
and Can you tell me what would be th Driver Path(Default) |
|
| Back to top |
|
 |
| Ratan |
| Posted: Mon Jun 12, 2006 10:43 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Is this path to the db2 libraries correct in your adapter batch file:
C:\IBM\WebSphereAdapters"\lib\db2java.zip
usually it is C:\....\IBM\SQLLIB\LIB\db2java.zip unless you have copied it to the above path.
_________________
-Ratan |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Mon Jun 12, 2006 1:00 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
yes Ratan,
Thats what I have given as DRIVER LIB....
If Possible..Pls Clarify
What is the Differenece between these two statements..
1. REM set JCLASSES="XXXXXXXXXXXXX"
2.AGENTCLASS="com.crossworlds.oda.jdbcoda.JDBCOda "
AND
1. set DRIVERPATH="XXXXXXXXXXXXXXXX"
2.REM set DRIVERLIB=C:\IBM\WebSphereAdapters\bin\enu_usa
Pls Help |
|
| Back to top |
|
|
| Ratan |
| Posted: Mon Jun 12, 2006 1:03 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
REM is a remark (Comment ) in batch files.
_________________
-Ratan |
|
| Back to top |
|
|
| reksmq |
| Posted: Tue Jun 27, 2006 4:26 pm Post subject: JDBC ASBO creation error |
|
|
Newbie
Joined: 27 Jun 2006
Posts: 7
|
Hi All,
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:WBRKBKDB
4.Database DRiver COM.ibm.db2.jdbc.DB2Driver
5.DefaultBO Prefix DELTA
The ODA Agent only says
Error in call "core.setAgent properties:Unable to Establish Connection to Database :Reason The specified driver class COM.ibm.db2.jdbc.DB2Driver could not be found."
I am using DB2 8.2 version and JDBC adapter 2.6.
Let me know where i am going wrong ?
Thanks in advance
Reks |
|
| Back to top |
|
|
| vk |
| Posted: Tue Jun 27, 2006 5:22 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
db2jdbc.zip is the driver for older version of DB2. For version 8 and above the JDBC driver is db2jcc.jar and the driver class is com.ibm.db2.jcc.Db2Driver
I have used db2jcc.jar to successfully connect to the DB2 v8.2 database using both JDBC Adapter and the ODA.
Regards,
VK. |
|
| Back to top |
|
|
| mqmaniac |
| Posted: Thu Aug 03, 2006 4:41 pm Post subject: |
|
|
Master
Joined: 27 Dec 2005
Posts: 201
|
Thanks for all your replies..
Finally It worked and I am able to Run the JDBC ODA and create an ASBO
These are the modifications I made..Might be useful!!
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=C:\Progra~1\ibm\SQLLIB\java\db2java.zip;"%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:\Program Files\SQLLIB\bin
set DRIVERLIB=C:\Progra~1\ibm\SQLLIB\BIN;
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 |
|
|
|
|
