When I use the *<![CDATA[jdbc:hsqldb:file:src/test/resources/sql/testdb]]>*I
get this error:
*[INFO] Error executing database operation: CLEAN_INSERT
Embedded error: The database is already in use by another process:
[EMAIL PROTECTED]
=C:\opt\temp\appfuse\myproject\co
re\src\test\resources\sql\testdb.lck, exists=true, locked=false,
valid=false, fl =null]: java.lang.Exception: java.io.IOException: The
process c
annot access the file because another process has locked a portion of the
file : C:\opt\temp\appfuse\myproject\core\src\test\resources\sql\testdb
.lck
*
Then I used *
<![CDATA[jdbc:hsqldb:file:src/test/resources/sql/testdb;shutdown=true]]>*and
got this error:
*<![CDATA[org.dbunit.dataset.NoSuchTableException: role
at
org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:223)
at
org.dbunit.operation.AbstractOperation.getOperationMetaData(AbstractOperation.java:73)
*
Now when I look at the tesdb.log I see this:
*/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C1*/drop table if exists user_role
create table user_role (user_id bigint not null, role_id bigint not null,
primary key (user_id, role_id))
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-1
INSERT INTO ROLE VALUES(-1,1,'Administrator role (can edit
Users)','ROLE_ADMIN Gak')
COMMIT
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-1
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-2
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-3
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=4
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM APP_USER WHERE ID=-1
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
SET AUTOCOMMIT TRUE
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=4
COMMIT
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-1
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-2
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-3
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
SET AUTOCOMMIT TRUE
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
SET AUTOCOMMIT FALSE
DELETE FROM APP_USER WHERE ID=-1
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
SET AUTOCOMMIT TRUE
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
DELETE FROM USER_ROLE WHERE USER_ID=-2 AND ROLE_ID=-1
DELETE FROM USER_ROLE WHERE USER_ID=-1 AND ROLE_ID=-2
DELETE FROM APP_USER WHERE ID=-1
DELETE FROM ROLE WHERE ID=-3
DELETE FROM ROLE WHERE ID=-2
DELETE FROM ROLE WHERE ID=-1
DELETE FROM ROLE WHERE ID=4
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
INSERT INTO USER_ROLE VALUES(-1,-2)
INSERT INTO USER_ROLE VALUES(-2,-1)
SET AUTOCOMMIT FALSE
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-1
INSERT INTO ROLE VALUES(-1,0,'Administrator role (can edit
Users)','ROLE_ADMIN')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-2
INSERT INTO ROLE VALUES(-2,0,'Default role for all Users','ROLE_USER')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=-3
INSERT INTO ROLE VALUES(-3,0,'Test role for Test Users','ROLE_TEST')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM ROLE WHERE ID=4
INSERT INTO ROLE VALUES(4,0,'Another Test Role','ANOTHER_ROLE')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM APP_USER WHERE ID=-1
INSERT INTO APP_USER
VALUES(-1,1,NULL,'[EMAIL
PROTECTED]','Mick','Knutson',NULL,'1234','base454','(415)
555-1212','mickknutson','http://baselogic.com',-1)
SET AUTOCOMMIT TRUE
/*C3*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C4*/SET SCHEMA PUBLIC
CONNECT USER SA
drop table if exists app_user
drop table if exists role
drop table if exists user_role
create table user_role (user_id bigint not null, role_id bigint not null,
primary key (user_id, role_id))
SET AUTOCOMMIT FALSE
DELETE FROM ADDRESS WHERE ID=-1
INSERT INTO ADDRESS VALUES(-1,1,'725 Florida Street #5','San
Francisco','US','94110','CA')
SET AUTOCOMMIT TRUE
/*C5*/SET SCHEMA PUBLIC
CONNECT USER SA
drop table if exists address
drop table if exists app_user
drop table if exists role
drop table if exists user_role
create table user_role (user_id bigint not null, role_id bigint not null,
primary key (user_id, role_id))
*
It seems that it is suppose to be working, but the test are failing.
On Mon, Apr 28, 2008 at 4:18 PM, Adam Hardy <[EMAIL PROTECTED]>
wrote:
> Sorry. I keep confusing them. HSQL is also known as Hypersonic. Can be
> confusing. But have you checked out whether the schema creation really
> occurs and then gets lost, or whether it just never happens?
>
> Try the JDBC params such as default_schema=true
>
> or try a file db instead of in-memory e.g.
>
> jdbc:hsqldb:file:src/test/resources/sql/testdb
>
>
> Mick Knutson on 29/04/08 00:06, wrote:
>
> > I do not have any issues with h2 and it is working fairly good. But HSQL
> > does not work.
> >
> > Will this parameter work on HSQL as well?
> >
> >
> > On Mon, Apr 28, 2008 at 3:50 PM, Adam Hardy <
> > [EMAIL PROTECTED]>
> > wrote:
> >
> > Hi Mick,
> > >
> > > have you tried using the param on the end of the JDBC URL like this:
> > >
> > > jdbc:h2:mem:test_db;DB_CLOSE_DELAY=-1
> > >
> > > it might be the case that hibernate is using seperate connections to
> > > build
> > > the schema and then access it - in which case H2 can just drop
> > > everything.
> > >
> > >
> > >
> > > Mick Knutson on 27/04/08 16:39, wrote:
> > >
> > > I ran through this entire chapter. There was nothing new to what I
> > > > was
> > > > already doing. As I stated, everything works fine in MySql. The
> > > > tables
> > > > get
> > > > created, then the data gets populated, then the dbunit tests get
> > > > run
> > > > just
> > > > fine. No issues.
> > > >
> > > > But when I move to hsql, the sql file from the hibernate plugin gets
> > > > generated, but I get several different failures now.
> > > >
> > > > *1. When I use the <drop>false</drop>, the import.sql that is
> > > > generated
> > > > does
> > > > not have table drop statements, thus I get this error:*
> > > > *[myproject] ERROR [main] SchemaExport.execute(202) | schema export
> > > > unsuccessful
> > > > org.hibernate.JDBCException: Error during import script execution
> > > > at
> > > >
> > > >
> > > > org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:258)
> > > > at
> > > >
> > > > org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192)
> > > > at
> > > >
> > > > org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
> > > > at
> > > >
> > > >
> > > > org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:311)
> > > > ...
> > > > Caused by: java.sql.SQLException: Table already exists: USER_ROLE in
> > > > statement [create table user_role]
> > > > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> > > > at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> > > > at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> > > > at
> > > >
> > > >
> > > > com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
> > > > at
> > > >
> > > >
> > > > org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)
> > > > *
> > > >
> > > >
> > > > *2. When I use the <drop>true</drop> my iport.sql that gets
> > > > generated
> > > > starts
> > > > like:*
> > > > *alter table app_user drop constraint FK459C57294AD68248;
> > > > alter table user_role drop constraint FK143BF46AE8EA6EF6;
> > > > alter table user_role drop constraint FK143BF46A43BFAB16;
> > > > drop table address if exists;
> > > > drop table app_user if exists;
> > > > drop table role if exists;
> > > > drop table user_role if exists;*
> > > >
> > > > *But then I get this error:*
> > > > *Caused by: java.sql.SQLException: Table not found: APP_USER in
> > > > statement
> > > > [alter table app_user]
> > > > at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> > > > at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> > > > at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> > > > at
> > > >
> > > >
> > > > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> > > > at
> > > >
> > > >
> > > > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> > > > at
> > > >
> > > >
> > > > org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)*
> > > >
> > > > So it appears the sql that is generated is failing. The app_user
> > > > table
> > > > does
> > > > not exist because this is a memory db right?
> > > >
> > > > *Then I tried to just scale everything back to what you had, but
> > > > adding
> > > > execution phase like:*
> > > > *<plugin>
> > > > <groupId>org.codehaus.mojo</groupId>
> > > > <artifactId>hibernate3-maven-plugin</artifactId>
> > > > <version>2.1</version>
> > > > <configuration>
> > > > <components>
> > > > <component>
> > > > <name>hbm2ddl</name>
> > > >
> > > > <implementation>annotationconfiguration</implementation>
> > > > </component>
> > > > </components>
> > > > </configuration>
> > > > <executions>
> > > > <execution>
> > > > <id>hbm2ddl</id>
> > > > <phase>process-test-resources</phase>
> > > > <goals>
> > > > <goal>hbm2ddl</goal>
> > > > </goals>
> > > > </execution>
> > > > </executions>
> > > > <dependencies>
> > > > <dependency>
> > > > <groupId>${jdbc.groupId}</groupId>
> > > > <artifactId>${jdbc.artifactId}</artifactId>
> > > > <version>${jdbc.version}</version>
> > > > </dependency>
> > > > </dependencies>
> > > > </plugin>
> > > > *
> > > > *
> > > > and I still get:*
> > > >
> > > > *[myproject] DEBUG [main] RoleDaoJpaTest.prepareDataSet(34) |
> > > > Invoked
> > > > prepareDataSet()
> > > > [myproject] INFO [main] RoleDaoJpaTest.toString(168) |
> > > > ==========================================================
> > > > [myproject] INFO [main] RoleDaoJpaTest.toString(169) | package
> > > > org.dbunit.dataset.class org.dbunit.dataset.ReplacementDataSet
> > > > [myproject] INFO [main] RoleDaoJpaTest.toString(170) |
> > > > ==========================================================
> > > > [myproject] INFO [main] RoleDaoJpaTest.toString(171) |
> > > > [EMAIL PROTECTED]
> > > > _dataSet=[address, role, app_user, user_role]
> > > > _objectMap={}
> > > > _substringMap={}
> > > > _startDelim=<null>
> > > > _endDelim=<null>
> > > > ]
> > > > [myproject] INFO [main] RoleDaoJpaTest.toString(177) |
> > > > ==========================================================
> > > > [myproject] DEBUG [main] RoleDaoJpaTest.loadSeedData(73) | Exception
> > > > in
> > > > initializing database
> > > > org.dbunit.dataset.NoSuchTableException: address
> > > > org.dbunit.dataset.NoSuchTableException: address
> > > > at
> > > >
> > > >
> > > > org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:223)
> > > > at
> > > >
> > > >
> > > > org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:223)
> > > > *
> > > >
> > > >
> > > > Then looking around, it seems to be failing like:
> > > >
> > > > *[myproject] INFO [main] SchemaExport.execute(154) | Running hbm2ddl
> > > > schema
> > > > export
> > > > [myproject] DEBUG [main] SchemaExport.execute(170) | import file not
> > > > found:
> > > > /import.sql
> > > > [myproject] INFO [main] SchemaExport.execute(179) | exporting
> > > > generated
> > > > schema to database
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > app_user
> > > > drop foreign key FK459C57294AD68248
> > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > alter
> > > > table
> > > > app_user drop foreign key FK459C57294AD68248
> > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Table not found:
> > > > APP_USER
> > > > in statement [alter table app_user]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > user_role
> > > > drop foreign key FK143BF46AE8EA6EF6
> > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > alter
> > > > table
> > > > user_role drop foreign key FK143BF46AE8EA6EF6
> > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Column not found:
> > > > FOREIGN
> > > > in statement [alter table user_role drop foreign]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > user_role
> > > > drop foreign key FK143BF46A43BFAB16
> > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > alter
> > > > table
> > > > user_role drop foreign key FK143BF46A43BFAB16
> > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Column not found:
> > > > FOREIGN
> > > > in statement [alter table user_role drop foreign]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table if
> > > > exists
> > > > address
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table if
> > > > exists
> > > > app_user
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table if
> > > > exists
> > > > role
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table if
> > > > exists
> > > > user_role
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > address
> > > > (id bigint not null auto_increment, version integer, address
> > > > varchar(25)
> > > > not
> > > > null, city varchar(25) not null, country varchar(2) not null,
> > > > postal_code
> > > > varchar(25) not null, province varchar(25) not null, primary
> > > > key(id))
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > create
> > > > table address (id bigint not null auto_increment, version integer,
> > > > address
> > > > varchar(25) not null, city varchar(25) not null, country varchar(2)
> > > > not
> > > > null, postal_code varchar(25) not null, province varchar(25) not
> > > > null,
> > > > primary key (id))
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Unexpected
> > > > token:
> > > > AUTO_INCREMENT in statement [create table address (id bigint not
> > > > null
> > > > auto_increment]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > app_user
> > > > (id bigint not null auto_increment, version integer, confirmPassword
> > > > varchar(255), email varchar(50) not null, first_name varchar(50) not
> > > > null,
> > > > last_name varchar(50) not null, middle_name varchar(50), password
> > > > varchar(100) not null, password_hint varchar(50), phone_number
> > > > varchar(25),
> > > > username varchar(25) not null, website varchar(50), address_fk
> > > > bigint,
> > > > primary key (id))
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > create
> > > > table app_user (id bigint not null auto_increment, version integer,
> > > > confirmPassword varchar(255), email varchar(50) not null, first_name
> > > > varchar(50) not null, last_name varchar(50) not null, middle_name
> > > > varchar(50), password varchar(100) not null, password_hint
> > > > varchar(50),
> > > > phone_number varchar(25), username varchar(25) not null, website
> > > > varchar(50), address_fk bigint, primary key (id))
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Unexpected
> > > > token:
> > > > AUTO_INCREMENT in statement [create table app_user (id bigint not
> > > > null
> > > > auto_increment]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > role
> > > > (id
> > > > bigint not null auto_increment, version integer, description
> > > > varchar(255)
> > > > not null, name varchar(64) not null, primary key (id))
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > create
> > > > table role (id bigint not null auto_increment, version integer,
> > > > description
> > > > varchar(255) not null, name varchar(64) not null, primary key (id))
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Unexpected
> > > > token:
> > > > AUTO_INCREMENT in statement [create table role (id bigint not null
> > > > auto_increment]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > user_role
> > > > (user_id bigint not null, role_id bigint not null, primary key
> > > > (user_id,
> > > > role_id))
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > app_user
> > > > add index FK459C57294AD68248 (address_fk), add constraint
> > > > FK459C57294AD68248
> > > > foreign key (address_fk) references address (id)
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > alter
> > > > table app_user add index FK459C57294AD68248 (address_fk), add
> > > > constraintFK459C57294AD68248 foreign key (address_fk) references
> > > > address
> > > > (id)
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Table not found:
> > > > APP_USER in statement [alter table app_user]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > user_role
> > > > add index FK143BF46AE8EA6EF6 (user_id), add constraint
> > > > FK143BF46AE8EA6EF6
> > > > foreign key (user_id) references app_user (id)
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > alter
> > > > table user_role add index FK143BF46AE8EA6EF6 (user_id), add
> > > > constraint
> > > > FK143BF46AE8EA6EF6 foreign key (user_id) references app_user (id)
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Wrong data type:
> > > > FK143BF46AE8EA6EF6 in statement [alter table user_role add index
> > > > FK143BF46AE8EA6EF6]
> > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > user_role
> > > > add index FK143BF46A43BFAB16 (role_id), add constraint
> > > > FK143BF46A43BFAB16
> > > > foreign key (role_id) references role (id)
> > > > [myproject] ERROR [main] SchemaExport.create(274) | Unsuccessful:
> > > > alter
> > > > table user_role add index FK143BF46A43BFAB16 (role_id), add
> > > > constraint
> > > > FK143BF46A43BFAB16 foreign key (role_id) references role (id)
> > > > [myproject] ERROR [main] SchemaExport.create(275) | Wrong data type:
> > > > FK143BF46A43BFAB16 in statement [alter table user_role add index
> > > > FK143BF46A43BFAB16]
> > > > [myproject] INFO [main] SchemaExport.execute(196) | schema export
> > > > complete
> > > > [myproject] DEBUG [main] SessionFactoryImpl.checkNamedQueries(392) |
> > > > Checking 1 named HQL queries
> > > > [myproject] DEBUG [main] SessionFactoryImpl.checkNamedQueries(400) |
> > > > Checking named query: User-byRole
> > > > [myproject] DEBUG [main] QueryTranslatorImpl.parse(246) | parse() -
> > > > HQL:
> > > > select u from com.baselogic.domain.User u where (select r from
> > > > com.baselogic.domain.Role r where r.name = :roleName) in elements
> > > > (u.roles)
> > > > *
> > > >
> > > >
> > > >
> > > > On Sun, Apr 27, 2008 at 7:12 AM, Brian E. Fox <
> > > > [EMAIL PROTECTED]>
> > > > wrote:
> > > >
> > > > Chapter 7 of Maven: The Definitive Guide shows a multimodule
> > > > example
> > > >
> > > > > that happens to use Hibernate: http://www.sonatype.com/book
> > > > >
> > > > > -----Original Message-----
> > > > > From: Mick Knutson [mailto:[EMAIL PROTECTED]
> > > > > Sent: Saturday, April 26, 2008 10:11 AM
> > > > > To: maven
> > > > > Subject: [m2] can't get hibernate plugin to work with hsql
> > > > >
> > > > > zI am trying to run hibernate to generate sql, populate my db and
> > > > > then
> > > > > run
> > > > > some tests.
> > > > > Well, if I use MySql, I do not have any issues at all. But when I
> > > > > switch
> > > > > to
> > > > > hsql, i can't get the databasse tables to be created, then I get a
> > > > > table
> > > > > not
> > > > > exist error in dbunit.
> > > > >
> > > > > Here is my hibernate plugin:
> > > > > <plugin>
> > > > > <groupId>org.codehaus.mojo</groupId>
> > > > > <artifactId>hibernate3-maven-plugin</artifactId>
> > > > > <version>2.1</version>
> > > > > <configuration>
> > > > > <components>
> > > > > <component>
> > > > > <name>hbm2ddl</name>
> > > > >
> > > > > <implementation>annotationconfiguration</implementation>
> > > > > </component>
> > > > > <component>
> > > > > <name>hbm2hbmxml</name>
> > > > >
> > > > > <outputDirectory>src/main/resources</outputDirectory>
> > > > > </component>
> > > > > </components>
> > > > > <componentProperties>
> > > > > <drop>true</drop>
> > > > >
> > > > >
> > > > >
> > > > > <configurationfile>/src/main/resources/hibernate.cfg.xml</configurationf
> > > > > ile>
> > > > > <jdk5>true</jdk5>
> > > > > <skip>${maven.test.skip}</skip>
> > > > > </componentProperties>
> > > > > </configuration>
> > > > > <executions>
> > > > > <execution>
> > > > > <id>hbm2ddl</id>
> > > > > <phase>process-test-resources</phase>
> > > > > <goals>
> > > > > <goal>hbm2ddl</goal>
> > > > > </goals>
> > > > > </execution>
> > > > > </executions>
> > > > > <dependencies>
> > > > > <dependency>
> > > > > <groupId>${jdbc.groupId}</groupId>
> > > > > <artifactId>${jdbc.artifactId}</artifactId>
> > > > > <version>${jdbc.version}</version>
> > > > > </dependency>
> > > > > </dependencies>
> > > > > </plugin>
> > > > >
> > > > > So what am I missing? Why do the tables for Mysql but with HSQL
> > > > > they
> > > > > do
> > > > > not?
> > > > > Also, I do not see any files generated in src/main/resources/
> > > > >
> > > > > Here is the trace when I run hibernate alone:
> > > > >
> > > > > [myproject] INFO [main] SchemaExport.execute(154) | Running
> > > > > hbm2ddl
> > > > > schema
> > > > > export
> > > > > [myproject] DEBUG [main] SchemaExport.execute(170) | import file
> > > > > not
> > > > > found:
> > > > > /import.sql
> > > > > [myproject] INFO [main] SchemaExport.execute(179) | exporting
> > > > > generated
> > > > > schema to database
> > > > > [myproject] INFO [main]
> > > > > DriverManagerConnectionProvider.configure(41)
> > > > > |
> > > > > Using Hibernate built-in connection pool (not for production use!)
> > > > > [myproject] INFO [main]
> > > > > DriverManagerConnectionProvider.configure(42)
> > > > > |
> > > > > Hibernate connection pool size: 20
> > > > > [myproject] INFO [main]
> > > > > DriverManagerConnectionProvider.configure(45)
> > > > > |
> > > > > autocommit mode: false
> > > > > [myproject] INFO [main]
> > > > > DriverManagerConnectionProvider.configure(80)
> > > > > |
> > > > > using driver: org.hsqldb.jdbcDriver at URL:
> > > > > jdbc:hsqldb:file:target/testd
> > > > > b-hsql;shutdown=true
> > > > > [myproject] INFO [main]
> > > > > DriverManagerConnectionProvider.configure(83)
> > > > > |
> > > > > connection properties: {user=sa, password=}
> > > > > [myproject] DEBUG [main]
> > > > > DriverManagerConnectionProvider.getConnection(93) |
> > > > > total checked-out connections: 0
> > > > > [myproject] DEBUG [main]
> > > > > DriverManagerConnectionProvider.getConnection(109)
> > > > > | opening new JDBC connection
> > > > > [myproject] DEBUG [main]
> > > > > DriverManagerConnectionProvider.getConnection(115)
> > > > > | created connection to:
> > > > > jdbc:hsqldb:file:target/testdb-hsql;shutdown
> > > > > =true, Isolation Level: 2
> > > > > alter table app_user drop constraint FK459C57294AD68248;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > app_user
> > > > > drop constraint FK459C57294AD68248;
> > > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > > alter
> > > > > table
> > > > > app_user drop constraint FK459C57294AD68248
> > > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Table not found:
> > > > > APP_USER
> > > > > in statement [alter table app_user]
> > > > > alter table user_role drop constraint FK143BF46AE8EA6EF6;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > user_role
> > > > > drop constraint FK143BF46AE8EA6EF6;
> > > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > > alter
> > > > > table
> > > > > user_role drop constraint FK143BF46AE8EA6EF6
> > > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Table not found:
> > > > > USER_ROLE
> > > > > in statement [alter table user_role]
> > > > > alter table user_role drop constraint FK143BF46A43BFAB16;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > user_role
> > > > > drop constraint FK143BF46A43BFAB16;
> > > > > [myproject] DEBUG [main] SchemaExport.drop(288) | Unsuccessful:
> > > > > alter
> > > > > table
> > > > > user_role drop constraint FK143BF46A43BFAB16
> > > > > [myproject] DEBUG [main] SchemaExport.drop(289) | Table not found:
> > > > > USER_ROLE
> > > > > in statement [alter table user_role]
> > > > > drop table address if exists;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table
> > > > > address
> > > > > if
> > > > > exists;
> > > > > drop table app_user if exists;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table
> > > > > app_user
> > > > > if
> > > > > exists;
> > > > > drop table role if exists;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table
> > > > > role
> > > > > if
> > > > > exists;
> > > > > drop table user_role if exists;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | drop table
> > > > > user_role if
> > > > > exists;
> > > > > create table address (id bigint generated by default as identity
> > > > > (start
> > > > > with
> > > > > 1), version integer, address varchar(25) not null, city
> > > > > varchar(25)
> > > > > not null, country varchar(2) not null, postal_code varchar(25) not
> > > > > null,
> > > > > province varchar(25) not null, primary key (id));
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > > address
> > > > > (id bigint generated by default as identity (start with 1),
> > > > > version
> > > > > int
> > > > > eger, address varchar(25) not null, city varchar(25) not null,
> > > > > country
> > > > > varchar(2) not null, postal_code varchar(25) not null, province
> > > > > varchar(25
> > > > > ) not null, primary key (id));
> > > > > create table app_user (id bigint generated by default as identity
> > > > > (start
> > > > > with 1), version integer, confirmPassword varchar(255), email
> > > > > varchar(50
> > > > > ) not null, first_name varchar(50) not null, last_name varchar(50)
> > > > > not
> > > > > null,
> > > > > middle_name varchar(50), password varchar(100) not null,
> > > > > password_hi
> > > > > nt varchar(50), phone_number varchar(25), username varchar(25) not
> > > > > null,
> > > > > website varchar(50), address_fk bigint, primary key (id));
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > > app_user
> > > > > (id bigint generated by default as identity (start with 1),
> > > > > version in
> > > > > teger, confirmPassword varchar(255), email varchar(50) not null,
> > > > > first_name
> > > > > varchar(50) not null, last_name varchar(50) not null, middle_name
> > > > > var
> > > > > char(50), password varchar(100) not null, password_hint
> > > > > varchar(50),
> > > > > phone_number varchar(25), username varchar(25) not null, website
> > > > > varchar(50)
> > > > > , address_fk bigint, primary key (id));
> > > > > create table role (id bigint generated by default as identity
> > > > > (start
> > > > > with
> > > > > 1), version integer, description varchar(255) not null, name
> > > > > varchar(64
> > > > > ) not null, primary key (id));
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > > role
> > > > > (id
> > > > > bigint generated by default as identity (start with 1), version
> > > > > intege
> > > > > r, description varchar(255) not null, name varchar(64) not null,
> > > > > primary
> > > > > key
> > > > > (id));
> > > > > create table user_role (user_id bigint not null, role_id bigint
> > > > > not
> > > > > null,
> > > > > primary key (user_id, role_id));
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | create table
> > > > > user_role
> > > > > (user_id bigint not null, role_id bigint not null, primary key
> > > > > (user_
> > > > > id, role_id));
> > > > > alter table app_user add constraint FK459C57294AD68248 foreign key
> > > > > (address_fk) references address;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > app_user
> > > > > add constraint FK459C57294AD68248 foreign key (address_fk)
> > > > > references
> > > > > a
> > > > > ddress;
> > > > > alter table user_role add constraint FK143BF46AE8EA6EF6 foreign
> > > > > key
> > > > > (user_id) references app_user;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > user_role
> > > > > add constraint FK143BF46AE8EA6EF6 foreign key (user_id) references
> > > > > app
> > > > > _user;
> > > > > alter table user_role add constraint FK143BF46A43BFAB16 foreign
> > > > > key
> > > > > (role_id) references role;
> > > > > [myproject] DEBUG [main] SchemaExport.execute(303) | alter table
> > > > > user_role
> > > > > add constraint FK143BF46A43BFAB16 foreign key (role_id) references
> > > > > rol
> > > > > e;
> > > > > [myproject] INFO [main] SchemaExport.execute(196) | schema export
> > > > > complete
> > > > > [myproject] DEBUG [main]
> > > > > DriverManagerConnectionProvider.closeConnection(129) | returning
> > > > > connection
> > > > > to pool, pool size: 1
> > > > > [myproject] INFO [main] DriverManagerConnectionProvider.close(147)
> > > > > |
> > > > > cleaning up connection pool:
> > > > > jdbc:hsqldb:file:target/testdb-hsql;shutdown=tr
> > > > > ue
> > > > > [WARNING] 3 errors occurred while performing <hbm2ddl>.
> > > > > *[ERROR] Error #1: java.sql.SQLException: Table not found:
> > > > > APP_USER in
> > > > > statement [alter table app_user]
> > > > > [ERROR] Error #1: java.sql.SQLException: Table not found:
> > > > > USER_ROLE in
> > > > > statement [alter table user_role]
> > > > > [ERROR] Error #1: java.sql.SQLException: Table not found:
> > > > > USER_ROLE in
> > > > > statement [alter table user_role]
> > > > > [INFO]
> > > > >
> > > >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Thanks,
Mick Knutson
http://www.baselogic.com
http://www.blincmagazine.com
http://www.linkedin.com/in/mickknutson
http://www.djmick.com
http://www.myspace.com/mickknutson
http://www.myspace.com/BLiNCMagazine
http://tahoe.baselogic.com
---
