-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
welinder
 Post subject: NullpointerException on simple update query
PostPosted: Wed Apr 05, 2006 8:41 am 
Newbie

Joined: Thu Mar 23, 2006 11:14 am
Posts: 6
The code below works fine on hibernate 3.0, but crashes on 3.1.2 and 3.1.3. Anyone knows why?

Hibernate version:3.1.2, 3.1.3

Code between sessionFactory.openSession() and session.close():
Code:
String cardUpdate = "update VC set timestamp = :newTimestamp where VP = :VP and VC = :VC and timestamp = :oldTimestamp";
tx = session.beginTransaction();
String newTimestamp = "20060405143624.268";
int updated = session.createQuery(cardUpdate).setString("VP", vc.getVpId()).setString("VC", vc.getVcId()).setString("newTimestamp", newTimestamp).setString("oldTimestamp", vc.getTimestamp()).executeUpdate();

Full stack trace of any exception that occurs:
java.lang.NullPointerException
at org.hibernate.hql.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:341)
at org.hibernate.hql.ast.tree.IdentNode.getDataType(IdentNode.java:263)
at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:34)
at org.hibernate.hql.ast.HqlSqlWalker.prepareLogicOperator(HqlSqlWalker.java:1000)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3984)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1758)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1683)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1683)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.updateStatement(HqlSqlBaseWalker.java:358)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:237)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
...

Name and version of the database you are using:
Sybase
Top
 Profile  
 
olak
 Post subject:
PostPosted: Wed Jan 31, 2007 9:31 am 
Beginner
Beginner

Joined: Wed Jan 31, 2007 6:54 am
Posts: 22
I experience a similar problem, code worked fine with 3.0.5, but after upgrading to 3.2.2 I get this problem. I have read the migration guide, but didnt find any obvious solution.

Hibernate version:
core-3.2.2GA, 3.0.5

Full stack trace of any exception that occurs:
java.lang.NullPointerException
at org.hibernate.hql.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:342)
at org.hibernate.hql.ast.tree.IdentNode.getDataType(IdentNode.java:266)
at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.extractDataType(BinaryLogicOperatorNode.java:168)
at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:34)
at org.hibernate.hql.ast.HqlSqlWalker.prepareLogicOperator(HqlSqlWalker.java:1007)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3992)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at no.imr.lsss.database.queries.FetchQuery.execute(FetchQuery.java:113)
at no.imr.lsss.database.DatabaseConnection.executeQuery(DatabaseConnection.java:236)
at no.imr.lsss.database.DatabaseConnection.executeFetchQuery(DatabaseConnection.java:212)
at no.imr.lsss.database.DatabaseConnection.getSelection(DatabaseConnection.java:161)
at no.imr.lsss.framework.admin.SurveyConf.getPlatformsFromDatabase(SurveyConf.java:408)
at no.imr.lsss.framework.admin.SurveyConf.getAllowedPlatforms(SurveyConf.java:442)
at no.imr.lsss.framework.admin.SurveyConf.access$700(SurveyConf.java:28)
at no.imr.lsss.framework.admin.SurveyConf$8.valueChanged(SurveyConf.java:231)
at no.imr.tools.parameter.BaseParameter.notifyParameterListeners(BaseParameter.java:202)
at no.imr.tools.parameter.BaseParameter.setStringValue(BaseParameter.java:169)
at no.imr.tools.parameter.ParameterEditor$ParameterAction.setValue(ParameterEditor.java:569)
at no.imr.tools.parameter.ParameterEditor$ParameterAction.popupMenuWillBecomeInvisible(ParameterEditor.java:536)
at javax.swing.JComboBox.firePopupMenuWillBecomeInvisible(JComboBox.java:961)
at javax.swing.plaf.basic.BasicComboPopup.firePopupMenuWillBecomeInvisible(BasicComboPopup.java:335)
at javax.swing.JPopupMenu.setVisible(JPopupMenu.java:758)
at javax.swing.JPopupMenu.menuSelectionChanged(JPopupMenu.java:1443)
at javax.swing.MenuSelectionManager.setSelectedPath(MenuSelectionManager.java:95)
at javax.swing.MenuSelectionManager.clearSelectedPath(MenuSelectionManager.java:127)
at javax.swing.plaf.basic.BasicComboPopup.hide(BasicComboPopup.java:203)
at javax.swing.plaf.basic.BasicComboBoxUI.setPopupVisible(BasicComboBoxUI.java:835)
at javax.swing.JComboBox.setPopupVisible(JComboBox.java:798)
at javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(BasicComboPopup.java:819)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:273)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at javax.swing.plaf.basic.BasicComboPopup$1.processMouseEvent(BasicComboPopup.java:480)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
at java.awt.Dialog$1.run(Dialog.java:1039)
at java.awt.Dialog$3.run(Dialog.java:1091)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1089)
at java.awt.Component.show(Component.java:1419)
at java.awt.Component.setVisible(Component.java:1372)
at java.awt.Window.setVisible(Window.java:801)
at java.awt.Dialog.setVisible(Dialog.java:979)
at no.imr.tools.swing.wizardry.Wizard.showDialog(Wizard.java:147)
at no.imr.lsss.framework.admin.NewSurveyWizard.show(NewSurveyWizard.java:69)
at no.imr.lsss.viewer.SurveyManager.createNew(SurveyManager.java:150)
at no.imr.lsss.viewer.MainDisplay$25.actionPerformed(MainDisplay.java:921)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.AbstractButton.doClick(AbstractButton.java:337)
at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:1139)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2844)
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:670)
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:678)
at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:678)
at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:649)
at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:267)
at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:254)
at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2921)
at javax.swing.SwingUtilities.processKeyBindings(SwingUtilities.java:1551)
at javax.swing.UIManager$2.postProcessKeyEvent(UIManager.java:1450)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:703)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:958)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:830)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:657)
at java.awt.Component.dispatchEventImpl(Component.java:4282)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Name and version of the database you are using:
HSQLDB
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
11:59:11,250 DEBUG SessionImpl:220 - opened session at timestamp: 4793307755520000
11:59:11,250 DEBUG JDBCTransaction:54 - begin
11:59:11,250 DEBUG ConnectionManager:419 - opening JDBC connection
11:59:11,265 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
11:59:11,265 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
11:59:11,265 DEBUG JDBCTransaction:59 - current autocommit status: false
11:59:11,265 DEBUG JDBCContext:210 - after transaction begin
11:59:11,265 DEBUG QueryPlanCache:70 - unable to locate HQL query plan in cache; generating (from Platform where Nation=578)
11:59:11,265 DEBUG QueryTranslatorImpl:246 - parse() - HQL: from no.imr.lsss.database.tables.hibernate.Platform where Nation=578
11:59:11,265 DEBUG AST:266 - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| \-[FROM] 'from'
| \-[RANGE] 'RANGE'
| \-[DOT] '.'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'no'
| | | | | | \-[IDENT] 'imr'
| | | | | \-[IDENT] 'lsss'
| | | | \-[IDENT] 'database'
| | | \-[IDENT] 'tables'
| | \-[IDENT] 'hibernate'
| \-[IDENT] 'Platform'
\-[WHERE] 'where'
\-[EQ] '='
+-[IDENT] 'Nation'
\-[NUM_INT] '578'

11:59:11,265 DEBUG ErrorCounter:68 - throwQueryException() : no errors
11:59:11,265 DEBUG HqlSqlBaseWalker:111 - select << begin [level=1, statement=select]
11:59:11,281 DEBUG FromElement:108 - FromClause{level=1} : no.imr.lsss.database.tables.hibernate.Platform (no alias) -> platform0_
11:59:11,281 DEBUG HqlSqlWalker:475 - attempting to resolve property [Nation] as a non-qualified ref
12:00:21,015 DEBUG JDBCTransaction:152 - rollback
12:00:21,015 DEBUG JDBCTransaction:163 - rolled back JDBC Connection
12:00:21,031 DEBUG JDBCContext:215 - after transaction completion
12:00:21,031 DEBUG ConnectionManager:402 - aggressively releasing JDBC connection
12:00:21,046 DEBUG ConnectionManager:439 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
12:00:21,046 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
12:00:21,062 DEBUG SessionImpl:422 - after transaction completion
WARNING 12:00:24 DatabaseQuery.error: Database error, FetchQuery
java.lang.NullPointerException
at org.hibernate.hql.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:342)
at org.hibernate.hql.ast.tree.IdentNode.getDataType(IdentNode.java:266)
at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.extractDataType(BinaryLogicOperatorNode.java:168)
at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:34)
...
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.