Thanks! Please try again now.....
----- Original Message -----
From: "Matt Veitas" <[EMAIL PROTECTED]>
To: "hibernate list" <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 2:43 PM
Subject: Re: [Hibernate] Oracle users...
> Just ran the two tests against Oracle 9.2.01 on Win 2000.
>
> FooBarTest = SUCCESS
> MultiTableTest = FAILURE
>
> MultiTableTest output:
>
> D:\jdk1.4\bin\javaw.exe -classpath
>
G:\intellij\lib\junit.jar;D:\jdk1.4\jre\lib\charsets.jar;D:\jdk1.4\jre\lib\j
aws.jar;D:\jdk1.4\jre\lib\jce.jar;D:\jdk1.4\jre\lib\jsse.jar;D:\jdk1.4\jre\l
ib\rt.jar;D:\jdk1.4\jre\lib\sunrsasign.jar;D:\jdk1.4\jre\lib\ext\dnsns.jar;D
:\jdk1.4\jre\lib\ext\ldapsec.jar;D:\jdk1.4\jre\lib\ext\localedata.jar;D:\jdk
1.4\jre\lib\ext\sunjce_provider.jar;G:\projects\sourceforge\hibernate\head\H
ibernate\lib\commons-collections.jar;G:\projects\sourceforge\hibernate\head\
Hibernate\lib\commons-dbcp.jar;G:\projects\sourceforge\hibernate\head\Hibern
ate\lib\commons-lang.jar;G:\projects\sourceforge\hibernate\head\Hibernate\li
b\commons-logging.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\c
ommons-pool.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\j2ee.ja
r;G:\projects\sourceforge\hibernate\head\Hibernate\lib\jcs.jar;G:\projects\s
ourceforge\hibernate\head\Hibernate\lib\jdom.jar;G:\projects\sourceforge\hib
ernate\head\Hibernate\lib\junit.jar;G:\projects\sourceforge\hibernate\head\H
ibernate\lib\odmg.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\x
alan.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\xerces.jar;G:\
projects\sourceforge\hibernate\head\Hibernate\lib\xml-apis.jar;G:\projects\s
ourceforge\hibernate\head\Hibernate\lib\cglib.jar;G:\projects\sourceforge\hi
bernate\head\Hibernate\lib\c3p0.jar;G:\projects\sourceforge\hibernate\head\H
ibernate\build;G:\projects\sourceforge\hibernate\head\Hibernate;G:\projects\
common-lib\ojdbc14.jar;G:\intellij\lib\idea_rt.jar
> com.intellij.rt.execution.junit.TextTestRunner
> cirrus.hibernate.test.MultiTableTest
> Nov 24, 2002 10:41:41 PM cirrus.hibernate.impl.DatastoreImpl storeResource
> INFO: Mapping resource: cirrus/hibernate/test/Multi.hbm.xml
> Nov 24, 2002 10:41:42 PM cirrus.hibernate.helpers.XMLHelper
parseInputSource
> INFO: Parsing XML: unknown system id
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.Environment <clinit>
> INFO: Hibernate 1.2 beta 3
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.Environment <clinit>
> INFO: loaded properties from resource hibernate.properties
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.Environment <clinit>
> INFO: using java.io streams to persist binary types
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.Environment <clinit>
> INFO: JVM proxy support: true
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.sql.Dialect <init>
> INFO: Using dialect: cirrus.hibernate.sql.OracleDialect
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.sql.Dialect <init>
> INFO: Using dialect: cirrus.hibernate.sql.OracleDialect
> Nov 24, 2002 10:41:43 PM cirrus.hibernate.sql.Dialect <init>
> INFO: Using dialect: cirrus.hibernate.sql.OracleDialect
> Nov 24, 2002 10:41:43 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Hibernate connection pool size: 2
> Nov 24, 2002 10:41:43 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Using driver: oracle.jdbc.driver.OracleDriver at URL:
> jdbc:oracle:thin:@snotslinger:1521:tower11
> Nov 24, 2002 10:41:43 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Connection properties: {user=hibernate, password=hibernate}
> alter table subclass drop constraint subclassFK0
> Unsuccessful: ORA-00942: table or view does not exist
>
> alter table subclass drop constraint subclassFK1
> Unsuccessful: ORA-00942: table or view does not exist
>
> alter table nuthasubclass drop constraint nuthasubclassFK0
> Unsuccessful: ORA-00942: table or view does not exist
>
> alter table submulti drop constraint submultiFK0
> Unsuccessful: ORA-00942: table or view does not exist
>
> alter table rootclass drop constraint rootclassFK0
> Unsuccessful: ORA-00942: table or view does not exist
>
> drop table rootclass cascade constraints
> Unsuccessful: ORA-00942: table or view does not exist
>
> drop table subclass cascade constraints
> Unsuccessful: ORA-00942: table or view does not exist
>
> drop table nuthasubclass cascade constraints
> Unsuccessful: ORA-00942: table or view does not exist
>
> drop table submulti cascade constraints
> Unsuccessful: ORA-00942: table or view does not exist
>
> drop sequence hibernate_sequence
> Unsuccessful: ORA-02289: sequence does not exist
>
> create table rootclass (id_ NUMBER(19,0) not null, count_ NUMBER(10,0)
> not null, name VARCHAR2(255), address VARCHAR2(255), date_ DATE, parent
> NUMBER(19,0), primary key (id_))
> create table subclass (id_ NUMBER(19,0) not null, intprop NUMBER(10,0)
> not null, other1 NUMBER(19,0), other3 NUMBER(19,0), foo VARCHAR2(255),
> primary key (id_))
> create table nuthasubclass (sid NUMBER(19,0) not null, extraProp
> VARCHAR2(255), other2 NUMBER(19,0), cal DATE, floaty FLOAT, primary key
> (sid))
> create table submulti (sid NUMBER(19,0) not null, amount FLOAT, parent
> NUMBER(19,0), primary key (sid))
> alter table subclass add constraint subclassFK0 foreign key (other1)
> references rootclass
> alter table subclass add constraint subclassFK1 foreign key (other3)
> references subclass
> alter table nuthasubclass add constraint nuthasubclassFK0 foreign key
> (other2) references nuthasubclass
> alter table submulti add constraint submultiFK0 foreign key (parent)
> references submulti
> alter table rootclass add constraint rootclassFK0 foreign key (parent)
> references subclass
> create index rootclassIDX1 on rootclass (parent)
> create sequence hibernate_sequence
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.sql.Dialect <init>
> INFO: Using dialect: cirrus.hibernate.sql.OracleDialect
> Nov 24, 2002 10:41:45 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Hibernate connection pool size: 2
> Nov 24, 2002 10:41:45 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Using driver: oracle.jdbc.driver.OracleDriver at URL:
> jdbc:oracle:thin:@snotslinger:1521:tower11
> Nov 24, 2002 10:41:45 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider configure
> INFO: Connection properties: {user=hibernate, password=hibernate}
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
> INFO: JDBC result set fetch size: 25
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
> INFO: Use outer join fetching: true
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
> INFO: Use scrollable result sets: true
> Nov 24, 2002 10:41:45 PM
> cirrus.hibernate.connection.DriverManagerConnectionProvider finalize
> INFO: Cleaning up dereferenced connection pool:
> jdbc:oracle:thin:@snotslinger:1521:tower11
> Nov 24, 2002 10:41:45 PM
> cirrus.hibernate.impl.SessionFactoryObjectFactory addInstance
> INFO: no JDNI name configured
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
> INFO: Query language substitutions: {no='N', true=1, yes='Y', false=0}
> Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
> INFO: Query language imports: cirrus.hibernate.test
> .Nov 24, 2002 10:41:46 PM cirrus.hibernate.helpers.JDBCExceptionReporter
> logExceptions
> WARNING: SQL Error: 1, SQLState: 23000
> Nov 24, 2002 10:41:46 PM cirrus.hibernate.helpers.JDBCExceptionReporter
> logExceptions
> SEVERE: ORA-00001: unique constraint (HIBERNATE.SYS_C005158) violated
>
> E.E.
> Time: 0.75
> There were 2 errors:
> 1)
>
testMultiTable(cirrus.hibernate.test.MultiTableTest)cirrus.hibernate.Hiberna
teException:
> More than one row with the given identifier was found: 123, for class:
> cirrus.hibernate.test.Multi
> at cirrus.hibernate.loader.EntityLoader.load(EntityLoader.java:73)
> at
>
cirrus.hibernate.persister.MultiTableEntityPersister.load(MultiTableEntityPe
rsister.java:553)
> at cirrus.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:1539)
> at
> cirrus.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1410)
> at cirrus.hibernate.impl.SessionImpl.load(SessionImpl.java:1348)
> at
>
cirrus.hibernate.test.MultiTableTest.testMultiTable(MultiTableTest.java:54)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
> at
>
com.intellij.rt.execution.junit.TextTestRunner.main(TextTestRunner.java:12)
> 2)
>
testMultiTableCollections(cirrus.hibernate.test.MultiTableTest)java.sql.SQLE
xception:
> ORA-00001: unique constraint (HIBERNATE.SYS_C005158) violated
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
> at
>
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047
)
> at
>
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
> at
>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2709)
> at
>
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
> at
>
cirrus.hibernate.persister.MultiTableEntityPersister.insert(MultiTableEntity
Persister.java:621)
> at
>
cirrus.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:20)
> at cirrus.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:1670)
> at cirrus.hibernate.impl.SessionImpl.execute(SessionImpl.java:1650)
> at cirrus.hibernate.impl.SessionImpl.flush(SessionImpl.java:1595)
> at
>
cirrus.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:51)
> at
>
cirrus.hibernate.test.MultiTableTest.testMultiTableCollections(MultiTableTes
t.java:139)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
> at
>
com.intellij.rt.execution.junit.TextTestRunner.main(TextTestRunner.java:12)
>
> FAILURES!!!
> Tests run: 3, Failures: 0, Errors: 2
>
> Process terminated with exit code -1
>
>
>
>
> Gavin King wrote:
>
> >Would someone please grab a CVS update and run FooBarTest and
MultiTableTest
> >on Oracle 9 and confirm that they are both now working....
> >
> >TIA
> >
> >Gavin
> >
> >
> >
> >-------------------------------------------------------
> >This sf.net email is sponsored by:ThinkGeek
> >Welcome to geek heaven.
> >http://thinkgeek.com/sf
> >_______________________________________________
> >hibernate-devel mailing list
> >[EMAIL PROTECTED]
> >https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> >
> >
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hibernate-devel mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
