standardjbosscmp-jdbc.xml broken for DB2 7.2?

mpatnode Jun 20, 2003 5:02 PM

In DB2 7.2 Timestamps are Dates not Timestamps (yes only IBM). This was mapped correctly in 3.0.4 standardjbosscmp-jdbc.xml and is broken in 3.0.7 and beyond (3.2.1 incl). Any reason for the change? Does DB2 8.0 work differently?

In short the lines:

<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>

Need to read

<java-type>java.sql.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>

For DB2 7.2. Was this change tested?

1. Re: standardjbosscmp-jdbc.xml broken for DB2 7.2?

mpatnode Jun 20, 2003 5:32 PM (in response to mpatnode)

My bad. I now suspect my contactors edited the 3.0.4 file. This problem was probably in 3.0.4 as well.
Actions
2. Re: standardjbosscmp-jdbc.xml broken for DB2 7.2?

mpatnode Jun 20, 2003 6:57 PM (in response to mpatnode)

Grrrrrr!!! That needs to be java.util.Date!

<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
Actions

Go to original post