Configuring the WmJDBCAdapter for Oracle 817

Hi,
I am trying to configure the connection type (Oracle) on the Adapters > JDBCAdapter > Configure Connection Type screen in the IS Administrator. I am putting for the DataSource class “oracle.jdbc.pool.OracleDataSource” as suggested in the Help screen and the User guide. I am using the Oracle JDBC driver
contained in classes12.zip which I put on to the jars directory on the IS. The driver is loaded as I manage to configure
the database alias and test the connection (although this uses a different connection mentod). The connection is not created
and when I look in the server log I see the following:

2002-11-18 19:34:26 GMT wm.art.admin.connection:createResource com.wm.pkg.art.error.DetailedServiceException: [ART.118.5011] Adapter Runtime (Connection): Unable to create new connection Database:IopDbsCom. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:26 GMT wm.art.admin.connection:createResource [ART.118.5011] Adapter Runtime (Connection): Unable to create new connection Database:IopDbsCom. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:26 GMT wm.art.admin.connection:createResource [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:26 GMT wm.art.admin.connection:createResource [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:25 GMT wm.art.admin.connection:createResource [ADA.001.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:25 GMT wm.art.admin.connection:createResource [wm-cjdbc30][Oracle JDBC Driver]Unable to connect. Invalid URL. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:25 GMT Database:IopDbsCom [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:24 GMT Database:IopDbsCom [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:24 GMT Database:IopDbsCom [ADA.001.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:34:24 GMT Database:IopDbsCom [wm-cjdbc30][Oracle JDBC Driver]Unable to connect. Invalid URL. Stack trace data … ec305bc60d648982f163bd7c66 NULL ec305bc60d648982f163bd7c66
2002-11-18 19:30:15 GMT

I am putting standard things (name of the DB host, name of the DB and 1521 port) and drivetType=thin.
I am missing obviously something.

From the looks of this error, your database URL is not formatted properly. Also, I would recommend that you use a different driver, considering you already have an Oracle 8.1.7 client installed on your locl machine.

Try the following settings:

    []Database URL: jdbc:oracle:thin:@localhost:port:DB Name []Database Username: username []Database Password: password []Database Driver: oracle.jdbc.driver.OracleDriver
    [/list]

    You also may want to review the thread at http://www.wmusers.com/wmusers/messages/117/544.shtml for additional pointers.

    Good luck.

Thanks a lot for above answers, it is very helpful and the problem is solved. However, I’ve got new questions.
Now I want to pass on the results returned by db.execSQL, my understanding is, I need to convert the com.wm.util.Table object results to a String list. From the ISBuiltInService guide, it seems the way to do this is to call pub.table:tableToStringTable service. This package is deprecated and I can’t find it in my installation. Can I download this package somewhere? Or is there any reference about com.wm.util.Table, so I can write a java service myself to do the data conversion?
Many thanks for all the help.

Hi, Min Li.

Here is a thread that discusses this exact problem.

http://www.wmusers.com/wmusers/messages/117/1366.shtml

Glad you are finding the answers you need…