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

[Max Rydahl Andersen (JIRA)]

     [ https://issues.jboss.org/browse/JBIDE-8669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Max Rydahl Andersen resolved JBIDE-8669.
----------------------------------------

    Resolution: Cannot Reproduce Bug


> 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
>         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.M3
>
>
> 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