well,I am not really sure what the problem is, but try this dirty solution:
after executing >ant insert-sql-files delete all the lines that does not have "schema-idtable-init.sql" within it ,in ./WEB-INF/src/sql/sqldb.map and again execute: >ant insert-sql-files good luck Akmal >From: Hongbin Liu <[EMAIL PROTECTED]> >Reply-To: "Turbine Users List" <[EMAIL PROTECTED]> >To: Turbine Users List <[EMAIL PROTECTED]> >Subject: tdk; ant init; sql exception >Date: Wed, 5 Jun 2002 23:36:24 -0500 (EST) > > > >Hi all: > >Thanks to those who answered my previous question. > >I have changed to tdk-2.2-b1.tar.gz, taking >someone's suggestion. Everything is OK except >that when I run > >ant init > >under WEB-INF/build > >it throws a couple of sql exceptions. > >like this: > >project-insert-sql: >[torque-insert-sql] Our new url -> jdbc:mysql://127.0.0.1/newapp >[torque-insert-sql] Executing file: >/home/lhb/packages/tdk/webapps/newapp/WEB-INF/src/sql/third-schema.sql >[torque-insert-sql] Executing file: >/home/lhb/packages/tdk/webapps/newapp/WEB-INF/src/sql/third-schema-idtable-init.sql >[torque-insert-sql] Failed to execute: insert into ID_TABLE (id_table_id, >table_name, next_id, quantity) VALUES (101, 'RDF3', 100, 10) >[torque-insert-sql] java.sql.SQLException: General error: Table >'newapp.ID_TABLE' doesn't exist > > >However 'newapp.ID_TABLE' does exist. See commond line >out put from mysql: > >mysql> use newapp; >Database changed >mysql> select * from ID_TABLE; >+-------------+-------------------------+---------+----------+ >| ID_TABLE_ID | TABLE_NAME | NEXT_ID | QUANTITY | >+-------------+-------------------------+---------+----------+ >| 131 | RDF | 100 | 10 | >| 111 | TURBINE_PERMISSION | 100 | 10 | >| 112 | TURBINE_ROLE | 100 | 10 | >| 113 | TURBINE_GROUP | 100 | 10 | >| 114 | TURBINE_ROLE_PERMISSION | 100 | 10 | >| 115 | TURBINE_USER | 100 | 10 | >| 116 | TURBINE_USER_GROUP_ROLE | 100 | 10 | >| 117 | TURBINE_SCHEDULED_JOB | 100 | 10 | >+-------------+-------------------------+---------+----------+ >8 rows in set (0.00 sec) > >And I insert successfully the above entry to the table manually. >Is it weird? > >Another issue: in create-db.sql there is sql statement >drop database if exists default; >mysql seems not to like the word default. I am wondering >what the statement is useful for. > >regards, > >Hong > > > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
