This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 110730 - Inserts on Oracle DB JDBC BC
Summary: Inserts on Oracle DB JDBC BC
Status: RESOLVED INCOMPLETE
Alias: None
Product: soa
Classification: Unclassified
Component: Binding Components (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Naveen Kuncharapu
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-24 12:39 UTC by mweyers
Modified: 2007-11-16 13:45 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description mweyers 2007-07-24 12:39:43 UTC 
I am trying to insert into an Oracle DB using the JDBC BC and the BPEL engine in Netbeans 6.0 M10 Build 200707110000
Evrytime I insert I get the message 
Caused by: java.sql.SQLException: ORA-01008: not all variables bound

It works fine when I use the find operation
I am using ojdbc14 for the jdbc driver.
Comment 1 Venkat Srinivasan 2007-10-04 06:46:13 UTC 
--
Comment 2 Sergey Lunegov 2007-10-26 10:52:38 UTC 
Please provide exact steps, projects, other artifacts.
Comment 3 mweyers 2007-11-16 13:43:15 UTC 
Below my exact steps

1) I create BPEL Project
2) I create a connection pool and JDBC resource on Glassfish and Picg the DB to see that it works
3) I create a WSDL to the DB using the JDBC Wizard
4) I create an WSDL to receive message and return message
5) I build a simple BPEL project taking the input from the message WSDL, inserting it into on of the fields from the 
Insert WSDL (Using BPEL Mapper)
6) I associate the InsertOut to the return Message
7) I create a Composite App
8) I attach the BPEL project to the composite App
9) I deploy the Composite App to Glassfish
10) I set up a test case to insert the recors
11) the System Fails returning:
Executing SQL....insert into "SAN_INT"."SC_EVENT_IN" 
("REPORTED_MSS","PRIORITY_CODE","REPORTED_TYPE","UPDATED_BY","SLA_RELEVANT","REPORTED_SHORTNAME","MAJOR","EX_SCR","CAUSE
_CODE","COMPANY","INITIAL_ASSIGNMENT","CONTACT_PHONE","CONTACT_MSS","END_POINT_1_BUILDING","RESTORE_TIME","STATUS","SOLU
TION_CANDIDATE","CONTACT_REGION","ISS_VERSION","REMEDY_NO","EX_SERVICE_MGR","EVEXPIRE","DOWNTIME_START","CONTACT_MAIL_AD
DRESS","END_POINT_2_BUILDING","REFERRAL_NO","PROBLEM_MSS","BUILDING","OPENER_SYSTEM","OWNERSHIP","REASON_CAUSEDBY","DOWN
TIME","VERSION","EVENTREG_NAME","LINE_CARRIER_NAME","REPORTED_PHONE","ASSIGNMENT","SERIAL_NO","CONTACT_COMPANY","DBTYP",
"REPORTED_EMAIL","ASSIGNEE_EMAIL","RESOLVE_SUBCATEGORY2","VENDOR_NAME","EVTIME","DTE_NO","INFORMED_BY","CURRENT_OWNERSHI
P","CONTACT_SHORTNAME","CONTACT_ROOM","PLANNED_START","EX_NUMBER","MODEL","RESOLVE_SUBCATEGORY1","COMPONENT_SHORTNAME","
RESOLVE_SUBCATEGORY3","CQ_WITH_ERROR","ACTOR","PROBLEM_STATUS","RESOLVE_CATEGORY","EXTERN_SYS","BRIEF_DESCRIPTION","REPO
RTED_FIRSTNAME","CONTACT_LASTNAME","SUBCATEGORY3","END_POINT_2_ZIP","WORK_END","PARENT","FLG_WORK","REASON_TYPE","END_PO
INT_2_STREET","PROVIDER","END_POINT_2_COUNTRY_CODE","END_POINT_1_ZIP","COST_CENTRE","OPENED_BY","PRIORITY_INITIAL","EVST
ATUS","EVFIELDS","VENDOR","DOWNTIME_END","EVTYPE","UPDATE_TIME","RESOLUTION_CODE","EVUSERSEQ","PROVIDER_NAME","EVUSER","
WORKAROUND","CQ_IMPORT_DATE","SUBCATEGORY2","HOME_ASSIGNMENT","END_POINT_1_CITY","RESOLUTION","BUSINESS_IMPACT","COST_CE
NTRE_CONTACT","ABEND_CODE","END_POINT_1_STREET","WORK_START","END_POINT_2_CONTACT_LAST_NAME","EX_PRIORITY","EVSYSSEQ","E
X_COMPANY","SC_NUMBER","REPORTED_BY","ASSIGNED_TO","CONTACT_BUILDING","EX_DOWNSTART","EVSEPCHAR","END_POINT_1","EX_DOWNE
ND","SUBCATEGORY1","END_POINT_2_CITY","ID","CONTACT_NAME","CQ_DESCRIPTION","REPORTED_LASTNAME","NETWORK_TYPE","SW_NAME",
"CONTACT_DEPT","CUSTOMER_INFO","TARGET_TIME","JUSTIFICATION","COMPONENT_MSS","ACTION","OPEN_TIME","END_POINT_1_COUNTRY_C
ODE","RESOLVED_TIME","URGENCY","ALERT_TIME","CATEGORY","ROOM","PROBLEM_SHORTNAME","EVENT_STATUS","LOGICAL_NAME","PLANNED
_END","REACTION_TIME","OPERATING_SYSTEM","ASSIGNED_FULLNAME","CLOSE_TIME","EVSYSOPT","CONTACT_FIRSTNAME","SYSTEM_LEVEL",
"DEVICE_NAME","USER_INFORMED","INFORMED_TIME","END_POINT_1_CONTACT_LAST_NAME","END_POINT_2","EVID","CATEGORY_TYPE","SW_R
ELEASE") values 
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Failed to write message:.
javax.jbi.messaging.MessagingException: Error occured while executing SQL.insert into "SAN_INT"."SC_EVENT_IN" 
("REPORTED_MSS","PRIORITY_CODE","REPORTED_TYPE","UPDATED_BY","SLA_RELEVANT","REPORTED_SHORTNAME","MAJOR","EX_SCR","CAUSE
_CODE","COMPANY","INITIAL_ASSIGNMENT","CONTACT_PHONE","CONTACT_MSS","END_POINT_1_BUILDING","RESTORE_TIME","STATUS","SOLU
TION_CANDIDATE","CONTACT_REGION","ISS_VERSION","REMEDY_NO","EX_SERVICE_MGR","EVEXPIRE","DOWNTIME_START","CONTACT_MAIL_AD
DRESS","END_POINT_2_BUILDING","REFERRAL_NO","PROBLEM_MSS","BUILDING","OPENER_SYSTEM","OWNERSHIP","REASON_CAUSEDBY","DOWN
TIME","VERSION","EVENTREG_NAME","LINE_CARRIER_NAME","REPORTED_PHONE","ASSIGNMENT","SERIAL_NO","CONTACT_COMPANY","DBTYP",
"REPORTED_EMAIL","ASSIGNEE_EMAIL","RESOLVE_SUBCATEGORY2","VENDOR_NAME","EVTIME","DTE_NO","INFORMED_BY","CURRENT_OWNERSHI
P","CONTACT_SHORTNAME","CONTACT_ROOM","PLANNED_START","EX_NUMBER","MODEL","RESOLVE_SUBCATEGORY1","COMPONENT_SHORTNAME","
RESOLVE_SUBCATEGORY3","CQ_WITH_ERROR","ACTOR","PROBLEM_STATUS","RESOLVE_CATEGORY","EXTERN_SYS","BRIEF_DESCRIPTION","REPO
RTED_FIRSTNAME","CONTACT_LASTNAME","SUBCATEGORY3","END_POINT_2_ZIP","WORK_END","PARENT","FLG_WORK","REASON_TYPE","END_PO
INT_2_STREET","PROVIDER","END_POINT_2_COUNTRY_CODE","END_POINT_1_ZIP","COST_CENTRE","OPENED_BY","PRIORITY_INITIAL","EVST
ATUS","EVFIELDS","VENDOR","DOWNTIME_END","EVTYPE","UPDATE_TIME","RESOLUTION_CODE","EVUSERSEQ","PROVIDER_NAME","EVUSER","
WORKAROUND","CQ_IMPORT_DATE","SUBCATEGORY2","HOME_ASSIGNMENT","END_POINT_1_CITY","RESOLUTION","BUSINESS_IMPACT","COST_CE
NTRE_CONTACT","ABEND_CODE","END_POINT_1_STREET","WORK_START","END_POINT_2_CONTACT_LAST_NAME","EX_PRIORITY","EVSYSSEQ","E
X_COMPANY","SC_NUMBER","REPORTED_BY","ASSIGNED_TO","CONTACT_BUILDING","EX_DOWNSTART","EVSEPCHAR","END_POINT_1","EX_DOWNE
ND","SUBCATEGORY1","END_POINT_2_CITY","ID","CONTACT_NAME","CQ_DESCRIPTION","REPORTED_LASTNAME","NETWORK_TYPE","SW_NAME",
"CONTACT_DEPT","CUSTOMER_INFO","TARGET_TIME","JUSTIFICATION","COMPONENT_MSS","ACTION","OPEN_TIME","END_POINT_1_COUNTRY_C
ODE","RESOLVED_TIME","URGENCY","ALERT_TIME","CATEGORY","ROOM","PROBLEM_SHORTNAME","EVENT_STATUS","LOGICAL_NAME","PLANNED
_END","REACTION_TIME","OPERATING_SYSTEM","ASSIGNED_FULLNAME","CLOSE_TIME","EVSYSOPT","CONTACT_FIRSTNAME","SYSTEM_LEVEL",
"DEVICE_NAME","USER_INFORMED","INFORMED_TIME","END_POINT_1_CONTACT_LAST_NAME","END_POINT_2","EVID","CATEGORY_TYPE","SW_R
ELEASE") values 
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.executeOutboundSQL(OutboundMessageProcessor.java:635)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.processInOut(OutboundMessageProcessor.java:315)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.execute(OutboundMessageProcessor.java:207)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.run(OutboundMessageProcessor.java:128)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-01008: not all variables bound
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.executeOutboundSQL(OutboundMessageProcessor.java:631)
        ... 4 more
Pattern for exchange Id 189800260845110-19838-134145122674790246 is http://www.w3.org/2004/08/wsdl/in-out
[Fatal Error] :1:1: Content is not allowed in prolog.
Fault Processing Error. Fault Name is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}
systemFault and Fault Value is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault 
is not handled in the current scope. Sending faults for the pending requests in the current scope before propagating 
the fault to the enclosing scope.
Setting MessageEx id 189800260845110-19838-134145122674630245 with error: Processing Error. Fault Name is 
{http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault and Fault Value is 
{http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault
HTTPBC-E00721: Provider for service [null] endpoint [messageWSDLPort] responded with an error status. No detail was 
provided.

I use the driver ojcb14.zip

Please advise
Comment 4 mweyers 2007-11-16 13:45:09 UTC 
1) I create BPEL Project
2) I create a connection pool and JDBC resource on Glassfish and Picg the DB to see that it works
3) I create a WSDL to the DB using the JDBC Wizard
4) I create an WSDL to receive message and return message
5) I build a simple BPEL project taking the input from the message WSDL, inserting it into on of the fields from the 
Insert WSDL (Using BPEL Mapper)
6) I associate the InsertOut to the return Message
7) I create a Composite App
8) I attach the BPEL project to the composite App
9) I deploy the Composite App to Glassfish
10) I set up a test case to insert the recors
11) the System Fails returning:
Executing SQL....insert into "SAN_INT"."SC_EVENT_IN" 
("REPORTED_MSS","PRIORITY_CODE","REPORTED_TYPE","UPDATED_BY","SLA_RELEVANT","REPORTED_SHORTNAME","MAJOR","EX_SCR","CAUSE
_CODE","COMPANY","INITIAL_ASSIGNMENT","CONTACT_PHONE","CONTACT_MSS","END_POINT_1_BUILDING","RESTORE_TIME","STATUS","SOLU
TION_CANDIDATE","CONTACT_REGION","ISS_VERSION","REMEDY_NO","EX_SERVICE_MGR","EVEXPIRE","DOWNTIME_START","CONTACT_MAIL_AD
DRESS","END_POINT_2_BUILDING","REFERRAL_NO","PROBLEM_MSS","BUILDING","OPENER_SYSTEM","OWNERSHIP","REASON_CAUSEDBY","DOWN
TIME","VERSION","EVENTREG_NAME","LINE_CARRIER_NAME","REPORTED_PHONE","ASSIGNMENT","SERIAL_NO","CONTACT_COMPANY","DBTYP",
"REPORTED_EMAIL","ASSIGNEE_EMAIL","RESOLVE_SUBCATEGORY2","VENDOR_NAME","EVTIME","DTE_NO","INFORMED_BY","CURRENT_OWNERSHI
P","CONTACT_SHORTNAME","CONTACT_ROOM","PLANNED_START","EX_NUMBER","MODEL","RESOLVE_SUBCATEGORY1","COMPONENT_SHORTNAME","
RESOLVE_SUBCATEGORY3","CQ_WITH_ERROR","ACTOR","PROBLEM_STATUS","RESOLVE_CATEGORY","EXTERN_SYS","BRIEF_DESCRIPTION","REPO
RTED_FIRSTNAME","CONTACT_LASTNAME","SUBCATEGORY3","END_POINT_2_ZIP","WORK_END","PARENT","FLG_WORK","REASON_TYPE","END_PO
INT_2_STREET","PROVIDER","END_POINT_2_COUNTRY_CODE","END_POINT_1_ZIP","COST_CENTRE","OPENED_BY","PRIORITY_INITIAL","EVST
ATUS","EVFIELDS","VENDOR","DOWNTIME_END","EVTYPE","UPDATE_TIME","RESOLUTION_CODE","EVUSERSEQ","PROVIDER_NAME","EVUSER","
WORKAROUND","CQ_IMPORT_DATE","SUBCATEGORY2","HOME_ASSIGNMENT","END_POINT_1_CITY","RESOLUTION","BUSINESS_IMPACT","COST_CE
NTRE_CONTACT","ABEND_CODE","END_POINT_1_STREET","WORK_START","END_POINT_2_CONTACT_LAST_NAME","EX_PRIORITY","EVSYSSEQ","E
X_COMPANY","SC_NUMBER","REPORTED_BY","ASSIGNED_TO","CONTACT_BUILDING","EX_DOWNSTART","EVSEPCHAR","END_POINT_1","EX_DOWNE
ND","SUBCATEGORY1","END_POINT_2_CITY","ID","CONTACT_NAME","CQ_DESCRIPTION","REPORTED_LASTNAME","NETWORK_TYPE","SW_NAME",
"CONTACT_DEPT","CUSTOMER_INFO","TARGET_TIME","JUSTIFICATION","COMPONENT_MSS","ACTION","OPEN_TIME","END_POINT_1_COUNTRY_C
ODE","RESOLVED_TIME","URGENCY","ALERT_TIME","CATEGORY","ROOM","PROBLEM_SHORTNAME","EVENT_STATUS","LOGICAL_NAME","PLANNED
_END","REACTION_TIME","OPERATING_SYSTEM","ASSIGNED_FULLNAME","CLOSE_TIME","EVSYSOPT","CONTACT_FIRSTNAME","SYSTEM_LEVEL",
"DEVICE_NAME","USER_INFORMED","INFORMED_TIME","END_POINT_1_CONTACT_LAST_NAME","END_POINT_2","EVID","CATEGORY_TYPE","SW_R
ELEASE") values
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Failed to write message:.
javax.jbi.messaging.MessagingException: Error occured while executing SQL.insert into "SAN_INT"."SC_EVENT_IN" 
("REPORTED_MSS","PRIORITY_CODE","REPORTED_TYPE","UPDATED_BY","SLA_RELEVANT","REPORTED_SHORTNAME","MAJOR","EX_SCR","CAUSE
_CODE","COMPANY","INITIAL_ASSIGNMENT","CONTACT_PHONE","CONTACT_MSS","END_POINT_1_BUILDING","RESTORE_TIME","STATUS","SOLU
TION_CANDIDATE","CONTACT_REGION","ISS_VERSION","REMEDY_NO","EX_SERVICE_MGR","EVEXPIRE","DOWNTIME_START","CONTACT_MAIL_AD
DRESS","END_POINT_2_BUILDING","REFERRAL_NO","PROBLEM_MSS","BUILDING","OPENER_SYSTEM","OWNERSHIP","REASON_CAUSEDBY","DOWN
TIME","VERSION","EVENTREG_NAME","LINE_CARRIER_NAME","REPORTED_PHONE","ASSIGNMENT","SERIAL_NO","CONTACT_COMPANY","DBTYP",
"REPORTED_EMAIL","ASSIGNEE_EMAIL","RESOLVE_SUBCATEGORY2","VENDOR_NAME","EVTIME","DTE_NO","INFORMED_BY","CURRENT_OWNERSHI
P","CONTACT_SHORTNAME","CONTACT_ROOM","PLANNED_START","EX_NUMBER","MODEL","RESOLVE_SUBCATEGORY1","COMPONENT_SHORTNAME","
RESOLVE_SUBCATEGORY3","CQ_WITH_ERROR","ACTOR","PROBLEM_STATUS","RESOLVE_CATEGORY","EXTERN_SYS","BRIEF_DESCRIPTION","REPO
RTED_FIRSTNAME","CONTACT_LASTNAME","SUBCATEGORY3","END_POINT_2_ZIP","WORK_END","PARENT","FLG_WORK","REASON_TYPE","END_PO
INT_2_STREET","PROVIDER","END_POINT_2_COUNTRY_CODE","END_POINT_1_ZIP","COST_CENTRE","OPENED_BY","PRIORITY_INITIAL","EVST
ATUS","EVFIELDS","VENDOR","DOWNTIME_END","EVTYPE","UPDATE_TIME","RESOLUTION_CODE","EVUSERSEQ","PROVIDER_NAME","EVUSER","
WORKAROUND","CQ_IMPORT_DATE","SUBCATEGORY2","HOME_ASSIGNMENT","END_POINT_1_CITY","RESOLUTION","BUSINESS_IMPACT","COST_CE
NTRE_CONTACT","ABEND_CODE","END_POINT_1_STREET","WORK_START","END_POINT_2_CONTACT_LAST_NAME","EX_PRIORITY","EVSYSSEQ","E
X_COMPANY","SC_NUMBER","REPORTED_BY","ASSIGNED_TO","CONTACT_BUILDING","EX_DOWNSTART","EVSEPCHAR","END_POINT_1","EX_DOWNE
ND","SUBCATEGORY1","END_POINT_2_CITY","ID","CONTACT_NAME","CQ_DESCRIPTION","REPORTED_LASTNAME","NETWORK_TYPE","SW_NAME",
"CONTACT_DEPT","CUSTOMER_INFO","TARGET_TIME","JUSTIFICATION","COMPONENT_MSS","ACTION","OPEN_TIME","END_POINT_1_COUNTRY_C
ODE","RESOLVED_TIME","URGENCY","ALERT_TIME","CATEGORY","ROOM","PROBLEM_SHORTNAME","EVENT_STATUS","LOGICAL_NAME","PLANNED
_END","REACTION_TIME","OPERATING_SYSTEM","ASSIGNED_FULLNAME","CLOSE_TIME","EVSYSOPT","CONTACT_FIRSTNAME","SYSTEM_LEVEL",
"DEVICE_NAME","USER_INFORMED","INFORMED_TIME","END_POINT_1_CONTACT_LAST_NAME","END_POINT_2","EVID","CATEGORY_TYPE","SW_R
ELEASE") values
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.executeOutboundSQL(OutboundMessageProcessor.java:635)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.processInOut(OutboundMessageProcessor.java:315)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.execute(OutboundMessageProcessor.java:207)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.run(OutboundMessageProcessor.java:128)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-01008: not all variables bound
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
        at com.sun.jbi.jdbcbc.OutboundMessageProcessor.executeOutboundSQL(OutboundMessageProcessor.java:631)
        ... 4 more
Pattern for exchange Id 189800260845110-19838-134145122674790246 is http://www.w3.org/2004/08/wsdl/in-out
[Fatal Error] :1:1: Content is not allowed in prolog.
Fault Processing Error. Fault Name is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}
systemFault and Fault Value is {http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault
is not handled in the current scope. Sending faults for the pending requests in the current scope before propagating 
the fault to the enclosing scope.
Setting MessageEx id 189800260845110-19838-134145122674630245 with error: Processing Error. Fault Name is 
{http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault and Fault Value is 
{http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling}systemFault
HTTPBC-E00721: Provider for service [null] endpoint [messageWSDLPort] responded with an error status. No detail was 
provided.

I use the driver ojcb14.zip

Please advise