Re: re[eclipselink-users] served keywords

[Mike Kienenberger <mkienenb@xxxxxxxxx>]

This is a guess, but it's a pretty reasonable guess based on other
eclipselink.x parameters.

Put it in META-INF/persistence.xml:

<persistence...>

    <persistence-unit ...>
        <properties>
            <property name="eclipselink.database.delimiters" value="true"/>
        </properties>
    </persistence-unit>

</persistence>


On Fri, Sep 11, 2009 at 6:15 PM, Derek Knapp <derek@xxxxxxxxxxxxxx> wrote:
> anyone know where to put
>
> "eclipselink.database.delimiters"="true"
>
>
> Derek
>
>
> Derek Knapp wrote:
>
> I'm using mysql, this is the complete query that is generated
>
> SELECT t1."to", t1.cc, t1.bcc, t1.reportid, t1.userid, t0.userid,
> t0.firstname, t0.lastname, t0.phoneno, t0.cellno, t0.email, t0.password,
> t0.managerid, t0.title, t0.disclaimer, t0.signaturestatus, t0.signatureline,
> t0.country, t0.region, t0.regionid, t0.city, t0.cityid, t0.office,
> t0.officeid, t0.team, t0.teamid, t0.adminlevel, t0.companyid FROM users t0,
> reportdistribution t1 WHERE (((t1.reportid = ?) AND (t1.userid = ?)) AND
> (t0.userid = t1.userid))
>
> I have tried manually running it in mysql, and i get the same error
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '"to", t1.cc, t1.bcc, t1.reportid, t1.userid, t0.userid, t0.firstname,
> t0.lastnam' at line 1
>
>
> Tom Ware wrote:
>
> Hi Derek,
>
>   What does the full SQL string you are getting look like?
>
>   What database are you on?
>
> -Tom
>
> Derek Knapp wrote:
>
> using the "\"to\"" worked well, and I was very happy, until i tried joining
> this to another table
>
> which would cause it to generate sql similar to   select table."to" from
> ....
>
> which is also invalid... so I'm trying to find more information on the
>
> "eclipselink.database.delimiters"="true"
>
> property, but google isn't doing me any good.. only thing I find is my
> question
>
>
>
> Derek
>
>
> To handle reserved words you need to quote them.  You can do this when you
> define your mappings, just give the column name as "\"TO\"" instead of "to".
>
> EclipseLink 2.0 (1.2 as well) (JPA 2.0) support automatically quoting
> columns as well.
>
> I think the property is,
> "eclipselink.database.delimiters"="true"
>
>
> Derek Knapp-3 wrote:
>>
>> I'm switching to exlipselink from toplink for some of the new features
>> (mainly the batch and fetch query hints) however, I'm encountering one
>> problem.. I have some entities with columns that have reserved names..
>> for example, "to" and "from" (it is a table to store an email). The
>> problem is with the following query.
>>
>> "select e from Email e where e.id = :id"
>>
>> in toplink, this wasn't a problem.. the query it would generate is
>>
>> "SELECT t0.id, t0.subject, t0.to, t0.from FROM email t0 where t0.id = 1"
>>
>> but in eclipselink, its not adding the t0. to the list of columns... > aka
>> its generating the following sql
>>
>> "SELECT id, subject, to, from FROM email t0 where t0.id = 1"
>>
>> which is clearly invalid....
>>
>>
>> is there any way in eclipselink to make it add the t0. ?  or is the only
>> solution to rename the columns in the database (which would be a large
>> amount of work :( )
>>
>>
>
>
> -----
> 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
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> ________________________________
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>