Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 328487

Summary:

DBWSBuilder does not write out sessions.xml correctly for SQL Operations with build-statements

Product:

z_Archived

Reporter:

Mike Norman <michael.norman>

Component:

Eclipselink

Assignee:

Nobody - feel free to take it <nobody>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

CC:

eclipselink.dbws-inbox

Version:

unspecified

Target Milestone:

---

Hardware:

All

OS:

All

Whiteboard:

Attachments:

Description	Flags
add check for presence of build-statement's	none
add check for presence of build-statement's	none

Description Mike Norman

2010-10-22 11:14:12 EDT

Given a DBWS SQL Operation with a build-statement:
<dbws-builder>
  <properties>
      <property name="projectName">testSQL</property>
      <property name="driver">oracle.jdbc.OracleDriver</property>
      <property name="url">jdbc:oracle:thin:@localhost:1521:ORCL</property>
      <property name="username">user</property>
      <property name="password">password</property>
      <property name="platformClassname">org.eclipse.persistence.platform.database.oracle.Oracle10Platform</property>
      <property name="dataSource">jdbc/someDataSource</property>
      <property name="wsdlLocationURI">http://localhost:8080/testSQL/testSQL?wsdl</property>
  </properties>
  <sql
    name="tablewithpk" 
    isCollection="true" 
    returnType="testSQLType" 
  >
  <statement><![CDATA[select id,name from simpletable]]></statement>
  <build-statement><![CDATA[select id,name from simpletable where 0=1]]></build-statement>
  </sql>
</dbws-builder>

The eclipselink-dbws-sessions.xml contains:

<primary-project xsi:type="class">org.eclipse.persistence.sessions.Project</primary-project>


It should contain:

<primary-project xsi:type="xml">/META-INF/eclipselink-dbws-or.xml</primary-project>

Comment 1 Mike Norman

2010-10-22 11:30:18 EDT

Created attachment 181511 [details]
add check for presence of build-statement's

Comment 2 Mike Norman

2010-10-22 11:37:00 EDT

Created attachment 181514 [details]
add check for presence of build-statement's

Comment 3 Mike Norman

2010-10-22 13:50:08 EDT

fixed in SVN: 8389

Will backport to 2.1.3 once the 2.1 stream opens up (workaround is to
manually edit the sessions.xml - see 
http://old.nabble.com/Re%3A-DBWS-output-format-p30029866.html)

Comment 4 Eclipse Webmaster

2022-06-09 10:21:11 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink