Hi,
> In my application I have my own USERS table and this seems to conflict
> with the system USERS table.
>
> When I try to get meta data via jdbc, I get a combo of my table and
> the system table.
>
> resultSet = metaData.getColumns(null, "", tableName, "%");
> while (resultSet.next()) {
> final String columnName = resultSet.getString(4);
> }
Sorry I can't reproduce the problem, it works for me. Could you
provide a complete test case please?
import java.sql.*;
public class Test {
public static void main(String[] args) throws Exception {
Class.forName("org.h2.Driver");
Connection conn = DriverManager.getConnection("jdbc:h2:~/test4");
conn.createStatement().execute("CREATE TABLE IF NOT EXISTS
COLUMNS(A INT)");
DatabaseMetaData metaData = conn.getMetaData();
ResultSet resultSet = metaData.getColumns(null, "", "COLUMNS", "%");
while (resultSet.next()) {
System.out.println(resultSet.getString(4));
}
}
}
This prints A for me.
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
