DatabaseMetaData.getColumns
Posted by: Serghei Jelauc
Date: February 15, 2005 11:10PM

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.

Options: ReplyQuote


Subject
Written By
Posted
DatabaseMetaData.getColumns
February 15, 2005 11:10PM


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.