WAS 6.1 loads wrong jdbc provider - Websphere

This is a discussion on WAS 6.1 loads wrong jdbc provider - Websphere ; Hello all, i am having a problem in my preproduction websphere server with the conection to the database. The server use the wrong jdbc driver for my datasource. In my local server all is ok. Can you help me? The ...

+ Reply to Thread
Results 1 to 3 of 3

Thread: WAS 6.1 loads wrong jdbc provider

  1. WAS 6.1 loads wrong jdbc provider

    Hello all,

    i am having a problem in my preproduction websphere server with the conection to the database. The server use the wrong jdbc driver for my datasource. In my local server all is ok. Can you help me?

    The datasource, provider, etc configurations are identical in both server.

    In my local server (all ok):
    ================================================== ================================================== =======
    [29/09/08 16:31:51:475 CEST] 00000014 InternalOracl I DSRA8203I: Nombre del producto Database: Oracle
    [29/09/08 16:31:51:490 CEST] 00000014 InternalOracl I DSRA8204I: Versión del producto Database: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.1 - Production
    [29/09/08 16:31:51:506 CEST] 00000014 InternalOracl I DSRA8205I: Nombre del controlador JDBC: Oracle JDBC driver
    [29/09/08 16:31:51:506 CEST] 00000014 InternalOracl I DSRA8206I: Versión del controlador JDBC: 8.1.7.0.0
    [29/09/08 16:31:51:537 CEST] 00000014 InternalOracl I DSRA8212I: El nombre de DataStoreHelper es: com.ibm.websphere.rsadapter.OracleDataStoreHelper@ 2abc2abc.
    [29/09/08 16:31:51:584 CEST] 00000012 ResourceMgrIm I WSVR0049I: Se enlaza DefaultEJBTimerDataSource como jdbc/DefaultEJBTimerDataSource
    [29/09/08 16:31:51:600 CEST] 00000014 WSRdbDataSour I DSRA8208I: Tipo de controlador JDBC : ""
    ================================================== ================================================== =======



    The log output is (preproduction server with the error):
    ================================================== ================================================== =======
    [30/09/08 17:05:35:628 CEST] 00000018 InternalOracl I DSRA8203I: Nombre del producto Database: Oracle
    [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8204I: Versión del producto Database: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.1 - Production
    [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8205I: Nombre del controlador JDBC: Oracle JDBC driver
    [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8206I: Versión del controlador JDBC: *10.2.0.3.0* *- WHY??????*
    [30/09/08 17:05:35:659 CEST] 00000018 InternalOracl I DSRA8212I: El nombre de DataStoreHelper es: com.ibm.websphere.rsadapter.OracleDataStoreHelper@ 62da62da.
    [30/09/08 17:05:35:737 CEST] 00000018 InternalOracl W DSRA7019W: Se debe utilizar Oracle10gDataStoreHelper o una de sus subclases al configurar WebSphere DataSources de modo que se ejecuten con el controlador JDBC de Oracle10g.
    [30/09/08 17:05:35:753 CEST] 00000018 WSRdbDataSour I DSRA8208I: Tipo de controlador JDBC : ""
    ================================================== ================================================== =======


    Thank you

  2. Re: WAS 6.1 loads wrong jdbc provider

    jharor@ono.com wrote:
    > Hello all,
    >
    > i am having a problem in my preproduction websphere server with the conection to the database. The server use the wrong jdbc driver for my datasource. In my local server all is ok. Can you help me?
    >
    > The datasource, provider, etc configurations are identical in both server.
    >
    > In my local server (all ok):
    > ================================================== ================================================== =======
    > [29/09/08 16:31:51:475 CEST] 00000014 InternalOracl I DSRA8203I: Nombre del producto Database: Oracle
    > [29/09/08 16:31:51:490 CEST] 00000014 InternalOracl I DSRA8204I: Versión del producto Database: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
    > With the Partitioning option
    > JServer Release 8.1.7.4.1 - Production
    > [29/09/08 16:31:51:506 CEST] 00000014 InternalOracl I DSRA8205I: Nombre del controlador JDBC: Oracle JDBC driver
    > [29/09/08 16:31:51:506 CEST] 00000014 InternalOracl I DSRA8206I: Versión del controlador JDBC: 8.1.7.0.0
    > [29/09/08 16:31:51:537 CEST] 00000014 InternalOracl I DSRA8212I: El nombre de DataStoreHelper es: com.ibm.websphere.rsadapter.OracleDataStoreHelper@ 2abc2abc.
    > [29/09/08 16:31:51:584 CEST] 00000012 ResourceMgrIm I WSVR0049I: Se enlaza DefaultEJBTimerDataSource como jdbc/DefaultEJBTimerDataSource
    > [29/09/08 16:31:51:600 CEST] 00000014 WSRdbDataSour I DSRA8208I: Tipo de controlador JDBC : ""
    > ================================================== ================================================== =======
    >
    >
    >
    > The log output is (preproduction server with the error):
    > ================================================== ================================================== =======
    > [30/09/08 17:05:35:628 CEST] 00000018 InternalOracl I DSRA8203I: Nombre del producto Database: Oracle
    > [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8204I: Versión del producto Database: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
    > With the Partitioning option
    > JServer Release 8.1.7.4.1 - Production
    > [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8205I: Nombre del controlador JDBC: Oracle JDBC driver
    > [30/09/08 17:05:35:643 CEST] 00000018 InternalOracl I DSRA8206I: Versión del controlador JDBC: *10.2.0.3.0* *- WHY??????*
    > [30/09/08 17:05:35:659 CEST] 00000018 InternalOracl I DSRA8212I: El nombre de DataStoreHelper es: com.ibm.websphere.rsadapter.OracleDataStoreHelper@ 62da62da.
    > [30/09/08 17:05:35:737 CEST] 00000018 InternalOracl W DSRA7019W: Se debe utilizar Oracle10gDataStoreHelper o una de sus subclases al configurar WebSphere DataSources de modo que se ejecuten con el controlador JDBC de Oracle10g.
    > [30/09/08 17:05:35:753 CEST] 00000018 WSRdbDataSour I DSRA8208I: Tipo de controlador JDBC : ""
    > ================================================== ================================================== =======
    >
    >
    > Thank you
    >

    Your configurations aren't identical.

    Make sure the .jar files you're using for the Oracle JDBC drivers are
    identical.

    Ken

  3. Re: WAS 6.1 loads wrong jdbc provider

    What path to driver you use.
    Driver path sets in field +Classpath+ in JDBC Provider.
    Check paths variable.

    anton_evane

+ Reply to Thread