This discussion is archived
10 Replies Latest reply: Oct 21, 2008 9:54 AM by 843830 RSS

Issue while invoking database

843830 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    send me your wsdl file, for to verify
  • 2. Re: Issue while invoking database
    jtahlborn Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated
    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.