Problem enabling JDBC Adapter

, ,
1

Hello All
We are experiencing a problem trying to enable our JDBC adapter (6.0.2.) instances using Oracle 9i.
I have placed the classes12.zip in IntegrationServer\lib\jars

The errors are:
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test.Connectionracle_connection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located.
oracle.jdbc.pool.OracleDataSource

The adapter is JDBC 6.0.2.

Here are the Connection properties:

Connection Type: JDBC Adapter Connection

Test.Connectionracle_connection Details
Connection Type JDBC Adapter Connection
Package Name Test

Connection Properties

Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
server name:ec34dev
user scott
password ******
databaseName ORCL
portNumber 1521
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 (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

OS Windows Xp-Sp2

Current User SYSTEM

Working Dir C:\webMethods6\IntegrationServer

C:\Program Files\webMethods6\jvm\win142\lib\rt.jar
C:\Program Files\webMethods6\jvm\win142\lib\i18n.jar
C:\Program Files\webMethods6\IntegrationServer\lib\proxy.jar
swapRows();writeTD(“row”);Server ClasspathwriteTD(“rowdata-l”);C:\Program Files\webMethods6\IntegrationServer\updates\IS_6-1_FP2.jar
C:\Program Files\webMethods6\IntegrationServer\updates\IS_6-1_SP1.jar
C:\Program Files\webMethods6\IntegrationServer\lib\classes
C:\Program Files\webMethods6\IntegrationServer\lib\server.jar
C:\Program Files\webMethods6\IntegrationServer\lib\client.jar
C:\Program Files\webMethods6\IntegrationServer\lib\mail.jar
C:\Program Files\webMethods6\common\lib\client61.jar
C:\Program Files\webMethods6\common\lib\apiutil61.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entbase.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entcertlist.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entcms.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entjsse.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entmisc.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entnsext.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entp10.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entp11.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entp12.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entp5.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entp7.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entserverlogin.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entsmime.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entsmimev3.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entssl.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\enttunnel.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entuser.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entroaming.jar
C:\Program Files\webMethods6\IntegrationServer\lib\entrust\entxml.jar
C:\Program Files\webMethods6\IntegrationServer\lib\jars\classes12.zip
C:\Program Files\webMethods6\IntegrationServer\lib\jars\mfapi611.jar
C:\Program Files\webMethods6\IntegrationServer\lib\jars\sl53_cj33.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmART\code\jars\static\wmartbundle.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmFlatFile\code\jars\static\ffcore.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmFlatFile\code\jars\static\tspace.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmPRT\code\jars\static\1jxpathpatch.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmPRT\code\jars\static\castor-0.9.5.2.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmPRT\code\jars\static\commons-jxpath-1.1.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmPRT\code\jars\static\jwsdl-1.0.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmPRT\code\jars\static\wmprt.jar
C:\Program Files\webMethods6\IntegrationServer\packages\WmWin32\code\classes\

Any feedback ??
Thanx in advance

2

Hi Vidyat,
IMO, one should not install webMethods IS in directory like C:\Program Files\webMethods6.

Instead you should install it in C:\webMethods6 or some directory where space is not involved.

Particularly, if there is Broker, Workflow and other products involved, the space in “Program Files” can cause problems.

From your post, I find that though the IS is installed in C:\Program Files\webMethods6, your Working Dir is C:\webMethods6\IntegrationServer. Do you even have a directory called C:\webMethods6?

Once you install IS in a directory like C:\webMethods6 and this problem still persists, then open the zip file \lib\jars\classes12.zip and see if the class OracleDataSource.class exists oracle/jdbc/pool.

HTH,
Bhawesh

3

hi vidyat,
it seems to me that you had classes12.jar file in Integrationserver\lib \jar.
if not
please install (copy and paste) the classes12.jar file is in it.
as bhawesh mention
open the zip file \lib\jars\classes12.zip and see if the class OracleDataSource.class exists oracle/jdbc/pool.
if it is not their then install (copy and paste)
classes111.jar file

regards
waseem

4

hi vidyat,

Just check out have you copied class12.jar and class111.jar into IntegrationServer\lib\jars

Regards

Nikhil

5

goodddddddddddddd… but I think u hvn’t set the classpath for that jar…
please check it and then try to enable the Connection
U will get
Enjoy
Istiyak Vasiwala

6

Hi all,

when i try to enable my jdbc adapter… i m gettin the following error

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Connection:conn.[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”.Io exception: The Network Adapter could not establish the connection Can anyone help with this??

7

Do you have the correct username, password, SID for the database…??

8

which connection r you using like SQL connection or Oracle Connection.

-Red

9

Oracle connection

10

My guess is that you don’t have the hostname and / or port for your database server correct. Be sure that the hostname is reachable from your IS server by attempting to ping it. The default port for Oracle is usally 1521, but could be, and often is, changed to another value by your DBA.

Mark

11

how do i find out the host name???