Did you specify torque.database property in the build.properties file? Torque use this to generate proper SQL statements.
Howard Lin > -----Original Message----- > From: Vinod_Thapliyal [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 1:31 AM > To: Turbine Torque Users List > Subject: java.sql.SQLException: ORA-02026: missing LINK keyword > > > 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 > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
