Perhaps you can help me out... I used to upload my data to the live military mode s site using my Raspberry Pi 2. As I also use it for other hobby projects I have been offline for some time.
Now I want to get back to upload my data also to this site. However, the java client seems to have an error. It does fetch the data from dump1090, but when uploading there is something wrong.
Fetching data:
Code: Select all
MSG,6,333,15,400AE3,115,2016/04/03,07:29:43.619,2016/04/03,07:29:43.619,,37025,,,,,,1000,0,0,0,0
MSG 6 400AE3 Roermond, NL 2016/04/03 1000 37025
[4CA97E, 3C6628, 471EA7, 471F63, 485064, 471EAA, 4CA808, 3C49C8, 400AE3]
MSG 6 Prepared Statmentcom.mysql.jdbc.JDBC4PreparedStatement@187f9e0: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('400AE3','Roermond, NL','2016/04/03','07:29:43.619','07:29:43.619','1000','37025')
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: MSG 6 Prepared Statmentcom.mysql.jdbc.JDBC4PreparedStatement@187f9e0: INSERT IGNORE INTO statusPI(HexCode, Location, Date ,Time, GMTTIME, squawk, Altitude) VALUES ('400AE3','Roermond, NL','2016/04/03','07:29:43.619','07:29:43.619','1000','37025')
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO:
Code: Select all
Exception: Exc H6 Status PI com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
at foo.db.Logging_Current.main(Logging_Current.java:403)
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: Exception: Exc H6 Status PIcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'modes.statusPI' doesn't exist
Apr 03, 2016 7:29:43 AM foo.db.Logging_Current main
INFO:
Can anyone help me out?