Have you set the dialect to Oracle9Dialect ?
/max
Hi, I am trying to build Hibernate 2.1 on windows 2000 using the database as Oracle 9i. The Hibernate2.jar has been successfully build. But all the tests are failing. The main reason for failing the test cases is that the SQL create queries fired by the tests are not compatible with the oracle 9i.
Test case run command: ant -Djdbc.driver=D:/oracle/ora90/jdbc/lib/classes12.jar junitreport)
From the log file (TEST-org.hibernate.test.ABCProxyTest.txt) of the test ABCProxyTest, It is clear that
1. Connection with the database has been established properly . 2. No create table SQL command fired by Tests is syntactically correct for oracle 9i .
eg:SQL command fired = "create table A (identifier_column number(19,0) not null, clazz_discriminata number(10,0), name long, forward number(19,0), count_ number(10,0), c1 long, c number(19,0), c2 long, primary key (identifier_column)) "
Oracle error: "ORA-01754: a table may contain only one column of type LONG"
I am giving some of the logs of the test case, please have a look.
Thanks in advance for solution,
Tarun.
Logs =====================
Testsuite: org.hibernate.test.ABCProxyTest
Tests run: 6, Failures: 0, Errors: 6, Time elapsed: 5.031 sec
------------- Standard Output ---------------
12:21:19,031 INFO Environment:478 - Hibernate 2.1.7
12:21:19,046 INFO Environment:512 - loaded properties from resource
hibernate.properties:
{hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver,
hibernate.cglib.use_reflection_optimizer=true,
hibernate.cache.provider_class=net.sf.hibernate.cache.EhCacheProvider,
hibernate.cache.use_query_cache=true, hibernate.max_fetch_depth=1,
hibernate.dialect=net.sf.hibernate.dialect.OracleDialect,
hibernate.jdbc.use_streams_for_binary=true,
hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1,
false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1,
hibernate.connection.username=system,
hibernate.cache.region_prefix=hibernate.test,
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:test,
hibernate.connection.password=manager,
hibernate.jdbc.batch_versioned_data=true,
hibernate.connection.pool_size=1}
12:21:19,046 INFO Environment:537 - using java.io streams to persist
binary types
12:21:19,046 INFO Environment:538 - using CGLIB reflection optimizer
12:21:19,046 INFO Environment:567 - using JDK 1.4 java.sql.Timestamp handling
12:21:19,062 INFO Configuration:314 - Mapping resource:
org/hibernate/test/ABCProxy.hbm.xml
12:21:19,328 INFO Binder:230 - Mapping class: org.hibernate.test.A -> A
12:21:19,453 INFO Binder:170 - Mapping subclass: org.hibernate.test.B -> A
12:21:19,453 INFO Binder:572 - Mapping collection:
org.hibernate.test.B.map -> map
12:21:19,468 INFO Binder:170 - Mapping subclass: org.hibernate.test.C1 -> A
12:21:19,484 INFO Binder:170 - Mapping subclass: org.hibernate.test.C2 -> A
12:21:19,484 INFO Binder:230 - Mapping class: org.hibernate.test.D -> D
12:21:19,484 INFO Binder:230 - Mapping class: org.hibernate.test.E -> E
12:21:19,515 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:19,515 INFO Configuration:632 - processing one-to-many
association mappings
12:21:19,515 INFO Binder:1182 - Mapping collection:
org.hibernate.test.C1.c2s -> A
12:21:19,515 INFO Binder:1182 - Mapping collection:
org.hibernate.test.C2.c1s -> A
12:21:19,531 INFO Configuration:641 - processing one-to-one
association property references
12:21:19,531 INFO Configuration:666 - processing foreign key constraints
12:21:19,531 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:19,546 INFO SettingsFactory:70 - Maximim outer join fetch depth: 1
12:21:19,546 INFO SettingsFactory:74 - Use outer join fetching: true
12:21:19,546 INFO DriverManagerConnectionProvider:42 - Using
Hibernate built-in connection pool (not for production use!)
12:21:19,546 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 1
12:21:19,562 INFO DriverManagerConnectionProvider:77 - using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:test
12:21:19,562 INFO DriverManagerConnectionProvider:78 - connection
properties: {user=system, password=manager}
12:21:19,562 INFO TransactionManagerLookupFactory:33 - No
TransactionManagerLookup configured (in JTA environment, use of
process level read-write cache is not recommended)
12:21:19,859 INFO SettingsFactory:114 - Use scrollable result sets: true
12:21:19,859 INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(): false
12:21:19,859 INFO SettingsFactory:120 - Optimize cache for minimal puts: false
12:21:19,859 INFO SettingsFactory:129 - Query language substitutions:
{no='N', true=1, yes='Y', false=0}
12:21:19,859 INFO SettingsFactory:140 - cache provider:
net.sf.hibernate.cache.EhCacheProvider
12:21:19,875 INFO SettingsFactory:152 - query cache factory:
net.sf.hibernate.cache.StandardQueryCacheFactory
12:21:19,875 INFO Configuration:1121 - instantiating and configuring caches
12:21:19,906 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.E. Configuring using the
defaultCache settings.
12:21:19,906 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.B.map. Configuring using the
defaultCache settings.
12:21:19,906 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.C2.c1s. Configuring using the
defaultCache settings.
12:21:19,921 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.D. Configuring using the
defaultCache settings.
12:21:19,921 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.A. Configuring using the
defaultCache settings.
12:21:19,921 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.C1.c2s. Configuring using the
defaultCache settings.
12:21:20,015 INFO SessionFactoryImpl:119 - building session factory
12:21:20,531 INFO SessionFactoryObjectFactory:82 - Not binding
factory to JNDI, no JNDI name configured
12:21:20,546 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:20,546 INFO Configuration:632 - processing one-to-many
association mappings
12:21:20,546 INFO Configuration:641 - processing one-to-one
association property references
12:21:20,546 INFO Configuration:666 - processing foreign key constraints
12:21:20,546 INFO Configuration:632 - processing one-to-many
association mappings
12:21:20,546 INFO Configuration:641 - processing one-to-one
association property references
12:21:20,546 INFO Configuration:666 - processing foreign key constraints
12:21:20,546 INFO SchemaExport:98 - Running hbm2ddl schema export
12:21:20,546 INFO SchemaExport:117 - exporting generated schema to database
12:21:20,546 INFO DriverManagerConnectionProvider:42 - Using
Hibernate built-in connection pool (not for production use!)
12:21:20,546 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 1
12:21:20,546 INFO DriverManagerConnectionProvider:77 - using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:test
12:21:20,546 INFO DriverManagerConnectionProvider:78 - connection
properties: {user=system, password=manager}
12:21:20,578 DEBUG SchemaExport:132 - alter table A drop constraint
FK4163EFC66504
12:21:20,640 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK4163EFC66504
12:21:20,640 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,640 DEBUG SchemaExport:132 - alter table A drop constraint FK41D7A392C5
12:21:20,656 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK41D7A392C5
12:21:20,656 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,656 DEBUG SchemaExport:132 - alter table A drop constraint FK4163
12:21:20,656 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK4163
12:21:20,656 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,656 DEBUG SchemaExport:132 - alter table map drop constraint
FK1A55C100DD
12:21:20,656 DEBUG SchemaExport:137 - Unsuccessful: alter table map
drop constraint FK1A55C100DD
12:21:20,656 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,656 DEBUG SchemaExport:132 - drop table D cascade constraints
12:21:20,656 DEBUG SchemaExport:137 - Unsuccessful: drop table D
cascade constraints
12:21:20,656 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,656 DEBUG SchemaExport:132 - drop table A cascade constraints
12:21:20,671 DEBUG SchemaExport:137 - Unsuccessful: drop table A
cascade constraints
12:21:20,671 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,671 DEBUG SchemaExport:132 - drop table map cascade constraints
12:21:20,671 DEBUG SchemaExport:137 - Unsuccessful: drop table map
cascade constraints
12:21:20,671 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,671 DEBUG SchemaExport:132 - drop table E cascade constraints
12:21:20,671 DEBUG SchemaExport:137 - Unsuccessful: drop table E
cascade constraints
12:21:20,671 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,671 DEBUG SchemaExport:149 - create table D ( id number(19,0) not null, amount float, primary key (id) ) 12:21:20,703 DEBUG SchemaExport:149 - create table A ( identifier_column number(19,0) not null, clazz_discriminata number(10,0), name long, forward number(19,0), count_ number(10,0), c1 long, c number(19,0), c2 long, primary key (identifier_column) ) 12:21:20,703 ERROR SchemaExport:154 - Unsuccessful: create table A (identifier_column number(19,0) not null, clazz_discriminata number(10,0), name long, forward number(19,0), count_ number(10,0), c1 long, c number(19,0), c2 long, primary key (identifier_column)) 12:21:20,703 ERROR SchemaExport:155 - ORA-01754: a table may contain only one column of type LONG
12:21:20,703 DEBUG SchemaExport:149 - create table map ( BID number(19,0) not null, MAPVAL number(10,0), MAPKEY long not null, primary key (BID, MAPKEY) ) 12:21:20,703 ERROR SchemaExport:154 - Unsuccessful: create table map (BID number(19,0) not null, MAPVAL number(10,0), MAPKEY long not null, primary key (BID, MAPKEY)) 12:21:20,703 ERROR SchemaExport:155 - ORA-02269: key column cannot be of LONG datatype
12:21:20,703 DEBUG SchemaExport:149 - create table E (
id number(19,0) not null,
amount float,
primary key (id)
)
12:21:20,718 DEBUG SchemaExport:149 - alter table A add constraint
FK4163EFC66504 foreign key (c) references A
12:21:20,734 ERROR SchemaExport:154 - Unsuccessful: alter table A add
constraint FK4163EFC66504 foreign key (c) references A
12:21:20,734 ERROR SchemaExport:155 - ORA-00942: table or view does not exist
12:21:20,734 DEBUG SchemaExport:149 - alter table A add constraint
FK41D7A392C5 foreign key (forward) references E
12:21:20,734 ERROR SchemaExport:154 - Unsuccessful: alter table A add
constraint FK41D7A392C5 foreign key (forward) references E
12:21:20,734 ERROR SchemaExport:155 - ORA-00942: table or view does not exist
12:21:20,734 DEBUG SchemaExport:149 - alter table A add constraint
FK4163 foreign key (c) references A
12:21:20,734 ERROR SchemaExport:154 - Unsuccessful: alter table A add
constraint FK4163 foreign key (c) references A
12:21:20,734 ERROR SchemaExport:155 - ORA-00942: table or view does not exist
12:21:20,734 DEBUG SchemaExport:149 - alter table map add constraint
FK1A55C100DD foreign key (BID) references A
12:21:20,750 ERROR SchemaExport:154 - Unsuccessful: alter table map
add constraint FK1A55C100DD foreign key (BID) references A
12:21:20,750 ERROR SchemaExport:155 - ORA-00942: table or view does not exist
12:21:20,750 INFO SchemaExport:160 - schema export complete
12:21:20,750 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:oracle:thin:@localhost:1521:test
12:21:20,750 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:20,750 INFO Configuration:632 - processing one-to-many
association mappings
12:21:20,750 INFO Configuration:641 - processing one-to-one
association property references
12:21:20,750 INFO Configuration:666 - processing foreign key constraints
12:21:20,750 INFO Configuration:632 - processing one-to-many
association mappings
12:21:20,750 INFO Configuration:641 - processing one-to-one
association property references
12:21:20,750 INFO Configuration:666 - processing foreign key constraints
12:21:20,750 INFO UpdateTimestampsCache:35 - starting update
timestamps cache at region:
net.sf.hibernate.cache.UpdateTimestampsCache
12:21:20,750 WARN EhCache:94 - Could not find configuration for
net.sf.hibernate.cache.UpdateTimestampsCache. Configuring using the
defaultCache settings.
12:21:20,750 INFO StandardQueryCache:41 - starting query cache at
region: net.sf.hibernate.cache.StandardQueryCache
12:21:20,765 WARN EhCache:94 - Could not find configuration for
net.sf.hibernate.cache.StandardQueryCache. Configuring using the
defaultCache settings.
12:21:20,859 WARN JDBCExceptionReporter:57 - SQL Error: 942, SQLState: 42000
12:21:20,859 ERROR JDBCExceptionReporter:58 - ORA-00942: table or view
does not exist
12:21:20,875 WARN JDBCExceptionReporter:57 - SQL Error: 942, SQLState: 42000
12:21:20,875 ERROR JDBCExceptionReporter:58 - ORA-00942: table or view
does not exist
12:21:20,875 INFO SessionFactoryImpl:540 - closing
12:21:20,875 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:oracle:thin:@localhost:1521:test
12:21:20,875 INFO SchemaExport:98 - Running hbm2ddl schema export
12:21:20,875 INFO SchemaExport:117 - exporting generated schema to database
12:21:20,875 INFO DriverManagerConnectionProvider:42 - Using
Hibernate built-in connection pool (not for production use!)
12:21:20,875 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 1
12:21:20,875 INFO DriverManagerConnectionProvider:77 - using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:test
12:21:20,875 INFO DriverManagerConnectionProvider:78 - connection
properties: {user=system, password=manager}
12:21:20,906 DEBUG SchemaExport:132 - alter table A drop constraint
FK4163EFC66504
12:21:20,968 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK4163EFC66504
12:21:20,968 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,968 DEBUG SchemaExport:132 - alter table A drop constraint FK41D7A392C5
12:21:20,968 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK41D7A392C5
12:21:20,968 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,968 DEBUG SchemaExport:132 - alter table A drop constraint FK4163
12:21:20,968 DEBUG SchemaExport:137 - Unsuccessful: alter table A drop
constraint FK4163
12:21:20,968 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,968 DEBUG SchemaExport:132 - alter table map drop constraint
FK1A55C100DD
12:21:20,968 DEBUG SchemaExport:137 - Unsuccessful: alter table map
drop constraint FK1A55C100DD
12:21:20,968 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:20,968 DEBUG SchemaExport:132 - drop table D cascade constraints
12:21:21,062 DEBUG SchemaExport:132 - drop table A cascade constraints
12:21:21,062 DEBUG SchemaExport:137 - Unsuccessful: drop table A
cascade constraints
12:21:21,062 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:21,062 DEBUG SchemaExport:132 - drop table map cascade constraints
12:21:21,062 DEBUG SchemaExport:137 - Unsuccessful: drop table map
cascade constraints
12:21:21,062 DEBUG SchemaExport:138 - ORA-00942: table or view does not exist
12:21:21,062 DEBUG SchemaExport:132 - drop table E cascade constraints
12:21:21,125 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:oracle:thin:@localhost:1521:test
12:21:21,140 INFO SchemaExport:160 - schema export complete
12:21:21,140 INFO DriverManagerConnectionProvider:143 - cleaning up
connection pool: jdbc:oracle:thin:@localhost:1521:test
12:21:21,156 INFO Configuration:314 - Mapping resource:
org/hibernate/test/ABCProxy.hbm.xml
12:21:21,203 INFO Binder:230 - Mapping class: org.hibernate.test.A -> A
12:21:21,203 INFO Binder:170 - Mapping subclass: org.hibernate.test.B -> A
12:21:21,203 INFO Binder:572 - Mapping collection:
org.hibernate.test.B.map -> map
12:21:21,203 INFO Binder:170 - Mapping subclass: org.hibernate.test.C1 -> A
12:21:21,203 INFO Binder:170 - Mapping subclass: org.hibernate.test.C2 -> A
12:21:21,203 INFO Binder:230 - Mapping class: org.hibernate.test.D -> D
12:21:21,203 INFO Binder:230 - Mapping class: org.hibernate.test.E -> E
12:21:21,203 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:21,203 INFO Configuration:632 - processing one-to-many
association mappings
12:21:21,203 INFO Binder:1182 - Mapping collection:
org.hibernate.test.C1.c2s -> A
12:21:21,203 INFO Binder:1182 - Mapping collection:
org.hibernate.test.C2.c1s -> A
12:21:21,203 INFO Configuration:641 - processing one-to-one
association property references
12:21:21,203 INFO Configuration:666 - processing foreign key constraints
12:21:21,203 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:21,203 INFO SettingsFactory:70 - Maximim outer join fetch depth: 1
12:21:21,203 INFO SettingsFactory:74 - Use outer join fetching: true
12:21:21,203 INFO DriverManagerConnectionProvider:42 - Using
Hibernate built-in connection pool (not for production use!)
12:21:21,203 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 1
12:21:21,203 INFO DriverManagerConnectionProvider:77 - using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:test
12:21:21,203 INFO DriverManagerConnectionProvider:78 - connection
properties: {user=system, password=manager}
12:21:21,203 INFO TransactionManagerLookupFactory:33 - No
TransactionManagerLookup configured (in JTA environment, use of
process level read-write cache is not recommended)
12:21:21,234 INFO SettingsFactory:114 - Use scrollable result sets: true
12:21:21,234 INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(): false
12:21:21,234 INFO SettingsFactory:120 - Optimize cache for minimal puts: false
12:21:21,234 INFO SettingsFactory:129 - Query language substitutions:
{no='N', true=1, yes='Y', false=0}
12:21:21,234 INFO SettingsFactory:140 - cache provider:
net.sf.hibernate.cache.EhCacheProvider
12:21:21,234 INFO SettingsFactory:152 - query cache factory:
net.sf.hibernate.cache.StandardQueryCacheFactory
12:21:21,234 INFO Configuration:1121 - instantiating and configuring caches
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.E. Configuring using the
defaultCache settings.
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.B.map. Configuring using the
defaultCache settings.
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.C2.c1s. Configuring using the
defaultCache settings.
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.D. Configuring using the
defaultCache settings.
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.A. Configuring using the
defaultCache settings.
12:21:21,234 WARN EhCache:94 - Could not find configuration for
hibernate.test.org.hibernate.test.C1.c2s. Configuring using the
defaultCache settings.
12:21:21,234 INFO SessionFactoryImpl:119 - building session factory
12:21:21,281 INFO SessionFactoryObjectFactory:82 - Not binding
factory to JNDI, no JNDI name configured
12:21:21,281 INFO Dialect:86 - Using dialect:
net.sf.hibernate.dialect.OracleDialect
12:21:21,281 INFO Configuration:632 - processing one-to-many
association mappings
12:21:21,281 INFO Configuration:641 - processing one-to-one
association property references
12:21:21,281 INFO Configuration:666 - processing foreign key constraints
12:21:21,281 INFO Configuration:632 - processing one-to-many
association mappings
12:21:21,281 INFO Configuration:641 - processing one-to-one
association property references
12:21:21,281 INFO Configuration:666 - processing foreign key constraints
12:21:21,281 INFO SchemaExport:98 - Running hbm2ddl schema export
12:21:21,281 INFO SchemaExport:117 - exporting generated schema to database
12:21:21,281 INFO DriverManagerConnectionProvider:42 - Using
Hibernate built-in connection pool (not for production use!)
12:21:21,281 INFO DriverManagerConnectionProvider:43 - Hibernate
connection pool size: 1
12:21:21,281 INFO DriverManagerConnectionProvider:77 - using driver:
oracle.jdbc.driver.OracleDriver at URL:
jdbc:oracle:thin:@localhost:1521:test
12:21:21,281 INFO DriverManagerConnectionProvider:78 - connection
properties: {user=system, password=manager}
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-- Max Rydahl Andersen callto://max.rydahl.andersen
Hibernate [EMAIL PROTECTED] http://hibernate.org
JBoss Inc [EMAIL PROTECTED] http://jboss.com
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
