Hi,
I use the preferred id generation method ID_TABLE and IDBroker.
I have no problems to write in the visitor table from Turbine when
it is a new tuple. The system work right! But If I want to write a new
tuple in my own tables, I encoured this problem (for all tables):
My request is like some this:
// Request in the Visitor table: does match it!
Criteria cCreateVisitor = new Criteria();
cCreateVisitor.add(TurbineUserPeer.USERNAME, username);
cCreateVisitor.add(TurbineUserPeer.PASSWORD, password);
cCreateVisitor.add(TurbineUserPeer.LAST_NAME, surname);
cCreateVisitor.add(TurbineUserPeer.FIRST_NAME, name);
Object oVisitorid = TurbineUserPeer.doInsert(cCreateVisitor);
Integer createVisitorid = new Integer(oVisitorid.toString());
int visitorid = createVisitorid.intValue() ;
System.out.println(visitorid);
// But this doesn't match (But does match in the compilation form):
Criteria cCreatePerson = new Criteria();
cCreatePerson.add(PersonPeer.NAME, name);
Object oCreatePerson = PersonPeer.doInsert(cCreatePerson);
Integer CreatePersonId = new Integer(oCreatePerson.toString());
int PersonId = CreatePersonId.intValue() ;
The console "say":
Update (select) whereClause=TABLE_NAME='Visitor'
472
Update (select) whereClause=TABLE_NAME='person'
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:293)
at
oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java,
Compiled Code)
at
oracle.jdbc.driver.OracleStatement.getLongValue(OracleStatement.java:1896)
at
oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:1882)
at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:235)
at org.apache.turbine.util.db.IDBroker.selectRow(IDBroker.java:554)
at org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java, Compiled
Code)
at org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:226)
at org.apache.turbine.util.db.IDBroker.getNextId(IDBroker.java:199)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:695)
at org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:615)
Notes:
- I can read in my own DB and I can make an update in an existing tuple
(But this tuple has been created in SQL request with the worksheet of
Oracle)
- I have puted TableMap.IDBROKERTABLE in the all om.map
- The tuples in the table ID_TABLE are correctly inserted!
It seems to have a problem to write a new tuple, with my drivers?! I
use
the classes111.jar jdbc drivers!
somebody knows this problem?!
Thanks to help
J.G
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
