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:
 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.