Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 328487 - DBWSBuilder does not write out sessions.xml correctly for SQL Operations with build-statements
Summary: DBWSBuilder does not write out sessions.xml correctly for SQL Operations with...
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-22 11:14 EDT by Mike Norman CLA
Modified: 2022-06-09 10:21 EDT (History)
1 user (show)

See Also:

Attachments
add check for presence of build-statement's (733 bytes, patch)
2010-10-22 11:30 EDT, Mike Norman CLA 		no flags Details | Diff
add check for presence of build-statement's (1.07 KB, patch)
2010-10-22 11:37 EDT, Mike Norman CLA 		no flags Details | Diff
Show Obsolete (1) View All 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 Mike Norman CLA 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 CLA 2010-10-22 11:30:18 EDT 
Created attachment 181511 [details]
add check for presence of build-statement's
Comment 2 Mike Norman CLA 2010-10-22 11:37:00 EDT 
Created attachment 181514 [details]
add check for presence of build-statement's
Comment 3 Mike Norman CLA 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 CLA 2022-06-09 10:21:11 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink