[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] LEFT OUTER JOIN not being honored
|
What version are you using, did you try the 1.1 release.
cmathrusse wrote:
>
> I actually had not specified the target database, which defaults
> EclipseLink to "Auto" and should allow EclipseLink to retrieve the
> database type for the JDBC MetaData. Looking at the log file pertaining to
> when my application starts, I see the following:
> <BR /><BR />
> <code>
> [#|2009-05-04T11:00:42.315-0700|CONFIG|sun-appserver2.1|org.eclipse.persistence.session.file:/D:/dev/glassfish-v2.1/domains/domain1/applications/j2ee-apps/ecv/ecv-ejb_jar/-ecv-pu.connection|_ThreadID=45;_ThreadName=Thread-1010;|Connected:
> jdbc:derby://cmathrusxp:1527/ecv;;create=true
> <BR /><BR />
> User: ecv
> <BR /><BR />
> Database: Apache Derby Version: 10.4.2.1 - (706043)
> <BR /><BR />
> Driver: Apache Derby Network Client JDBC Driver Version: 10.4.2.1 -
> (706043)|#]
> <BR /><BR />
>
>
> [#|2009-05-04T11:00:42.315-0700|CONFIG|sun-appserver2.1|org.eclipse.persistence.session.file:/D:/dev/glassfish-v2.1/domains/domain1/applications/j2ee-apps/ecv/ecv-ejb_jar/-ecv-pu.connection|_ThreadID=45;_ThreadName=Thread-1010;|connecting(DatabaseLogin(
> <BR /><BR />
> platform=>JavaDBPlatform
> <BR /><BR />
> user name=> ""
> <BR /><BR />
> connector=>JNDIConnector datasource name=>null
>
> ))|#]
> <BR /><BR />
> </code>
> <BR /><BR />
> Even though this shows the target database to be Derby, I explicitly set
> the database <code>property name="eclipselink.target-database"
> value="JavaDB"</code> but the generated SQL still showed the issue.
> <BR /><BR />
> <code>
> SELECT t0.id, t0.mod_date, t0.create_date, t0.version, t0.sieve,
> t0.mod_by, t0.resource_id, t0.severity, t0.distribution_id
> <BR />
> FROM notification_definition t0 LEFT OUTER JOIN distribution_sieve t1 ON
> (t1.id = t0.sieve)
> <BR />
> WHERE ((((t0.resource_id = ?) AND (t0.severity IS NULL)) OR
> ((t0.resource_id IS NULL) AND (t0.severity = ?)))
> <BR />
> AND ((((t1.include = 1) AND (t1.organization = ?)) OR ((t1.include = 0)
> AND NOT ((t1.organization = ?)))) OR t0.sieve =* NULL))
> </code>
> <BR /><BR />
>
> Thanks for the help...
>
-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://www.nabble.com/LEFT-OUTER-JOIN-not-being-honored-tp23341277p23387339.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.