Dear ojb-user mailing list subscribers!
I have just started my adveture with OJB. I've read the "Getting
Started" and FAQ and have tried to launch the ojb_blank. It works great
with the Hsqldb but don't want to work with PostgreSQL.
The problem is the setup-db target. It seems that the target can't work
because it tries to remove tables before it try to create them. The
tables are not present in the database so the whole process is going to
nowhere. Here is a feedback from ant (the output is a mess so please find the 'add-shutdown-sql-file' target and look at next 5 lines):
"
D:\_0\ojb-blank>ant setup-db
Buildfile: build.xml
compile:
xdoclet:
[ojbdoclet] 2006-08-13 02:53:24,044 [main] INFO xdoclet.XDocletMain.start - Running
<ojbrepository/>
[ojbdoclet] 2006-08-13 02:53:24,926 [main] INFO xdoclet.XDocletMain.start - Running
<torqueschema/>
setup-db:
check-use-classpath:
check-run-only-on-schema-change:
sql-check:
sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Torque project! |
[echo] | |
[echo] +------------------------------------------+
sql-classpath:
[echo] loading templates from classpath
[torque-sql] Using contextProperties file: D:\_0\ojb-blank\build.properties
[torque-sql] Using classpath
[torque-sql] Generating to file
D:\_0\ojb-blank\build\database\report.ojb_blank.sql.generation
[torque-sql] 2006-08-13 02:53:27,820 [main] INFO
org.apache.torque.engine.database.transform.XmlToAppData - Parsing fil
e: 'ojbcore-schema.xml'
[torque-sql] 2006-08-13 02:53:27,890 [main] INFO
org.apache.torque.engine.database.transform.DTDResolver - Resolver: us
ed database.dtd from 'org.apache.torque.engine.database.transform' package
[torque-sql] 2006-08-13 02:53:28,000 [main] INFO
org.apache.torque.engine.database.transform.XmlToAppData - Parsing fil
e: 'project-schema.xml'
[torque-sql] 2006-08-13 02:53:28,030 [main] INFO
org.apache.torque.engine.database.transform.DTDResolver - Resolver: us
ed database.dtd from 'org.apache.torque.engine.database.transform' package
sql-template:
create-db-check:
create-db:
[torque-data-model] Using classpath
[torque-data-model] Generating to file
D:\_0\ojb-blank\build\database\create-db.sql
[torque-data-model] 2006-08-13 02:53:40,458 [main] INFO
org.apache.torque.engine.database.transform.XmlToAppData - Pars
ing file: 'ojbcore-schema.xml'
[torque-data-model] 2006-08-13 02:53:40,468 [main] INFO
org.apache.torque.engine.database.transform.DTDResolver - Resol
ver: used database.dtd from 'org.apache.torque.engine.database.transform'
package
[torque-data-model] 2006-08-13 02:53:40,568 [main] INFO
org.apache.torque.engine.database.transform.XmlToAppData - Pars
ing file: 'project-schema.xml'
[torque-data-model] 2006-08-13 02:53:40,568 [main] INFO
org.apache.torque.engine.database.transform.DTDResolver - Resol
ver: used database.dtd from 'org.apache.torque.engine.database.transform'
package
shutdown-check:
append-shutdown-sql:
[echo]
[echo] Executing the create-db.sql script ...
[echo]
[sql] Executing file: D:\_0\ojb-blank\build\database\create-db.sql
[sql] 2 of 2 SQL statements executed successfully
insert-sql:
shutdown-check:
add-shutdown-sql-file:
[torque-sql-exec] Our new url -> jdbc:postgresql://localhost/ojb_blank
[torque-sql-exec] Executing file:
D:\_0\ojb-blank\build\database\project-schema.sql
[torque-sql-exec] Failed to execute: DROP TABLE Product CASCADE; CREATE TABLE
Product ( id integer NOT NULL, name varcha
r (100), price float, stock integer, PRIMARY KEY (id) );
[torque-sql-exec] org.postgresql.util.PSQLException: ERROR: table "product"
does not exist
[torque-sql-exec] Executing file:
D:\_0\ojb-blank\build\database\ojbcore-schema.sql
[torque-sql-exec] Failed to execute: DROP TABLE OJB_HL_SEQ CASCADE; CREATE
TABLE OJB_HL_SEQ ( TABLENAME varchar (250) NO
T NULL, MAX_KEY int8, GRAB_SIZE integer, VERSION integer, PRIMARY KEY
(TABLENAME) ); DROP TABLE OJB_NRM CASCADE; CREATE
TABLE OJB_NRM ( NAME varchar (250) NOT NULL, OID_ bytea, PRIMARY KEY (NAME) );
DROP TABLE OJB_DLIST CASCADE; CREATE TABL
E OJB_DLIST ( ID integer NOT NULL, SIZE_ integer, PRIMARY KEY (ID) ); DROP
TABLE OJB_DLIST_ENTRIES CASCADE; CREATE TABLE
OJB_DLIST_ENTRIES ( ID integer NOT NULL, DLIST_ID integer NOT NULL, POSITION_
integer, OID_ bytea, PRIMARY KEY (ID) );
DROP TABLE OJB_DSET CASCADE; CREATE TABLE OJB_DSET ( ID integer NOT NULL, SIZE_
integer, PRIMARY KEY (ID) ); DROP TABLE
OJB_DSET_ENTRIES CASCADE; CREATE TABLE OJB_DSET_ENTRIES ( ID integer NOT NULL,
DLIST_ID integer NOT NULL, POSITION_ inte
ger, OID_ bytea, PRIMARY KEY (ID) ); DROP TABLE OJB_DMAP CASCADE; CREATE TABLE
OJB_DMAP ( ID integer NOT NULL, SIZE_ int
eger, PRIMARY KEY (ID) ); DROP TABLE OJB_DMAP_ENTRIES CASCADE; CREATE TABLE
OJB_DMAP_ENTRIES ( ID integer NOT NULL, DMAP
_ID integer NOT NULL, KEY_OID bytea, VALUE_OID bytea, PRIMARY KEY (ID) );
[torque-sql-exec] org.postgresql.util.PSQLException: ERROR: table "ojb_hl_seq"
does not exist
[torque-sql-exec] 0 of 2 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 33 seconds
"
I'm using:
- MS Windows XP SP2
- JDK 1.5.0_07
- ant 1.6.5
- PostgreSQL 8.1.4 for Windows. The server is installed on my comuter so the
database connection points to the localhost
Please help with that for I don't have any more ideas what should I do (of
course I don't want to create tables by hand if such a great tools like OJB and
Torque exist).
Thank you in advance.
Krzysztof Borkowski
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
