db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ferruh Zamangoer" <ferruh.zamang...@gmx.de>
Subject AW: (newbie) Error creating db with Postgres
Date Tue, 05 Jul 2005 08:08:02 GMT
I had the same error when I try to create the database? I also create it by
hand :=).



-----Urspr√ľngliche Nachricht-----
Von: Matthias Klein [mailto:matthias@cmklein.de] 
Gesendet: Dienstag, 5. Juli 2005 03:18
An: torque-user@db.apache.org
Betreff: (newbie) Error creating db with Postgres

Today I tried adapting the tutorial example to postgresql but create-db
resulted in errors.
I did search the mailing list and documentation but could not find an
answer.

Here is what I did:

1. Installed PostgreSQL 8.0 (build 311) on localhost port 5432 with user
postgres/postgres

2. Created a dir "torquetest" in which I placed torque-3.1.1.jar and
torque-gen-3.1.1.jar

3. Placed the JDBC driver in %MAVEN_HOME%/lib/endorsed (The documentation
doesn't mention that the driver has to be there. BTW: is there another
(better) way to do that? Adding the driver to the classpath didn't work:
driver could not be loaded)

4. Created id-table-schema.xml and project-schema.xml and placed them in
/src/schema. The content of those files is just copy&paste from the tutorial

5. created project.properties in torquetest:

torque.project = bookstore
torque.database = postgresql
torque.targetPackage = ca.nrc.test.om
torque.database.createUrl = jdbc:postgresql://localhost:5432
torque.database.buildUrl = jdbc:postgresql://localhost:5432/bookstore
torque.database.url = jdbc:postgresql://localhost:5432/bookstore
torque.database.driver = org.postgresql.Driver
torque.database.user = postgres
torque.database.password = postgres
torque.database.host = localhost

6. created log4j.properties in torquetest (also copy&paste)

7. Ran maven plugin:download -DartifactId=maven-torque-plugin
-DgroupId=torque -Dversion=3.1.1

Now I ran maven torque which worked fine and created those peer classes.


But with maven torque:create-db I got an error:

build:start:

torque:init:

torque:create-db:
    [torque-data-model] Using classpath
    [torque-data-model] Generating to file
C:\JavaCode\torquetest\target\sql\cre
ate-db.sql
    [echo]
          Executing the create-db.sql script ...


BUILD FAILED
File...... C:\Documents and
Settings\Matthias\.maven\cache\maven-torque-plugin-3
.1.1\plugin.jelly
Element... sql
Line...... 394
Column.... 44
org.postgresql.util.PSQLException: Backend start-up failed: FATAL: database
"boo
kstore" does not exist.
Total time: 4 seconds
Finished at: Mon Jul 04 22:12:03 ADT 2005


Now I created bookstore manually but then I got a message that the build
failed because the db already existed and could not be dropped.

I assume this is a very trivial config problem. But I can't seem to find the
solution.
Any suggestions?

Thanks

Matt


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message