Problem with Mysql 5.0.44 with Connector 5.0.8

[Ravi kumar]

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.