Re: HOWTO: Calculate primary key inside the "insert" stored procedure

> Did you tried to set field as read-only? > access = "read-only" Not yet. I will though. Right now. > OJB version? Straight from CVS HEAD (well, yesterday) Thanks for the idea, -- Sergey - To unsubscribe, e-mail: [EMAIL PRO

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 see

RE: Stored procedures in MS SQL

Ron, > I just submitted to the OJB-dev mailing list an update to the documentation > related to OJB's support for stored procedures. Look for it to appear on > the OJB website sometime soon. Thanks a million. This is exactly what I asked. -- 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 i

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: 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 s

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 requeste

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 gi