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

[Jiri Peterka (JIRA)]

    [ https://jira.jboss.org/browse/JBIDE-7488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12566277#comment-12566277 ] 

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

> 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