[jbosstools-issues] [JBoss JIRA] Updated: (JBIDE-8669) Dot character is not supported in DB schema name in Hibernate Configuration
Max Rydahl Andersen (JIRA)
jira-events at lists.jboss.org
Wed May 11 17:22:21 EDT 2011
[ https://issues.jboss.org/browse/JBIDE-8669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Max Rydahl Andersen updated JBIDE-8669:
---------------------------------------
Fix Version/s: 3.3.0.M2
> Dot character is not supported in DB schema name in Hibernate Configuration
> ---------------------------------------------------------------------------
>
> Key: JBIDE-8669
> URL: https://issues.jboss.org/browse/JBIDE-8669
> Project: Tools (JBoss Tools)
> Issue Type: Bug
> Components: Hibernate
> Affects Versions: LATER
> Environment: Hibernate tools version is 3.4.0.v20110215-1252-H31-GA
> (by the way it's not listed in the Jira version menu)
> Win XP
> Eclipse Helios Service Release 1
> WTP 3.2.3
> Dali 2.3.3
> MySQL 5.5.9
> Reporter: Boris Na
> Assignee: Max Rydahl Andersen
> Priority: Minor
> Fix For: 3.3.0.M2
>
>
> 1/ Create a schema on MySQL called: myschema.domain
> 2/ Create a JPA project
> 3/ Create an entity called myEntity
> 4/ Create The corresponding Table (via generated script)
> 5/ Configure Data Source Explorer to the connection => This works well
> 6/ Configure Hibernate explorer (using above connection)
> 7/ Try to open the Database part of this view => you get an SQL exception:
> org.hibernate.exception.SQLGrammarException: Could not get list of suggested identity strategies from database. Probably a JDBC driver problem.
> (...)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.DOMAIN like 'myentity'' at line 1
> (...)
> Hint:
> I just checked the SQL query (via MySQL proxy) and it lacks `` around the schema name in one query:
> show table status from MYSCHEMA.DOMAIN like 'myentity'
> Just replace dot by underscore and everything works well.
--
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