While calling a Store procedure from MS SQL server, following issue can come
Problem:
Conversion of type 365366 whose JDBC type is OTHER to a Java object is not supported.
An attempt was made to convert type 365366 to a Java object using an unsupported JDBC type: OTHER.
; nested exception is:
BINDING.JCA-11800
Unimplemented object conversion.
Conversion of type 365366 whose JDBC type is OTHER to a Java object is not supported.
An attempt was made to convert type 365366 to a Java object using an unsupported JDBC type: OTHER.
Use a data type with a supported JDBC type.
Solution:
Go to your Database adapter connection factory and change PlateformClassName from
org.eclipse.persistence.platform.database.Oracle10Platform
To
oracle.toplink.platform.database.SQLServerPlatform
Comments
11 responses to “Conversion of type ” whose JDBC type is OTHER to a Java object is not supported.”
Hi
I did the above but still get the error – any ideas?
Thanks
After doing that, did you update your DBAdapter in deployments and restarted the server?
Since the targets for the datasource are the soa servers, I restarted the soa servers. I will restart the admin server to see if this makes a difference.
Thanks
Ok restarted Admin server and still the same error.
Hi,
Please go to your datasource–connection pool and share Driver Class Name: it should be weblogic.jdbc.sqlserver.SQLServerDriver
weblogic.jdbc.sqlserver.SQLServerDriver
I am only targetting this datasource to the SOA servers. Do I need to also include the Admin server?
That is not required
We are still having issues with this. Now created a dummy stored procedure with no parameters and now getting '[FMWGEN][SQLServer JDBC Driver][SQLServer]Could not find stored procedure…' error.
Any ideas?
Thanks
Are you using XA Data source? if not required try to use non XA. or please check the below
https://blogs.oracle.com/vijaya/sqlserver-jdbc-driver-:-could-not-find-stored-procedure
Hi…. I aa also facing the same issue… I followed the instructions given above but still facing the same issue…. Error:
An attempt was made to convert type 2008-09-29 to a Java object using an unsupported JDBC type: DATE.
Hi… I am also facing the sane issue even after doing the above steps … Error faced:
An attempt was made to convert type 2008-09-29 to a Java object using an unsupported JDBC type: DATE.