Sorry I didn't read your first post properly :(. Maybe there is a trim function that discards the white space. I got the feeling this actually resides in the Oracle JDBC drivers.
Another option would be to pad the char with white space before persisting it?
Try
@PrePersist
________________
Thanks and regards
Kenneth Clark
Solutions Engineer
Tel: 27 (0) 11 679 3075
Fax: 27 (0) 86 647 4819
Mobile: 27 (0) 84 583 1348
Email: kenneth.clark_at_skyetech.co.za
Website:
http://www.skyetech.co.za
-----Original Message-----
From: Kenneth Clark [mailto:kenneth.clark_at_skyetech.co.za]
Sent: 10 January 2008 21:59
To: users_at_glassfish.dev.java.net
Subject: RE: Problems with Oracle's CHAR datatype and JPA
I had a similar issue and it almost drove me mad. The resolution for me was to have the char lengths all the same size (fitting the data). The only thing I can think of if you need variable data lengths in the fields is to change the type varchar. I don't know if this is a viable solution.
________________
Thanks and regards
Kenneth Clark
Solutions Engineer
Tel: 27 (0) 11 679 3075
Fax: 27 (0) 86 647 4819
Mobile: 27 (0) 84 583 1348
Email: kenneth.clark_at_skyetech.co.za
Website:
http://www.skyetech.co.za
-----Original Message-----
From: glassfish_at_javadesktop.org [mailto:glassfish_at_javadesktop.org]
Sent: 10 January 2008 21:53
To: users_at_glassfish.dev.java.net
Subject: Re: Problems with Oracle's CHAR datatype and JPA
More updates:
I can also get correct results if I right pad my parameter value to the desired length (in which case I can use [i]=[/i] instead of [i]like[/i]), but when it tries to do foreign key matching it still fails:
SELECT USERID <...> WHERE (USERID = ?)
bind => [151504 ] //note the spaces here
but as it goes through the joins . . .
SELECT t1.USERID <...> t1 WHERE ((t0.USERID = ?) <...>
bind => [151504]
. . . it loses the padding.
I even changed my getter and setter in my entity to right pad just in case.
[Message sent by forum member 'marcusocasey' (marcusocasey)]
http://forums.java.net/jive/thread.jspa?messageID=253265
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 2008/01/08 13:38
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 2008/01/08 13:38
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 2008/01/08 13:38
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 2008/01/08 13:38