Java type mismatch; expected java.util.Date, got java.sql.Timestamp

, ,
1

Hi all,

I am currently using JDBC Adapter and a specific notification service.
The environment is :

JDBC Adapter 6.0.3
Integration Server 6.1 SP1 + Fixes
Oracle 9.2 database with compatible parameter set to 8.1.0
ojdbc14.zip for Oracle driver

At implementation i have no problem to test notification. Once a new line is inserted in my database, the line is triggered and the correct document is published in Broker.

My problem occurs when I deploy my package in delivery IntegrationServer with WmDeployer. Indeed after deployment, insertion of the same line generate following errors :

[ISS.0098.9007] Data does not conform to the Publishable Document Type BscsMVPNP
rovisioning.adapter:insertCmdNotificationPublishDocument errors: INVALID
List of errors:
[0] pathName=/INSERT_DATE errorCode=VV-004 errorMessage=[ISC.0082.9033] Java typ
e mismatch; expected java.util.Date, got java.sql.Timestamp

INSERT_DATE defined at implementation time as java.util.Date switchs after deployment as java.sql.Timestamp.

Does anyone have an idea how to resolve this problem ?

I am using the last oracle driver (downloaded from OTN ojdbc14.zip)

Thanks in advance.
Djibril.

2

Also the JDBC Adapter Connection properties :

driverType=thin;loginTimeout=60000;connectionProperties={oracle.jdbc.V8Compatible=true}