MySQL Forums
Forum List  »  Quality Assurance

Problem with Mysql 5.0.44 with Connector 5.0.8
Posted by: Ravi kumar
Date: May 17, 2008 09:47AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with Mysql 5.0.44 with Connector 5.0.8
2490
May 17, 2008 09:47AM


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.