Mapping java object to Oracle TYPE ... - The Diigo Meta page

• 11 Jan 08
  

  Srinivas Raghu

  java object oracle type

  • It did not work even if I set classpath to nls_charset12.jar.
    
    solution:
    1. I have downloaded 10g jdbc driver
    2. removed 9.2 driver files from classpath
    3. set classpath to
    C:\oracle\ora92\jdbc\lib\ojdbc14.jar; (10g driver classes)
    C:\oracle\ora92\jdbc\lib\orai18n.jar; (as you suggested)
    
    It worked!
  • I have a Oracle TYPE declared in database, with few attributes.
    
    I have a Java class with the same set of attributes and also implements SQLDATA interface and provided implementation for two of interface methods readSQL() and writeSQL(). These methods are not there in Oracle TYPE. Now, Can I map this java object to Oracle TYPE as follows:
    
    Map typeMap = connection.getTypeMap();
    typeMap.put("REQSUM_OBJ_T", Class.forName("RequisitionSummary"));
    connection.setTypeMap(typeMap);
    callableStatement = connection.prepareCall("{? = call NW2IDAA.INS_REQSUM_PROC(?)}");
    callableStatement.setObject(1, reqsum);
    callableStatement.execute();
    
    
    I am getting an error while setting object to callable statement as follows:
    
    java.sql.SQLException: Non supported character set: oracle-character-set-178
  • Mapping java object to Oracle TYPE

  1 more annotation...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.