Now that we are reaching the "wolf's" statement ("let's start sucking each
other d**** quite yet") I want to thank all of you guys that post help on
jboss... I think you really make the "feel" of the group and felt the
praise on the "friendliness and readiness" of the group support that sandeep
recently posted (again thx sandeep) to be well deserved...
So please, before i get too mushy, please keep on posting, keep on helping,
keep on keeping it up :).
Also, for those that are already on the list, get ready and attach your
seatbelts, we are going through vertical take off and expect to see ALOT of
newbie users starting Sept 1st when we start making some serious noise
around jboss' production readiness (we'll get there ;-).
So again, get ready, brace yourselves, thank you for being here and helping.
You make the group alive and the success of jboss depends on you, almost
completely for the next phase. Keep it up, heck step it up!
Again thanks for your support and help,
marc
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of John Moore
> Sent: Tuesday, August 15, 2000 2:01 PM
> To: 'jBoss'
> Subject: RE: [jBoss-User] Oracle
>
>
>
> 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]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
