hello, folks.
I have a problem during follow "getting started" document.
The error message is like below..
append-shutdown-sql:
[echo]
[echo] Executing the create-db.sql script ...
[echo]
[sql] Executing file: /Users/younwook/ws/ojb/productmanager/
build/database/create-db.sql
[sql] 2 of 2 SQL statements executed successfully
insert-sql:
shutdown-check:
add-shutdown-sql-file:
[torque-sql-exec] File 'project-schema.sql' in sqldbmap does not
exist, so skipping it.
[torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/
productmanager
[torque-sql-exec] Executing file: /Users/younwook/ws/ojb/
productmanager/build/database/ojbcore-schema.sql
[torque-sql-exec] Failed to execute: #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_HL_SEQ #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_HL_SEQ; CREATE TABLE
OJB_HL_SEQ ( TABLENAME VARCHAR (250) NOT NULL, MAX_KEY BIGINT,
GRAB_SIZE INTEGER, VERSION INTEGER, PRIMARY KEY(TABLENAME) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_NRM #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_NRM; CREATE TABLE OJB_NRM
( NAME VARCHAR (250) NOT NULL, OID_ LONGBLOB, PRIMARY KEY(NAME) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DLIST #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DLIST; CREATE TABLE
OJB_DLIST ( ID INTEGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DLIST_ENTRIES #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DLIST_ENTRIES; CREATE
TABLE OJB_DLIST_ENTRIES ( ID INTEGER NOT NULL, DLIST_ID INTEGER NOT
NULL, POSITION_ INTEGER, OID_ LONGBLOB, PRIMARY KEY(ID) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DSET #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DSET; CREATE TABLE
OJB_DSET ( ID INTEGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DSET_ENTRIES #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DSET_ENTRIES; CREATE
TABLE OJB_DSET_ENTRIES ( ID INTEGER NOT NULL, DLIST_ID INTEGER NOT
NULL, POSITION_ INTEGER, OID_ LONGBLOB, PRIMARY KEY(ID) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DMAP #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DMAP; CREATE TABLE
OJB_DMAP ( ID INTEGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
-----------------------------------------------------------------------
[torque-sql-exec] # OJB_DMAP_ENTRIES #
-----------------------------------------------------------------------
[torque-sql-exec] drop table if exists OJB_DMAP_ENTRIES; CREATE
TABLE OJB_DMAP_ENTRIES ( ID INTEGER NOT NULL, DMAP_ID INTEGER NOT
NULL, KEY_OID LONGBLOB, VALUE_OID LONGBLOB, PRIMARY KEY(ID) );
[torque-sql-exec] java.sql.SQLException: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '; CREATE TABLE OJB_HL_SEQ
( TABLENAME VARCHAR (250) NOT NULL, MAX_KEY BIGINT, GR' at line 3
[torque-sql-exec] 0 of 1 SQL statements executed successfully
Would you please provide advice about it..? I tried to search this
mailing list, but I couldn't find the solution...
Any information or comment also highly appreciated.
thanks, regards...
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
