You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Don Hill <do...@eweb-service.com> on 2003/01/21 17:55:24 UTC
Re[2]: postgresql
Hello Antoine,
Tuesday, January 21, 2003, 11:00:28 AM, you wrote:
AS> Please,
AS> somebody can help me
AS> Thanks
AS> ----- Original Message -----
AS> From: "Antoine Santos" <an...@cgbi.fr>
AS> To: "Jetspeed Users List" <je...@jakarta.apache.org>
AS> Sent: Monday, January 20, 2003 4:10 PM
AS> Subject: postgresql
AS> Hello,
AS> I have a problem with my postgresql database.
AS> I can't add un new user.
AS> What's the problem.
AS> Thank for the help.
AS> This is my conf:
AS> torque.database.default=default
AS> torque.database.default.adapter=postgresql
AS> torque.dsfactory.default.connection.driver = org.postgresql.Driver
AS> torque.dsfactory.default.connection.url =
AS> jdbc:postgresql://127.0.0.1:5432/jetspeedDB
AS> torque.dsfactory.default.connection.user = sa
AS> torque.dsfactory.default.connection.password =
AS> torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc
AS> eFactory
AS> torque.dsfactory.default.pool.defaultMaxConnections=10
AS> torque.dsfactory.default.pool.maxExpiryTime=3600
AS> torque.dsfactory.default.pool.connectionWaitTimeout=10
AS> This is the error:
AS> <!--StartFragment-->Horrible Exception:
AS> java.lang.reflect.InvocationTargetException: java.sql.SQLException: ERROR:
AS> ExecAppend: Fail to add null value in not null attribute user_id
AS> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
AS> at
AS> org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
AS> .java:505)
AS> at
AS> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
AS> ava:320)
AS> at
AS> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
AS> ava:48)
AS> at
AS> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State
AS> ment.java:197)
AS> at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
AS> at com.workingdogs.village.Record.save(Unknown Source)
AS> at com.workingdogs.village.Record.save(Unknown Source)
AS> at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
AS> at
AS> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
AS> bineUserPeer.java:242)
AS> at
AS> org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
AS> bineUserPeer.java:215)
AS> at
AS> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
AS> TurbineUserManagement.java:309)
AS> at
AS> org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
AS> gement.java:134)
AS> at
AS> org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
AS> 238)
AS> at
AS> org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns
AS> ert(UserUpdateAction.java:251)
AS> --
AS> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
AS> For additional commands, e-mail: <ma...@jakarta.apache.org>
Seems to me that you need to compare the tables that come with
Jetspeed hypersonic and postgres, is there identity columns, have you
created some columns with a not null attr.
Another test would be to get the sql that is being executed, try to
execute it in the psql tool, does it suceed or do you get the same
error.
HTH
--
Best regards,
Don mailto:donhill@eweb-service.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Re[2]: postgresql
Posted by Antoine Santos <an...@cgbi.fr>.
I compare the structure tables of hypersonic database and postgres database
:
- the columns user_id is not an identity column (as in the
turbine-postgres.sql file)
I succeeded an insert sql in the turbine_user in the psql tool.
I don't understand why user_id has a null value
org.apache.jetspeed.services.security.UserException: Failed to create
account 'test': ERROR: ExecAppend: Fail to add null value in not null
attribute user_id
is there any users that use postgresql with jetspeed?
----- Original Message -----
From: "Don Hill" <do...@eweb-service.com>
To: "Jetspeed Users List" <je...@jakarta.apache.org>
Sent: Tuesday, January 21, 2003 5:55 PM
Subject: Re[2]: postgresql
> Hello Antoine,
>
> Tuesday, January 21, 2003, 11:00:28 AM, you wrote:
>
> AS> Please,
> AS> somebody can help me
> AS> Thanks
>
> AS> ----- Original Message -----
> AS> From: "Antoine Santos" <an...@cgbi.fr>
> AS> To: "Jetspeed Users List" <je...@jakarta.apache.org>
> AS> Sent: Monday, January 20, 2003 4:10 PM
> AS> Subject: postgresql
>
>
> AS> Hello,
>
> AS> I have a problem with my postgresql database.
> AS> I can't add un new user.
> AS> What's the problem.
>
> AS> Thank for the help.
>
> AS> This is my conf:
> AS> torque.database.default=default
> AS> torque.database.default.adapter=postgresql
> AS> torque.dsfactory.default.connection.driver = org.postgresql.Driver
> AS> torque.dsfactory.default.connection.url =
> AS> jdbc:postgresql://127.0.0.1:5432/jetspeedDB
> AS> torque.dsfactory.default.connection.user = sa
> AS> torque.dsfactory.default.connection.password =
> AS>
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc
> AS> eFactory
> AS> torque.dsfactory.default.pool.defaultMaxConnections=10
> AS> torque.dsfactory.default.pool.maxExpiryTime=3600
> AS> torque.dsfactory.default.pool.connectionWaitTimeout=10
>
> AS> This is the error:
> AS> <!--StartFragment-->Horrible Exception:
> AS> java.lang.reflect.InvocationTargetException: java.sql.SQLException:
ERROR:
> AS> ExecAppend: Fail to add null value in not null attribute user_id
> AS> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
> AS> at
> AS>
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
> AS> .java:505)
> AS> at
> AS>
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
> AS> ava:320)
> AS> at
> AS>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
> AS> ava:48)
> AS> at
> AS>
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State
> AS> ment.java:197)
> AS> at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
> AS> at com.workingdogs.village.Record.save(Unknown Source)
> AS> at com.workingdogs.village.Record.save(Unknown Source)
> AS> at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
> AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
> AS> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
> AS> at
> AS>
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
> AS> bineUserPeer.java:242)
> AS> at
> AS>
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
> AS> bineUserPeer.java:215)
> AS> at
> AS>
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
> AS> TurbineUserManagement.java:309)
> AS> at
> AS>
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
> AS> gement.java:134)
> AS> at
> AS>
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
> AS> 238)
> AS> at
> AS>
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns
> AS> ert(UserUpdateAction.java:251)
>
>
>
>
> AS> --
> AS> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> AS> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
> Seems to me that you need to compare the tables that come with
> Jetspeed hypersonic and postgres, is there identity columns, have you
> created some columns with a not null attr.
>
> Another test would be to get the sql that is being executed, try to
> execute it in the psql tool, does it suceed or do you get the same
> error.
>
> HTH
>
> --
> Best regards,
> Don mailto:donhill@eweb-service.com
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>