#143 NullPointerException in getImpliedConstraints

[filiprem]

I have this error while running schemaspy. I can provide more details if needed.

filip@zeus:~/bin/schemaspy$ java -jar schemaSpy_5.0.0.jar -t pgsql -cp postgresql-8.4-701.jdbc4.jar -host postgres-master -db dev -s w2gi -u postgres -o ss_w2gi
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details..................................................................................................................................................................................................................................................................(236sec)
Writing/graphing summary...java.lang.NullPointerException
at net.sourceforge.schemaspy.DbAnalyzer.getImpliedConstraints(DbAnalyzer.java:68)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:288)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

filip@zeus:~/bin/schemaspy$ java -version
java version "1.6.0_24"
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)

[Andress Calderon]

Hey there!

I got exactly the same error working with PostgreSQL. I checked a bit the code and after use the -noimplied tag I got another error:

Using database properties:
[/home/and/Documents/Colciencias/Convenio615/Design/DB/schemaSpyGUI20090302/schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details........................................(1sec)
Writing/graphing summary............(0sec)
Writing/diagramming details.....................................java.lang.NullPointerException
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendPrimaryKeys(XmlTableFormatter.java:193)
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendTable(XmlTableFormatter.java:105)
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendTables(XmlTableFormatter.java:82)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:386)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

So I realized that the problem was in a previous change to a primary key's name. I just remove the constraint and redo it and now it is running smoothly... =D

[filiprem]

With -noimplied:

filip@zeus:~/bin/schemaspy$ java -jar schemaSpy_5.0.0.jar -t pgsql -cp postgresql-8.4-701.jdbc4.jar -host postgres-master -db dev -s w2gi -u postgres -o ss_w2
gi -noimplied
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details......................................................................................................................................
.................................................................................................................................(258sec)
Writing/graphing summary......dot -Tpng:gd ss_w2gi/diagrams/summary/relationships.real.large.dot -oss_w2gi/diagrams/summary/relationships.real.large.png -Tcma
px: gd-png: fatal libpng error: image size exceeds user limits in IHDR
dot -Tpng:gd ss_w2gi/diagrams/summary/relationships.real.large.dot -oss_w2gi/diagrams/summary/relationships.real.large.png -Tcmapx: gd-png error: setjmp retur
ns error condition
......(301sec)
Writing/diagramming details...................................................................................................................................
.................................................................................................................................java.lang.NullPointerExceptio
n
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendPrimaryKeys(XmlTableFormatter.java:193)
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendTable(XmlTableFormatter.java:105)
at net.sourceforge.schemaspy.view.XmlTableFormatter.appendTables(XmlTableFormatter.java:82)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:386)
at net.sourceforge.schemaspy.Main.main(Main.java:42)