Hi,
My environment: Windows XP Home PostgreSQL 8.2 (on localhost) LogicAlloy 1.2.2 (on localhost)
My MySQL database subscriber works perfectly but I can't create a postgresql subscriber. Error: com.logicalloy.ale.exception.ImplementationException: An error occurred while adding the subscriber. com.logicalloy.ale.Spec.subscribe(Spec.java:251) com.logicalloy.ale.ALE.subscribe(ALE.java:156) com.logicalloy.ale.mgmt.SubscribersAction.update(SubscribersAction.java:134) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:150) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) javax.servlet.http.HttpServlet.service(HttpServlet.java:616) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) org.mortbay.http.HttpContext.handle(HttpContext.java:1530) org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) org.mortbay.http.HttpContext.handle(HttpContext.java:1482) org.mortbay.http.HttpServer.service(HttpServer.java:909) org.mortbay.http.HttpConnection.service(HttpConnection.java:820) org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
I figured out it needs the following table(it works with mysql): CREATE TABLE `tbleventreport` ( `id` varchar(250) default NULL, `tagbits` varchar(250) default NULL, `encodingtype` varchar(250) default NULL, `tagid` varchar(250) default NULL, `aleid` varchar(250) default NULL, `ecspecname` varchar(250) default NULL, `groupname` varchar(250) default NULL, `ecreportname` varchar(250) default NULL, `terminationcondition` varchar(250) default NULL, `reporttimestamp` varchar(250) default NULL, `tagtimestamp` varchar(250) default NULL, `tagslogicalreader` varchar(250) default NULL, `tagsantennaport` varchar(250) default NULL, `filter` varchar(250) default NULL, `gmi` varchar(250) default NULL, `serialnum` varchar(250) default NULL, `generalmanagernum` varchar(250) default NULL, `objectclass` varchar(250) default NULL, `partition` varchar(250) default NULL, `companyprefix` varchar(250) default NULL, `itemreference` varchar(250) default NULL, `serialreference` varchar(250) default NULL, `assettype` varchar(250) default NULL, `individualassetreference` varchar(250) default NULL, `locationreference` varchar(250) default NULL, `extensioncomponent` varchar(250) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
But with postgre it's not work. Can anyone help me, what do I wrong?
Thanks! Akos Kiszely
Log in to post a comment.
Hi,
My environment:
Windows XP Home
PostgreSQL 8.2 (on localhost)
LogicAlloy 1.2.2 (on localhost)
My MySQL database subscriber works perfectly but I can't create a postgresql subscriber.
Error:
com.logicalloy.ale.exception.ImplementationException: An error occurred while adding the subscriber.
com.logicalloy.ale.Spec.subscribe(Spec.java:251)
com.logicalloy.ale.ALE.subscribe(ALE.java:156)
com.logicalloy.ale.mgmt.SubscribersAction.update(SubscribersAction.java:134)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:150)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
org.mortbay.http.HttpServer.service(HttpServer.java:909)
org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
I figured out it needs the following table(it works with mysql):
CREATE TABLE `tbleventreport` (
`id` varchar(250) default NULL,
`tagbits` varchar(250) default NULL,
`encodingtype` varchar(250) default NULL,
`tagid` varchar(250) default NULL,
`aleid` varchar(250) default NULL,
`ecspecname` varchar(250) default NULL,
`groupname` varchar(250) default NULL,
`ecreportname` varchar(250) default NULL,
`terminationcondition` varchar(250) default NULL,
`reporttimestamp` varchar(250) default NULL,
`tagtimestamp` varchar(250) default NULL,
`tagslogicalreader` varchar(250) default NULL,
`tagsantennaport` varchar(250) default NULL,
`filter` varchar(250) default NULL,
`gmi` varchar(250) default NULL,
`serialnum` varchar(250) default NULL,
`generalmanagernum` varchar(250) default NULL,
`objectclass` varchar(250) default NULL,
`partition` varchar(250) default NULL,
`companyprefix` varchar(250) default NULL,
`itemreference` varchar(250) default NULL,
`serialreference` varchar(250) default NULL,
`assettype` varchar(250) default NULL,
`individualassetreference` varchar(250) default NULL,
`locationreference` varchar(250) default NULL,
`extensioncomponent` varchar(250) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
But with postgre it's not work. Can anyone help me, what do I wrong?
Thanks!
Akos Kiszely