[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6837) Sql sharing: diffrente bind variable sixe generates difenerent sql id on shared memory

[Fernando Paris (JIRA)]

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

Fernando Paris commented on HHH-6837:
-------------------------------------

Please modify title. "Sql sharing: different bind variable sizes generates different sql ids on shared memory"

> Sql sharing: diffrente bind variable sixe generates difenerent sql id on shared memory
> --------------------------------------------------------------------------------------
>
>                 Key: HHH-6837
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6837
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>            Reporter: Fernando Paris
>            Priority: Critical
>
> We are experiencing the problem described on the link. http://tkyte.blogspot.com/2007/04/sharing-sql.html
> We have been searching a way to set the bind parameter size on hibernate for the prepared statement but we haven't found anything. 
> Do you have any solution for that? there 1200 versions of the samesql on database memory due this issue
> We are thinking to develop an aop interceptor that sets this value with defineParameterType(..) from the preparedsstatement

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira