3 Replies Latest reply: Mar 10, 2013 7:56 PM by 991448 RSS

    DB Adapter calling stored procedure in MS SQL Server.

    user366389
      Hi
      i am calling a stored procedure in a MS SQL Server.
      I configured a Datasource for MS SQL Server driver as Oracle's MS SQL Server Driver(Type 4) Versions: 7.0 and later and provide all db details of sql server. I tested the data source and was getting success message. My BPEL code is just talking with input parameter and then calling the stored procedure in sql server. I was able to compile the code in jdeveloper and deploy to weblogic. But when i am testing the code. i am getting an error.


      <env:Fault>
      <faultcode>env:Server</faultcode>
      <faultstring>Exception occured when binding was invoked.
      Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'IDMService' failed due to: JCA Binding Component connection issue.
      JCA Binding Component is unable to create an outbound JCA (CCI) connection.
      Test:IDMService [ IDMService_ptt::IDMService(InputParameters,OutputParameters) ] : The JCA Binding Component was unable to establish an outbound JCA CCI connection due to the following issue: javax.resource.spi.IllegalStateException: [Connector:199176]Unable to execute allocateConnection(...) on ConnectionManager. A stale Connection Factory or Connection Handle may be used. The connection pool associated with it has already been destroyed. Try to re-lookup Connection Factory eis/sql/idm from JNDI and get a new Connection Handle.
      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.</faultstring>
      <faultactor/>
      <detail>
      <exception>[Connector:199176]Unable to execute allocateConnection(...) on ConnectionManager. A stale Connection Factory or Connection Handle may be used. The connection pool associated with it has already been destroyed. Try to re-lookup Connection Factory eis/sql/idm from JNDI and get a new Connection Handle.</exception>
      </detail>
      </env:Fault>

      What is the problem with connection . How cna i rectify it.

      Thanks,
      Venu Raja