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



Joe

Butting in half way through here but so sorry if I missed the point,

Why can't you use the libraries property on the JDBC connection to achieve
what you need?

Ie.

Properties prop = new Properties();
Prop.put("libraries" "LIB1 LIB2 etc");

DriveManager.getConnection("JDBC url",Prop);

Cheer

Neill



-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Joe Sam Shirah
Sent: 16 June 2009 18:42
To: Java Programming on and around the iSeries / AS400
Subject: Re: [OT}Difference JDBC connection for AS400 and Postgres


Hi Ashish,

On first read, I thought you were talking about being able to get tables

from multiple databases, like you can get tables from multiple
libraries/collections on the AS/400. That's something I'm facing in a
current project, where to avoid multiple connection pools, looks like I'll
have to qualify the table names when I want something from other than the
default. That raises some issues fro a test environment.

After seeing Glenn's response, I reread your mail. I agree with him: in

general, you should be able to access tables in the default database ( the
one specified in the URL or properties ) without qualification. Each
database has quirks, however, so you should always check the driver
documentation.

My other comment is I don't understand why Glenn's team qualifies AS/400

names. Most people use the library list, just as for other applications, or

you can just set one if you want to. The only reason offhand I can think of

for not usimg the library list is to avoid system naming. I'm sure there
are others.


Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message -----
From: "Ashish Kulkarni" <ashish.kulkarni13@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 16, 2009 11:18 AM
Subject: [OT}Difference JDBC connection for AS400 and Postgres


HiWhen i have to create a JDBC connection for AS400, i can set the AS400
library name in my JDBC url like
jdbc:as400:myas400/mycollect;naming=system;
and then write a query select * from mytable

Where mycollect is my database, so if i change the url
to jdbc:as400:myas400/mycollect1, i can run the same query with out having
to change SQL query

but in postgres or oracle, i have to write my query as
select * from mycollect.mytable

So if i want to get data from other database, i will have to modify call
the
queries.

Is this correct, or is there some other way of specifying database name in
JDBC connection
--


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.