I've changed my db from the hypersonic (version 1.4) in the WEB-INF/db folder to the Hypersonic db (version 1.6) that is started when JBoss-2.4.4_Tomcat-4.0.3 is started. When trying to create new user i get the following error : There has been an Error! Reason: org.apache.jetspeed.services.security.UserException: Failed to retrieve user 'test': This function is not supported: 84 Get/Post Data: action = CreateNewUserAndConfirm user = anon password_confirm = test username = test firstname = test lastname = test page = default.psml email = test@test.com submit2 = Create New Account template = /html/ShowError.vm password = test Stacktrace: java.sql.SQLException: This function is not supported: 84 at org.hsql.Trace.getError(Trace.java:124) at org.hsql.Trace.getError(Trace.java:115) at org.hsql.Trace.error(Trace.java:133) at org.hsql.Column.readData(Column.java:666) at org.hsql.Result.(Result.java:84) at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644) at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37) at com.workingdogs.village.QueryDataSet.(Unknown Source) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1526) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1481) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1433) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1363) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:344) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:314) at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.doSelectUsers(TurbineUserPeer.java:110) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:177) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:376) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addDefaultPSML(TurbineUserManagement.java:357) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:318) at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:134) at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:236) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:206) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) at org.apache.turbine.modules.Page.build(Page.java:90) at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) at org.apache.turbine.Turbine.doGet(Turbine.java:510) at org.apache.turbine.Turbine.doPost(Turbine.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107) at java.lang.Thread.run(Unknown Source) rethrown as org.apache.torque.TorqueException: This function is not supported: 84 at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1534) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1481) at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1433) at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1363) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:344) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doSelectVillageRecords(BaseTurbineUserPeer.java:314) at org.apache.jetspeed.om.security.turbine.TurbineUserPeer.doSelectUsers(TurbineUserPeer.java:110) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:177) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:376) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addDefaultPSML(TurbineUserManagement.java:357) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:318) at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:134) at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:236) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:206) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) at org.apache.turbine.modules.Page.build(Page.java:90) at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) at org.apache.turbine.Turbine.doGet(Turbine.java:510) at org.apache.turbine.Turbine.doPost(Turbine.java:616) rethrown as org.apache.jetspeed.services.security.UserException: Failed to retrieve user 'test': This function is not supported: 84 at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.getUser(TurbineUserManagement.java:181) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.removeUser(TurbineUserManagement.java:376) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addDefaultPSML(TurbineUserManagement.java:357) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:318) at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:134) at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:236) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:206) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) at org.apache.turbine.modules.Page.build(Page.java:90) at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) at org.apache.turbine.Turbine.doGet(Turbine.java:510) at org.apache.turbine.Turbine.doPost(Turbine.java:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107) at java.lang.Thread.run(Unknown Source) What did i do wrong or where can i go to fix it ? anybody any clues ? Werner -- ---------------------------------------------------------------------- ir. Werner Ramaekers Enterprise Java Solutions Architect - Shift@ Sun Certified Java Programmer "May the source be with you." ---------------------------------------------------------------------- -- To unsubscribe, e-mail: For additional commands, e-mail: