Topic
  • 5 replies
  • Latest Post - ‏2017-02-17T18:42:01Z by MarkFilley
SystemAdmin
SystemAdmin
37421 Posts

Pinned topic How can i find JDBC driver version in WAS server?

‏2006-01-20T08:05:15Z |
I got some error realate to Oracle JDBC driver, I want to know version of
the driver but i didn't find it in systemOut.log.

How can i find the driver version?

Pls help me.

Updated on 2006-01-23T07:22:21Z at 2006-01-23T07:22:21Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    37421 Posts

    Re: How can i find JDBC driver version in WAS server?

    ‏2006-01-20T11:05:38Z  
    w.park wrote:

    >I got some error realate to Oracle JDBC driver, I want to know version of
    >the driver but i didn't find it in systemOut.log.
    >
    >How can i find the driver version?
    >
    >Pls help me.
    >
    >
    >
    >
    That will be found in the Oracle JDBC Driver. Not in WebSphere. You
    might try asking in an Oracle newsgroup about how to get its version
    from the .zip file.

    Ken
  • SystemAdmin
    SystemAdmin
    37421 Posts

    Re: How can i find JDBC driver version in WAS server?

    ‏2006-01-20T15:00:30Z  
    w.park wrote:

    >I got some error realate to Oracle JDBC driver, I want to know version of
    >the driver but i didn't find it in systemOut.log.
    >
    >How can i find the driver version?
    >
    >Pls help me.
    >
    >
    >
    >
    That will be found in the Oracle JDBC Driver. Not in WebSphere. You
    might try asking in an Oracle newsgroup about how to get its version
    from the .zip file.

    Ken
    I can see in SystemOut.log of applications looking up a DataSource
    information logs with code DSRA8203I / DSRA8204I / DSRA8205I / DSRA8206I
    which print the database product / database version / driver name / driver
    version.

    Alternatively, java.sql.DatabaseMetaData returns this information with
    getDriverName(), getDriverVersion(), etc.

    HTH.

  • SystemAdmin
    SystemAdmin
    37421 Posts

    Re: How can i find JDBC driver version in WAS server?

    ‏2006-01-23T07:22:21Z  
    I can see in SystemOut.log of applications looking up a DataSource
    information logs with code DSRA8203I / DSRA8204I / DSRA8205I / DSRA8206I
    which print the database product / database version / driver name / driver
    version.

    Alternatively, java.sql.DatabaseMetaData returns this information with
    getDriverName(), getDriverVersion(), etc.

    HTH.

    Thanks a lot!!
    I found the driver version exactly...
    especially the code was very useful to find the version of oracle...
    Have a nice day
    "Ben_" <reply@newsgroup.com> wrote in message
    news:dqqtsn$alrq$1@news.boulder.ibm.com...
    >I can see in SystemOut.log of applications looking up a DataSource
    > information logs with code DSRA8203I / DSRA8204I / DSRA8205I / DSRA8206I
    > which print the database product / database version / driver name / driver
    > version.
    >
    > Alternatively, java.sql.DatabaseMetaData returns this information with
    > getDriverName(), getDriverVersion(), etc.
    >
    > HTH.
    >
    >

  • MarkFilley
    MarkFilley
    2 Posts

    Re: How can i find JDBC driver version in WAS server?

    ‏2015-06-12T15:18:03Z  
    Thanks a lot!!
    I found the driver version exactly...
    especially the code was very useful to find the version of oracle...
    Have a nice day
    "Ben_" <reply@newsgroup.com> wrote in message
    news:dqqtsn$alrq$1@news.boulder.ibm.com...
    >I can see in SystemOut.log of applications looking up a DataSource
    > information logs with code DSRA8203I / DSRA8204I / DSRA8205I / DSRA8206I
    > which print the database product / database version / driver name / driver
    > version.
    >
    > Alternatively, java.sql.DatabaseMetaData returns this information with
    > getDriverName(), getDriverVersion(), etc.
    >
    > HTH.
    >
    >

    Here are 2 examples from servers, first is from a WLE 7.2.0.0 on SQL Server

    DSRA8203I: Database product name : Microsoft SQL Server
    DSRA8204I: Database product version : 10.50.1600
    DSRA8205I: JDBC driver name  : JNetDirect JSQLConnect - JDBC 4
    DSRA8206I: JDBC driver version  : 5.94

     

    Here is BPM 8.5.5.0 on DB2. You can see that this is also DB2 10.5. FP3 from DSRA08204I

    DSRA8225I: DataSource JNDI name : jdbc/TeamWorksDB

    DSRA8203I: Database product name : DB2/NT64
    DSRA8204I: Database product version : SQL10053
    DSRA8205I: JDBC driver name  : IBM Data Server Driver for JDBC and SQLJ
    DSRA8206I: JDBC driver version  : 4.11.69
    DSRA8218I: JDBC driver specification level  : 4.0
    DSRA8212I: DataStoreHelper name is: com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@67c85533.
    DSRA8208I: JDBC driver type  : 4

     

    Updated on 2016-05-19T00:08:04Z at 2016-05-19T00:08:04Z by MarkFilley
  • MarkFilley
    MarkFilley
    2 Posts

    Re: How can i find JDBC driver version in WAS server?

    ‏2017-02-17T18:42:01Z  

    Here are 2 examples from servers, first is from a WLE 7.2.0.0 on SQL Server

    DSRA8203I: Database product name : Microsoft SQL Server
    DSRA8204I: Database product version : 10.50.1600
    DSRA8205I: JDBC driver name  : JNetDirect JSQLConnect - JDBC 4
    DSRA8206I: JDBC driver version  : 5.94

     

    Here is BPM 8.5.5.0 on DB2. You can see that this is also DB2 10.5. FP3 from DSRA08204I

    DSRA8225I: DataSource JNDI name : jdbc/TeamWorksDB

    DSRA8203I: Database product name : DB2/NT64
    DSRA8204I: Database product version : SQL10053
    DSRA8205I: JDBC driver name  : IBM Data Server Driver for JDBC and SQLJ
    DSRA8206I: JDBC driver version  : 4.11.69
    DSRA8218I: JDBC driver specification level  : 4.0
    DSRA8212I: DataStoreHelper name is: com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@67c85533.
    DSRA8208I: JDBC driver type  : 4

     

    For DB2 you can use a command line to also determine the jdbc version. See this post.

    java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version

    
    http://stackoverflow.com/questions/32572610/determine-the-sql-server-jdbc-version-on-command-line
    
    Updated on 2017-02-17T18:42:45Z at 2017-02-17T18:42:45Z by MarkFilley