Migrating to MySQL 5.0.44 from MySQL 4, Issue in getMetaData().getColumns()
Hi,
My MySQL data directory is as follows,
mysql\ravi directory is
adapter.frm
adapterproperties.frm
adgraphs.frm
adwmipolleddata.frm
agentdefvalobject.MYD
agentdefvalobject.MYI
agentdefvalobject.frm
alert.MYD
alert.MYI
alert.frm
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:13306/ravi","root","");
Statement stm=con.createStatement();
System.out.println("connection established");
Hashtable temp =new Hashtable();
DatabaseMetaData dbmd= con.getMetaData();
ResultSet rs=null;
rs=dbmd.getColumns(null,null,null,null);
while(rs.next())
{
String tabname=rs.getString(3);
System.out.println(" >>>> getMetaDataInfo >>>>> " + tabname);
}
This method returns getColumns() returns the following Exception while trying with MySQL 5.0.44 Enterprise Edition with MySQL connector as 5.0.7.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'opmanagerdb.adapter' doesn't exist
But I tried the same data with MySQL 4.0 , it returns the table names.
>>>> getMetaDataInfo >>>>> adapter
>>>> getMetaDataInfo >>>>> adapter
>>>> getMetaDataInfo >>>>> adapter
>>>> getMetaDataInfo >>>>> adapterproperties
>>>> getMetaDataInfo >>>>> adapterproperties
>>>> getMetaDataInfo >>>>> adapterproperties
>>>> getMetaDataInfo >>>>> adgraphs
>>>> getMetaDataInfo >>>>> adgraphs
>>>> getMetaDataInfo >>>>> admonitorrulelist
>>>> getMetaDataInfo >>>>> admonitorrulelist
>>>> getMetaDataInfo >>>>> admonitorrulelist
>>>> getMetaDataInfo >>>>> adservicerulelist
>>>> getMetaDataInfo >>>>> adservicerulelist
>>>> getMetaDataInfo >>>>> adservicerulelist
>>>> getMetaDataInfo >>>>> adservicesdefinition
>>>> getMetaDataInfo >>>>> adservicesdefinition
>>>> getMetaDataInfo >>>>> adventneterrorcode
>>>> getMetaDataInfo >>>>> adventneterrorcode
>>>> getMetaDataInfo >>>>> adventneterrorcode
>>>> getMetaDataInfo >>>>> adwmipolleddata
>>>> getMetaDataInfo >>>>> adwmipolleddata
>>>> getMetaDataInfo >>>>> agentdefvalobject
>>>> getMetaDataInfo >>>>> agentdefvalobject
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
>>>> getMetaDataInfo >>>>> alert
What will be the problem, Is there any bug or mysql is changed the behaviour of this method.
Please help me to come out this.
I appreciate you help.
Subject
Views
Written By
Posted
Migrating to MySQL 5.0.44 from MySQL 4, Issue in getMetaData().getColumns()
2960
May 17, 2008 09:16AM
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.