commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramana Ramachandran <ramana_ramachand...@yahoo.com>
Subject Re: [SQL] problems with Oracle 8.1.7
Date Tue, 11 Feb 2003 03:01:40 GMT
hi
I updated to the latest CVS head and saw the Jelly
templates.  When trying to run bin\ddl.bat, I see that
dbtool.bat is missing.  Commenting and proceeding I
find that forehead.jar is missing.  Any pointers on
how to get going on the new ddl way?
thanks
ramana

--- Ramana Ramachandran
<ramana_ramachandran@yahoo.com> wrote:
> hi
> <obligatory> I am a newbie to commons project, also
> to
> the commons-sql subproject.  I just installed maven
> and eclipse...  I guess you get the idea!
> </obligatory>
> 
> I am trying to use commons-sql(to do inserts ona
> tables dynamically) on Oracle 8.1.7 and I am running
> into couple of issues
> 
> I created TestOracleDbDynaSql.java (modelled exacly
> like TestHsqlDbDynaSql.java) and ran Junit test
> cases
> (invoked using maven java:jar)
> 
> (1) When creating the table
> create table coltype
> (
>     COL_INTEGER INTEGER NULL ,
>     COL_FLOAT FLOAT NULL ,
>     COL_DECIMAL DECIMAL (15,3) NULL ,
>     COL_DEC_NOSCALE DECIMAL (15,0) NULL ,
>     COL_CHAR CHAR (15) NULL ,
>     COL_VARCHAR VARCHAR (15) NULL ,
>     COL_DATE DATE NULL ,
>     COL_TIME TIME NULL ,
>     COL_TIMESTAMP TIMESTAMP NULL 
> );
> 
> The following error has occurred:
> 
> ORA-00902: invalid datatype
> 
> The datatype that it is complaining on is "TIME"
> 
> (2) When I look through toad, it looks like the pre
> insert trigger on the table "book" did not get
> created
> properly.  It had
> 
> begin
> select book_seq.nextval into :new.book_id from dual
> 
> and the "end" token was missing
> 
> (3) I am not too sure yet, but it "seems" that if we
> created the table names and the columns all
> uppercase,
> then the dynasql.copy() fails...
> 
> code snippet
> ============
> 
>         DynaBean bean = (DynaBean) iter.next();
>         assertTrue("Found a dynaBean row", bean !=
> null);
>         log.info( "Found book: " + bean.get("title")
> );
>         assertEquals( "bean has corrrect isbn",
> "ISBN-XYZ", bean.get("isbn") );
>         assertEquals( "bean has corrrect title",
> "The
> Hanging Garden", bean.get("title") );
>     	DynaBean bean2 = dynaSql.copy("book", bean);
>     	assertTrue("Copied a dynaBean ", bean2 !=
> null);
>     	assertEquals( "bean2 has corrrect isbn",
> "ISBN-XYZ", bean2.get("isbn") );
>     	log.info( "bean2 isbn: " + bean2.get("isbn") );
>     	assertEquals( "bean2 has corrrect title", "The
> Hanging Garden", bean2.get("title") );
>     	log.info( "bean2 title: " + bean2.get("title")
> );
> 
> (4) It is a general maven question, how do I create
> a
> test report for the new test case
> TestOracleDbDynaSql.java?
> 
> Any help is resolving these issues would be greatly
> appreciated!
> 
> Thanks
> ramana
> 
> Log of the Junit of TestOracleDbDynaSql attached
> =================================================
> Jan 29, 2003 2:02:26 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> SEVERE: Command failed: drop table coltype CASCADE
> CONSTRAINTS. Reason: java.sql.SQLException:
> ORA-00942:
> table or view does not exist
> 
> Jan 29, 2003 2:02:26 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> SEVERE: Command failed:
>
-------------------------------------------------------------------------
> -- book
>
-------------------------------------------------------------------------
> 
> create sequence book_seq. Reason:
> java.sql.SQLException: ORA-00955: name is already
> used
> by an existing object
> 
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> WARNING: java.sql.SQLWarning: Warning: execution
> completed with warning
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> SEVERE: Command failed: end. Reason:
> java.sql.SQLException: ORA-00900: invalid SQL
> statement
> 
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> WARNING: java.sql.SQLWarning: Warning: execution
> completed with warning
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> SEVERE: Command failed:
>
-------------------------------------------------------------------------
> -- coltype
>
-------------------------------------------------------------------------
> 
> create table coltype
> (
>     COL_INTEGER INTEGER NULL ,
>     COL_FLOAT FLOAT NULL ,
>     COL_DECIMAL DECIMAL (15,3) NULL ,
>     COL_DEC_NOSCALE DECIMAL (15,0) NULL ,
>     COL_CHAR CHAR (15) NULL ,
>     COL_VARCHAR VARCHAR (15) NULL ,
>     COL_DATE DATE NULL ,
>     COL_TIME TIME NULL ,
>     COL_TIMESTAMP TIMESTAMP NULL 
> ). Reason: java.sql.SQLException: ORA-00902: invalid
> datatype
> 
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> WARNING: java.sql.SQLWarning: Warning: execution
> completed with warning
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.util.DDLExecutor
> evaluateBatch
> INFO: Executed: 12 statement(s) with 4 error(s)
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.dynabean.AbstractTestDynaSql
> testInsert
> INFO: Inserted author:
> org.apache.commons.sql.dynabean.SqlDynaBean@1484a05
> Jan 29, 2003 2:02:27 PM
> org.apache.commons.sql.dynabean.AbstractTestDynaSql
> testInsert
> INFO: Inserted author:
> org.apache.commons.sql.dynabean.SqlDynaBean@1e78fc6
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Mime
View raw message