Topic
  • 2 replies
  • Latest Post - ‏2012-02-24T07:27:55Z by SystemAdmin
SystemAdmin
SystemAdmin
203 Posts

Pinned topic How to configure JDBC driver for oracle 11g in Infospehere Warehouse app?

‏2012-02-17T10:01:33Z |
Hello,

We have problem to make connection to oracle 11g in Infosphere Warehouse application.
Here is description:
  • Menu: Manage Connections, Manage Data Server Drivers is place where is driver registered with parameters
-Driver name: Oracle
-Data server type: Oracle
-Driver class name: oracle.jdbc.xa.client.OracleXADataSource
-Driver file/home/drivers/ojdbc6.jar

  • Menu: Manage Connections, Manage Connections
On test connection named "Abacus" which is very simple, we get this :Connection to Abacus failed. http://Exception. error message = oracle.jdbc.xa.client.OracleXADataSource incompatible with java.sql.Driver

Can anybody help us?
Updated on 2012-02-24T07:27:55Z at 2012-02-24T07:27:55Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: How to configure JDBC driver for oracle 11g in Infospehere Warehouse app?

    ‏2012-02-23T16:21:47Z  
    I think you should use the Oracle Thin Driver, with the ojdbc6.jar. The driver class name should be oracle.jdbc.OracleDriver, and the connection URL something like: jdbc:oracle:thin:@<Host>:1521:<SID>.

    Hope this help
  • SystemAdmin
    SystemAdmin
    203 Posts

    Re: How to configure JDBC driver for oracle 11g in Infospehere Warehouse app?

    ‏2012-02-24T07:27:55Z  
    I think you should use the Oracle Thin Driver, with the ojdbc6.jar. The driver class name should be oracle.jdbc.OracleDriver, and the connection URL something like: jdbc:oracle:thin:@<Host>:1521:<SID>.

    Hope this help
    Fandiño,
    this helps, Thank you...
    Colleague of mine also suggested a change like this, just now :-) and it works.
    Thanks again.