Oracle 9i parameters for WmJDBCAdapter

, ,
1

I cannot for the life of me set up a successful connection to Oracle 9i using the WmJDBCAdapter on the IS server. I am entering what I think to be correct parameters ( I am using the data class name found in the JDBCAdapter manual), and using driverType= thin, plus all the standard fields. Below is the error I am getting:

java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:152)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java)
at com.wm.adapter.wmjdbc.connection.JDBCConnection.initializeConnection(Unknown Source)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:111)
at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionEntry.(WmConnectionPool.java:898)
at com.wm.app.b2b.server.jca.WmConnectionPool.init(WmConnectionPool.java:252)
at com.wm.app.b2b.server.jca.WmConnectionPool.(WmConnectionPool.java:167)
at com.wm.app.b2b.server.jca.WmConnectionManager.setConfiguration(WmConnectionManager.java:197)
at com.wm.pkg.art.j2eecaBridge.WmConnectionManagerPropertiesBridge.setManagerProperties(WmConnectionManagerPropertiesBridge.java:121)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.createConnectionManager(ConnectionDataNodeManager.java:771)
at com.wm.pkg.art.ns.ConnectionDataNode.enable(ConnectionDataNode.java:543)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1045)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java(Compiled Code))
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Compiled Code))
at com.wm.a

An example of the correct parameters for Oracle 9i would be appreciate

2

Hi Gordon,

Pls check the params which you cofigured in the IS server admin as shown below:If not pls make modify according…

Alias = MYALIAS (What ever name you want)

  • dbURL = jdbc:oracle:thin:@MYORACLESERVER:1521:MYORACLEINSTAN CE

  • dbDriver = oracle.jdbc.driver.OracleDriver

This is the JDBC Driver.

If you want to use this driver, you have to copy classes12.zip (find in oracle installation folder) to C:\webMethods\IntegrationServer4\lib\jars and restart your Integration Server.

Finally invoke pub.db:connect service for testing the connection between IS to Oracle.

HTH.

3

Hi Gordon

Try using DataSource as oracle.jdbc.pool.OracleConnectionPoolDataSource

This should solve your problem