db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GUY Laurent Ext OCISI <lguy....@francetelecom.com>
Subject Error "turbine_user" is not a sequence when adding a new user
Date Fri, 09 Jul 2004 07:24:27 GMT
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


Mime
View raw message