MQSeries.net :: View topic - developing BOD using DB2,JDBC ODA

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » developing BOD using DB2,JDBC ODA

developing BOD using DB2,JDBC ODA

« View previous topic :: View next topic »

Author

Message

mqmaniac

Posted: Tue Mar 28, 2006 3:28 pm Post subject: developing BOD using DB2,JDBC ODA

Master

Joined: 27 Dec 2005
Posts: 201

I am trying to connect to a database on UDB DB2,In the 6 step process in the step 2,I am lookig for the following

1.DATABASE URL"Mydatabase Name is DELTA"
2.databaseDriver

I do not know what values to be entered for these.
Sometimes,after selectinf the JDBC ODA,The BOD Designer siply hangs and does nothing.

Please help.
Thanks in Advance

Posted: Tue Mar 28, 2006 11:29 pm Post subject:

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

DatabaseUrl - jdbc:db2://<MachineName>:<PortNo>:<DatabaseName>
Eg: jdbc:db2://M1:50000/ABC

DatabaseDriver - com.ibm.db2.jcc.DB2Driver

What is the version of the DB2 database you are trying to connect to? The above path is for Db2 8 or above. You need to specify the path of JDBC jar file db2jcc.jar in start_JDBCODA.bat

Regards,
VK.

mqmaniac

Posted: Wed Mar 29, 2006 2:47 pm Post subject:

Master

Joined: 27 Dec 2005
Posts: 201

Thanks for your reply.

Can you please tell me where to look for port number of the database?
I am using 8.1/fixpack 2 for the database.

I am working wth CROSSWORLDS JDBC adapter.

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=

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

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » developing BOD using DB2,JDBC ODA

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