#171 NumberFormatException

N/A
open
nobody
None
5
2014-08-21
2013-07-23
Pavel Dobryakov
No

Try run :
java -jar ./schemaSpy_5.0.0.jar -t mysql -o /var/doc/feedlog -host xxx -db feedlog -u xxx -p xxx -dp /var/lib/mysql-connector-java-5.1.25/mysql-connector-java-5.1.25-bin.jar -loglevel finest
and get such output

12:42:31.367 INFO: SchemaAnalyzer.analyze - Starting schema analysis
12:42:31.459 CONFIG: ConnectionURLBuilder.<init> - connectionURL: jdbc:mysql://xxx/feedlog
12:42:31.460 INFO: SchemaAnalyzer.getConnection - Using database properties:
12:42:31.460 INFO: SchemaAnalyzer.getConnection - [./schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties
12:42:32.223 INFO: SchemaAnalyzer.analyze - Connected to MySQL - 5.5.30-30.2-log
12:42:32.224 INFO: SchemaAnalyzer.analyze - Gathering schema details
java.lang.NumberFormatException: For input string: "3454549518"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:495)
at java.lang.Integer.parseInt(Integer.java:527)
at net.sourceforge.schemaspy.model.Database.getBasicTableMeta(Database.java:366)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:232)
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)

as i understand problem is here:
info about table
TABLE_CATALOG: def
TABLE_SCHEMA: feedlog
TABLE_NAME: feed_tick
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compressed
TABLE_ROWS: 3445555420
AVG_ROW_LENGTH: 37
DATA_LENGTH: 130093678592
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 98954641408
DATA_FREE: 2097152
AUTO_INCREMENT: 12108766586
CREATE_TIME: 2013-04-28 20:30:02
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
CHECKSUM: NULL
CREATE_OPTIONS: row_format=COMPRESSED
TABLE_COMMENT: Feed

i try run with -norows but id did not help

Discussion