What is the database? If is Oracle or SapDB, exists specifics sequence managers that works with Sequences (from Oracle and Sap sequence objects - so you don't need the tables).
As I learned from time working with OJB, if you work "in memory" and uses sequences from Sap or Oracle, you don't need any extra table created on database (I've all tables, but they are always empty - and my "jdbc captured log" shows no command using this tables). Thomas, can you correct-me if I'm wrong? M2c, Edson Richter -----Mensagem original----- De: Ryan Joseph [mailto:[EMAIL PROTECTED]] Enviada em: Monday, November 18, 2002 4:14 AM Para: OJB Users List Assunto: Sequence Mgr/Primary Key problem Hello, I am trying to store a simple object that contains a primary key object. My OJB install seems to work out fine as far as queries go, but storing produces the following error: [org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException during the execution of materializeObject (for a org.apache.ojb.broker.util.sequence.HighLowSequence): General error: Table 'TulipQA.OJB_HL_SEQ' doesn't exist General error: Table 'TulipQA.OJB_HL_SEQ' doesn't exist My DB name is TulipQA. There is no table OJB_HL_SEQ in TulipQA, but there is an ojb database that DOES contain this table. Do I need to do some more setup to get the auto-increment for a PK working? Here is a my field descriptor: <field-descriptor id="1" name="id" column="pkTestCaseID" jdbc-type="INTEGER" primarykey="true" autoincrement="true" /> Here is the relevant excerpt from my class: private int id; private String testCaseName; private String testCaseCode; public void setId(int new_id){ id = new_id; } public int getId(){ return id; } If anyone can offer any help/assistance, that would be great. If I can provide any additional information - let me know. Thanks -Ryan -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> --- E-Mail recebido est� sem virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 11/13/2002 --- Email foi verificado quanto a exist�ncia de virus antes de seu envio, e n�o h� virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 11/13/2002 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
