Several times exception from derby implementation was thrown (were unable to
eproduce and check if it caused by any our work)
-----------------------------------------------------------------------------------------------------------------------------
Key: DERBY-2074
URL: http://issues.apache.org/jira/browse/DERBY-2074
Project: Derby
Issue Type: Bug
Components: Newcomer
Affects Versions: 10.1.3.1
Environment: WinXP Professional, Java 1.5.0_06
Reporter: Kovylin Alexandr
Priority: Minor
12:34:45,323 ERROR [pool-1-thread-3] history.helpers.HistoryDataAccessHelper -
failed to read measurements, filter = (fromTime=Mon Nov 06 12:34:00 MSK 2006,
toTime=Mon Nov 13 12:34:00 MSK 2006, , properties=2-6-2-value)
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback;
uncategorized SQLException for SQL [SELECT COUNT(DISTINCT
sshis.measurement_time) FROM sshis_property_measurement sshis INNER JOIN
sstmp_filter_3 filtertbl ON sshis.property_id = filtertbl.property_id WHERE
sshis.measurement_time >= ? AND sshis.measurement_time < ?]; SQL state [XJ001];
error code [0]; Java exception:':
java.lang.NullPointerException'.; nested exception is
org.apache.derby.impl.jdbc.EmbedSQLException: Java exception: ':
java.lang.NullPointerException'.
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.registerAccessMethod(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.findMethodFactoryByImpl(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.createSort(UnknownSource)
at
org.apache.derby.impl.sql.execute.DistinctScalarAggregateResultSet.loadSorter(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DistinctScalarAggregateResultSet.openCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:535)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:561)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:579)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:589)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:619)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:629)
at
org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:656)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.MeasurementsSaveGetHelper.getMeasurements(MeasurementsSaveGetHelper.java:81)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper$7.doInTransaction(HistoryDataAccessHelper.java:315)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper$7.doInTransaction(HistoryDataAccessHelper.java:314)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:117)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper.getMeasurements(HistoryDataAccessHelper.java:313)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.asyncread.MeasurementsReadTask.executeTask(MeasurementsReadTask.java:127)
at
com.meshnetics.wsn.ctrl.dispatcher.services.history.asyncread.MeasurementsReadTask.run(MeasurementsReadTask.java:97)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
