NullPointerException on empty result set running against Oracle

[hoyacom]

NullPointerException on empty result set running against Oracle

[GoogleCodeExporter]

Facing same issue for DB2 database too.

<dependency>
  <groupId>org.bgee.log4jdbc-log4j2</groupId>
  <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
  <version>1.15</version>
</dependency>

Original comment by [email protected] on 19 Nov 2013 at 5:27

[GoogleCodeExporter]

We're facing the same issue. And the problem is indeed specific to the oracle 
driver which closes an empty result set the first time next() is called.

So is there an update on the status of this bug? It's preventing us from using 
JDBC logging effectively at the moment.

Original comment by [email protected] on 9 Dec 2013 at 9:42

[GoogleCodeExporter]

OK, I'll try to fix that today.

Original comment by [email protected] on 9 Dec 2013 at 9:45

[GoogleCodeExporter]

I deployed a snapshot, could you please tell me all if it fixes your issues? If 
it doesn't, please provide me the exception stacktraces. 

<dependency>
  <groupId>org.bgee.log4jdbc-log4j2</groupId>
  <artifactId>log4jdbc-log4j2-jdbcXX</artifactId>
  <version>1.16-SNAPSHOT</version>
</dependency>

I haven't actually installed Oracle, nor DB2, but mocked the behavior of 
returning a null ResultSetMetaData. Given the error it generated, I am not 
totally convinced that the diagnostic is correct. So please keep me posted :)

Original comment by [email protected] on 11 Dec 2013 at 12:24

[GoogleCodeExporter]

Just tried it out (on Oracle). The NPE is gone and result set logging is 
working.

Thanks a lot!

Original comment by [email protected] on 11 Dec 2013 at 7:35

[GoogleCodeExporter]

OK, the diagnostic was correct: because the ResultSetMetaData could not be 
acquired, the Integer columnCount in DefaultResultSetCollector was null; when 
calling getColumnCount, which returns an int, the auto boxing was generating 
the NPE. 

columnCount is now an int, with default value 0, and another attribute is used 
to ensure that the metadata are acquired only once. 

Artifact version 1.16 released. Closing this issue.

Original comment by [email protected] on 12 Dec 2013 at 12:21

• Changed state: Verified