java.sql.SQLException: ORA-02026: missing LINK keyword

[Vinod_Thapliyal <Vi...@infosys.com>]

Hi,

I am trying to define database schema and generate some tables and I am getting the following error: Although the build is successful but the ant is not able to properly create the create-db.sql file.
create -db.sql file:
-- drop database bookstore;
-- create database bookstore;

C:\Torque\torque-3.0> ant -f build-torque.xml create-db
Buildfile: build-torque.xml

create-db-check:

create-db:
[torque-data-model] Generating to file C:\Torque\torque-3.0\src\sql\create-db.sql
[torque-data-model] Resolver: used database.dtd from org.apache.torque.engine.database.transform package
[torque-data-model] Resolver: used database.dtd from org.apache.torque.engine.database.transform package
     [echo]
     [echo]       Executing the create-db.sql script ...
     [echo]
      [sql] Executing file: C:\Torque\torque-3.0\src\sql\create-db.sql
      [sql] 0 of 0 SQL statements executed successfully

BUILD SUCCESSFUL
Total time: 9 seconds
I have checked that my build.properties and torque. properties point to same database drivers.

My build.properties is  as follows:

torque.project = bookstore


torque.database.createUrl = jdbc:oracle:thin:@triveni:1521:galileo

torque.database.buildUrl = jdbc:oracle:thin:@triveni:1521:galileo

torque.database.url = jdbc:oracle:thin:@triveni:1521:galileo

torque.database.driver = oracle.jdbc.driver.OracleDriver
torque.database.user = turbine		
torque.database.password =turbine  
torque.database.host = 127.0.0.1

my torque.properties file is as follows:

log4j.rootCategory = DEBUG, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout

torque.database.bookstore.adapter=oracle


torque.database.default=bookstore
torque.database.bookstore.driver = oracle.jdbc.driver.OracleDriver
torque.database.bookstore.url = jdbc:oracle:thin:@triveni:1521:galileo
torque.database.bookstore.username = turbine	
torque.database.bookstore.password = turbine  

torque.sameJavaName = false