DatabaseMetaData.getCatalogs()
От | Peter Futaro |
---|---|
Тема | DatabaseMetaData.getCatalogs() |
Дата | |
Msg-id | ef32f7760702210134n18560449l9a6ef125ece83d33@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: DatabaseMetaData.getCatalogs()
|
Список | pgsql-jdbc |
Dear all,
I have a remote machine, which is ushing Postgres v.7.4.11.
This machine has 2 database :
Database A & Database B
I have a task to list out the available database inside that machine in a combo box. I have tried to using :
public String getDBList()
{
String s = "";
try
{
Class.forName(sDriver);
connection_this = DriverManager.getConnection(sURL, sUser, sPassword);
dbMetaData_this = connection_this.getMetaData();
resultSet_this = dbMetaData_this.getCatalogs();
while(resultSet_this.next())
{
if(!resultSet_this.isFirst())
s += ",";
s += resultSet_this.getString(1);
}
return s;
}
catch(SQLException e)
{
return "error";
}
}
This will only return the database, that I state inside the URL
(e.g. String sURL = "jdbc:postgresql://<<ip>>:5432/databaseA" ---> will return "databaseA" only).
I try to connect without stating any database inside the URL, also cannot.
Can you guys please help me ?
Thank you.
Peter Futaro
I have a remote machine, which is ushing Postgres v.7.4.11.
This machine has 2 database :
Database A & Database B
I have a task to list out the available database inside that machine in a combo box. I have tried to using :
public String getDBList()
{
String s = "";
try
{
Class.forName(sDriver);
connection_this = DriverManager.getConnection(sURL, sUser, sPassword);
dbMetaData_this = connection_this.getMetaData();
resultSet_this = dbMetaData_this.getCatalogs();
while(resultSet_this.next())
{
if(!resultSet_this.isFirst())
s += ",";
s += resultSet_this.getString(1);
}
return s;
}
catch(SQLException e)
{
return "error";
}
}
This will only return the database, that I state inside the URL
(e.g. String sURL = "jdbc:postgresql://<<ip>>:5432/databaseA" ---> will return "databaseA" only).
I try to connect without stating any database inside the URL, also cannot.
Can you guys please help me ?
Thank you.
Peter Futaro
В списке pgsql-jdbc по дате отправления: