RE: [OT}Difference JDBC connection for AS400 and Postgres

Nope sorry my fault, I didn't pick up the fact that your scenario wasn't on
AS400.

Oh well... maybe one day I'll have something useful to say!!!

Cheers neill

PS.

check out the Visual Studio 10 beta, it's pretty awesome.

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


Hi Neill,

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

Yep, you did, or more likely I didn't express myself clearly enough.

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.

I thought that from the line "like you can get tables from multiple
libraries/collections on the AS/400," it would be clear that my comment was
directed towards different database engines, in my case SQL Server. They
generally don't have anything like library lists.

Additionally, since most of the rest of my mail deals with the library
list, I thought it would be clear I'm familiar with it.

Last, I think most people who've been on this list for a while are aware
that I wrote the JDBC 2.0 tutorial on Sun's site a few years back:

http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/

which includes DB2/400 in the examples. So, I don't know everything, but I
do understand some of the basics.


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: "Neill Harper" <neill.harper@xxxxxxxx>
To: "'Java Programming on and around the iSeries / AS400'"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, June 16, 2009 2:16 PM
Subject: RE: [OT}Difference JDBC connection for AS400 and Postgres

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

--