type mapping for oracle8i

[sheckler]

The default mapping for String in EJB is VARCHAR(255):


<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR2(255)</sql-type>


I would like to have an other String type mapped to VARCHAR(4000) and tried the following:


<java-type>java.lang.StringBuffer</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>VARCHAR2(4000)</sql-type>


This works for update, but not for getting the data from the database :
java.sql.SQLException: Got a java.lang.String[cl=0, value=Es ist was passiert] while looking for a java.lang.StringBuffer[cl=16671929]

What would be the correct mapping?

Stefan

[scoy]

What version of JBoss are you using?

Steve Coy

[sheckler]

Hi Steve,
I am using JBoss 3.2.1 and found the solution meanwhile:

I use the following mapping


<java-type>java.lang.String</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
<sql-type>VARCHAR2(4000)</sql-type>


and deploy my EntityBean's getter as jdbc-type LONGVARCHAR , then it works!

Thanks
Stefan