I am trying to use OJB and find it really comfortable. But there are some things still hard to understand.
I am trying to work with some very simple table (in Microsoft SQL) having the primary ID as INTEGER. As a SequenceManager, I use HiLo implementation. I do everything as requested - but the manager fails miserably on new object creation. First, I thought is misses OJB_HL_SEQ table - well, I created it manually (taken the script from tests). Then I turned the SQL logging on (to DEBUG level) and see that it is trying to do two SELECTs from OJB_HL_SEQ (by the tablename and fieldname) and then - one INSERT. And it failes on this INSERT - I get the error about inability to get the Identity for the new object. Is there any way I could get more information about the problem? What could this be?
More general question - what kind of SequenceManager people use for MS SQL server in clustered environment. As an application server we are going to use Tomcat and JBoss (and take DataSource from them as a connection pool).
Thanks for any hints,
Sergey
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
