[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5909) SybaseASE15Dialect getMaxAliasLength() cause SQL exception

[Yang Li (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39931#action_39931 ] 

Yang Li commented on HHH-5909:
------------------------------

I want to clarify, the same SQL can be executed in Sybase Central Interactive SQL (GUI based Sybase client tool) without any error. However, it will generate the same error in Sybase shell command isql client environment.

> SybaseASE15Dialect getMaxAliasLength() cause SQL exception
> ----------------------------------------------------------
>
>                 Key: HHH-5909
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5909
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.0, 3.6.1
>         Environment: Sybase ASE 15.5 with Sybase JDBC 3 (jconn3.jar)
> Hibernate 3.6.0 final
> JDK 1.6.0_23
>            Reporter: Yang Li
>            Priority: Critical
>   Original Estimate: 0.5h
>  Remaining Estimate: 0.5h
>
> After upgrade Hibernate from 3.2.0 to 3.6.0, I got following exception with following SQL (converted from HQL):
> select defaultwdo1_.displayDescriptionTemplate as displayDescriptionTemplate30_1_ from WJob wjob0_, WDocDist defaultwdo1_
> Caused by: com.sybase.jdbc3.jdbc.SybSQLException: The identifier that starts with 'displayDescriptionTemplate30_1' is too long. Maximum length is 30.
> 	at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
> 	at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
> 	at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
> 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
> 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
> The same SQL can be executed in native Sybase ISQL environment without any error. 
> The workaround using Sybase11Dilect or modify getMaxAliasLength() inside SybaseASE15Dialect to return a smaller number(e.g. 20)

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira