[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Type Mapping Oracle 9i

[derharri]

Hello,

i am using Jboss 4.0.4 with EJB2.1 and a Oracle Database.
In my database there are tables containing CLOB fields.
The EJB accessing these tables use a "special" jbosscmp-jdbc.xml in which i explicitely define the CLOB type for the relevant fields.

<cmp-field>
  | 	<field-name>lsData</field-name>
  | 	<column-name>LSDATA</column-name>
  | 	<jdbc-type>CLOB</jdbc-type>
  | 	<sql-type>CLOB</sql-type>
  | </cmp-field>

That works fine but makes me have to use different jbosscmp-jdbc.xml files for different databases (e.g SQLServer).
Maybe i misunderstood something but i think normaly such type-mapping has do be done in standardjbosscmp-jdbc.xml in the conf directory of my used server implementation.
But when i define the CLOB mapping in that file it does not work.

<mapping>
  | 	<java-type>java.lang.String</java-type>
  | 	<jdbc-type>CLOB</jdbc-type>
  | 	<sql-type>CLOB</sql-type>
  | </mapping>

JBoss does not throw neither an exception nor error or warning.
The accessing method in the bean just returns null such as if the db field contains null. I draw the conclusion, that JBoss just has problems reading the db data of the CLOB field.

Can someone explain why my the "global" mapping does not work?
Maybe i just forgot something else?

Thanks for your help


Harri E.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4038407#4038407

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4038407