10 Replies Latest reply: Oct 21, 2008 11:54 AM by 843830 RSS

    Issue while invoking database

    843830
      Hi All,
      I am try to retrive data from a derby database for which I have created a WSDL from database and passing one value in the request and trying to retrive the record based on the value given in the request. But I am getting the below error while invoking the database.

      <SOAP-ENV:Fault>
      <faultcode xmlns="">SOAP-ENV:Server</faultcode>
      <faultstring xmlns="">BPCOR-6135:A fault was not handled in the process scope; Fault Name is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault; Fault Data is &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;&lt;jbi:message xmlns:sxeh=&quot;http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling&quot; type=&quot;sxeh:faultMessage&quot; version=&quot;1.0&quot; xmlns:jbi=&quot;http://java.sun.com/xml/ns/jbi/wsdl-11-wrapper&quot;&gt;&lt;jbi:part&gt;Error occured while executing SQL.select FIRSTNAME,ID,EMAIL,LASTNAME from EMPLOYEE&lt;/jbi:part&gt;&lt;/jbi:message&gt;. Sending errors for the pending requests in the process scope before terminating the process instance</faultstring>
      <faultactor xmlns="">sun-bpel-engine</faultactor>
      <detail xmlns="">
      <detailText>BPCOR-6135:A fault was not handled in the process scope; Fault Name is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault; Fault Data is &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;&lt;jbi:message xmlns:sxeh=&quot;http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling&quot; type=&quot;sxeh:faultMessage&quot; version=&quot;1.0&quot; xmlns:jbi=&quot;http://java.sun.com/xml/ns/jbi/wsdl-11-wrapper&quot;&gt;&lt;jbi:part&gt;Error occured while executing SQL.select FIRSTNAME,ID,EMAIL,LASTNAME from EMPLOYEE&lt;/jbi:part&gt;&lt;/jbi:message&gt;. Sending errors for the pending requests in the process scope before terminating the process instance
      Caused by: BPCOR-6131:An Error status was received while doing an invoke (partnerLink=PartnerLink2, portType={http://j2ee.netbeans.org/wsdl/EmployeeWSDL}jdbcPortType, operation=find)
      BPCOR-6129:Line Number is 28
      BPCOR-6130:Activity Name is Invoke1
      Caused by: Error occured while executing SQL.select FIRSTNAME,ID,EMAIL,LASTNAME from EMPLOYEE
      Caused by: Table/View &apos;EMPLOYEE&apos; does not exist.
      Caused by: Table/View &apos;EMPLOYEE&apos; does not exist.</detailText>
      </detail>
      </SOAP-ENV:Fault>

      Could you plz help me in fixing this issue.

      Thanks,
      Srinivas
        • 1. Re: Issue while invoking database
          843830
          send me your wsdl file, for to verify
          • 2. Re: Issue while invoking database
            jtahlborn
            it says you are trying to do a select from the table/view "EMPLOYEE", which doesn't exist. does this table exist?
            • 3. Re: Issue while invoking database
              843830
              Below is wsdl which I am using.


              <?xml version="1.0" encoding="UTF-8"?>


              <definitions name="EmployeeWSDL" targetNamespace="http://j2ee.netbeans.org/wsdl/EmployeeWSDL" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:ns="http://j2ee.netbeans.org/xsd/tableSchema" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://j2ee.netbeans.org/wsdl/EmployeeWSDL" xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/">


              <types>


              <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/">


              <xsd:import namespace="http://j2ee.netbeans.org/xsd/tableSchema" schemaLocation="EMPLOYEE.xsd"/>


              </xsd:schema>


              </types>


              <message name="insertRetMsg">


              <part name="part" type="xsd:int"/>


              </message>


              <message name="inputMsg">


              <part name="part" element="ns:EMPLOYEE"/>


              </message>


              <message name="outputMsg">


              <part name="part" element="ns:EMPLOYEE"/>


              </message>


              <portType name="jdbcPortType">


              <operation name="insert">


              <input name="inputInsert" message="tns:inputMsg"/>


              <output name="outputInsert" message="tns:insertRetMsg"/>


              </operation>


              <operation name="update">


              <input name="inputUpdate" message="tns:inputMsg"/>


              </operation>


              <operation name="delete">


              <input name="inputDelete" message="tns:inputMsg"/>


              </operation>


              <operation name="find">


              <input name="inputFind" message="tns:inputMsg"/>


              <output name="outputFind" message="tns:outputMsg"/>


              </operation>


              <operation name="pollrecords">


              <input name="inputPoll" message="tns:inputMsg"/>


              </operation>


              </portType>


              <binding name="binding" type="tns:jdbcPortType">


              <jdbc:binding xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <operation name="insert">


              <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <input name="inputInsert">


              <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="ID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="EMPLOYEE" Transaction="NOTransaction" numberOfRecords="" operationType="insert" paramOrder="FIRSTNAME,ID,EMAIL,LASTNAME" sql="insert into EMPLOYEE (FIRSTNAME,ID,EMAIL,LASTNAME) values (?,?,?,?)"/>


              </input>


              <output name="outputInsert">


              <jdbc:output xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" returnPartName="part"/>


              </output>


              </operation>


              <operation name="update">


              <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <input name="inputUpdate">


              <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="ID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="EMPLOYEE" Transaction="NOTransaction" numberOfRecords="" operationType="update" paramOrder="FIRSTNAME,ID,EMAIL,LASTNAME" sql="update EMPLOYEE set FIRSTNAME = ?,ID = ?,EMAIL = ?,LASTNAME = ?"/>


              </input>


              </operation>


              <operation name="delete">


              <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <input name="inputDelete">


              <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="ID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="EMPLOYEE" Transaction="NOTransaction" numberOfRecords="" operationType="delete" paramOrder="" sql="delete from EMPLOYEE"/>


              </input>


              </operation>


              <operation name="find">


              <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <input name="inputFind">


              <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnValue="" MoveRowToTableName="" PKName="ID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="EMPLOYEE" Transaction="NOTransaction" operationType="find" paramOrder="" sql="select FIRSTNAME,ID,EMAIL,LASTNAME from EMPLOYEE"/>


              </input>


              <output name="outputFind">


              <jdbc:output xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" returnPartName="part"/>


              </output>


              </operation>


              <operation name="pollrecords">


              <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/>


              <input name="inputPoll">


              <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="ID" PollMilliSeconds="5000" PollingPostProcessing="Delete" TableName="EMPLOYEE" Transaction="NOTransaction" numberOfRecords="" operationType="poll" paramOrder="" sql="select FIRSTNAME,ID,EMAIL,LASTNAME from EMPLOYEE"/>


              </input>


              </operation>


              </binding>


              <service name="service">


              <port name="port" binding="tns:binding">


              <jdbc:address xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" jndiName="VIRJNDI"/>


              </port>


              </service>


              <plink:partnerLinkType xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" name="jdbcpartner">


              <plink:role name="jdbcPortTypeRole" portType="tns:jdbcPortType"/>


              </plink:partnerLinkType>


              </definitions>



              • 4. Re: Issue while invoking database
                jtahlborn
                i didn't ask about the wsdl, i was asking about the database. does the EMPLOYEE table/view exist in the database or not?
                • 5. Re: Issue while invoking database
                  843830
                  I'm looking at this problem now. I've been able to reproduce it. If/when I find an answer, I'll let you know.

                  Thanks,

                  Alex
                  • 6. Re: Issue while invoking database
                    843830
                    I'm assuming that you're using the default EMPLOYEE table that comes with Derby on Glassfish. If so, this table is part of the VIR schema, and you will have to create a JDBC Connection Pool for connections to these datasources. You will also have to create a JNDI entry that points to these new JDBC Connection Pool.

                    It's likely that you just used the default JNDI entry that came up at the end of the WSDL wizard. In your case, it's wrong to just accept the default because the database pool represented by this JNDI entry doesn't point to your database!

                    Let me know if this helps.

                    Alex
                    • 7. Re: Issue while invoking database
                      843830
                      Alex,
                      I haven't used the default JNDI name. I have used the one which is created in the GlassFish admin console. But still the same error.

                      Thanks,
                      Srinivas
                      • 8. Re: Issue while invoking database
                        843830
                        What are the properties that you used to create the JDBC Connection Pool? What is the JNDI name that you used? If this is the "one created in the GlassFish admin console", I should be able to replicate, but I just need some of the details.
                        • 9. Re: Issue while invoking database
                          843830

                          These are the properties which I used while creating connection pool and JNDI Binding.

                          User: APP
                          Database Name: VIR
                          DSN: VIRDSN
                          Passwd:app


                          JNDI Name: VIRJNDI

                          Thanks,
                          Srinivas

                          • 10. Re: Issue while invoking database
                            843830
                            These properties aren't correct. The user and password for the VIR database is vir and vir respectively. This is likely the cause of your problem. Reset the user and password fields to these values and it should work.