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

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

Hello Kees,

In the current framework, you indeed should use update for inserts. And the special overloaded forms of update with a KeyBinder argument for the key generation.

Isabelle

On Sun, May 18, 2003 at 11:16:18AM +0200, kees jan voogd wrote:
> Hi Isabelle,
> 
> 
> For what it's worth I agree with you. You just can't put everything in
> stored procedures. Omission of inserts from the framework was a mistake and
> an omission in an ohterwise very readable book.
> 
> For your solotion I would not look into pk (or guid) generation right away.
> This is just a part of the inserts. And a very nasty issue one at that too.
> 
> I've been using the JdbcTemplate's update methods for inserts. The only iffy
> thing there is that the method call is update instead of insert (logged as
> update aswell). A change there would be sufficient (imho).
> 
> As for pk generation i've been using the select SEQ.nextval from dual bit. I
> built numbergeneratator class doing these selects. (based on just table name
> SEQ_PK_table and SEQ_table_colum for other sequences).
> 
> Complete integration of pk generatation into the framwork would provide
> quite a lot of problems (more then they would solve ??).
> 
> 
> 
> anyway,
> 
> 
> 
> Goodluck !
> 
> 
> 
> KJ
> 
> 
> 
> 
> 
> 
> 
> "Isabelle Muszynski" <isa...@me...> wrote in message
> news:<200...@lu...>...
> > Will have a look at how we could best incorporate insert functionality and
> will get back to you.
> >
> > Isabelle
> >
> >
> > On Wed, Apr 16, 2003 at 02:10:56PM +0100, Rod Johnson wrote:
> > > Isabelle,
> > >
> > > You make a valid point about not wanting to need another product for
> just
> > > one problem.
> > >
> > > My view is that
> > > - we don't want to get into full-blown O/R mapping
> > > - BUT there is scope in building more JDBC-based functionality and
> > > abstractions on top of the Spring JDBC way of doing things. To my mind
> the
> > > central value proposition of Spring JDBC is the exception hierarchy and
> way
> > > it frees developers of the tedious and error-prone tasks of raw JDBC.
> > > Additional features can validly be layered on top.
> > >
> > > So I think you should propose how you think we should add the insert
> > > functionality, perhaps even implement it, so we can discuss it and
> > > incorporate it if we're all comfortable with it. I think it's
> > > - important that any abstraction shouldn't impose potential
> inefficiency,
> > > and should allow the use of efficient RDBMS functions like Oracle
> sequences
> > > - important that it should be compatible with JDBC 3.0 moving forward.
> > >
> > > Thomas, do you have any thoughts on this?
> > >
> > > Regards,
> > > Rod
> > >
> > > > 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
> > >
> > >
> > >
> > >
> > >
> >
> > --
> > 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
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/03
> 
> 
> 

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