[jboss-user] [EJB 3.0] - Re: .. problems with clob's and oracle (ojdbc14_g)

[urbanj]

hi sandor,

.. thanks for your quick response. 

   - i switched to the ojdbc5_g.jar oracle driver, 
   - added this annotation,...


  | @Entity @Table(name="TableName")
  | @Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
  | public class ClassNamet {
  |   @Column(name="Name1")
  |   private String name1;
  |   @Column(name="Name2")
  |   private String name2;
  |   ***
  |   **
  |   *
  | 
  |   @Lob
  |   @Column(name="Col_Clob", columnDefinition="CLOB")
  |   private Clob col_clob; 
  | 

but still get the same error:


  | 12:55:27,831 WARN  [JDBCExceptionReporter] SQL Error: 932, SQLState: 42000
  | 12:55:27,831 ERROR [JDBCExceptionReporter] ORA-00932: inconsistent datatypes: expected - got CLOB
  | 

I#m also not 100% procent sure where it breaks. is it the oracle driver or is it the mapping? If u can tell me, how you solved it, that'll be perfect.

thanks a lot,
joern 



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

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