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