Problem with SQL Server and Ojb

2005-02-17 Thread Kevin Viet
Hello I am using db-ojb-1.0.1.jar. My database is running on a server using Microsoft SQL Server. I have a problem with the high/low sequence generation with the OJB_HL_SEQ table. When I create a new object in my application, I store it immediately in the database and get the following error :

RE: Problem with SQL Server and Ojb

2005-02-17 Thread Kevin Viet
: OJB Users List Objet : Re: Problem with SQL Server and Ojb Hi Kevin, which driver do you use, Sun's JdbcOdbc bridge? If yes, this could lead to problems, try a real (don't use type 1 driver) jdbc-driver instead. Sorry can't help more, never used MSSQL. regards, Armin Kevin Viet wrote: Hello

RE: Problem with SQL Server and Ojb

2005-02-17 Thread Kevin Viet
that scheme on SQL server, it's never worked well for me, especially in multiple app server farm situations. I would use the StoredProcedureSequenceImpl or the Native one (haven't tried the native one myself though). Ryan -Original Message- From: Kevin Viet [mailto:[EMAIL PROTECTED] Sent