I am trying to get the Pack Filter Rule to work and when i create a rule and click ok it does not show up on the screen and i get these errors on the server:
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$db209636.execute()
at org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.java :248)
at org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.java :207)
at org.jivesoftware.openfire.plugin.rules.RuleManagerProxy.addRule(RuleManagerProx y.java:34)
at org.jivesoftware.openfire.plugin.packetFilter.rule_002dform_jsp._jspService(rul e_002dform_jsp.java:192)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.jivesoftware.openfire.container.PluginServlet.handleJSP(PluginServlet.java: 229)
at org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:87 )
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1093)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:42)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.j ava:829)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
2008.11.04 10:47:21 Closing statement 82639 (belonging to connection 123) automatically
2008.11.04 10:48:17 Stat: server_sessions. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:17 Stat: conversations. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:17 Stat: server_bytes. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:17 Stat: packet_count. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:17 Stat: sessions. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:17 Stat: proxyTransferRate. Last sample: 1225820820. New sample: 1225820880
2008.11.04 10:48:21 Closing statement 555218 (belonging to connection 123) automatically
2008.11.04 10:48:21 Closing statement 180aaf4 (belonging to connection 123) automatically
2008.11.04 10:49:17 Stat: server_sessions. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:17 Stat: conversations. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:17 Stat: server_bytes. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:17 Stat: packet_count. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:17 Stat: sessions. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:17 Stat: proxyTransferRate. Last sample: 1225820880. New sample: 1225820940
2008.11.04 10:49:21 Closing statement 1c5c090 (belonging to connection 123) automatically
2008.11.04 10:49:21 Closing statement 10f8c53 (belonging to connection 123) automatically
2008.11.04 10:50:17 Stat: server_sessions. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:17 Stat: conversations. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:17 Stat: server_bytes. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:17 Stat: packet_count. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:17 Stat: sessions. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:17 Stat: proxyTransferRate. Last sample: 1225820940. New sample: 1225821000
2008.11.04 10:50:21 Closing statement 1753442 (belonging to connection 122) automatically
2008.11.04 10:50:21 Closing statement 1ba1446 (belonging to connection 122) automatically
2008.11.04 10:50:22 DefaultAdminProvider: XML Property was set: lastModified
2008.11.04 10:51:17 Stat: server_sessions. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:17 Stat: conversations. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:17 Stat: server_bytes. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:17 Stat: packet_count. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:17 Stat: sessions. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:17 Stat: proxyTransferRate. Last sample: 1225821000. New sample: 1225821060
2008.11.04 10:51:21 Closing statement 191180b (belonging to connection 123) automatically
2008.11.04 10:51:21 Closing statement c1b052 (belonging to connection 123) automatically
2008.11.04 10:52:17 Stat: server_sessions. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:17 Stat: conversations. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:17 Stat: server_bytes. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:17 Stat: packet_count. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:17 Stat: sessions. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:17 Stat: proxyTransferRate. Last sample: 1225821060. New sample: 1225821120
2008.11.04 10:52:21 Closing statement 465c6b (belonging to connection 122) automatically
2008.11.04 10:52:21 Closing statement 15d855a (belonging to connection 122) automatically
2008.11.04 10:53:17 Stat: server_sessions. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:17 Stat: conversations. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:17 Stat: server_bytes. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:17 Stat: packet_count. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:17 Stat: sessions. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:17 Stat: proxyTransferRate. Last sample: 1225821120. New sample: 1225821180
2008.11.04 10:53:21 Closing statement 186088c (belonging to connection 125) automatically
2008.11.04 10:53:21 Closing statement 1baaa (belonging to connection 125) automatically