DatabaseMetaData.getColumns
Hi all.
I've just dowloaded and installed MySql 5.0.2 and JConnector 3.1.6.
In my application I try to get columns name for a particular table and have the exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Connection reset
STACKTRACE:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:75)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:94)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:122)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2292)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159)
at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:890)
and so on.
here is a my code:
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=blabla");
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getColumns("null", "null", "test_table", "null");
while(rs.next()) {
String name = rs.getString("COLUMN_NAME");
System.out.println(name);
}
rs.close();
con.close();
}
catch(Exception e) {
e.printStackTrace();
}
In the same way I get all Tables in DB and all works fine.
What is the problem?
Thanks in advance.
Subject
Written By
Posted
DatabaseMetaData.getColumns
February 15, 2005 11:10PM
February 16, 2005 07:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.