Hi, I repost this message here because I don't think the jetspeed-user list was the
right place.
Any help would be fully appreciated on this problem.
I use Jetspeed 1.5 (with Torque 3.1) on my local host, and PostgreSQL 7.3.2, on a
Linux server
I try to add a new user :
String username="foo";
JetspeedUser jUser = new BaseJetspeedUser();
jUser.setName(username);
jUser.setUserName(username);
jUser.setPassword(username);
jUser.setFirstName(username);
jUser.setLastName(username);
jUser.setEmail(username+"@test.com");
jUser.setConfirmed(User.CONFIRM_DATA);
try {
JetspeedSecurity.addUser(jUser);
}
catch (Exception e) {
logger.error("Error adding user in DB ["+e.toString()+"]");
}
And I get this exception :
Error adding user in DB [org.apache.jetspeed.services.security.UserException: Failed
to create account 'foo': ERROR: "turbine_user" is not a sequence
Although the exception is thrown, the new user is added in database.
(The TURBINE_USER table has a sequence named TURBINE_USER_SEQ on USER_ID field)
I get the same problem when Jetspeed tries to create the default.psml :
turbine_user_profile is not a sequence.
Here has the logs in jetspeedservices.log :
org.postgresql.util.PSQLException: ERROR: "turbine_user" is not a sequence
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
at com.workingdogs.village.QueryDataSet.<init>(Unknown Source)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncrementIdGenerator.java:194)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncrementIdGenerator.java:127)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:771)
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)
[...]
rethrown as
org.apache.torque.TorqueException: ERROR: "turbine_user" is not a sequence
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:780)
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)
[...]
Caused by: org.postgresql.util.PSQLException: ERROR: "turbine_user" is not a sequence
at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
at com.workingdogs.village.QueryDataSet.<init>(Unknown Source)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncrementIdGenerator.java:194)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncrementIdGenerator.java:127)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:771)
... 56 more
Any idea about this ?
Laurent
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
