Hi, 

when I run 
  ant prepare-testdb

I get
      [sql] Executing file: E:\Programme\jakarta-ojb-0.9.5\target\src\sql\create-db.sql
      [sql] Failed to execute: ECHO Not implemented
      [sql] java.sql.SQLException: Unexpected token: 37000 Unexpected token: ECHO in 
statement [ECHO Not implemented]
      [sql] 0 of 1 SQL statements executed successfully


The file src\sql\create-db.sql contains only
----
ECHO Not implemented

----

any ideas? Thank you!
Bernd


Here is the log,
if you need more logs, please let me know :)

------------------------------------------------------------
E:\Programme\jakarta-ojb-0.9.5>ant -version
Apache Ant version 1.5 compiled on July 9 2002
E:\Programme\jakarta-ojb-0.9.5>set java_home
JAVA_HOME=E:\Programme\JavaSoft\jdk\1.4.0

E:\Programme\jakarta-ojb-0.9.5>
E:\Programme\jakarta-ojb-0.9.5>E:\Programme\JavaSoft\jdk\1.4.0\jre\bin\java -version
java version "1.4.0"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0-b92)
Java HotSpot(TM) Client VM (build 1.4.0-b92, mixed mode)

E:\Programme\jakarta-ojb-0.9.5>ant prepare-testdb
Buildfile: build.xml

useP6Spy:

dontUseP6Spy:
     [echo] NOT using P6Spy

set-archive-name:

set-archive-name-date:

detect-jdk:

use-jdk12:

use-jdk13:

use-jdk14:
     [echo] detected JDK 1.4

init:

prepare:

prepare-testdb:
   [delete] Deleting directory E:\Programme\jakarta-ojb-0.9.5\target\test
     [copy] Copying 1 file to E:\Programme\jakarta-ojb-0.9.5\target\test
     [copy] Copying 1 file to E:\Programme\jakarta-ojb-0.9.5\target\test
     [copy] Copying 1 file to E:\Programme\jakarta-ojb-0.9.5\target\test
     [copy] Copying 1 file to E:\Programme\jakarta-ojb-0.9.5\target\test
     [copy] Copying 14 files to E:\Programme\jakarta-ojb-0.9.5\target\test\ojb

project-sql-classpath:
     [echo] +------------------------------------------+
     [echo] |                                          |
     [echo] | Generating SQL for OJB Testsuite!        |
     [echo] | enJoy!                                   |
     [echo] |                                          |
     [echo] +------------------------------------------+
[torque-sql] Using contextProperties file: 
E:\Programme\jakarta-ojb-0.9.5\build.properties
[torque-sql] Using classpath
[torque-sql] Generating to file 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\report.ojbtest.sql.generation
[torque-sql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-sql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package

project-create-db-classpath:
     [echo]
     [echo]       driver="org.hsqldb.jdbcDriver"
     [echo]       url="jdbc:hsqldb:target/test/OJB"
     [echo]       userid="sa"
     [echo]       password=""
     [echo]
[torque-create-db] Using classpath
[torque-create-db] Generating to file 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\create-db.sql
[torque-create-db] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-create-db] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-create-db] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-create-db] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
      [sql] Executing file: E:\Programme\jakarta-ojb-0.9.5\target\src\sql\create-db.sql
      [sql] Failed to execute: ECHO Not implemented
      [sql] java.sql.SQLException: Unexpected token: 37000 Unexpected token: ECHO in 
statement [ECHO Not implemented]
      [sql] 0 of 1 SQL statements executed successfully

project-datasql-classpath:
     [echo] +-----------------------------------------------+
     [echo] |                                               |
     [echo] | Generating SQL from data XML !                |
     [echo] | enJoy!                                        |
     [echo] |                                               |
     [echo] +-----------------------------------------------+
     [echo]  taking build.properties from: build.properties
[torque-datasql] Using contextProperties file: 
E:\Programme\jakarta-ojb-0.9.5\build.properties
[torque-datasql] Using classpath
[torque-datasql] Generating to file 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\ojbtest-data.sql
[torque-datasql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-datasql] Resolver: used database.dtd from 
org.apache.torque.engine.database.transform package
[torque-datasql] Resolver: used 
E:\Programme\jakarta-ojb-0.9.5\src\schema\ojbtest-data.dtd

project-insert-sql:
[torque-insert-sql] Our new url -> jdbc:hsqldb:target/test/OJB
[torque-insert-sql] Executing file: 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\ojbtest-schema.sql
[torque-insert-sql] Executing file: 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\ojbcore-schema.sql
[torque-insert-sql] Executing file: 
E:\Programme\jakarta-ojb-0.9.5\target\src\sql\ojbtest-data.sql
[torque-insert-sql] 171 of 171 SQL statements executed successfully

BUILD SUCCESSFUL
Total time: 41 seconds
-------------------------------------------------


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to