7 Replies Latest reply: Apr 9, 2013 5:35 AM by veejai24 RSS

    OSB: Not able to insert data into Teradata database

    veejai24
      Hi,

      Created a connection to teradata in JDeveloper and creted JCA connection for a table. Copied those wsdl, schema and jca file into OSB and try to use it with in proxy service and passing data from proxy service.

      I have kept the jar files (tdgssconfig.jar and terajdbc4.jar) with in classpath of weblogic and created datasource connection and tested, its working fine.
      Then using the below platform class name created the connection factory, and updated connection facotry, it got updated successfully without any issues.

      org.eclipse.persistence.platform.database.DatabasePlatform

      But when we try to pass message from OSB, we are receiving error message as below, are we missing any configuration setup in weblogic - osb managed server to connect to teradata

      Teradata Connection Factory
      Configured Outbound Connection Pool Configuration Table
      eis/DB/TERADATA_CF
      platformClassName: org.eclipse.persistence.platform.database.DatabasePlatform
      xADataSourceName: jdbc/TERADATA_DS1

      The invocation resulted in an error: <jca-transport-application-error xmlns="http://www.bea.com/wli/sb/transports/jca" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      +<jca-transport-error-message>Invoke JCA outbound service failed with application error</jca-transport-error-message>+
      +<jca-runtime-fault-detail>+
      +<eis-error-code xsi:nil="true"/>+
      +<eis-error-message xsi:nil="true"/>+
      +<exception>com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/LoadXML/LoadXML [ LoadXML_ptt::LoadXML(InputParameters) ] - WSIF JCA Execute of operation 'LoadXML' failed due to: Database platform not supported.+
      Database platform org.eclipse.persistence.platform.database.DatabasePlatform is not supported
      An attempt was made to use an unsupported database platform: org.eclipse.persistence.platform.database.DatabasePlatform
      +; nested exception is:+

      BINDING.JCA-11825
      Database platform not supported.
      Database platform org.eclipse.persistence.platform.database.DatabasePlatform is not supported
      An attempt was made to use an unsupported database platform: org.eclipse.persistence.platform.database.DatabasePlatform
      Use one of the supported database platforms.

      Thanks,
      Vijay