[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6578) BasicFormatterImpl Null Pointer Exception

[Gail Badner (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gail Badner resolved HHH-6578.
------------------------------

    Resolution: Duplicate
      Assignee: Gail Badner

> BasicFormatterImpl Null Pointer Exception
> -----------------------------------------
>
>                 Key: HHH-6578
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6578
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.6
>            Reporter: Sylvain Vieujot
>            Assignee: Gail Badner
>            Priority: Minor
>
> When format_sql is true, BasicFormatterImpl throws a NPE for queries starting with brackets :
> For the query :
> (SELECT * FROM HtmlPageWithSectionDAOTest$TestEntity WHERE status=2 AND section='fr' ORDER BY sortOrder,title) UNION ALL (SELECT * FROM HtmlPageWithSectionDAOTest$TestEntity WHERE status=2 AND section='ar' AND alias NOT IN ( SELECT alias FROM HtmlPageWithSectionDAOTest$TestEntity WHERE status=2 AND section IN ('fr')) ORDER BY sortOrder,title)
> I get the following exception :
> java.lang.NullPointerException
> 	at org.hibernate.jdbc.util.BasicFormatterImpl$FormatProcess.isFunctionName(BasicFormatterImpl.java:374)
> 	at org.hibernate.jdbc.util.BasicFormatterImpl$FormatProcess.openParen(BasicFormatterImpl.java:355)
> 	at org.hibernate.jdbc.util.BasicFormatterImpl$FormatProcess.perform(BasicFormatterImpl.java:156)
> 	at org.hibernate.jdbc.util.BasicFormatterImpl.format(BasicFormatterImpl.java:91)
> 	at org.hibernate.jdbc.util.SQLStatementLogger.logStatement(SQLStatementLogger.java:109)
> 	at org.hibernate.jdbc.AbstractBatcher.log(AbstractBatcher.java:444)
> 	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:511)
> 	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
> 	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
> 	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
> 	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
> 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
> 	at org.hibernate.loader.Loader.doList(Loader.java:2533)
> 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
> 	at org.hibernate.loader.Loader.list(Loader.java:2271)
> 	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
> 	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
> 	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
> 	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
> ...

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