Re: Best way to code SQL query in web application

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.