Skip to main content

  • Mapping java object to 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
    • 1 more annotations...

  • ONJava.com -- Configuring JBoss 4.0 JDBC Connectivity

      • 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>
        • Class: oracle.jdbc.driver.OracleDriver
        • URL: jdbc:oracle:thin:@<host>:<port>:<database>
        • Class: oracle.jdbc.xa.client.OracleXADataSource
        • URL: jdbc:oracle:thin:@<host>:<port>:<database>
        • Class: oracle.jdbc.driver.OracleDriver
        • URL: jdbc:oracle:oci8:@<database>

  • Jboss Faq - All jboss and j2ee questions answered - View Thread - Need help on EJB

    • 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.
1 - 3 of 3
Showing 20▼ items per page
List Comments (0)

Sponsored Links

Ads by Google