Aha. This is because I ran "ant new" at some point and was working in the newly created project. I think there's some naming inconsistency that I haven't tracked down yet.
Andrew > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
