Problem:
We are running Oracle WebLogic Server 11g and have created a connection factory to a Microsoft SQL Server database.
Even though the JCA adapter was configured correctly, upon execution of our SOA Suite code, we received the following error:
Solution:
1. Log in to the WebLogic Administration Console.
2. Navigate to Deployments > DBAdapter
3. Expand
4. Locate and click on the JNDI for your connection.
5. Replace platformClassName as follows:
7. Try again.
Applicable Versions:
References:
We are running Oracle WebLogic Server 11g and have created a connection factory to a Microsoft SQL Server database.
Even though the JCA adapter was configured correctly, upon execution of our SOA Suite code, we received the following error:
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'MySQLServerDBAdap' failed due to: Unimplemented object conversion. Conversion of type 2012-10-30T14:47:15-04:00 whose JDBC type is OTHER to a Java object is not supported. An attempt was made to convert type 2012-10-30T14:47:15-04:00 to a Java object using an unsupported JDBC type: OTHER. Use a data type with a supported JDBC type. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
Solution:
1. Log in to the WebLogic Administration Console.
2. Navigate to Deployments > DBAdapter
3. Expand
4. Locate and click on the JNDI for your connection.
5. Replace platformClassName as follows:
OLD:
org.eclipse.persistence.platform.database.Oracle10Platform
NEW:
oracle.toplink.platform.database.SQLServerPlatform
6. Save your changes, redeploy the adapter, and activate the changes.
7. Try again.
Applicable Versions:
- Oracle WebLogic Server 11g (11.1.1.5+)
References:
No comments:
Post a Comment