[jbosstools-issues] [JBoss JIRA] Closed: (JBIDE-7488) MySQLMetaDataDialect wrong attempt to get table metadata
Jiri Peterka (JIRA)
jira-events at lists.jboss.org
Tue Nov 30 11:44:10 EST 2010
[ https://jira.jboss.org/browse/JBIDE-7488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Peterka closed JBIDE-7488.
-------------------------------
> 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)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the jbosstools-issues
mailing list