Tuesday, January 19, 2010

Access Oracle Blob and Timestamp Columns

Many of the time we use Blob and Timestamps column in Oracle. When we access them using JDBC, we will get Oracle specific Java objects when result set is returned from DB. e.g oracle.sql.BLOB, oracle.sql.TIMESTAMP but we may need them in the form of java.sql.Blob and java.sql.Timestamp

To get it in right way we need add the following start-up properties

-Doracle.jdbc.J2EE13Compliant=true

No comments: