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:41:07 PST

I am also worried it is a driver issue. But if it is--how can I use JPA for these tables?

I have noticed in the past similar problem behavior using straight JDBC.

If my SQL says
"select userid from user_group_ where userid = ?"

. . . and then I do
preparedStatement.setString(user);

. . . it doesn't work, but if I change my sql to:
"select userid from user_group_ where userid = '" + user + "'";

. . . then it works.
[Message sent by forum member 'marcusocasey' (marcusocasey)]

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