General error: "java.lang.NullPointerException" while executing update statement on H2 table

[Manik Dhawan]

Hi,

I am getting the below error while trying to update one our tables in H2 Database. We are using H2 version : 1.3.161.
The problem comes often and is not reproducible.

 Error while executing query 'update LocatorForward set MACAddress='e8e732:194828',SwitchIPAddress='10.255.221.152',LinkCount='0',linkIpAddr='',TimeStmp='2012-12-19 21:01:39.852',IfIndex='0',Slot='1',Port='1001',VlanID='221',IfSpeed='-1',IfAdminStatus='-1',PortDuplexMode='-1',userid=NULL,domain='0',disposition='1',unp='',classsource='0',serviceId='0',isid='0',Chassis='1' where MACAddress='e8e732:194828' and SwitchIPAddress='10.255.221.152' and VlanID='221''.  General error: "java.lang.NullPointerException" [50000-161].

org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-161]        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)         at org.h2.message.DbException.get(DbException.java:158)              at org.h2.message.DbException.convert(DbException.java:281)     at org.h2.message.DbException.toSQLException(DbException.java:254)    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:368)        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:154)   at



The same statement runs perfectly fine from DBVisualizer console.

Can anyone help please.

-Manik

[Noel Grandin]

You've removed part of the stacktrace, so I can't tell you what is wrong.

[Manik Dhawan]

Here you go

19 Dec 2012 21:01:40 ERROR : [In forward, switch 10.255.221.152]:  Error while executing query 'update LocatorForward set MACAddress='e8e732:194828',SwitchIPAddress='10.255.221.152',LinkCount='0',linkIpAddr='',TimeStmp='2012-12-19 21:01:39.852',IfIndex='0',Slot='1',Port='1001',VlanID='221',IfSpeed='-1',IfAdminStatus='-1',PortDuplexMode='-1',userid=NULL,domain='0',disposition='1',unp='',classsource='0',serviceId='0',isid='0',Chassis='1' where MACAddress='e8e732:194828' and SwitchIPAddress='10.255.221.152' and VlanID='221''.  General error: "java.lang.NullPointerException" [50000-161].

org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-161]        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)         at 

org.h2.message.DbException.get(DbException.java:158)              at 

org.h2.message.DbException.convert(DbException.java:281)     at 

org.h2.message.DbException.toSQLException(DbException.java:254)    at 

org.h2.message.TraceObject.logAndConvert(TraceObject.java:368)        at 

org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:154)   at 

com.ov1.services.shared.XYDatabaseConnection.executeQuery(Unknown Source)          at com.ov1.services.shared.XYDatabaseConnection.xySQLProcessQuery(Unknown Source)              at com.ov1.services.shared.XYDatabaseConnection.processQueryAndRelease(Unknown Source)  at com.ov1.services.shared.XYDatabaseConnection.modValue(Unknown Source)  at 

com.ov1.locator.server.LocatorDBServer.saveForwardCollection(Unknown Source)         at com.ov1.locator.server.LocatorDBServer.saveForwardCollectionUpdateTimeStamp(Unknown Source)   at com.ov1.locator.server.NetForwardDiscoveryUpdater.getAosTable(Unknown Source)   at 

om.ov1.locator.server.NetForwardDiscoveryUpdater.getAosTable(Unknown Source)   at 

com.ov1.locator.server.NetForwardDiscoveryUpdater.getTable(Unknown Source)           at com.ov1.locator.server.NetForwardDiscoveryUpdater.updateCachedInfo(Unknown Source)      at 

com.ov1.services.server.DiscoveryList2.updateCachedInfo(Unknown Source)     at 

com.ov1.services.server.DiscoveryList2.privateUpdate(Unknown Source)             at com.ov1.services.server.DiscoveryList2$PollSwitchesTaskPerformer.performTask(Unknown Source)       at 

com.ov1.util.shared.TaskInfo.performTask(Unknown Source)     at 

com.ov1.util.shared.TaskQueue$TaskQueuePerformer.performTask(Unknown Source) at 

com.ov1.util.shared.TaskInfo.performTask(Unknown Source)     at 

com.ov1.util.shared.ThreadPoolWorkThread.run(Unknown Source)

Caused by: java.lang.NullPointerException   at org.h2.jdbc.JdbcStatement.setExecutingStatement(JdbcStatement.java:971)    at 

org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:167)   at 

org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)

[Noel Grandin]

This bug was fixed about 8 versions ago.

[Manik Dhawan]

Thanks Noel..will try out 1.3.169.