[Schemaspy-users] NullPointerException on AS/400

[Friedman, J. <jfr...@op...>]

Hi,
 
My props file contains:
 
egrep -v '^#|^$' SAMI.properties
description=IBM DB2 with the Type 4 'Net' Driver
extends=db2
driver=com.ibm.as400.access.AS400JDBCDriver
connectionSpec=jdbc:as400://piglet:446/
host=piglet
db=S105P35M
username=FTPIDE
password=******
schemas=VIEWLIB,OPPDATA,OPPTDATA
selectViewSql=select view_definition text from qsys2.views where
table_name=:view and table_schema=:schema
selectCheckConstraintsSql=select constraint_name constraint_name, 'x'
table_name, check_clause from qsys2.syschkcst where
constraint_schema=:schema
selectTableIdsSql=select table_catalog table_id, table_name table_name
from qsys2.tables where table_schema=:schema
selectIndexIdsSql=select iasp_number index_id, index_name index_name,
table_name table_name from qsys2.sysindexes where table_schema=:schema
 

My command:
 
java -jar $HOME/schemaspy/schemaSpy.jar -dp $HOME/schemaspy/jt400.jar -t
$HOME/schemaspy/sources/daily/SAMI.properties -u FTPIDE -p ****** -o
$HOME/schemaspy/data/SAMI -norows -s OPPTDATA


My error:
 
....................................java.lang.NullPointerException
        at
net.sourceforge.schemaspy.model.TableIndex.compareTo(TableIndex.java:136
)
        at
net.sourceforge.schemaspy.model.TableIndex.compareTo(TableIndex.java:9)
        at java.util.TreeMap.put(TreeMap.java:545)
        at java.util.TreeSet.add(TreeSet.java:238)
        at
java.util.AbstractCollection.addAll(AbstractCollection.java:305)
        at java.util.TreeSet.addAll(TreeSet.java:295)
        at java.util.TreeSet.<init>(TreeSet.java:143)
        at
net.sourceforge.schemaspy.view.HtmlTablePage.writeIndexes(HtmlTablePage.
java:330)
        at
net.sourceforge.schemaspy.view.HtmlTablePage.write(HtmlTablePage.java:65
)
        at
net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:297
)
        at net.sourceforge.schemaspy.Main.main(Main.java:21)


I did get output, but some tables were missing:

ls tables | wc -l
173

grep 'Tables and' index.html
<p><b>736 Tables and 23 Views:</b>

Thank you,
Jason Friedman
Data Architecture
303-768-3109 


------------------------------------------------------------------------------
This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies. OppenheimerFunds may, at its sole discretion, monitor, review, retain and/or disclose the content of all email communications. 
==============================================================================