#179 NullPointerException when having two tables with the same name

[test toto]

There already a closed Ticket about the same bug.
My problem is that I have two tables with the same name, one with lowecase and the other with UPPERCASE.

I'm using Oracle 11g.

Gathering schema details...............java.lang.NullPointerException
at net.sourceforge.schemaspy.model.Table.initColumnAutoUpdate(Table.java:338)
at net.sourceforge.schemaspy.model.Table.initColumns(Table.java:303)
at net.sourceforge.schemaspy.model.Table.<init>(Table.java:88)
at net.sourceforge.schemaspy.model.Database$TableCreator.createImpl(Database.java:1003)
at net.sourceforge.schemaspy.model.Database$TableCreator.create(Database.java:999)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:259)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

Are you planning to fixe this bug ?
Thanks

[Andrew H]

NOTE: CANDIDATE CODE FIX DETAILED BELOW, BINARY x86 JAR FIX ATTACHED

I also received this error, specifically these two lines were the same:

Gathering schema details…java.lang.NullPointerException
at net.sourceforge.schemaspy.model.Table.initColumnAutoUpdate(Table.java:338)

I couldn't figure out what the issue may have been with my actual database table (SQL Server 2008 via jtds Single Sign-On [i.e. Windows Authentication]).

So I downloaded the schemaSpy 5.0.0 source code and changed line 340 of Table.java from:

    } catch (SQLException exc) {

to

    } catch (Exception exc) {

and produced the JAR file attached.

So now, when this NullPointerException is produced, it is simply logged and SchemaSpy moves on.

FYI1: my logfile now looks like this:

15:40:55.820 FINE:    Database$NameValidator.isValid - Including table AuditDynamicPropertyTypes: matches inclusion pattern ".*"
15:40:55.820 FINE:    Table.<init> - app.AuditDynamicPropertyTypes
15:40:55.828 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.lang.NullPointerException
15:40:55.829 WARNING: Table.initColumnAutoUpdate - SQL: select * from app."AuditDynamicPropertyTypes" where 0 = 1
15:40:55.831 FINE:    Database$TableCreator.createImpl - Found details of table AuditDynamicPropertyTypes
15:40:56.509 FINE:    Database$NameValidator.isValid - Including table DynamicPropertyTypes: matches inclusion pattern ".*"
15:40:56.510 FINE:    Table.<init> - app.DynamicPropertyTypes
15:40:56.516 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: java.lang.NullPointerException
15:40:56.516 WARNING: Table.initColumnAutoUpdate - SQL: select * from app."DynamicPropertyTypes" where 0 = 1
15:40:56.520 FINE:    Database$TableCreator.createImpl - Found details of table DynamicPropertyTypes

FYI2: I'm not fully aware of the potential implications of my source code change - however, I have checked and both of the Tables AuditDynamicPropertyTypes and DynamicPropertyTypes do appear to be completely documented in the resulting output.