From: | arun vc <vcarun(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | problem in using DatabaseMetaData getColumns() |
Date: | 2002-09-02 14:49:02 |
Message-ID: | 20020902144902.52552.qmail@web11504.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
hello
i am getting error while using uisng
dmd.getColumns(null,null,MY_TABLE_NAME,null);
i am gtting error while using the new pgjdbc2.jar
driver with the old driver postgresql.jar this method
is working .can you help me in solving this problem.
i am sending a sample code
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
import java.sql.ResultSet;
class CheckDB
{
public static void main(String args[])throws
Exception{
String MY_TABLE_NAME="computers";
Connection con;
try
{
Class.forName("org.postgresql.Driver");
con =
DriverManager.getConnection(jdbc:postgresql://localhost/mytab,loginname,password);
DatabaseMetaData dmd = con.getMetaData();
String[] tableType = {"TABLE"};
ResultSet rs = dmd.getTables(null, null, null,
tableType);
while ( rs.next() )
{
if(MY_TABLE_NAME.equals(rs.getString( "TABLE_NAME"
)))
System.out.println(MY_TABLE_NAME +" found in
database " ) ;
}
rs.close();
rs = dmd.getColumns(null,null,MY_TABLE_NAME,null);
// when i try to use
getColumns(null,null,MY_TABLE_NAME,null); method
// i am getting exception :ERROR: parser: parse
error at or near "("
// i am gtting this error while using the new
pgjdbc2.jar Driver
// with the old driver postgresql.jar this method is
working
while(rs.next())
{
colNames[totalFields]=rs.getString( "COLUMN_NAME"
);//here COLUMN_NAME is a key word
System.out.println("COLUMN_NAME : " +
colNames[totalFields]);
}
rs.close();
}
catch(SQLException e)
{
System.out.println("here i am :"+e.getMessage());
}
}
}
=====
would you like to help someone see the beauty of the world through your eyes long after you have gone http://www.ebai.org
Arun VC, E Team India Web Solutions,
Serene,Anupama Nagar,Pongummoodu,Trivandrum
Phone Off: +91 471 558089. Res : +91 471 343954.
http://www.e-zenit.it
http://www.geocities.com/vcarun
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jochem van Dieten | 2002-09-02 15:00:43 | Re: Length of sql cols in postgresql |
Previous Message | Bruce Momjian | 2002-09-02 14:04:20 | Re: Length of sql cols in postgresql |