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