[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-8669) Dot character is not supported in DB schema name in Hibernate Configuration

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.