JDBC adapter connection error on oracle 9i

[something]

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.jarServer class Path

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\


Please help me .....

[mcarlson]

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

[something]

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....

[mcarlson]

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

[jeevanrego]

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

[something]

Hai,

Still I am getting same errors,pls help me....

[raymoser]

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

[harishnamdeo]

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:

[harishnamdeo]

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
How can i find our database URL. and where shuld be it place.

[harishnamdeo]

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