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.