Re: [Hibernate] Oracle users...

[Matt V. <mv...@ob...>]

Just ran the two tests against Oracle 9.2.01 on Win 2000.

FooBarTest =3D SUCCESS
MultiTableTest =3D FAILURE

MultiTableTest output:

D:\jdk1.4\bin\javaw.exe -classpath=20
G:\intellij\lib\junit.jar;D:\jdk1.4\jre\lib\charsets.jar;D:\jdk1.4\jre\li=
b\jaws.jar;D:\jdk1.4\jre\lib\jce.jar;D:\jdk1.4\jre\lib\jsse.jar;D:\jdk1.4=
\jre\lib\rt.jar;D:\jdk1.4\jre\lib\sunrsasign.jar;D:\jdk1.4\jre\lib\ext\dn=
sns.jar;D:\jdk1.4\jre\lib\ext\ldapsec.jar;D:\jdk1.4\jre\lib\ext\localedat=
a.jar;D:\jdk1.4\jre\lib\ext\sunjce_provider.jar;G:\projects\sourceforge\h=
ibernate\head\Hibernate\lib\commons-collections.jar;G:\projects\sourcefor=
ge\hibernate\head\Hibernate\lib\commons-dbcp.jar;G:\projects\sourceforge\=
hibernate\head\Hibernate\lib\commons-lang.jar;G:\projects\sourceforge\hib=
ernate\head\Hibernate\lib\commons-logging.jar;G:\projects\sourceforge\hib=
ernate\head\Hibernate\lib\commons-pool.jar;G:\projects\sourceforge\hibern=
ate\head\Hibernate\lib\j2ee.jar;G:\projects\sourceforge\hibernate\head\Hi=
bernate\lib\jcs.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\=
jdom.jar;G:\projects\sourceforge\hibernate\head\Hibernate\lib\junit.jar;G=
:\projects\sourceforge\hibernate\head\Hibernate\lib\odmg.jar;G:\projects\=
sourceforge\hibernate\head\Hibernate\lib\xalan.jar;G:\projects\sourceforg=
e\hibernate\head\Hibernate\lib\xerces.jar;G:\projects\sourceforge\hiberna=
te\head\Hibernate\lib\xml-apis.jar;G:\projects\sourceforge\hibernate\head=
\Hibernate\lib\cglib.jar;G:\projects\sourceforge\hibernate\head\Hibernate=
\lib\c3p0.jar;G:\projects\sourceforge\hibernate\head\Hibernate\build;G:\p=
rojects\sourceforge\hibernate\head\Hibernate;G:\projects\common-lib\ojdbc=
14.jar;G:\intellij\lib\idea_rt.jar=20
com.intellij.rt.execution.junit.TextTestRunner=20
cirrus.hibernate.test.MultiTableTest
Nov 24, 2002 10:41:41 PM cirrus.hibernate.impl.DatastoreImpl storeResourc=
e
INFO: Mapping resource: cirrus/hibernate/test/Multi.hbm.xml
Nov 24, 2002 10:41:42 PM cirrus.hibernate.helpers.XMLHelper parseInputSou=
rce
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=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 2
Nov 24, 2002 10:41:43 PM=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using driver: oracle.jdbc.driver.OracleDriver at URL:=20
jdbc:oracle:thin:@snotslinger:1521:tower11
Nov 24, 2002 10:41:43 PM=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Connection properties: {user=3Dhibernate, password=3Dhibernate}
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)=20
not null, name VARCHAR2(255), address VARCHAR2(255), date_ DATE, parent=20
NUMBER(19,0), primary key (id_))
create table subclass (id_ NUMBER(19,0) not null, intprop NUMBER(10,0)=20
not null, other1 NUMBER(19,0), other3 NUMBER(19,0), foo VARCHAR2(255),=20
primary key (id_))
create table nuthasubclass (sid NUMBER(19,0) not null, extraProp=20
VARCHAR2(255), other2 NUMBER(19,0), cal DATE, floaty FLOAT, primary key=20
(sid))
create table submulti (sid NUMBER(19,0) not null, amount FLOAT, parent=20
NUMBER(19,0), primary key (sid))
alter table subclass add constraint subclassFK0 foreign key (other1)=20
references rootclass
alter table subclass add constraint subclassFK1 foreign key (other3)=20
references subclass
alter table nuthasubclass add constraint nuthasubclassFK0 foreign key=20
(other2) references nuthasubclass
alter table submulti add constraint submultiFK0 foreign key (parent)=20
references submulti
alter table rootclass add constraint rootclassFK0 foreign key (parent)=20
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=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 2
Nov 24, 2002 10:41:45 PM=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using driver: oracle.jdbc.driver.OracleDriver at URL:=20
jdbc:oracle:thin:@snotslinger:1521:tower11
Nov 24, 2002 10:41:45 PM=20
cirrus.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Connection properties: {user=3Dhibernate, password=3Dhibernate}
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=20
cirrus.hibernate.connection.DriverManagerConnectionProvider finalize
INFO: Cleaning up dereferenced connection pool:=20
jdbc:oracle:thin:@snotslinger:1521:tower11
Nov 24, 2002 10:41:45 PM=20
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=3D'N', true=3D1, yes=3D'Y', false=
=3D0}
Nov 24, 2002 10:41:45 PM cirrus.hibernate.impl.SessionFactoryImpl <init>
INFO: Query language imports: cirrus.hibernate.test
=2ENov 24, 2002 10:41:46 PM cirrus.hibernate.helpers.JDBCExceptionReporte=
r=20
logExceptions
WARNING: SQL Error: 1, SQLState: 23000
Nov 24, 2002 10:41:46 PM cirrus.hibernate.helpers.JDBCExceptionReporter=20
logExceptions
SEVERE: ORA-00001: unique constraint (HIBERNATE.SYS_C005158) violated

E.E.
Time: 0.75
There were 2 errors:
1)=20
testMultiTable(cirrus.hibernate.test.MultiTableTest)cirrus.hibernate.Hibe=
rnateException:=20
More than one row with the given identifier was found: 123, for class:=20
cirrus.hibernate.test.Multi
    at cirrus.hibernate.loader.EntityLoader.load(EntityLoader.java:73)
    at=20
cirrus.hibernate.persister.MultiTableEntityPersister.load(MultiTableEntit=
yPersister.java:553)
    at cirrus.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:1539)
    at=20
cirrus.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1410)
    at cirrus.hibernate.impl.SessionImpl.load(SessionImpl.java:1348)
    at=20
cirrus.hibernate.test.MultiTableTest.testMultiTable(MultiTableTest.java:5=
4)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at=20
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
    at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
    at=20
com.intellij.rt.execution.junit.TextTestRunner.main(TextTestRunner.java:1=
2)
2)=20
testMultiTableCollections(cirrus.hibernate.test.MultiTableTest)java.sql.S=
QLException:=20
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=20
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
    at=20
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2=
047)
    at=20
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:19=
40)
    at=20
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
ava:2709)
    at=20
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedSt=
atement.java:589)
    at=20
cirrus.hibernate.persister.MultiTableEntityPersister.insert(MultiTableEnt=
ityPersister.java:621)
    at=20
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=20
cirrus.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:=
51)
    at=20
cirrus.hibernate.test.MultiTableTest.testMultiTableCollections(MultiTable=
Test.java:139)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at=20
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
    at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
    at=20
com.intellij.rt.execution.junit.TextTestRunner.main(TextTestRunner.java:1=
2)

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 MultiTable=
Test
>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
>hib...@li...
>https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
> =20
>