Tutorial problem...

[Younwook Jang <yo...@gmail.com>]

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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: Tutorial problem...

[Thomas Dudziak <to...@gmail.com>]

On 6/11/06, Younwook Jang <yo...@gmail.com> wrote:

> 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.

This error usually happens because either the database is not
correctly configured in build.properties (URL, database type), or
you're not allowed to execute these DDL statements (might be because
it happens right at the first SQL statement). Can you try to execute
the SQL script manually
(/Users/younwook/ws/ojb/productmanager/build/database/ojbcore-schema.sql)
and see whether the errors persist ? I tried the SQL statement where
the error happened, and it worked without a problem against a MySQL
4.1.
You should also ensure that you're using the newest JDBC driver
(3.1.13 at the moment).

Tom

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