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