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
[COLOR=#c60829]C:\Program Files\webMethods61\IntegrationServer\updates\TNS_6-1_Fix15.jar
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.
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.
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.
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
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: