Dear list,
I am trying to use NewAccout.jsp in "WEB-INF\templates\jsp\screens\html"
as a template for a form use to create a new account. When I submit this form
to create a new user I get an error saying that "ORA-02289: sequence does not
exist" (I'm using oracle as back end database), so I check with the torque
classes generated from security-schema.xml that come with jetspeed, the classes
such as "TurbineUser.java", "TurbineUserMapBuilder.java" have no mentioned of
using database sequence to genereate the ID, although the oracle script that
come with jetspeed for generating TURBINE_USER and other tables has an
instruction to create sequence associated with these tables. So what I did is
to modify the security-schema.xml file and regenerate the torque classes and I
have test this classes out side of web portal application, it work fine by
creating a new user with the ID taken form the specify oracle sequence, for
example new user in TURBINE_USER table take the ID from TURBINE_USER_SEQ.
But when I try to run everything from the context of the portal application
with my modify torque classes, I get the exception inside the "left.jsp" page
(when request the home page of the portal application) with rundata object
reference in this page have the value of null. Below is the example of my
security-schema.xml (just for table TURBINE_USER).
<table name="TURBINE_USER" idMethod="native">
<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>
<id-method-parameter value="TURBINE_USER_SEQ"/>
</table>
what exactly should I do to solve this problem or make this NewAccout.jsp work
with oracle database and using the sequence to generate the ID for a new user
added to the database.
Regards,
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! � Get yours free!
