You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Hans Plum <pl...@lat-lon.de> on 2006/11/08 12:14:41 UTC
JS 1.6 and PostgreSQL 8.x
Hi Developer Community,
last week I posted the attached email to the users list. I have still the same
problem with JS1.6 and PostgreSQL 8.1 when I try to add a user (see below).
Could anybody of you comment on JS1.6 and PostgreSQL 8.x in general? Did anybody
test JS1.6 against PostgreSQL 8.x?
Any comments are really appreciated.
Regards,
Hans
PS: I am looking forward to using JS2, but so fare I cannot switch because of
other restrictions.
-------- Original Message --------
Subject: JS 1.6: Constraint-Problems with PostgreSQL 8
Date: Fri, 03 Nov 2006 11:44:35 +0100
From: Hans Plum <pl...@lat-lon.de>
Reply-To: Jetspeed Users List <je...@portals.apache.org>
To: Jetspeed Users List <je...@portals.apache.org>
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
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by David Sean Taylor <da...@bluesunrise.com>.
Hans Plum wrote:
> Hi David,
>
> did you have the chance to do some first testing against PostgresSQL? If there
> is something to test on, please let us know ;-).
>
> Thanks,
> Hans
>
I haven't forgotten.
We now have PostgreSQL 8.1.5 installed here on one of the servers.
Im having trouble getting thru the firewall to the port right now.
Someone will be in tomorrow to help me out, and I'll test the 1.6
database then. No need to test 2.x since others are using it successfully
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by Hans Plum <pl...@lat-lon.de>.
David Sean Taylor wrote:
>
> Hans Plum wrote:
>
>> David Sean Taylor wrote:
>>
>>> Hans Plum wrote:
>>
>>
>> did you have the chance to do some first testing against PostgresSQL?
>> If there
>> is something to test on, please let us know ;-).
>>
> Hans, I modified the SQL scripts. They run for me.
> (I run them thru Ant, but you can run the scripts with another tool as
> well)
>
> Could you please test them out?
> See:
>
> http://issues.apache.org/jira/browse/JS1-565
Hi David,
sounds really good. I am not sure if I will find the time to test this week, but
I let you all know here as soon as possible.
Thanks in advance,
Hans
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by David Sean Taylor <da...@bluesunrise.com>.
Hans Plum wrote:
> David Sean Taylor wrote:
>> Hans Plum wrote:
>
> did you have the chance to do some first testing against PostgresSQL? If there
> is something to test on, please let us know ;-).
>
Hans, I modified the SQL scripts. They run for me.
(I run them thru Ant, but you can run the scripts with another tool as well)
Could you please test them out?
See:
http://issues.apache.org/jira/browse/JS1-565
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by Santiago Gala <sa...@gmail.com>.
I had 2.0 running with PostgreSQL 8.X for some time, no problem to report.
Not sure if changes in the schema broke it. Never tried 1.6 or 2.1 with it.
Regards
Santiago
On 11/15/06, Hans Plum <pl...@lat-lon.de> wrote:
>
> David Sean Taylor wrote:
> >
> > Hans Plum wrote:
> >
> >> Hi Developer Community,
> >>
> >> last week I posted the attached email to the users list. I have still
> >> the same
> >> problem with JS1.6 and PostgreSQL 8.1 when I try to add a user (see
> >> below).
> >>
> >> Could anybody of you comment on JS1.6 and PostgreSQL 8.x in general?
> >> Did anybody
> >> test JS1.6 against PostgreSQL 8.x?
> >>
> >> Any comments are really appreciated.
> >>
> >
> > I will install PostgreSQL (8.1.5) and see if I can work out any problems
> > with both 1.6 and 2.1. Will report my findings back to the list
>
> Hi David,
>
> did you have the chance to do some first testing against PostgresSQL? If
> there
> is something to test on, please let us know ;-).
>
> Thanks,
> Hans
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
>
>
Re: JS 1.6 and PostgreSQL 8.x
Posted by Hans Plum <pl...@lat-lon.de>.
David Sean Taylor wrote:
>
> Hans Plum wrote:
>
>> Hi Developer Community,
>>
>> last week I posted the attached email to the users list. I have still
>> the same
>> problem with JS1.6 and PostgreSQL 8.1 when I try to add a user (see
>> below).
>>
>> Could anybody of you comment on JS1.6 and PostgreSQL 8.x in general?
>> Did anybody
>> test JS1.6 against PostgreSQL 8.x?
>>
>> Any comments are really appreciated.
>>
>
> I will install PostgreSQL (8.1.5) and see if I can work out any problems
> with both 1.6 and 2.1. Will report my findings back to the list
Hi David,
did you have the chance to do some first testing against PostgresSQL? If there
is something to test on, please let us know ;-).
Thanks,
Hans
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by Hans Plum <pl...@lat-lon.de>.
David Sean Taylor wrote:
>
> Hans Plum wrote:
>
>> Hi Developer Community,
>>
>> last week I posted the attached email to the users list. I have still
>> the same
>> problem with JS1.6 and PostgreSQL 8.1 when I try to add a user (see
>> below).
>>
>> Could anybody of you comment on JS1.6 and PostgreSQL 8.x in general?
>> Did anybody
>> test JS1.6 against PostgreSQL 8.x?
>>
>> Any comments are really appreciated.
>>
>
> I will install PostgreSQL (8.1.5) and see if I can work out any problems
> with both 1.6 and 2.1. Will report my findings back to the list
Thanks David, that sounds really good :-). With your results, I would do some
testing for JS1.6 as well and let everybody know.
Regards,
Hans
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: JS 1.6 and PostgreSQL 8.x
Posted by David Sean Taylor <da...@bluesunrise.com>.
Hans Plum wrote:
> Hi Developer Community,
>
> last week I posted the attached email to the users list. I have still the same
> problem with JS1.6 and PostgreSQL 8.1 when I try to add a user (see below).
>
> Could anybody of you comment on JS1.6 and PostgreSQL 8.x in general? Did anybody
> test JS1.6 against PostgreSQL 8.x?
>
> Any comments are really appreciated.
>
I will install PostgreSQL (8.1.5) and see if I can work out any problems
with both 1.6 and 2.1. Will report my findings back to the list
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org