HOWTO: Calculate primary key inside the insert stored procedure

Hi all We are trying to insert objects into the table using OJB through some stored procedure (MS SQL 2000) _without_ specifying the primary key (so initially it is null). The key is supposed to be calculated inside the stored procedure. Unfortunately, we get exception assertValidPkFields - it

Re: Primary key/sequence for MS SQL server

Just in case anyone interested. I found the matter of problem. It is between OJB and JDBC driver (I used jtds driver). The thing is that HiLo seq. manager using the type java. lang.Long as a value for the unique id. And in the table it is INTEGER (and in repository_internal.xml as well). So this

Stored procedures in MS SQL

Hello all I am trying to make OJB work with the stored procedures on MS SQL server. In the documentation, it is mentioned that only Oracle SPs are supported. Is it difficult to add support for MS SQL? What are the main problems? Anyone tried? Regards, Sergey

RE: Stored procedures in MS SQL

I don't think that the current documentation was meant to imply that it only works for Oracle, however, the docs are out of sync with CVS at the moment. OJB CVS has support for using repository.xml to define sp's for insert, update, and delete of objects. Well, the question is how stable is

Primary key/sequence for MS SQL server

Hello all 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

OJB as JDO implementation: status request

Hello folks We are starting some project and would love to use some JDO implementation. We like ojb (well, just looking at the docs and the site:) - but concerned about the level of compatibility with Sun specs. We could not find any info on that subject on the web site - so could please anyone