[ https://jira.jboss.org/browse/JBIDE-7488?page=com.atlassian.jira.plugin.s... ] Dmitry Geraskov updated JBIDE-7488: ----------------------------------- Description: 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) was: MySQLMetaDataDialect uses "schema" instead of "catalog" name when try to execute "show table status ...". But "catalog" represents db_name. See MySQLMetaDataDialect #getSuggestedPrimaryKeyStrategyName(...) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/browse/JBIDE-7488?page=com.atlassian.jira.plugin.s... ] Dmitry Geraskov commented on JBIDE-7488: ---------------------------------------- Tested also with MySQL 3.23.0 -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/browse/JBIDE-7488?page=com.atlassian.jira.plugin.s... ] Jiri Peterka commented on JBIDE-7488: ------------------------------------- Verified in JBDS 4.0.0.beta2 h12, tested with multiple databases on mysql 5.1, Fedora 14-64b -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira