
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
WinXP Prof. jdk1.5 tomcat-5.5.15 mysql-5
|
|
|
Hi
I'm trying to use equinox with ibatis dao layer and mysql database but i am having problem:
SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in org/appfuse/dao/ibatis/UserSQL.xml. --- The error occurred while applying a parameter map. --- Check the getUsers-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Table 'equinox.app_user' doesn't exist.
I would like to create tables manualy but there is not an sql script for mysql in src\org\appfuse\dao\ibatis directory.
Please could you help me ?
|
|
Description
|
Hi
I'm trying to use equinox with ibatis dao layer and mysql database but i am having problem:
SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in org/appfuse/dao/ibatis/UserSQL.xml. --- The error occurred while applying a parameter map. --- Check the getUsers-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Table 'equinox.app_user' doesn't exist.
I would like to create tables manualy but there is not an sql script for mysql in src\org\appfuse\dao\ibatis directory.
Please could you help me ?
|
Show » |
Sort Order:
|
drop table app_user;
drop sequence user_sequence;
create table app_user (id bigint not null primary key, first_name varchar(50), last_name varchar(50), birthday timestamp);
create sequence user_sequence;
For the first two lines, you can probably drop them and for the 2nd two, use "create table app_user if not exists".
Matt