Hi,
I'm using appfuse-light-spring-ibatis-1.8.1.zip with mysql Ver 14.12
Distrib 5.0.45, for suse-linux-gnu (x86_64) and am hitting the following
error:
si6k1 appfuse: ant --noconfig test
Buildfile: build.xml
compile:
test:
[junit] Testsuite: org.appfuse.dao.UserDaoTest
[junit] Tests run: 3, Failures: 0, Errors: 3, Time elapsed: 1.558 sec
[...]
[junit] Testcase: testGetUsers(org.appfuse.dao.UserDaoTest):
Caused an ERROR
[junit] Could not obtain last_insert_id(); nested exception is
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'appfuse_light.user_sequence' doesn't exist
[junit] org.springframework.dao.DataAccessResourceFailureException:
Could not obtain last_insert_id(); nested exception is
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'appfuse_light.user_sequence' doesn't exist
[junit] at
org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer.getNextKey(MySQLMaxValueIncrementer.java:158)
[...]
The SQL schema seems OK, in that I can create it and select by hand:
si6k1 appfuse: mysql -u root appfuse_light <
./src/main/java/org/appfuse/dao/ibatis/create-mysql.sql
si6k1 appfuse: mysql -u root appfuse_light
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.0.45 SUSE MySQL RPM
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from user_sequence;
+-------+
| value |
+-------+
| 0 |
+-------+
1 row in set (0.01 sec)
Any idea what is wrong?
Thanks,
Andrew
PS The --noconfig switch stops ant 1.6.5 startup from switching to a
system installed 1.7 (which gives other errors due to incompatible ant
libraries). I doubt that is the source of the problem.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
