Re: Fw: [Springframework-developer] insert functionality in jdbc package

[Isabelle M. <isa...@me...>]

Hi everyone,

Personally, I don't think I'd want to commit to yet another framework such as hibernate for ex. in the project at work we're planning to do with spring. Most of what we need for jdbc is in spring, except for the insert functionality. Even with oracle, I don't like the idea of having to write a stored procedure for every single insert, I'd probably opt for the additional cost of a select next_val from dual in jdbc code (i.e. instead of just doing an insert, first retrieve the key val then do the insert). The main problem is with db's that don't have sequences, and if we agree to live with holes in the primary key sequences we can implement an algorithm where some sort of key manager per VM reserves a range of key values per table.

Isabelle


On Tue, Apr 15, 2003 at 09:10:13PM +0100, Rod Johnson wrote:
> Reply to again.
> 
> > I agree with Juergen. I don't think we should get carried away and think
> we
> > should compete with Hibernate and co.
> >
> > Spring JDBC is not O/R mapping. That space is way too crowded already.
> >
> > This is not to say that we cannot take on one or two selected problems,
> such
> > as those Isabelle proposed. But we have to be clear on the scope
> limitation.
> >
> > Regards,
> > Rod
> >
> > ----- Original Message -----
> > From: "jürgen höller [werk3AT]" <jue...@we...>
> > To: <spr...@li...>
> > Sent: Tuesday, April 15, 2003 10:56 AM
> > Subject: RE: [Springframework-developer] insert functionality in jdbc
> > package
> >
> >
> > Hi Isabelle, everyone,
> >
> > IMO we should rethink the scope of Spring's JDBC package. Insert
> > functionality would definitely make sense, but we are moving more and more
> > towards full-fledged persistence. That area is a crowded one: E.g. the
> issue
> > of unique key retrieval is typically solved by almost every O/R mapping
> > toolkit around.
> >
> > We should try to solve many typical problems, of course. But we should
> also
> > stick to a clear scope, without trying to compete with more focussed
> > solutions - just like we're already sticking to e.g. J2EE DataSources,
> > Log4J, JSP, and Velocity. They may not be perfect but they are good
> enough,
> > at least if you add some convenience stuff.
> >
> > I like Hibernate's "do one thing well" attitude
> > (http://hibernate.bluemars.net/38.html): "Be the best at something. Let
> > other projects worry about all the other things which you can't be the
> best
> > at." And: "Scope creep sinks more open source projects than any other
> > danger". I feel that we're already rather close to that frontier.
> >
> > Regards,
> > Juergen
> >
> >
> > -----Original Message-----
> > From: Isabelle Muszynski [mailto:met...@pa...]
> > Sent: Friday, April 11, 2003 9:30 AM
> > To: spr...@li...
> > Subject: [Springframework-developer] insert functionality in jdbc
> > package
> >
> >
> > Hi everyone,
> >
> > I feel we need insert functionality in the jdbc package. Depending on
> stored
> > procedures as Rod advises in his book is not always a solution, for ex.
> > mySQL does not currently support stored procedures. This introduces the
> > topic of unique key retrieval which is again very DB-dependent. We cannot
> > assume the DB has sequences or auto-increment columns.
> >
> > See http://ejbutils.sourceforge.net
> >
> > Your thoughts on this please.
> >
> > Isabelle
> >
> > --
> > Isabelle Muszynski
> > Zandweellaan 4
> > 2660 Antwerpen
> > Belgium
> > Tel. 32-(0)3-830 18 54
> > Mobile: 32-(0)485 49 50 89
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Etnus, makers of TotalView, The
> debugger
> > for complex code. Debugging C/C++ programs can leave you feeling lost and
> > disoriented. TotalView can help you find your way. Available on major UNIX
> > and Linux platforms. Try it free. www.etnus.com
> > _______________________________________________
> > Springframework-developer mailing list
> > Spr...@li...
> > https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Springframework-developer mailing list
> > Spr...@li...
> > https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
> 
> 

-- 
Isabelle Muszynski
Software Engineer
Zandweellaan 4
2660 Antwerpen
Belgium
Tel. 32-(0)3-830 18 54
Mobile: 32-(0)485 49 50 89
Email: isa...@me...
Website: www.meta-logix.com