Scott Bailey wrote:
John R Pierce wrote:
Scott Bailey wrote:
Well at work we've got Oracle, MySQL, MS SQL and Postgres. So I
generally use Aqua Data Studio because it works with all of them. For
MySQL and MS SQL you register a single connection to the server and
can switch to any database. Bu
John R Pierce wrote:
Scott Bailey wrote:
Well at work we've got Oracle, MySQL, MS SQL and Postgres. So I
generally use Aqua Data Studio because it works with all of them. For
MySQL and MS SQL you register a single connection to the server and
can switch to any database. But with Postgres, you
Scott Bailey wrote:
Well at work we've got Oracle, MySQL, MS SQL and Postgres. So I
generally use Aqua Data Studio because it works with all of them. For
MySQL and MS SQL you register a single connection to the server and
can switch to any database. But with Postgres, you have to register a
ne
John R Pierce wrote:
Scott Bailey wrote:
Is there an equivalent to psql's \connect database or MySQL/MS SQL's use
database command that will work with JDBC? It doesn't seem like I should
need to drop the connection and establish a new one just to switch
databases.
the \connect command disconn
Martin Gainty wrote:
true
scott was asking if you can utilise the same JDBC Type IV DB
connection for both
the original DB connection and utilise that same connection to connect
to another
DB (with a fresh set of database parameters)
my answer is i do not know of a way to use the same connecti
.com
> To: mgai...@hotmail.com
> CC: arta...@comcast.net; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Switching databases over JDBC/ODBC
>
> Martin Gainty wrote:
> > does '\connect' work with Type-IV JDBC Database?
> > can you effectively 'drop' the f
Martin Gainty wrote:
does '\connect' work with Type-IV JDBC Database?
can you effectively 'drop' the first DB connection
and somehow read a different set of DB parameters to connect to a new DB?
\connect is a psql command, nothing to do with JDBC.
In Java, you would Close() a JDBC connection,
sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Fri, 29 May 2009 17:07:03 -0700
> From: pie...@hogranch.com
> To: arta...@comcast.net
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Switching databases over JDBC/O
Scott Bailey wrote:
Is there an equivalent to psql's \connect database or MySQL/MS SQL's use
database command that will work with JDBC? It doesn't seem like I should
need to drop the connection and establish a new one just to switch
databases.
the \connect command disconnects from the current
conceptually if you consider the DB parameters which are necessary to establish
a SQL connection
you would need to accomodate 'BOTH' sets of these DB parameters
JDBC spec does'nt address the need to 'switch' so Type4 JDBC driver writers
concentrated on one connection to one database using a 'kno
You can establish a new connection without dropping the old one. Thus you
can be connected to 2 databases at the same time. Just use the appropriate
connection for the database you want.
Bayless
- Original Message -
From: "Scott Bailey"
To: "pgsql-general"
Sent: Friday, May 29, 200
11 matches
Mail list logo
