springframework-developer — Spring Framework developers list

Fw: [Springframework-developer] tutorial

[Rod J. <rod...@in...>]

And once more for the list!

> > Speaking of the ManualExtractionSqlQuery -- is there any chance that we
> > could rename this class to maybe MappingSqlQuery or something similar?
> > The current name makes it sound like there is a lot of manual work
> > involved in extracting some data from the database.  In reality, it is
> > an elegant way of mapping your row data to Java classes, and I think the
> > name should reflect this.  If we also renamed the extract() to mapRow(),
> > then that would in my mind make everything much clearer.  Any thoughts
> > on this?
>
> This is a good point. I've no objection. Is everyone happy with Thomas's
> proposed name?
>
> R
>

Re: [Springframework-developer] sql-error-codes.xml

[Rod J. <rod...@in...>]

I think we should make it look in both places. First in jdbc.core (no /)
then in the root of the classpath if not found. All jars should ship with
the file in the jdbc.core package.

Does this make sense?

Regards,
Rod

----- Original Message -----
From: "Thomas Risberg" <tri...@tr...>
To: <spr...@li...>
Sent: Sunday, May 04, 2003 3:37 PM
Subject: Re: [Springframework-developer] sql-error-codes.xml


> Jean-Pierre,
>
> I think there is some confusion over where this file should live.
> Juergen suggested moving the source to the jdbc.core package  and have
> the build script copy it to the root of the build directory. I made that
> change, but Rod also took out the leading '/' to make it look in the
> current directory.  I think we should put the '/' back in so the file
> will be found at the root of the classpath. That way you can put your
> version in WEB-INF/classes and it should be picked up.
>
> change line 38 of
> com.interface21.jdbc.core.SQLExceptionTranslaterFactory to:
>
> public static final String SQL_ERROR_CODE_PATH = "/sql-error-codes.xml";
>
> Thomas
>
> > Hi,
> >
> > Why the console tells me about the sql-error-codes.xml cannot be loaded
> > ?
> > It is in the jar. When I copy it in WEB-INF/classes, the behaviour is
> > the same. At least for normal processing, the database access runs well.
> >
> > Regards,
> >
> > Jean-Pierre Pawlak
> > jp....@ti...
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > 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
> >
> >
>
> --
> Thomas Risberg
> tri...@tr...
>
>
> -------------------------------------------------------
> 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

RE: [Springframework-developer] logo

[Travis C. <tra...@le...>]

Here is another idea.  I am taking a little different direction with =
this one.  I think it still needs something, but you can see where I am =
going.  As always please give me your feedback as we narrow in on the =
public face of spring.

thanks,
-travis



-----Original Message-----
From: Travis Chase=20
Sent: Monday, May 05, 2003 10:59 AM
To: spr...@li...
Subject: [Springframework-developer] logo



I have a few more ideas for logos and will try to get them done.  It has =
been pretty busy here at work and I also live in the Midwest were the =
huge storms were.  Needless to say, I had my computer off yesterday and =
didn't work on anything.

thanks,

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Travis L. Chase
Microsoft Certified Solutions Developer (MCSD)
Senior Programmer Analyst
Leggett & Platt, Inc.
tra...@le...
417-358-8131 ext.3865
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

"A dead thing can go with the stream, but only a living=20
 thing can go against it." - G. K. Chesterton

"Impartiality is a pompous name for indifference, which=20
 is an elegant name for ignorance." - G. K. Chesterton

=20



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

Re: [Springframework-developer] new version of tutorial

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

Well, can anybody help with a ready-made blurb?

Isabelle

On Mon, May 05, 2003 at 10:57:47AM -0500, Travis Chase wrote:
> The only comment I have is if these tutorials are going to be standalone, then each of them should have the same type of introduction blurb about what the Spring Framework is, how it came about, what it attempts to solve and what the current tutorial piece covered fits into the whole picture.
> 
> -travis
> 
> -----Original Message-----
> From: Isabelle Muszynski [mailto:isa...@me...]
> Sent: Monday, May 05, 2003 10:54 AM
> To: spr...@li...
> Subject: [Springframework-developer] new version of tutorial
> 
> 
> Hi everyone,
> 
> I've put a reworked version of the JDBC tutorial on my website. I've changed the order of package discussion (to object before core), and added a ManualExtractionSqlQuery. I've also included some UML diagrams.
> 
> Comments are welcome, as always.
> 
> 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
> _______________________________________________
> 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

[Springframework-developer] logo

[Travis C. <tra...@le...>]

I have a few more ideas for logos and will try to get them done.  It has =
been pretty busy here at work and I also live in the Midwest were the =
huge storms were.  Needless to say, I had my computer off yesterday and =
didn't work on anything.

thanks,

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Travis L. Chase
Microsoft Certified Solutions Developer (MCSD)
Senior Programmer Analyst
Leggett & Platt, Inc.
tra...@le...
417-358-8131 ext.3865
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

"A dead thing can go with the stream, but only a living=20
 thing can go against it." - G. K. Chesterton

"Impartiality is a pompous name for indifference, which=20
 is an elegant name for ignorance." - G. K. Chesterton

=20

[Springframework-developer] new version of tutorial

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

Hi everyone,

I've put a reworked version of the JDBC tutorial on my website. I've changed the order of package discussion (to object before core), and added a ManualExtractionSqlQuery. I've also included some UML diagrams.

Comments are welcome, as always.

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

Re: [Springframework-developer] spring-web broken on unix

[Chris S. <ch...@lo...>]

Hi Juergen,

Yes, that's much neater.  I forgot you could use a URL to load a file 
and agree about keeping the number of config parameters down.

Regards,
Chris

jürgen höller [werk3AT] wrote:

>Hi Chris,
>
>You're right, this can easily lead to confustion on Unix platforms. We need a more convenient solution.
>
>I don't want to introduce yet another config parameter, so I've applied a more general change. From the beginning, I've planned to support plain absolute file paths as a convenience, not as a major feature. Given the current problematic interpretation of file paths, I've removed AbstractApplicationContext's absolute file path support altogether, replacing the getResourceByRelativePath template method with getResourceByPath.
>
>This means that an ApplicationContext implementation can interpret any non-URL path any way it wants, not just relative file paths. AbstractApplicationContext's default implementation treats it as (absolute or relative) file path now, XmlWebApplicationContext generally as ServletContext resource (no matter if relative or not), ClassPathApplicationContext as classpath resource (always interpreting as root path, not relative to the class).
>
>Note that absolute file paths can still be accessed easily by using a URL like "file://C:/test/test.dat", so we don't lose that capability. I consider this clean and convenient, sacrificing non-URL absolute file path support isn't a hassle at all. Is that appropriate for your requirements too?
>
>Regards,
>Juergen
>
>
>-----Original Message-----
>From: Chris Smith [mailto:ch...@lo...]
>Sent: Monday, May 05, 2003 11:33 AM
>To: jürgen höller [werk3AT]
>Subject: Re: [Springframework-developer] spring-web broken on unix
>
>
>Hi Jürgen,
>
>I thought about suggesting using relative paths by default, but that 
>leads to a confusing situation where absolute paths are looked up in the 
>file system and relative paths are looked up in the servlet context.  
>Not to mention the fact that an absolute path on one OS can be 
>considered a relative path on another.  And I don't like removing the 
>leading "/" from "/WEB-INF" as there will be plenty of people who 
>include it and end up tearing their hair out when Spring reports it 
>can't find a file that patently exists (like I did yesterday!).
>
>What I was going to suggest in my original email is that we have an 
>explicit param that states where a config location should be loaded from:
>
><web-app>
>    <context-param>
>        <param-name>configLocation</param-name>
>        <param-value>/WEB-INF/applicationContext.xml</param-value>
>    </context-param>
>    <context-param>
>        <param-name>configLocationType</param-name>
>        <param-value>servletcontext</param-value>
>    </context-param>
>...
>
>configLocationType could have the values "servletcontext" or 
>"filesystem".  "servletcontext" should be the default for a web app 
>context loader, so you could omit it from the above example.  This way, 
>you can control where files are loaded from explicitly, regardless of 
>whether they are relative or absolute.
>
>So, that's what I was going to suggest yesterday, but I wasn't sure 
>whether servlets had the same restrictions as EJBs on accessing the file 
>system.  I'm sure I read it somewhere but still can't find it in the 
>servlet spec, so I guess it's ok.  (If it wasn't allowed, the solution 
>would be straightforward - always load from the servlet context).
>
>I'm happy to code this up if you like, but you'd have to commit it.
>
>Regards,
>Chris
>
>jürgen höller [werk3AT] wrote:
>
>  
>
>>Hi Chris, Spring web users,
>>
>>Thanks for the report! Admittedly, I only testet this on Windows and didn't think about Unix path names (should have come to my mind, though). I've changed the default paths ("/WEB-INF/applicationContext.xml", "/WEB-INF/<servlet-name>-servlet.xml") to clear relative paths now, omitting the leading slash.
>>
>>On the occasion, I've made config lookup more flexible, allowing not only for a servlet context init param "configLocation" for the root context, but also "configLocationPrefix" and "configLocationSuffix" for namespaced contexts (defaults are "WEB-INF/" and ".xml").
>>
>>Note that the trailing "-servlet" comes from the FrameworkServlet's namespace handling and is thus part of the namespace. To override the namespace for a specific servlet, just set a servlet init parameter "namespace" to the desired value.
>>
>>Default initialization should still behave like before, and often you won't need any customization. But if you like to, you can now customize config lookup like this:
>>
>><web-app>
>>	<context-param>
>>		<param-name>configLocationPrefix</param-name>
>>		<param-value>WEB-INF/myControllers/</param-value>
>>	</context-param>
>>	<context-param>
>>		<param-name>configLocation</param-name>
>>		<param-value>WEB-INF/myRoot.xml</param-value>
>>	</context-param>
>>	<listener>
>>		<listener-class>com.interface21.web.context.ContextLoaderListener</listener-class>
>>	</listener>
>> 	<servlet>
>>		<servlet-name>test</servlet-name>
>>		<servlet-class>com.interface21.web.servlet.ControllerServlet</servlet-class>
>>		<init-param>
>>			<param-name>namespace</param-name>
>>			<param-value>myTest</param-value>
>>		</init-param>
>>		<load-on-startup>3</load-on-startup>
>>	</servlet>
>></web-app>
>>
>>This should look up the root context file in "WEB-INF/myRoot.xml", and the ControllerServlet context file in "WEB-INF/myControllers/myTest.xml".
>>
>>Regards,
>>Juergen
>>
>>
>>-----Original Message-----
>>From: Chris Smith [mailto:ch...@lo...]
>>Sent: Sunday, May 04, 2003 3:02 PM
>>To: spr...@li...
>>Subject: [Springframework-developer] spring-web broken on unix
>>
>>
>>Hi everyone,
>>
>>Juergen, I've just found a problem with the changes you made to 
>>XmlWebApplicationContext recently.
>>
>>When loading the bean config in getInputStreamForBeanFactory(), it 
>>delegates to the base class AbstractApplicationContext's 
>>getResourceAsStream() method.  For a config location such as 
>>"/WEB-INF/test-servlet.xml", that method will try to load it using a 
>>URL, fail, catch the MalformedURLException, then see if the path is 
>>relative or absolute.  If relative, it loads it using the overridden 
>>getResourceByRelativePath().
>>
>>That all works fine on windows, but on unix, "/WEB-INF/test-servlet.xml" 
>>is considered an absolute path because it starts with a slash.  The 
>>context fails to load because it tries to load it as a File rather than 
>>    
>>
>>from the servlet context.
>  
>
>>The problem is that we can't tell whether a config location like 
>>"/WEB-INF/test-servlet.xml" is a path to a file or a resource in the 
>>servlet context.  I couldn't find it in a brief flick through the 
>>servlet spec, but I didn't think servlets were allowed to access 
>>resources outside the servlet container.  If that's the case, then 
>>XmlWebApplicationContext ought to override getResourceAsStream() with an 
>>implementation that always loads from the servlet context.
>>
>>Regards,
>>
>>Chris
>>
>>
>>
>>-------------------------------------------------------
>>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
>> 
>>
>>    
>>
>
>
>
>-------------------------------------------------------
>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
>  
>

RE: [Springframework-developer] spring-web broken on unix

[<jue...@we...>]

Hi Chris,

You're right, this can easily lead to confustion on Unix platforms. We =
need a more convenient solution.

I don't want to introduce yet another config parameter, so I've applied =
a more general change. From the beginning, I've planned to support plain =
absolute file paths as a convenience, not as a major feature. Given the =
current problematic interpretation of file paths, I've removed =
AbstractApplicationContext's absolute file path support altogether, =
replacing the getResourceByRelativePath template method with =
getResourceByPath.

This means that an ApplicationContext implementation can interpret any =
non-URL path any way it wants, not just relative file paths. =
AbstractApplicationContext's default implementation treats it as =
(absolute or relative) file path now, XmlWebApplicationContext generally =
as ServletContext resource (no matter if relative or not), =
ClassPathApplicationContext as classpath resource (always interpreting =
as root path, not relative to the class).

Note that absolute file paths can still be accessed easily by using a =
URL like "file://C:/test/test.dat", so we don't lose that capability. I =
consider this clean and convenient, sacrificing non-URL absolute file =
path support isn't a hassle at all. Is that appropriate for your =
requirements too?

Regards,
Juergen


-----Original Message-----
From: Chris Smith [mailto:ch...@lo...]
Sent: Monday, May 05, 2003 11:33 AM
To: j=FCrgen h=F6ller [werk3AT]
Subject: Re: [Springframework-developer] spring-web broken on unix


Hi J=FCrgen,

I thought about suggesting using relative paths by default, but that=20
leads to a confusing situation where absolute paths are looked up in the =

file system and relative paths are looked up in the servlet context. =20
Not to mention the fact that an absolute path on one OS can be=20
considered a relative path on another.  And I don't like removing the=20
leading "/" from "/WEB-INF" as there will be plenty of people who=20
include it and end up tearing their hair out when Spring reports it=20
can't find a file that patently exists (like I did yesterday!).

What I was going to suggest in my original email is that we have an=20
explicit param that states where a config location should be loaded =
from:

<web-app>
    <context-param>
        <param-name>configLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml</param-value>
    </context-param>
    <context-param>
        <param-name>configLocationType</param-name>
        <param-value>servletcontext</param-value>
    </context-param>
...

configLocationType could have the values "servletcontext" or=20
"filesystem".  "servletcontext" should be the default for a web app=20
context loader, so you could omit it from the above example.  This way,=20
you can control where files are loaded from explicitly, regardless of=20
whether they are relative or absolute.

So, that's what I was going to suggest yesterday, but I wasn't sure=20
whether servlets had the same restrictions as EJBs on accessing the file =

system.  I'm sure I read it somewhere but still can't find it in the=20
servlet spec, so I guess it's ok.  (If it wasn't allowed, the solution=20
would be straightforward - always load from the servlet context).

I'm happy to code this up if you like, but you'd have to commit it.

Regards,
Chris

j=FCrgen h=F6ller [werk3AT] wrote:

>Hi Chris, Spring web users,
>
>Thanks for the report! Admittedly, I only testet this on Windows and =
didn't think about Unix path names (should have come to my mind, =
though). I've changed the default paths =
("/WEB-INF/applicationContext.xml", =
"/WEB-INF/<servlet-name>-servlet.xml") to clear relative paths now, =
omitting the leading slash.
>
>On the occasion, I've made config lookup more flexible, allowing not =
only for a servlet context init param "configLocation" for the root =
context, but also "configLocationPrefix" and "configLocationSuffix" for =
namespaced contexts (defaults are "WEB-INF/" and ".xml").
>
>Note that the trailing "-servlet" comes from the FrameworkServlet's =
namespace handling and is thus part of the namespace. To override the =
namespace for a specific servlet, just set a servlet init parameter =
"namespace" to the desired value.
>
>Default initialization should still behave like before, and often you =
won't need any customization. But if you like to, you can now customize =
config lookup like this:
>
><web-app>
>	<context-param>
>		<param-name>configLocationPrefix</param-name>
>		<param-value>WEB-INF/myControllers/</param-value>
>	</context-param>
>	<context-param>
>		<param-name>configLocation</param-name>
>		<param-value>WEB-INF/myRoot.xml</param-value>
>	</context-param>
>	<listener>
>		=
<listener-class>com.interface21.web.context.ContextLoaderListener</listen=
er-class>
>	</listener>
>  	<servlet>
>		<servlet-name>test</servlet-name>
>		=
<servlet-class>com.interface21.web.servlet.ControllerServlet</servlet-cla=
ss>
>		<init-param>
>			<param-name>namespace</param-name>
>			<param-value>myTest</param-value>
>		</init-param>
>		<load-on-startup>3</load-on-startup>
>	</servlet>
></web-app>
>
>This should look up the root context file in "WEB-INF/myRoot.xml", and =
the ControllerServlet context file in =
"WEB-INF/myControllers/myTest.xml".
>
>Regards,
>Juergen
>
>
>-----Original Message-----
>From: Chris Smith [mailto:ch...@lo...]
>Sent: Sunday, May 04, 2003 3:02 PM
>To: spr...@li...
>Subject: [Springframework-developer] spring-web broken on unix
>
>
>Hi everyone,
>
>Juergen, I've just found a problem with the changes you made to=20
>XmlWebApplicationContext recently.
>
>When loading the bean config in getInputStreamForBeanFactory(), it=20
>delegates to the base class AbstractApplicationContext's=20
>getResourceAsStream() method.  For a config location such as=20
>"/WEB-INF/test-servlet.xml", that method will try to load it using a=20
>URL, fail, catch the MalformedURLException, then see if the path is=20
>relative or absolute.  If relative, it loads it using the overridden=20
>getResourceByRelativePath().
>
>That all works fine on windows, but on unix, =
"/WEB-INF/test-servlet.xml"=20
>is considered an absolute path because it starts with a slash.  The=20
>context fails to load because it tries to load it as a File rather than =

>from the servlet context.
>
>The problem is that we can't tell whether a config location like=20
>"/WEB-INF/test-servlet.xml" is a path to a file or a resource in the=20
>servlet context.  I couldn't find it in a brief flick through the=20
>servlet spec, but I didn't think servlets were allowed to access=20
>resources outside the servlet container.  If that's the case, then=20
>XmlWebApplicationContext ought to override getResourceAsStream() with =
an=20
>implementation that always loads from the servlet context.
>
>Regards,
>
>Chris
>
>
>
>-------------------------------------------------------
>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
> =20
>

Re: [Springframework-developer] Re: tutorial

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

Hi Chris,

I've put the java files on my website, in the downloads section.

Isabelle

On Mon, May 05, 2003 at 10:55:57AM +0100, Chris Smith wrote:
> Hi Isabelle,
> 
> I know you're in the middle of writing it, but is the tutorial available 
> for general consumption whilst you're working on it?  I can't find a url 
> for it anywhere.
> 
> Also, there was mention of a wiki in a previous post.  Did that get set up?
> 
> And the samples, are they available anywhere?
> 
> Sorry for all the questions, but I feel like I'm sooo missing out on 
> things :-)
> 
> Regards,
> Chris
> 
> Isabelle Muszynski wrote:
> 
> >Hi Brett,
> >
> >No, no one else has reported the problem. And I got some comments form 
> >some people on the tutorial, so they obviously managed to oepn the file. 
> >Could you try downloading it again?
> >
> >Isabelle
> >
> >On Mon, May 05, 2003 at 09:50:51AM +0100, Brett Bell wrote:
> > 
> >
> >>Hi Isabelle,
> >>
> >>I have downloaded the tutorial but Acrobat 5 reports that the file is
> >>damaged so I can't read it's contents.  Has anyone else reported this
> >>problem?
> >>
> >>Cheers
> >>
> >>Brett
> >>
> >>
> >>
> >>
> >>-------------------------------------------------------
> >>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

Re: [Springframework-developer] Re: tutorial

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

Hi Chris,

The tutorial is currently availble via the download section of my web site (www.meta-logix.com). I post a new version whenever another section is done, so you do get it while I'm working on it. The code samples are available, but the problem is that we need to decide where to put them. I'd prefer to be able to post them in the download section at sourceforge. However, until that gets cleared up, I'll post them on my website. I'll do that tonight.

Isabelle

On Mon, May 05, 2003 at 10:55:57AM +0100, Chris Smith wrote:
> Hi Isabelle,
> 
> I know you're in the middle of writing it, but is the tutorial available 
> for general consumption whilst you're working on it?  I can't find a url 
> for it anywhere.
> 
> Also, there was mention of a wiki in a previous post.  Did that get set up?
> 
> And the samples, are they available anywhere?
> 
> Sorry for all the questions, but I feel like I'm sooo missing out on 
> things :-)
> 
> Regards,
> Chris
> 
> Isabelle Muszynski wrote:
> 
> >Hi Brett,
> >
> >No, no one else has reported the problem. And I got some comments form 
> >some people on the tutorial, so they obviously managed to oepn the file. 
> >Could you try downloading it again?
> >
> >Isabelle
> >
> >On Mon, May 05, 2003 at 09:50:51AM +0100, Brett Bell wrote:
> > 
> >
> >>Hi Isabelle,
> >>
> >>I have downloaded the tutorial but Acrobat 5 reports that the file is
> >>damaged so I can't read it's contents.  Has anyone else reported this
> >>problem?
> >>
> >>Cheers
> >>
> >>Brett
> >>
> >>
> >>
> >>
> >>-------------------------------------------------------
> >>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

Re: [Springframework-developer] Re: tutorial

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

Hi Brett,

No, no one else has reported the problem. And I got some comments form some people on the tutorial, so they obviously managed to oepn the file. Could you try downloading it again?

Isabelle

On Mon, May 05, 2003 at 09:50:51AM +0100, Brett Bell wrote:
> Hi Isabelle,
> 
> I have downloaded the tutorial but Acrobat 5 reports that the file is
> damaged so I can't read it's contents.  Has anyone else reported this
> problem?
> 
> Cheers
> 
> Brett
> 
> 
> 
> 
> -------------------------------------------------------
> 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

[Springframework-developer] Re: tutorial

[Brett B. <br...@po...>]

Hi Isabelle,

I have downloaded the tutorial but Acrobat 5 reports that the file is
damaged so I can't read it's contents.  Has anyone else reported this
problem?

Cheers

Brett

[Springframework-developer] i21:bind tag for a collection

[p v. <vt...@ya...>]

I have a question about binding a collection. 

I have a simple html table with input fields. My 

bean given by formBackingObject (FormController) is a collection of simple beans. 

Is it possible to bind every input field with a property of a simple bean? 

the code of jsp: 

<table>

<i21:bind path="owners.values"> 

<%int i=0;%> 

<c:forEach var="owner" items="${status.value}"> 

<tr> 

<td><input type="text" length="3" value="<c:out value="${owner.code}"/>" name="code<%=i%>"/></td> 

<td><input type="text" length="15" value="<c:out value="${owner.firstName}"/>" name="firstname<%=i%>"/></td> 

<td><input type="text" length="20" value="<c:out value="${owner.lastName}"/>" name="lastname<%=i%>"/></td> 

<td><input type="text" length="40" value="<c:out value="${owner.address}"/>" name="address<%=i%>"/></td> 

<td><input type="text" length="25" value="<c:out value="${owner.city}"/>" name="city<%=i%>"/></td> 

<td><input type="text" length="15" value="<c:out value="${owner.tel}"/>" name="tel<%=i%>"/></td> 

</tr> 

<%i++;%> 

</c:forEach> 

</i21:bind> 

</table>

If you cannot bind the collections by the i21:bind tag, how can I send a new collection of 

simple beans in the jsp file back to the formcontroller (onSubmit(Object command)) ? 

Have you an example? 

Thanks in advance, 

Peter. 


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: [Springframework-developer] spring-web broken on unix

[<jue...@we...>]

Hi Chris, Spring web users,

Thanks for the report! Admittedly, I only testet this on Windows and =
didn't think about Unix path names (should have come to my mind, =
though). I've changed the default paths =
("/WEB-INF/applicationContext.xml", =
"/WEB-INF/<servlet-name>-servlet.xml") to clear relative paths now, =
omitting the leading slash.

On the occasion, I've made config lookup more flexible, allowing not =
only for a servlet context init param "configLocation" for the root =
context, but also "configLocationPrefix" and "configLocationSuffix" for =
namespaced contexts (defaults are "WEB-INF/" and ".xml").

Note that the trailing "-servlet" comes from the FrameworkServlet's =
namespace handling and is thus part of the namespace. To override the =
namespace for a specific servlet, just set a servlet init parameter =
"namespace" to the desired value.

Default initialization should still behave like before, and often you =
won't need any customization. But if you like to, you can now customize =
config lookup like this:

<web-app>
	<context-param>
		<param-name>configLocationPrefix</param-name>
		<param-value>WEB-INF/myControllers/</param-value>
	</context-param>
	<context-param>
		<param-name>configLocation</param-name>
		<param-value>WEB-INF/myRoot.xml</param-value>
	</context-param>
	<listener>
		=
<listener-class>com.interface21.web.context.ContextLoaderListener</listen=
er-class>
	</listener>
  	<servlet>
		<servlet-name>test</servlet-name>
		=
<servlet-class>com.interface21.web.servlet.ControllerServlet</servlet-cla=
ss>
		<init-param>
			<param-name>namespace</param-name>
			<param-value>myTest</param-value>
		</init-param>
		<load-on-startup>3</load-on-startup>
	</servlet>
</web-app>

This should look up the root context file in "WEB-INF/myRoot.xml", and =
the ControllerServlet context file in =
"WEB-INF/myControllers/myTest.xml".

Regards,
Juergen


-----Original Message-----
From: Chris Smith [mailto:ch...@lo...]
Sent: Sunday, May 04, 2003 3:02 PM
To: spr...@li...
Subject: [Springframework-developer] spring-web broken on unix


Hi everyone,

Juergen, I've just found a problem with the changes you made to=20
XmlWebApplicationContext recently.

When loading the bean config in getInputStreamForBeanFactory(), it=20
delegates to the base class AbstractApplicationContext's=20
getResourceAsStream() method.  For a config location such as=20
"/WEB-INF/test-servlet.xml", that method will try to load it using a=20
URL, fail, catch the MalformedURLException, then see if the path is=20
relative or absolute.  If relative, it loads it using the overridden=20
getResourceByRelativePath().

That all works fine on windows, but on unix, "/WEB-INF/test-servlet.xml" =

is considered an absolute path because it starts with a slash.  The=20
context fails to load because it tries to load it as a File rather than=20
from the servlet context.

The problem is that we can't tell whether a config location like=20
"/WEB-INF/test-servlet.xml" is a path to a file or a resource in the=20
servlet context.  I couldn't find it in a brief flick through the=20
servlet spec, but I didn't think servlets were allowed to access=20
resources outside the servlet container.  If that's the case, then=20
XmlWebApplicationContext ought to override getResourceAsStream() with an =

implementation that always loads from the servlet context.

Regards,

Chris



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

Re: [Springframework-developer] tutorial

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

Isabelle,

I think you have a good start, but I have a few suggestions.  Why not
start with the high level interfaces first, and then dig deeper into the
framework when we need to explain the more intricate features in more
detail.  I would start with the ManualExtractionSqlQuery and SqlUpdate
classes.

Speaking of the ManualExtractionSqlQuery -- is there any chance that we
could rename this class to maybe MappingSqlQuery or something similar? 
The current name makes it sound like there is a lot of manual work
involved in extracting some data from the database.  In reality, it is
an elegant way of mapping your row data to Java classes, and I think the
name should reflect this.  If we also renamed the extract() to mapRow(),
then that would in my mind make everything much clearer.  Any thoughts
on this?

Here is an exmple of what the Query would look like:

import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;

import com.interface21.jdbc.object.MappingSqlQuery;
import com.interface21.jdbc.core.SqlParameter;

/**
 * @author trisberg
 */
public class SpringEmployeeQuery extends MappingSqlQuery {

 public SpringEmployeeQuery(DataSource ds) {
  super(ds, "select EMPNO, ENAME, HIREDATE from EMP where EMPNO = ?");
  declareParameter(new SqlParameter(java.sql.Types.NUMERIC));
  compile();		
 }

 protected Object mapRow(ResultSet rs, int rownum) throws SQLException {
  Employee emp = new Employee();
  emp.setEmployeeId(rs.getInt("EMPNO"));
  emp.setName(rs.getString("ENAME"));
  emp.setHireDate(rs.getDate("HIREDATE"));
  return emp;
 }

}

Usage looks the same as before:

 int employeeId = 7788;
 SpringEmployeeQuery seq = new SpringEmployeeQuery(ds);
 java.util.List empList = seq.execute(employeeId);
 if (empList.iterator().hasNext()) {
  Employee emp = (Employee) empList.iterator().next();
  System.out.println(emp.getEmployeeId() + " " + 
    emp.getName() + " " + 
    emp.getHireDate().toString());
 }


One additional thought.  We currently require an explicit .compile() on
all queries and update statements.  Could we not compile the sql behind
the scenes instead of throwing an exception.  That would be more user
friendly and I can't see any disadvantage to this.  What do you think?


Thomas


> Hi everyone,
> 
> I've put the first part of the tutorial on the download section of my
website (www.meta-logix.com). I still need to incorporate the UML
diagrams, so it's a work in progress. 
> 
> 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
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
> 
> 

-- 
Thomas Risberg
tri...@tr...

Re: [Springframework-developer] sql-error-codes.xml

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

Jean-Pierre,

I think there is some confusion over where this file should live. 
Juergen suggested moving the source to the jdbc.core package  and have
the build script copy it to the root of the build directory. I made that
change, but Rod also took out the leading '/' to make it look in the
current directory.  I think we should put the '/' back in so the file
will be found at the root of the classpath. That way you can put your
version in WEB-INF/classes and it should be picked up.

change line 38 of
com.interface21.jdbc.core.SQLExceptionTranslaterFactory to:

public static final String SQL_ERROR_CODE_PATH = "/sql-error-codes.xml";

Thomas

> Hi,
> 
> Why the console tells me about the sql-error-codes.xml cannot be loaded
> ?
> It is in the jar. When I copy it in WEB-INF/classes, the behaviour is
> the same. At least for normal processing, the database access runs well.
> 
> Regards,
>  
> Jean-Pierre Pawlak
> jp....@ti...
>  
> 
> 
> 
> 
> 
> -------------------------------------------------------
> 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
> 
> 

-- 
Thomas Risberg
tri...@tr...

[Springframework-developer] spring-web broken on unix

[Chris S. <ch...@lo...>]

Hi everyone,

Juergen, I've just found a problem with the changes you made to 
XmlWebApplicationContext recently.

When loading the bean config in getInputStreamForBeanFactory(), it 
delegates to the base class AbstractApplicationContext's 
getResourceAsStream() method.  For a config location such as 
"/WEB-INF/test-servlet.xml", that method will try to load it using a 
URL, fail, catch the MalformedURLException, then see if the path is 
relative or absolute.  If relative, it loads it using the overridden 
getResourceByRelativePath().

That all works fine on windows, but on unix, "/WEB-INF/test-servlet.xml" 
is considered an absolute path because it starts with a slash.  The 
context fails to load because it tries to load it as a File rather than 
from the servlet context.

The problem is that we can't tell whether a config location like 
"/WEB-INF/test-servlet.xml" is a path to a file or a resource in the 
servlet context.  I couldn't find it in a brief flick through the 
servlet spec, but I didn't think servlets were allowed to access 
resources outside the servlet container.  If that's the case, then 
XmlWebApplicationContext ought to override getResourceAsStream() with an 
implementation that always loads from the servlet context.

Regards,

Chris

[Springframework-developer] tutorial

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

Hi everyone,

I've put the first part of the tutorial on the download section of my website (www.meta-logix.com). I still need to incorporate the UML diagrams, so it's a work in progress. 

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

[Springframework-developer] sql-error-codes.xml

[JP PAWLAK\(Tiscali\) <jp....@ti...>]

Hi,

Why the console tells me about the sql-error-codes.xml cannot be loaded
?
It is in the jar. When I copy it in WEB-INF/classes, the behaviour is
the same. At least for normal processing, the database access runs well.

Regards,
=A0
Jean-Pierre Pawlak
jp....@ti...
=A0

[Springframework-developer] tutorials

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

Hi everyone,

I have some files I could check in for the tutorials. It's basically on the jdbc package usage, nothing to do with the petclinic. We need to decide on a structure in cvs. I've put the sources in package tutorial, but maybe com.interface21.tutorial would be better. In any case, do we want a new module at the same level as main, or do we want all the tutorial stuff under main? I kind of don't like that.
The idea is that I write up some notes about what the code does, and that I go on doing the same kind of thing for the other packages in the framework. Seems to me we ultimately need 3 modules, main, petclinic and package_tutorials.

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

[Springframework-developer] bug in JdbcUtils

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

Hi everyone,

I found a bug in JdbcUtils.java countParameterPlaceholders, it wouldn't correclty parse something like "insert into foo values(?,?). After fixing it and wanting to commit, I found someone else had already fixed it. So thanks to whoever did it.

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

Re: RE : [Springframework-developer] src for long keys

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

Hello Jean-Pierre,

It might be a good idea to write an Oracle implementation as well, and then post to the list asking someone to test it. You are right, it is only a performance enhancement.

Isabelle


On Sat, May 03, 2003 at 09:29:36PM +0200, JP PAWLAK(Tiscali) wrote:
> Hi Isabelle,
> 
> So, my interrogation about the Double return key has now an answer. 
> I can implement the retrieving by bunches of keys. I better will not do
> for Oracle like RDBMS for which the increment factor is to retrieve from
> the sequence definition. Yes, it's only a matter of a SQL Select, but
> the time I was Oracle DBA is far and I will not have easy the
> possibility of testing it.
> That's said, it's not an urgent task as only a performance deal and I
> have work on implementing my application on the new framework with a lot
> of refactoring. Nevertheless, as key bunches are not a big deal, I hope
> work on in a few days.  
> 
> Regards,
> Jean-Pierre PAWLAK
> jp....@ti...
> 
> 
> -----Message d'origine-----
> De : spr...@li...
> [mailto:spr...@li...] De la
> part de Isabelle Muszynski
> Envoyé : samedi 3 mai 2003 20:44
> À : Thomas Risberg
> Cc : spr...@li...
> Objet : Re: [Springframework-developer] src for long keys
> 
> Hi Thomas,
> 
> I guess you're right. Even if someone declares the key as a NUMBER, it
> makes no sense to retrieve it as a Double. 
> 
> Isabelle
> 
> On Sat, May 03, 2003 at 02:29:20PM -0400, Thomas Risberg wrote:
> > Isabelle,
> > 
> > For NUMERIC we would be better off mapping to BigDecimal and 
> > use .longValue() or just use getLong().  Floats and Doubles are not 
> > reliably re-cast to a long for very large numbers so their use is 
> > limited.
> > 
> > I don't see why we would need to support anything other that int, long
> 
> > and String as return values.
> > 
> > Thomas
> > 
> > P.S.
> > 
> > I think you just replied to my e-mail address and not the list's - 
> > here is the message:
> > 
> > > Hi Thomas, Jean-Pierre,
> > > 
> > > If you don't mind adding Jean-Pierre's code, please do. I'm working 
> > on some code samples for the tutorial.
> > > I agree that Long's make sense, I was going to do it but then it 
> > slipped my mind.
> > > 
> > > The Double return value is there because of the practice of using 
> > NUMERIC columns for sequences.
> > > 
> > > As for retrieving bunches of keys at once, and then adding them out 
> > one by one, I agree that that makes sense as well. As a matter of fact
> 
> > it was raised in the mailing list when we first talked about insert 
> > functionality and key generation, I remember I referred to an open 
> > source project that does just that. It's not that complicated to do. 
> > Jean-Pierre, if you feel like doing it, why don't you go ahead, and 
> > then either Rod can give you commit access or one of us can check it 
> > in for you.
> > > 
> > > I completely agree on select max(id) + 1, it's very bad. I put in a 
> > code comment that explains why, but it's better than nothing for 
> > databases we do not have specific code for.
> > >
> 
>  
> ...
> 
> 
> 
> 

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

Re: [Springframework-developer] src for long keys

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

Hi Thomas,

I guess you're right. Even if someone declares the key as a NUMBER, it makes no sense to retrieve it as a Double. 

Isabelle

On Sat, May 03, 2003 at 02:29:20PM -0400, Thomas Risberg wrote:
> Isabelle,
> 
> For NUMERIC we would be better off mapping to BigDecimal and 
> use .longValue() or just use getLong().  Floats and Doubles are not 
> reliably re-cast to a long for very large numbers so their use is 
> limited.
> 
> I don't see why we would need to support anything other that int, long 
> and String as return values.
> 
> Thomas
> 
> P.S.
> 
> I think you just replied to my e-mail address and not the list's - 
> here is the message:
> 
> > Hi Thomas, Jean-Pierre,
> > 
> > If you don't mind adding Jean-Pierre's code, please do. I'm working 
> on some code samples for the tutorial.
> > I agree that Long's make sense, I was going to do it but then it 
> slipped my mind.
> > 
> > The Double return value is there because of the practice of using 
> NUMERIC columns for sequences.
> > 
> > As for retrieving bunches of keys at once, and then adding them out 
> one by one, I agree that that makes sense as well. As a matter of fact 
> it was raised in the mailing list when we first talked about insert 
> functionality and key generation, I remember I referred to an open 
> source project that does just that. It's not that complicated to do. 
> Jean-Pierre, if you feel like doing it, why don't you go ahead, and 
> then either Rod can give you commit access or one of us can check it 
> in for you.
> > 
> > I completely agree on select max(id) + 1, it's very bad. I put in a 
> code comment that explains why, but it's better than nothing for 
> databases we do not have specific code for.
> > 
> > Isabelle
> > 
> > On Sat, May 03, 2003 at 11:36:18AM -0400, Thomas Risberg wrote:
> > > Jean-Pierre,
> > > 
> > > Thanks for your changes.  I think adding long as a return value 
> has been
> > >  planned, but it was never implemented.  Isabelle, do you you want 
> to
> > > make these changes or do you want me to do it?  I'm modifying a few
> > > other jdbc classes this weekend, so I don't mind adding these 
> changes as
> > > well.
> > > 
> > > For key generation support I think we should provide support for 
> the
> > > following:
> > > 
> > > 1.  Sequences - like the OracleSequenceMaxValueIncrementer.  Do we 
> need
> > > something for Postgres and DB2?
> > > 
> > > 2.  Identity/Autoincrement - a "sequence" table where we use some 
> sql to
> > > increment and retrieve the next value.  This is implemented in
> > > MySQLMaxValueIncrementer.  Do we need implementations for HSQL, MS 
> SQL
> > > Server, DB2 and Sybase?
> > > 
> > > 3.  Stored Procedure = a procedure that wraps access to a Sequence,
> > > Identity/Autoincrement or any other proprietary database key 
> generation
> > > facility.  I'll look into providing an implementation for this.
> > > 
> > > I think we should discourage use of "select max(id) + 1" type of
> > > solutions and therefore we should remove the 
> RdbmsMaxValueIncrementer. 
> > > We can leave this type of implementation up to the individual 
> developer.
> > > 
> > > Thomas
> > > 
> > > > This is a multi-part message in MIME format.
> > > > 
> > > > 
> > > > Hi Isabelle,
> > > > 
> > > > Related on my last post on the Spring Framework list, I enclosed 
> my
> > > > proposals of changes to handle long keys on databases.
> > > > As I'm not registered as developer, I cannot upload. And in all 
> cases,
> > > > it's your work, so your approval is also mandatory.
> > > > 
> > > > NB: It's nothing about caching in this proposal.
> > > > 
> > > > Best regards,
> > > > Jean-Pierre PAWLAK
> > > > jp....@ti...
> > > >  
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > 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
> > 
> > 
> 
> 
> > Jean-Pierre,
> > 
> > Thanks for your changes.  I think adding long as a return value has 
> been
> >  planned, but it was never implemented.  Isabelle, do you you want to
> > make these changes or do you want me to do it?  I'm modifying a few
> > other jdbc classes this weekend, so I don't mind adding these 
> changes as
> > well.
> > 
> > For key generation support I think we should provide support for the
> > following:
> > 
> > 1.  Sequences - like the OracleSequenceMaxValueIncrementer.  Do we 
> need
> > something for Postgres and DB2?
> > 
> > 2.  Identity/Autoincrement - a "sequence" table where we use some 
> sql to
> > increment and retrieve the next value.  This is implemented in
> > MySQLMaxValueIncrementer.  Do we need implementations for HSQL, MS 
> SQL
> > Server, DB2 and Sybase?
> > 
> > 3.  Stored Procedure = a procedure that wraps access to a Sequence,
> > Identity/Autoincrement or any other proprietary database key 
> generation
> > facility.  I'll look into providing an implementation for this.
> > 
> > I think we should discourage use of "select max(id) + 1" type of
> > solutions and therefore we should remove the 
> RdbmsMaxValueIncrementer. 
> > We can leave this type of implementation up to the individual 
> developer.
> > 
> > Thomas
> > 
> > > This is a multi-part message in MIME format.
> > > 
> > > 
> > > Hi Isabelle,
> > > 
> > > Related on my last post on the Spring Framework list, I enclosed my
> > > proposals of changes to handle long keys on databases.
> > > As I'm not registered as developer, I cannot upload. And in all 
> cases,
> > > it's your work, so your approval is also mandatory.
> > > 
> > > NB: It's nothing about caching in this proposal.
> > > 
> > > Best regards,
> > > Jean-Pierre PAWLAK
> > > jp....@ti...
> > >  
> > 
> > 
> > 
> > -------------------------------------------------------
> > 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
> > 
> > 
> 
> -- 
> Thomas Risberg
> tri...@tr...
> 
> 
> -------------------------------------------------------
> 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

Re: [Springframework-developer] src for long keys

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

Isabelle,

For NUMERIC we would be better off mapping to BigDecimal and 
use .longValue() or just use getLong().  Floats and Doubles are not 
reliably re-cast to a long for very large numbers so their use is 
limited.

I don't see why we would need to support anything other that int, long 
and String as return values.

Thomas

P.S.

I think you just replied to my e-mail address and not the list's - 
here is the message:

> Hi Thomas, Jean-Pierre,
> 
> If you don't mind adding Jean-Pierre's code, please do. I'm working 
on some code samples for the tutorial.
> I agree that Long's make sense, I was going to do it but then it 
slipped my mind.
> 
> The Double return value is there because of the practice of using 
NUMERIC columns for sequences.
> 
> As for retrieving bunches of keys at once, and then adding them out 
one by one, I agree that that makes sense as well. As a matter of fact 
it was raised in the mailing list when we first talked about insert 
functionality and key generation, I remember I referred to an open 
source project that does just that. It's not that complicated to do. 
Jean-Pierre, if you feel like doing it, why don't you go ahead, and 
then either Rod can give you commit access or one of us can check it 
in for you.
> 
> I completely agree on select max(id) + 1, it's very bad. I put in a 
code comment that explains why, but it's better than nothing for 
databases we do not have specific code for.
> 
> Isabelle
> 
> On Sat, May 03, 2003 at 11:36:18AM -0400, Thomas Risberg wrote:
> > Jean-Pierre,
> > 
> > Thanks for your changes.  I think adding long as a return value 
has been
> >  planned, but it was never implemented.  Isabelle, do you you want 
to
> > make these changes or do you want me to do it?  I'm modifying a few
> > other jdbc classes this weekend, so I don't mind adding these 
changes as
> > well.
> > 
> > For key generation support I think we should provide support for 
the
> > following:
> > 
> > 1.  Sequences - like the OracleSequenceMaxValueIncrementer.  Do we 
need
> > something for Postgres and DB2?
> > 
> > 2.  Identity/Autoincrement - a "sequence" table where we use some 
sql to
> > increment and retrieve the next value.  This is implemented in
> > MySQLMaxValueIncrementer.  Do we need implementations for HSQL, MS 
SQL
> > Server, DB2 and Sybase?
> > 
> > 3.  Stored Procedure = a procedure that wraps access to a Sequence,
> > Identity/Autoincrement or any other proprietary database key 
generation
> > facility.  I'll look into providing an implementation for this.
> > 
> > I think we should discourage use of "select max(id) + 1" type of
> > solutions and therefore we should remove the 
RdbmsMaxValueIncrementer. 
> > We can leave this type of implementation up to the individual 
developer.
> > 
> > Thomas
> > 
> > > This is a multi-part message in MIME format.
> > > 
> > > 
> > > Hi Isabelle,
> > > 
> > > Related on my last post on the Spring Framework list, I enclosed 
my
> > > proposals of changes to handle long keys on databases.
> > > As I'm not registered as developer, I cannot upload. And in all 
cases,
> > > it's your work, so your approval is also mandatory.
> > > 
> > > NB: It's nothing about caching in this proposal.
> > > 
> > > Best regards,
> > > Jean-Pierre PAWLAK
> > > jp....@ti...
> > >  
> > 
> > 
> > 
> > -------------------------------------------------------
> > 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
> 
> 


> Jean-Pierre,
> 
> Thanks for your changes.  I think adding long as a return value has 
been
>  planned, but it was never implemented.  Isabelle, do you you want to
> make these changes or do you want me to do it?  I'm modifying a few
> other jdbc classes this weekend, so I don't mind adding these 
changes as
> well.
> 
> For key generation support I think we should provide support for the
> following:
> 
> 1.  Sequences - like the OracleSequenceMaxValueIncrementer.  Do we 
need
> something for Postgres and DB2?
> 
> 2.  Identity/Autoincrement - a "sequence" table where we use some 
sql to
> increment and retrieve the next value.  This is implemented in
> MySQLMaxValueIncrementer.  Do we need implementations for HSQL, MS 
SQL
> Server, DB2 and Sybase?
> 
> 3.  Stored Procedure = a procedure that wraps access to a Sequence,
> Identity/Autoincrement or any other proprietary database key 
generation
> facility.  I'll look into providing an implementation for this.
> 
> I think we should discourage use of "select max(id) + 1" type of
> solutions and therefore we should remove the 
RdbmsMaxValueIncrementer. 
> We can leave this type of implementation up to the individual 
developer.
> 
> Thomas
> 
> > This is a multi-part message in MIME format.
> > 
> > 
> > Hi Isabelle,
> > 
> > Related on my last post on the Spring Framework list, I enclosed my
> > proposals of changes to handle long keys on databases.
> > As I'm not registered as developer, I cannot upload. And in all 
cases,
> > it's your work, so your approval is also mandatory.
> > 
> > NB: It's nothing about caching in this proposal.
> > 
> > Best regards,
> > Jean-Pierre PAWLAK
> > jp....@ti...
> >  
> 
> 
> 
> -------------------------------------------------------
> 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
> 
> 

-- 
Thomas Risberg
tri...@tr...

Re: [Springframework-developer] src for long keys

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

Jean-Pierre,

Thanks for your changes.  I think adding long as a return value has been
 planned, but it was never implemented.  Isabelle, do you you want to
make these changes or do you want me to do it?  I'm modifying a few
other jdbc classes this weekend, so I don't mind adding these changes as
well.

For key generation support I think we should provide support for the
following:

1.  Sequences - like the OracleSequenceMaxValueIncrementer.  Do we need
something for Postgres and DB2?

2.  Identity/Autoincrement - a "sequence" table where we use some sql to
increment and retrieve the next value.  This is implemented in
MySQLMaxValueIncrementer.  Do we need implementations for HSQL, MS SQL
Server, DB2 and Sybase?

3.  Stored Procedure = a procedure that wraps access to a Sequence,
Identity/Autoincrement or any other proprietary database key generation
facility.  I'll look into providing an implementation for this.

I think we should discourage use of "select max(id) + 1" type of
solutions and therefore we should remove the RdbmsMaxValueIncrementer. 
We can leave this type of implementation up to the individual developer.

Thomas

> This is a multi-part message in MIME format.
> 
> 
> Hi Isabelle,
> 
> Related on my last post on the Spring Framework list, I enclosed my
> proposals of changes to handle long keys on databases.
> As I'm not registered as developer, I cannot upload. And in all cases,
> it's your work, so your approval is also mandatory.
> 
> NB: It's nothing about caching in this proposal.
> 
> Best regards,
> Jean-Pierre PAWLAK
> jp....@ti...
>