Bugs item #556704, was opened at 2002-05-16 10:27
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=556704&group_id=22866

Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Tim Fox (timfox)
Assigned to: Nobody/Anonymous (nobody)
Summary: Unable to persist Character type

Initial Comment:
It seems impossible to persist an attribute of type 
java.lang.Character using jboss cmp 2.x, and using 
Oracle 8.1 and either of Oracle's thin or oci drivers 
for 8.1.

Looking at JDBCUtil, the code uses the setObject() 
method on the PreparedStatement to set the column 
value.

If the value is of type java.lang.Character (and the 
column is of Oracle type char(1) - although this 
should make no difference), then it can be shown that 
none of the available sql types in JDK 1.3 will 
successfully complete without throwing an exception.

Hence it seems impossible to persist Character 
attributes.

I guess this will affect almost all Oracle users since 
in my experience almost everyone uses one of these two 
drivers.

In a way this is a failure of the driver to perform 
the mapping, but I guess it will also probably prevent 
Oracle users from using cmp until Oracle change the 
behaviour (which they may never do :()

I have attached a simple test program that does some 
raw jdbc to cycle through the available sql types 
until it finds one that works with setObject and 
character type.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=556704&group_id=22866

_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: [EMAIL PROTECTED]
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to