JDBC driver issues

Hi all,

I thnink this can be helpful information also for you, this info is related to following configuration:

Integration Server 6.1
JDBC Adapter 6.0.3.1
Oracle 9.2.0.6.0
Java Virtual Machine 1.4

And related problems:
1.) Not able to select time information form DATE column, as described in this thread:
http://wmusers.com/forum/showthread.php?t=9074

2.) Not able to select TIMESTAMP(6) column value.

The first problem can be solved, when you use the ojdbc14.zip JDBC driver (MANIFER entry Implementation-Time: “Thu Apr 25 23:14:02 2002”) and you are running JVM 1.4, than the value of DATE column is returned also with time information, but be careful, if you have in your database column TIMESTAMP(6) - timestamp with microseconds - as we have in our db, than when you refresh the connection that selects the column, the JDBC adapter detects the TIMESTAMP(6) as OTHER type and you will not be able to select microseconds, only first three chars - milliseconds will be selected.

The problem can be solved, when you use the classes12.zip JDBC driver (MANIFEST entry Implementation-Time: “Thu Apr 25 23:06:00 2002”), now when you refresh the select service, which selects TIMESTAMP(6) value, the JDBC adapter detects the type correctly as TIMESTAMP and select all 6 characters - microseconds, but arise the problem 1.) the time information will be not selected in case the column type is DATE ;o)

This is quite confusing, because before I used classes12.zip driver (MANIFEST entry Implementation-Time: “Thu Apr 25 23:06:00 2002”) and with this driver works time ok, but there was problem with TIMESTAMP(6) values.

So if you have also TIMESTAMP(6) columns and problem with selecting time information in DATE column, the solutionis is to apply the latest JDBC adapter fix (current is Fix16 or FP Fix11) and use classes12.zip driver (MANIFEST entry Implementation-Time: “Thu Apr 25 23:06:00 2002”) as mentioned before. The fix allows you to specify connection property in JDBC adapter connection (connectionProperties={oracle.jdbc.V8Compatible=true}) and the time information of DATE column and TIMESTAMP(6) values will be selected correctly.

[Handling of DATE type in JDBC driver]
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#08_01

Generally, always after driver update refresh all JDBC services and test the DATE / TIMESTAMP values, if they are selected / inserted correctly.

jogo