Hi, > Hello, > > I've been reading the extensive documentation at the OJB > site, but I was > wondering if someone could help me out with this small question to see > if OJB will work for my 'little' project. The questions might be a > little newbie-ish and I apologize in advance. > > [preface] > In our database, I have resources that are mapped out in Graph data > structures, much like a file system. Currently all DB calls are done > via stored procedures, but I am thinking I will need to come > up with an > alternative method for updating resources in the graph since the OJB > Cache will become dirty if I encapsulate too much at the DB.
exactly! > > [questions] > Can I get OJB to use a stored procedure to take over CRUD methods? If > so, at what layer/file do I need to modify? Have a lookt ate class SqlGenerator. it is responsible for generating the necessary SQL code. Currently we have no mechanisms to plugin user defined SqlGenerators, but this can be easily done if necessary. For the time being you might start to modify the existing code. > Is it possible to have the OJB validate against a timestamp on a table > row? yes, you can declare optimistic locking for Version or timstamp columns. cheers, Thomas This would be important if I am able to encapsulate > more at the DB > and if we would have a cluster of Tomcat Servers talking to a > single DB > (independent OJB caches). > > Any help would be greatly appreciated! > > Regards, > Jacob > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002 > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
