4 Replies Latest reply on Dec 13, 2007 5:49 AM by Jasmin Charbonneau

    JDBC Query Single Row service in WebSphere +SQL Server

    Level 1
      I use the JDBC - Query Single Row service in a process to query LC's "edcprincipalentity" table.

      The exact SQL statement specified in the property sheet is this:
      select commonname, email from edcprincipalentity e where e.id = '{$ /process_data/@InitiatorGUID $}'

      The Data Source name in its property sheet is: java:/IDP_DS

      It worked fine on a TurnKey server (Windows/JBoss/MySQL).

      But when I ran it on another server (Windows/WebSphere/SQL Server), I got the following error:

      [12/12/07 10:09:50:764 CST] 00000059 ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "doSupports" on bean "BeanId(LiveCycle8#adobe-dscf.jar#EjbTransactionCMTAdapter, null)". Exception data: java.lang.RuntimeException: Name not found in context "java:".
      at com.adobe.idp.dsc.jdbc.JDBCService.querySingle(JDBCService.java:213)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      ...
      ...

      So, I changed the Data Source name to "IDP_DS". But still got an error:

      [12/12/07 10:18:19:019 CST] 00000065 ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "doSupports" on bean "BeanId(LiveCycle8#adobe-dscf.jar#EjbTransactionCMTAdapter, null)". Exception data: java.lang.RuntimeException: enlist: caught Exception
      at com.adobe.idp.dsc.jdbc.JDBCService.querySingle(JDBCService.java:215)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:181)
      ...
      ...

      What do I need to do to make it work in WebSphere+SQLserver?

      Thanks