Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » DBWS: java.sql.SQLSyntaxErrorException
DBWS: java.sql.SQLSyntaxErrorException [message #778993] Sat, 14 January 2012 10:27
Lonneke Dikmans is currently offline Lonneke Dikmans
Messages: 2
Registered: January 2012
Junior Member
Environment:
OEPE 11172 (toplink_11114)
WLS 10.1.3.5
Linux VB
Oracle XE database
HR Schema

I generated a webservice on the procedure ADD_JOB_HISTORY that is part of the hr schema that Oracle delivers with Oracle XE

PROCEDURE add_job_history
( p_emp_id job_history.employee_id%type
, p_start_date job_history.start_date%type
, p_end_date job_history.end_date%type
, p_job_id job_history.job_id%type
, p_department_id job_history.department_id%type
)
IS
BEGIN
INSERT INTO job_history (employee_id, start_date, end_date,
job_id, department_id)
VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
END add_job_history;

I generated a webservice with the following builder file:

<?xml version="1.0" encoding="UTF-8"?>
<dbws-builder xmlns:xsd="[link here, not allowed to post : ]">
<properties>
..properties here
</property>
</properties>
<procedure
name="Jobhistory"
catalogPattern="TOPLEVEL"
procedurePattern="ADD_JOB_HISTORY"
isSimpleXMLFormat="true"
/>
</dbws-builder>

When I call this Webservice with SOAP UI

<[not allowed to post header]">
<soapenv:Header/>
<soapenv:Body>
<hrs:Jobhistory>
<hrs:P_EMP_ID>176</hrs:P_EMP_ID>
<hrs:P_START_DATE>2013-02-02</hrs:P_START_DATE>
<hrs:P_END_DATE>2014-02-02</hrs:P_END_DATE>
<hrs:P_JOB_ID>SA_MAN</hrs:P_JOB_ID>
<hrs:P_DEPARTMENT_ID>80</hrs:P_DEPARTMENT_ID>
</hrs:Jobhistory>
</soapenv:Body>
</soapenv:Envelope>

I get the following error:

[EL Warning]: 2012-01-14 11:01:11.478--DatabaseSessionImpl(14802092)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

Error Code: 900
Call: BEGIN ADD_JOB_HISTORY(P_EMP_ID=>?, P_START_DATE=>?, P_END_DATE=>?, P_JOB_ID=>?, P_DEPARTMENT_ID=>?); END;
bind => [176.0, 2013-02-02 00:00:00.0, 2014-02-02 00:00:00.0, SA_MAN, 80.0]
Query: ValueReadQuery(name="Jobhistory" )

However, the row does get added to the database!


Does anybody have any clues?

regards Lonneke
Previous Topic:DBWS: java.sql.SQLSyntaxErrorException
Next Topic:Problems retrieving a joined entity object
Goto Forum:
  


Current Time: Thu Oct 23 09:38:40 GMT 2014

Powered by FUDForum. Page generated in 0.01933 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software