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


  1.  Home
  2. JAVA400-L
  3. June 2009

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

On Tue, 2009-06-16 at 11:18 -0400, Ashish Kulkarni wrote:
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.

Hmmm, we do it the other way round, e.g. "jdbc:as400://hostname" and
then "SELECT * FROM LIBRARY.FILE"; in Postgres, we do
"jdbc:postgresql://hostname:5432/database" and then "SELECT * FROM
TABLE".

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

http://jdbc.postgresql.org/documentation/docs.html


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.