Stored Procedure support (was Re: [Springframework-developer] Preparing for 1.0.2)

[Tim K. <tim...@vi...>]

Hi Juergen,

I brought up an question on this list a while ago about the=20
StoredProcedure object, and if there were a way to safely access=20
outside variables in the RowMapper instance, like for instance in a=20
StoredProcedure object that I played aruond with, it worked great as a=20=

replacement for the older one I wrote before with one exception.  There=20=

was a particular place where i relied on a value (a user id) for one of=20=

the parameters of the procedure, and there didnt seem to be a=20
threadsafe way to make it available (getting the value from the=20
parameter Map) in the RowMapper, or at least as far as my knowledge of=20=

java goes.

So I was wondering if you had seen that email and if there's something=20=

I'm missing here?  The only solution I could think of was to actually=20
set up the sql to place that value as a column so it'd be accessible=20
from the ResultSet, but I was hoping to avoid having to do that.

thanks in advance,

-tim


On May 27, 2004, at 10:53 AM, j=FCrgen h=F6ller [werk3AT] wrote:

> Thomas,
>
> Any chance to review the JDBC changes today, in particular testing=20
> whether the stored procedure stuff still works as expected? I do trust=20=

> unit test suites, but well, you know :-)
>
> Note that there's also an adapted version of imagedb's=20
> DefaultImageDatabase in CVS, illustrating the use of a RowMapper with=20=

> JdbcTemplate rather than a MappingSqlQuery operation object.
>
> BTW, I'm currently working on Quartz JDBCJobStore integration with=20
> Spring, for a werk3AT project. This won't make it into Spring 1.0.2,=20=

> though. If anyone has already prototyped in that direction, please let=20=

> me know!
>
> Juergen
>
>
> -----Original Message-----
> From: spr...@li...
> [mailto:spr...@li...]On =
Behalf
> Of j=FCrgen h=F6ller [werk3AT]
> Sent: Thursday, May 27, 2004 10:34 AM
> To: spr...@li...
> Subject: Re: [Springframework-developer] Preparing for 1.0.2
>
>
> Oh well, time schedules and my perfectionism...
>
> I've done some further polishing, committed yesterday morning=20
> respectively today:
>
> - I've factored out RowMapperResultReader from SqlParameter, to make=20=

> RowMapper usable for plain JDBC queries too
> - JdbcTemplate.call respectively StoredProcedure supports=20
> ResultSetExtractor as output parameter too
> - I've slightly refactored JdbcTemplate.call's implementation to allow=20=

> for a higher level of code reuse
>
> - AbstractAutowireCapableBeanFactory catches Throwable on bean=20
> creation, rethrowing it as meaningful BeanCreationException
> - DefaultListableBeanFactory.preInstantiateSingletons cleans up=20
> already created singletons if it fails
> - XmlViewResolver and ResourceBundleViewResolver clean up their view=20=

> bean factories on context shutdown
>
> Thomas, it would be great if you had a chance to review the JDBC=20
> changes, and maybe run a couple of integration tests with stored=20
> procedures - to make sure that I haven't broken anything, even if the=20=

> test suite passes.
>
> As there haven't been any reports on problems with the garbage=20
> collection changes, I plan to go ahead and finalize 1.0.2 for=20
> tomorrow.
>
> Juergen
>
>
> ________________________________
>
> Von: spr...@li... im Auftrag=20=

> von j=FCrgen h=F6ller [werk3AT]
> Gesendet: Mi 26.05.2004 07:38
> An: spr...@li...
> Betreff: Re: [Springframework-developer] Preparing for 1.0.2
>
>
>
> There hasn't been any change in AbstractXsltView since 1.0 final, so I=20=

> guess this is usual behavior...
>
> BTW, current planned release date: tonight! I know, I know - this time=20=

> for real, provided that there's no showstopper :-)
>
> Juergen
>
>
> ________________________________
>
> Von: spr...@li... im Auftrag=20=

> von Darren Davison
> Gesendet: Mi 26.05.2004 01:40
> An: spr...@li...
> Betreff: Re: [Springframework-developer] Preparing for 1.0.2
>
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wednesday 26 May 2004 00:27, Darren Davison wrote:
>
>> AbstractXsltView (line 143) shown below is throwing a
>> TransformerConfigurationException.  The stylesheet is correctly =
loaded
>> and appears valid whether loaded from a servlet context resource or a
>> classpath resource (the 2 I tried).
>
> hmm..
>
> it seems that removing any <xsl:output> tags in the stylesheets=20
> themselves
> makes the problem disappear.  That strikes me as a bit odd though: has
> something changed recently in XSL world?  I can't find any info on=20
> this..
>
> Cheers,
> - --
> Darren Davison
> Public Key: http://www.davison.uk.net/pages/key.htm
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.4 (GNU/Linux)
>
> iD8DBQFAs9l7KLMLAN01aw0RAgFCAJ97NbqA547fyx6rCQLiSXkCUFWreQCghOiD
> Tle6ycCFcmn5hNf2ZLZznX0=3D
> =3D4YWT
> -----END PGP SIGNATURE-----
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle=20
> 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id149&alloc_id=9966&op=3Dick
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle=20
> 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id149&alloc_id=9966&op=3Dick
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle=20
> 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id149&alloc_id=9966&op=3Dick
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle=20
> 10g.
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id149&alloc_id=9966&op=3Dclick
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>