Hi,
I have connected to a informix database and I am trying to get the columns
names by using the JDBC DatabaseMetaData and the function getColumns().
try
{
Class driver = Class.forName("informix.api.jdbc.JDBCDriver");
DriverManager.registerDriver((Driver)driver.newInstance() );
Connection connection =
DriverManager.getConnection("jdbc:informix-api-direct:" +
";system=informix"+
";database=jsadb,
username,
password);
Statement statement = connection.createStatement();
DatabaseMetaData dbmd = connection.getMetaData();
//
// it gives an error on the line below
//
ResultSet col = dbmd.getColumns(null,null,"%",null);
ResultSetMetaData rsm = col.getMetaData();
}
The error that it produces is:-
"infotmix.api.jdbc.JDBCException: XIX000:-674:Routine (_i japi
jdbc_cvtype) cannot be resolved"
Has anybody got an idea on what I am doing wrong.
Any help will be much appreciated.
Thanks,
Jas