Thursday, May 11, 2017

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

11:23 AM  ,  11 comments


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


11 comments:

  1. AnonymousFebruary 7, 2018 at 11:34 AM

    Hi

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

    Thanks

    ReplyDelete
    Replies
    1. Muhammad NasirFebruary 7, 2018 at 8:56 PM

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

      Delete
  2. AnonymousFebruary 7, 2018 at 11:34 PM

    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

    ReplyDelete
  3. AnonymousFebruary 8, 2018 at 1:09 AM

    Ok restarted Admin server and still the same error.

    ReplyDelete
    Replies
    1. Muhammad NasirFebruary 8, 2018 at 1:15 AM

      Hi,

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

      Delete
  4. AnonymousFebruary 8, 2018 at 2:24 AM

    weblogic.jdbc.sqlserver.SQLServerDriver

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

    ReplyDelete
  5. AnonymousFebruary 20, 2018 at 7:07 AM

    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

    ReplyDelete
    Replies
    1. Muhammad NasirFebruary 20, 2018 at 7:53 AM

      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

      Delete
  6. SOA DeveloperMay 2, 2018 at 11:34 PM

    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.

    ReplyDelete
  7. SOA DeveloperMay 2, 2018 at 11:36 PM

    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.

    ReplyDelete

Subscribe to: Post Comments (Atom)