JDBC adapter connection error on oracle 9i

Hai

I have a problem when I am configuring JDBC adapter connection

error is

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Sreekanth:sreejdbc.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.Invalid Oracle URL specified: OracleDataSource.makeURLadapter is 6.0.3
Java 1.3.1

I have copied classes12.zip to IS\lib\jars

Java class Path
C:\Program Files\webMethods61\IntegrationServer\jvm\lib\rt.jarC:\Program Files\webMethods61\IntegrationServer\jvm\lib\i18n.jar
C:\Program Files\webMethods61\IntegrationServer\lib\proxy.jar
Server class Path

[COLOR=#c60829]C:\Program Files\webMethods61\IntegrationServer\updates\TNS_6-1_Fix15.jar

C:\Program Files\webMethods61\IntegrationServer\lib\classes
C:\Program Files\webMethods61\IntegrationServer\lib\server.jar
C:\Program Files\webMethods61\IntegrationServer\lib\client.jar
C:\Program Files\webMethods61\IntegrationServer\lib\mail.jar
C:\Program Files\webMethods61\common\lib\client61.jar
C:\Program Files\webMethods61\common\lib\apiutil61.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entbase.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entcertlist.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entcms.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entjsse.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entmisc.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entnsext.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entp10.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entp11.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entp12.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entp5.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entp7.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entserverlogin.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entsmime.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entsmimev3.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entssl.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\enttunnel.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entuser.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entroaming.jar
C:\Program Files\webMethods61\IntegrationServer\lib\entrust\entxml.jar
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes111.jar
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes111.zip
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.jar
C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.zip
C:\Program Files\webMethods61\IntegrationServer\lib\jars\javaxsql.zip
C:\Program Files\webMethods61\IntegrationServer\lib\jars\sl53_cj33.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmART\code\jars\static\wmartbundle.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmEDIINT\code\jars\static\ediint.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmFlatFile\code\jars\static\ffcore.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmFlatFile\code\jars\static\tspace.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmMonitor\code\jars\static\mIcons.zip
C:\Program Files\webMethods61\IntegrationServer\packages\WmPRT\code\jars\static\1jxpathpatch.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmPRT\code\jars\static\castor-0.9.5.2.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmPRT\code\jars\static\commons-jxpath-1.1.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmPRT\code\jars\static\jwsdl-1.0.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmPRT\code\jars\static\wmprt.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmTN\code\jars\static\tncore.jar
C:\Program Files\webMethods61\IntegrationServer\packages\WmWin32\code\classes[/color]


Please help me …

Why do you have 4 Oracle JDBC libraries in your class path? You should only need “classes12.zip” and not the other three.

The error message indicates that your database URL is incorrect. Since you are using the JDBC Adapter, you may not be specifying correct values for “serverName”, “databaseName”, “portNumber” properties or may have left off the “driverType=thin” value from the “Other Properties” setting.

Setting up an adapter connection is covered thoroughly in the JDBC Adapter User’s Guide.

Mark

thank you Mark Carlson…

I have deleted remain 3 libraries.and I change other properties as you mentioned.I have solved 1 error.
Now remian errors are

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Sreekanth:sreejdbc.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.com/ddtek/jdbc/extensions/ExtEmbeddedConnection

Details:

Transaction type: LOCAL_TRANSACTION
DataSource Class: oracle.jdbc.pool.OracleDataSource
serverName: localhost
user:sreekanth
password:*********
databaseName:SREE
OtherPropoerties:driverType=thin

please help me…

Ensure that the databaseName you are providing is the name of the Oracle instance or SID and not something else.

This should not matter, but try this class instead of the one you are using “oracle.jdbc.pool.OracleConnectionPoolDataSource”.

Also, if you specify an IP address or DNS name of the database server you will simply your life when it comes time to migrate the package.

Another best practice is to create a package that holds all of your adapter connections. That simplifies deployment and reduces impact on packages containing business logic when you only need to update adapter connection properties.

Mark

Hi

Do check in the tnsnames.ora file whether the database name is matching with database you have installed. Check if also the oracle listener is up also.

Cheers
Jeevan

Hai,

Still I am getting same errors,pls help me…

I know it may sound trivial, but you should look this up in the manual. The WmJDBC adapter is very well documented.

Either you have not specified the SID correctly, or the database URL is incorrect. I noticed that you DID NOT specify the database URL.

Look at the documentation carefully for the database URL and I suspect you will solve your own problem.

HTH,

Ray

Either you have not specified the SID correctly, or the database URL is incorrect. I noticed that you DID NOT specify the database URL.

what do u mean by database URL how can i specify the database URL and where we can do it.

:confused:

I am using following
Operating system - Windows XP SP-2
Databse - Oracle 9i (version-9.0.1.0.0)
JVM version - 1.4
driverType -thin

extra:- I have already copied ojdbc14.jar file into
1. C:\Program Files\webMethods61\IntegrationServer\lib\jars\ojdbc14.jar
2. C:\Program Files\webMethods61\IntegrationServer\lib\jars\classes12.zip

MYJDBC:MYCON Details
Connection _____________JDBC Adapter Connection
Package________________NEWORACLE

Connection Properties
Transaction Type ________NO_TRANSACTION
DataSource Class ________oracle.jdbc.pool.OracleConnectionPoolDataSource
serverName _____________localhost5555
user ___________________system
password _______________******
databaseName __________WMDB
portNumber _____________1433
networkProtocol _________tcp
Other Properties _________driverType=thin

Connection Management Properties
Enable Connection Pooling __true
Minimum Pool Size ________1
Maximum Pool Size ________10
Pool Increment Size _______1
Block Timeout ____________1000
Expire Timeout ___________1000
Startup Retry Count _______0
Startup Backoff Timeout ____10

And last whwn i goes to enable the connection than i find following error

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MYJDBC:MYCON.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.Io exception: The Network Adapter could not establish the connection

Plz help me out from this problem plz …thanx :uhoh:

How can i find our database URL. and where shuld be it place.

Hello every one use this link to solve ur prob---------- BOLuck
http://wmusers.com/forum/showthread.php?t=13419