Hi, normally the map builder classes generated by torque provides the name for the source of new ids for inserts. The map builder classes should correspond to the peer classes. Maybe you can check the sources for this.
Yours, Holger Wessels -- Holger We�els T-Systems Systems Integration T-Systems Nova GmbH Berkom Experte F&E Hausadresse: Goslarer Ufer 35, 10589 Berlin Telefon: (030) 34 97 - 22 66 Telefax: (030) 34 97 - 22 67 E-Mail: [EMAIL PROTECTED] Internet: http://www.t-systems.com Intranet: http://berkom.telekom.de -----Urspr�ngliche Nachricht----- Von: Pierre Henry [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 11. M�rz 2003 12:00 An: Jetspeed User List (E-mail) Betreff: oracle : bad sequence name hi, I have the following problem : I use views instead of tables for the turbine security tables. These views are based on tables that are common to several applications, but i don't need all the fields of these tables so I made views with only the fields corresponding to the original turbine fields. ( eg: the table WEB_USERS and the view V_TUR_USERS, V_TUR_USERS has exactly the same fields than the original TURBINE_USER table ) It works fine to do selects, but: when I want to insert a new user, torque is looking for a sequence whith the same name as my view. Obviously, there can't be any sequence with the same name as a view. I want to use a sequence which is valid for the basic table, not only the view. Another possibility would be not to use any sequence in the java code, but to do it via an Oracle trigger on the inserts into the table. So my question is : is there a way I can specify the name of the sequence to use with the "native" id method, or to completely block any sequence access. I tried to use "none" instead of "native" (modify security schema.xml and regenerate the Peers classes) but it still tries to read from the wrong sequence... follow an part of my schema.xml and the extract of my log file. Any suggestion welcome ! Pierre security-schema.xml : <database> <table name="V_TUR_USER" idMethod="none" javaName="TurbineUser"> <column name="USER_ID" required="true" primaryKey="true" autoIncrement="true" type="INTEGER"/> <column name="LOGIN_NAME" required="true" size="32" type="VARCHAR"/> <column name="PASSWORD_VALUE" required="true" size="32" type="VARCHAR"/> <column name="FIRST_NAME" required="true" size="99" type="VARCHAR"/> <column name="LAST_NAME" required="true" size="99" type="VARCHAR"/> <column name="EMAIL" size="99" type="VARCHAR"/> <column name="CONFIRM_VALUE" size="99" type="VARCHAR"/> <column name="MODIFIED" type="TIMESTAMP"/> <column name="CREATED" type="TIMESTAMP"/> <column name="LAST_LOGIN" type="TIMESTAMP"/> <column name="DISABLED" size="1" type="CHAR"/> <column name="OBJECTDATA" type="BINARY"/> <column name="PASSWORD_CHANGED" type="TIMESTAMP"/> <unique> <unique-column name="LOGIN_NAME"/> </unique> </table> other tables.... </database> logfile : [11 mars 2003 11:57:30 DEBUG] - SELECT V_TUR_USER.USER_ID, V_TUR_USER.LOGIN_NAME, V_TUR_USER.PASSWORD_VALUE, V_TUR_USER.FIRST_NAME, V_TUR_USER.LAST_NAME, V_TUR_USER.EMAIL, V_TUR_USER.CONFIRM_VALUE, V_TUR_USER.MODIFIED, V_TUR_USER.CREATED, V_TUR_USER.LAST_LOGIN, V_TUR_USER.DISABLED, V_TUR_USER.OBJECTDATA, V_TUR_USER.PASSWORD_CHANGED FROM V_TUR_USER WHERE V_TUR_USER.LOGIN_NAME='demo1' [11 mars 2003 11:57:30 DEBUG] - Elapsed time=30 ms [11 mars 2003 11:57:43 DEBUG] - select V_TUR_USER.nextval from dual [11 mars 2003 11:57:43 ERROR] - CreateNewUserAndConfirm java.sql.SQLException: ORA-02289: la s�quence n'existe pas (=the sequence doesn't exist) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:679 ) at com.workingdogs.village.QueryDataSet.<init>(Unknown Source) at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(SequenceId Gene rator.java:195) at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(SequenceIdGe nera tor.java:132) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(Bas eTur bineUserPeer.java:242) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(Bas eTur bineUserPeer.java:215) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addU ser( TurbineUserManagement.java:309) at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUser Mana gement.java:134) at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.j ava: 238) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(Cr eate NewUserAndConfirm.java:206) at org.apache.turbine.modules.Action.perform(Action.java:87) etc, etc....
smime.p7s
Description: S/MIME cryptographic signature
