I had this error when I ran my first app:
Non Recoverable System Fault : |
BINDING.JCA-12563
Exception
occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute
of Reference operation 'getcreditValidationSelect' failed due to: JCA
Binding Component connection issue.
JCA Binding Component is unable to create an outbound JCA (CCI)
connection.
validationForCC:getcreditValidation [
getcreditValidation_ptt::getcreditValidationSelect(getcreditValidationSelect_inputParameters,CreditcardinfoCollection)
] : The JCA Binding Component was unable to establish an outbound JCA
CCI connection due to the following issue: BINDING.JCA-12510
JCA Resource Adapter location error.
Unable to locate the JCA Resource Adapter via .jca binding file element
The JCA Binding Component is unable to startup the Resource Adapter
specified in the element:
location='eis/DB/soademoDatabase'.
The reason for this is most likely that either
1) the Resource Adapters RAR file has not been deployed successfully to
the WebLogic Application server or
2) the '' element in weblogic-ra.xml has not been set
to eis/DB/soademoDatabase. In the last case you will have to add a new
WebLogic JCA connection factory (deploy a RAR).
Please correct this and then restart the Application Server
Please make sure that the JCA connection factory and any dependent
connection factories have been configured with a sufficient limit for
max connections. Please also make sure that the physical connection to
the backend EIS is available and the backend itself is accepting
connections.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a
resolution.
and I found this solution:
SOA11g: "Exception occured when binding was invoked. Exception occured during invocation of JCA binding:" with DbAdapter
Error1:
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by java.lang.ClassCastException: oracle.tip.adapter.db.DBConnectionFactory. You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by java.lang.ClassCastException: oracle.tip.adapter.db.DBConnectionFactory. You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
Error2:
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'ReadSelect' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by Exception [EclipseLink-7060] (Eclipse Persistence Services2.1.2.v20101206r8635): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot acquire data source [jdbc/localDB]. Internal Exception: javax.naming.NameNotFoundException: Unable to resolve 'jdbc.localDB'. Resolved 'jdbc'; remaining name 'localDB'. You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'ReadSelect' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by Exception [EclipseLink-7060] (Eclipse Persistence Services
Requirement:
In SOA 11g i had requirement to access a different database. As regular i have created the datasource with the required details and added it to the DatabaseAdapters in outbound connection pool
In SOA 11g i had requirement to access a different database. As regular i have created the datasource with the required details and added it to the DatabaseAdapters in outbound connection pool
When i started using Dbadapter as part of my process I encountered with the above two (Error1 and Error2) error messages.
Issue and Resolution:
The weblogic-ra.xml file has to be updated with the details of the database as it gets the connection details from this file which solved the issue in my case.
Goto $SOA_HOME/soa/connectors/DbAdapter.rar
Open this archive and edit META-INF/weblogic-ra.xml
Add the new connection instance with the details as below
The solution is modifying the .rar file for DbAdapter manually.. but it worked.