Re: Best way to code SQL query in web application

[Brian Leathem <bleathem@xxxxxxxxx>]

Has anyone managed to get the library list to work with a JPA provider?

I've found I have to use the SQL naming convention ("." seperator) 
rather than the SYSTEM naming convention ("/" seperator) with the JPA 
providers I've tried.  Unfortunately, this precludes the use of a 
library list in the JDBC connections, which doesn't work well with our 
change management, etc., etc. ...

Brian

On 04/02/10 3:22 PM, James Perkins wrote:
> I personally like the library list approach. I think that is a very
> powerful part of the i5/OS is the library list. There have been MANY
> times where I have had to edit loads of SQL because of a schema
> (library) change.
> --
> James R. Perkins
>
>
>
> On Thu, Feb 4, 2010 at 14:25, Ashish Kulkarni
> <ashish.kulkarni13@xxxxxxxxx>  wrote:
>    
> > I have a question about writing SQL query in web application,
> > Which of the following is more efficient and why
> >
> > select  col1, col2, col3 from myschema.mytable;
> >
> > where i can specify myschema in a properties file and use it in my
> > application or hard code it
> >
> > OR
> >
> >
> > select  col1, col2, col3 from mytable;
> >
> > and set my JDBC connection with correct library list so it will resolve
> > where the table is at run time.
> >
> > I would like to know in respect to performance, would letting connection
> > know the schema will be faster or making it search in library list will be
> > fater
> >
> > Any ideas
> >
> > --
> > Ashish
> > www.ayurwellness.com
> > www.mysoftwareneeds.com
> > --
> > This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
> > To post a message email: JAVA400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> >
> >