× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yes, I have it working with the library list. I just added
"naming=system" to my URL and it uses the system (library list).
--
James R. Perkins



On Tue, Feb 9, 2010 at 19:21, Brian Leathem <bleathem@xxxxxxxxx> wrote:
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.




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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.