[Hibernate-issues] [Hibernate-JIRA] Created: (HB-499) Wrong alias with a class with $s name

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-499


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-499
    Summary: Wrong alias with a class with $s name
       Type: Bug

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1 beta 6

   Assignee: 
   Reporter: Alfonso da Silva

    Created: Tue, 25 Nov 2003 9:59 AM
    Updated: Tue, 25 Nov 2003 9:59 AM
Environment: Hibernate 2.1 beta 6, PostgreSQL 7.2

Description:
I have a class (generated with gclib) with this name:    
   persistent.core.DAO$$EnhancedByCGLIB$$0

When I want to load an object, Hibernate generates this SQL sentence:
  
  select dao$$enh0_.IDO as IDO0_, dao$$enh0_.nom as nom0_, dao$$enh0_.edat as edat0_ from alumne1 dao$$enh0_ where dao$$enh0_.IDO=?

and the JDBC driver crashes:

  java.sql.SQLException: ERROR:  parser: parse error at or near "$$"
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
        at org.postgresql.Connection.ExecSQL(Connection.java:398)
        at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
        at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
        at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
        at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:83)
        at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:631)
        at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:166)
        at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)

I think that the class alias generation would have to replace '$' by '_' (or another inoffensive character ;) ).

The class alias generation takes place in net.sf.hibernate.loader.OuterJoinLoader (lines 517-528) and uses net.sf.hibernate.sql.Alias.

Thankx.

  Kutlax.



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira