You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by GUY Laurent Ext OCISI <lg...@francetelecom.com> on 2004/07/09 09:24:27 UTC
Error "turbine_user" is not a sequence when adding a new user
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Error "turbine_user" is not a sequence when adding a new user
Posted by "Henning P. Schmiedehausen" <hp...@intermeta.de>.
GUY Laurent Ext OCISI <lg...@francetelecom.com> writes:
>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.
don't use "native" for the ID column in your table schema.
Regards
Henning
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
hps@intermeta.de +49 9131 50 654 0 http://www.intermeta.de/
RedHat Certified Engineer -- Jakarta Turbine Development -- hero for hire
Linux, Java, perl, Solaris -- Consulting, Training, Development
"Fighting for one's political stand is an honorable action, but re-
fusing to acknowledge that there might be weaknesses in one's
position - in order to identify them so that they can be remedied -
is a large enough problem with the Open Source movement that it
deserves to be on this list of the top five problems."
-- Michelle Levesque, "Fundamental Issues with
Open Source Software Development"
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org