users@glassfish.java.net

Re: RE: Problems with Oracle's CHAR datatype and JPA

From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Jan 2008 13:47:11 PST

I'm wondering how can you set up FKs that do not match PK type exactly. Does Oracle allow that?

We stumbled upon this problem several years ago in the CMP impl, and learned that Oracle driver (or database itself?) doesn't trim CHAR columns even though the SQL spec prescribes this behavior.

Regards,
-marina
[Message sent by forum member 'mvatkina' (mvatkina)]

http://forums.java.net/jive/thread.jspa?messageID=253285