Re: [Springframework-developer] Generated keys support

[Thomas R. <tho...@tr...>]

I'd like to wrap this up -

For SqlUpdate - I'm removing update(Object[], List) and leaving 
update(Object[], KeyHolder)

For JdbcTemplate - I'm changing update(PreparedStatementCreator, List) 
to update(PreparedStatementCreator, KeyHolder)

I'm also moving KeyHolder/GeneratedKeyHolder to jdbc.support package.

I'm comitting these changes tonight.

Thomas


Thomas Risberg wrote:

> We could add an update(PreparedStatementCreator, KeyHolder) method to 
> JdbcTemplate - should we get rid of the 
> update(PreparedStatementCreator, List) at the same time to keep things 
> simpler?  This would force the use of the KeyHolder.
>
> Thomas
>
> jürgen höller [werk3AT] wrote:
>
>> Oh, I didn't notice this. I was just wondering because JdbcTemplate's 
>> update(PreparedStatementCreator, List) method still takes a List for 
>> generated keys... Shouldn't it use a KeyHolder too? KeyHolder and co 
>> would have to reside in the core package then, I guess, because 
>> jdbc.core.support is intended to refer to jdbc.core but not the other 
>> way round. jdbc.support would be OK too, provided that KeyHolder does 
>> not depend on jdbc.core.
>>
>> Juergen
>>
>>
>> ________________________________
>>
>> Von: spr...@li... im Auftrag 
>> von Thomas Risberg
>> Gesendet: Sa 17.07.2004 19:31
>> An: spr...@li...
>> Betreff: Re: [Springframework-developer] Generated keys support
>>
>>
>>
>> I added a KeyHolder interface and a GeneratedKeyHolder class (in
>> jdbc.support).  They are used by the SqlUpdate.update(Object[],
>> KeyHolder) method.
>>
>> Here is an example:
>>
>>        SqlUpdate su = new SqlUpdate(dataSource, "insert into Show2
>> (name) values(?)");
>>        su.declareParameter(new SqlParameter("name", Types.VARCHAR));
>>        su.setReturnGeneratedKeys(true);
>>        su.setGeneratedKeysColumnNames(new String[] {"id"}); //this has
>> no effect for MySQL only DB2
>>        su.compile();
>>        Object[] val = {"Sven"};
>>        KeyHolder kh = new GeneratedKeyHolder();
>>        int updateCnt = su.update(val, kh);
>>        int myKey = kh.getKey().intValue();
>>        System.out.println("Key: " + myKey);
>>        List myKeys = kh.getKeyList();
>>        System.out.println(myKeys);
>>
>> Direct JdbcTemplate use would look like:
>>
>>        KeyHolder kh = new GeneratedKeyHolder();
>>        int rowsAffected =
>> getJdbcTemplate().update(newPreparedStatementCreator(args),
>> kh.getKeyList());
>>
>>
>> Thomas
>>
>> jürgen höller [werk3AT] wrote:
>>
>>  
>>
>>> Thomas,
>>>
>>> We discussed changing the List argument for generated keys into a 
>>> GeneratedKeysHolder class or the like, for easier access to a single 
>>> generated key (the typical use case). If we change that, we should 
>>> do so before 1.1 RC1, even if this means having 1.1 RC1 mid or late 
>>> next week rather than on Monday.
>>>
>>> Juergen
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by BEA Weblogic Workshop
>>> FREE Java Enterprise J2EE developer tools!
>>> Get your free copy of BEA WebLogic Workshop 8.1 today.
>>> http://ads.osdn.com/?ad_idG21&alloc_id040&op=click
>>> _______________________________________________
>>> Springframework-developer mailing list
>>> Spr...@li...
>>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>>
>>>
>>>
>>>
>>>
>>>   
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by BEA Weblogic Workshop
>> FREE Java Enterprise J2EE developer tools!
>> Get your free copy of BEA WebLogic Workshop 8.1 today.
>> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by BEA Weblogic Workshop
>> FREE Java Enterprise J2EE developer tools!
>> Get your free copy of BEA WebLogic Workshop 8.1 today.
>> http://ads.osdn.com/?ad_idG21&alloc_id040&op=click
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>  
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>