Conversion of type ” whose JDBC type is OTHER to a Java object is not supported.


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



Posted

in

,

by

Tags:

Comments

11 responses to “Conversion of type ” whose JDBC type is OTHER to a Java object is not supported.”

  1. Anonymous Avatar
    Anonymous

    Hi

    I did the above but still get the error – any ideas?

    Thanks

  2. Muhammad Nasir Avatar

    After doing that, did you update your DBAdapter in deployments and restarted the server?

  3. Anonymous Avatar
    Anonymous

    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

  4. Anonymous Avatar
    Anonymous

    Ok restarted Admin server and still the same error.

  5. Muhammad Nasir Avatar

    Hi,

    Please go to your datasource–connection pool and share Driver Class Name: it should be weblogic.jdbc.sqlserver.SQLServerDriver

  6. Anonymous Avatar
    Anonymous

    weblogic.jdbc.sqlserver.SQLServerDriver

    I am only targetting this datasource to the SOA servers. Do I need to also include the Admin server?

  7. Muhammad Nasir Avatar

    That is not required

  8. Anonymous Avatar
    Anonymous

    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

  9. Muhammad Nasir Avatar

    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

  10. SOA Developer Avatar

    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.

  11. SOA Developer Avatar

    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.