JS 1.6: Constraint-Problems with PostgreSQL 8

[Hans Plum <pl...@lat-lon.de>]

Hi all,

I am using Jetspeed 1.6 with PostgreSQL 8.1. After several problems and a lot of
searching the mailing lists, I figured out, that I had to

1. fix the src/sql/external/turbine-postgres.sql for the turbine_user table with
the password_changed column (changed the populate-skript accordindly)

2. change the datatype of turbine_user.objectdata from oid to bytea (otherwise
got some village errors)

3. used the torque-bindings from
http://www.bluesunrise.com/maven/jetspeed/distributions/torque-om/postgresql/jetspeed-torque-om-1.6.jar

Now, I am runing into a constraint problem (stacktrace see below).

For me it looks that the SQL scripts are some kind of outdated :-| ... is
somebody out there who could point me to a set of working SQL scripts for
PostgreSQL (working with the torque-bindings from bluesunrise or others) or give
some advice how to proceed/where to look at.

Any help is really appreciated. Thanks,
Hans




2006-11-03 11:19:52,780 [http-8080-Processor25] ERROR TurbineUserManagement -
Failed to create account 'hans11'
org.apache.torque.TorqueException: org.postgresql.util.PSQLException: ERROR:
null value in column "user_id" violates not-null constraint
        at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
        at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
        at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:241)
        at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
        at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
        at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
        at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
        at
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doInsert(UserUpdateAction.java:200)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.jetspeed.modules.actions.portlets.PortletActionEvent.fireEvent(PortletActionEvent.java:176)
        at
org.apache.jetspeed.modules.actions.portlets.PortletActionEvent.executeEvents(PortletActionEvent.java:133)
        at
org.apache.jetspeed.modules.actions.portlets.SecureVelocityPortletAction.executeEvents(SecureVelocityPortletAction.java:42)
        at
org.apache.jetspeed.modules.actions.portlets.GenericMVCAction.perform(GenericMVCAction.java:115)
        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:563)
        at org.apache.turbine.Turbine.doPost(Turbine.java:658)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"user_id" violates not-null constraint
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
        at com.workingdogs.village.Record.save(Unknown Source)

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org