Great !
Thanks Frank,
youngho
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Frank Kim
Sent: Wednesday, March 01, 2000 12:20 PM
To: Turbine
Subject: RE: How do I set the ID_TABLE initial value ??
> I would like to make a new user account with
> CreateNewUserAndLogin action in
> Jyve Package.
The comments in CreateNewUserAndLogin say:
This class is not used and is thus commented out, but is shown as an
example of
simply creating a new user. The reason it is commented out is because we
use the
CreateNewUserAndConfirm action by default. -JSS
But if you want to get it working let's just take the simple case and assume
you are using mySql which is the "default" supported database for Jyve. You
can try adding use.autoincrement.id=true to TurbineResources.properties. In
BasePeer.doInsert() this will do an insert assuming the database has an auto
increment feature like mysql. This feature hasn't been thoroughly tested so
your feedback is appreciated.
Or you can just use Village directly like in CreateNewUserAndConfirm.
>
> But when I tried to , the following error message happened.
>
> java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
> at java.util.Vector.elementAt(Vector.java)
> at org.apache.turbine.util.db.IDBroker.selectRow
> at org.apache.turbine.util.db.IDBroker.getNextIds
> at org.apache.turbine.util.db.IDBroker.getNextId
> at org.apache.turbine.om.peer.BasePeer.doInsert
> at org.apache.turbine.om.user.peer.TurbineUserPeer.doInsert
> at org.apache.turbine.modules.actions.CreateNewUser.build
> at org.apache.turbine.modules.ActionLoader.exec
> at org.apache.turbine.modules.actions.CreateNewUserAndLogin.build
>
> Actually the code exeuted some BasePeer routine more
> including BasePeer.executeQuery(queryString, "defalut", false) and
> BasePeer.getSelectResults( qds, 0, -1, false ) method
> with the quaryString = SELECT TABLE_NAME, NEXT_ID, QUANTITY FROM ID_TABLE
> WHERE TABLE_NAME = 'Visitor'.
> And the return results vector size is 0.
>
> I suspect that this comes from ID_TABLE initial value.
> I made the ID_TABLE but didn't insert any value.
The IDBroker stuff is meant to make apps more database independent by not
relying on db specific features like auto increment or Oracle sequences.
Jyve isn't set up to use it right now though.
Hope this helps.
> I need your help.
>
> Thansk in advance.
>
> youngho
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
