I tried to use HSqlDb with nukes (JBoss 4.0.0 + Nukes2.0). For that i had changed "nukes-ds.xml" to have. ... <jndi-name>NukesDS</jndi-name> <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url> <driver-class>org.hsqldb.jdbcDriver</driver-class> ...
Also i had created the objects in HSQLDB using the DDLs from "setup.ddl" that i had build at nukes-2.0\core\output\resources. (Of course i had to change the Sqls for HSQLDB syntax ). The Nukes deployment went well (Except the error : INFO [ServiceConfigurator] Problem configuring service jboss:service=Mail) and i am able to access the portal page at http://localhost:8080/nukes/. I think the DB connectivity is OK since i could see the user details entered in table "JBP_USERS" in HSQL DB, when i tried to create new user. But i get the following errors : ERROR [JDBCExceptionReporter] Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()] ERROR [JDBCExceptionReporter] could not insert: [org.jboss.nukes.core.impl.user.UserImpl] I guess "LAST_INSERT_ID()" is a MySql function. Can you let me know what other configuration (for HSqlDB) i have to do ?. Or is it not possible to use HSQLDB with the above JBoss\Nukes versions ??? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3859856#3859856 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3859856 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
