Srinivas Raghu's List: Java

• 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!

  • Mapping Java Object to Oracle TYPE.. problem and solutions..<br>
• 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...

• The <driver-class/> and  <connection-url/> settings for Oracle are  as follows:

    

  Oracle OCI Type 2 Driver

    
   
  • Class: oracle.jdbc.driver.OracleDriver
   
  • URL: jdbc:oracle:oci8:@<database>
   
    

  Oracle OCI Thin Type 4 Driver

    
   
  • Class: oracle.jdbc.driver.OracleDriver
   
  • URL: jdbc:oracle:thin:@<host>:<port>:<database>
   
    

  Oracle OCI XA Type 2 Driver

    
   
  • Class: oracle.jdbc.xa.client.OracleXADataSource
   
  • URL: jdbc:oracle:thin:@<host>:<port>:<database>
   
    

  Oracle OCI Type 2 Driver

    
   
  • Class: oracle.jdbc.driver.OracleDriver
   
  • URL: jdbc:oracle:oci8:@<database>

  • Oracle Drivers for Java

• To work with EJB applications on JBOSS server,
  1.apart from the application created the jars to place in the classpath are:
  ejb-api.jar,jca-api.jar(for any of the datasource you are using)
  2.Make a jar of the application and structure of the jar is:
  META-INF
  ejb-jar.xml
  jboss.xml
  class files
  3.The JNDI name is given in jboss.xml file,the JBoss has a standardjboss.xml for all ejb applications and this you can ignore for small applications
  4.Deploy the jar in any of the server configurations(default,all,minimal),the jndi name get resgisters in the JBOSS AS.
  5.Start the server,Run the client application.

  • Steps to work with EJB & JBoss