RE: [jBoss-User] Oracle

[John Moore]

I'm using 8.1.6 but here are a few that I found (and added to the jaws.xml)
;

         <mapping>
           <java-type>java.math.BigDecimal</java-type>
           <jdbc-type>NUMERIC</jdbc-type>
           <sql-type>NUMBER</sql-type>
         </mapping>
         <mapping>
           <java-type>java.lang.String</java-type>
           <jdbc-type>VARCHAR</jdbc-type>
           <sql-type>VARCHAR2</sql-type>
         </mapping>
         <mapping>
           <java-type>java.sql.TimeStamp</java-type>
           <jdbc-type>TIMESTAMP</jdbc-type>
           <sql-type>DATE</sql-type>
         </mapping>


I used the following code to gather the info from Oracle;  not great but it
helped alot since I couldn't find the mappings.

package orcltest;
import java.sql.*;

public class Test {

  public Test() throws java.sql.SQLException {
    String databaseURL = "jdbc:oracle:thin:@bear:1521:ORCL";
    String user = "asdf";
    String password = "asdf";
    // String driverName = "oracle.jdbc.driver.OracleDriver";

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    Connection conn =
      DriverManager.getConnection ( databaseURL , user , password );

    // Create a Statement
    Statement stmt = conn.createStatement ();

    // Select the ENAME column from the EMP table
    ResultSet rset = stmt.executeQuery ("select CUST_NO_IN, CUST_NAME_VC,
CUST_CREATE_DT from CUSTOMER_ACCOUNT_TBL");
    java.sql.ResultSetMetaData rsmd = rset.getMetaData();
    int numberOfColumns = rsmd.getColumnCount();
    System.out.println("There are " + numberOfColumns + " returned in the
result set");

    for( int i=numberOfColumns;i>0;i--) {
      System.out.print( rsmd.getColumnName(i) + "," );
      System.out.print( rsmd.getColumnType(i ) + ",");
      System.out.print( rsmd.getColumnTypeName(i)  + "," );
      try {
        String className = rsmd.getColumnClassName( i );
        System.out.print( className );
      }
      catch( java.lang.AbstractMethodError abme ) {
        System.out.print( " no class name for column");
        abme.printStackTrace();
      }
      catch( java.lang.Exception e ) {
        // System.out.println( e );
      }
      System.out.print("\n");
    }
    System.out.println( "java.sql.Types.TIMESTAMP: " +
java.sql.Types.TIMESTAMP  );
    System.out.println( "java.sql.Types.VARCHAR: " + java.sql.Types.VARCHAR
);
    System.out.println( "java.sql.Types.NUMERIC: "+ java.sql.Types.NUMERIC);

    // Iterate through the result and print the employee names
    while (rset.next ()) {
      System.out.println ( rset.getInt(1) + ", " + rset.getString (2) + ", "
+ rset.getDate(3 ));
    }
    rset.close();
    stmt.close();
    conn.commit();

    java.sql.Timestamp ts = new java.sql.Timestamp( new
java.util.Date().getTime() );
  }

  public static void main(String[] args) throws java.sql.SQLException {
    Test test1 = new Test();
  }
}

-----Original Message-----
From: Ingo Bruell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 15, 2000 1:36 PM
To: [EMAIL PROTECTED]
Subject: [jBoss-User] Oracle


Hi,
  is here someone who uses Oracle for persitence storing of
EntityBeans ? Who can me post the correct mapping for Oracle 8.1.5 ?
  

so long


Ingo Bruell                                 

---
<[EMAIL PROTECTED]>
<ICQ# 40377720>
Oldenburg    PGP-Fingerprint: 9DD0 1776 DF4D 5B16  A532 C2A1 4701 EEA2
Germany      PGP-Public-Key available at pgpkeys.mit.edu




--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]