[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-7488) MySQLMetaDataDialect wrong attempt to get table metadata

MySQLMetaDataDialect wrong attempt to get table metadata -------------------------------------------------------- Key: JBIDE-7488 URL: https://jira.jboss.org/browse/JBIDE-7488 Project: Tools (JBoss Tools) Issue Type: Bug Components: Hibernate Affects Versions: 3.2.0.Beta1 Reporter: Dmitry Geraskov Assignee: Dmitry Geraskov Fix For: 3.2.0.Beta2 MySQLMetaDataDialect uses "schema" instead of "catalog" name when try to execute "show table status ...". But "catalog" represents db_name. See MySQLMetaDataDialect #getSuggestedPrimaryKeyStrategyName(...) Test case: 1. Create several dbs in MySQL Server 2. Create console configuration with url jdbc:mysql://localhost:3306/?nullCatalogMeansCurrent=false 3. Open Console Configuration/Database OBSERVE: all databases retrieved sucessfully, but FAILURE: java.sql.SQLException: No database selected at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228) at org.hibernate.cfg.reveng.dialect.MySQLMetaDataDialect.getSuggestedPrimaryKeyStrategyName(MySQLMetaDataDialect.java:29)