database check

todays download

Sql error Table 'till.Cashups' does not exist

output suggests data base update module proffittcenter.DatabaseUpdate.execute(DatabaseUpdate.java:78)

table created is 'till.CashUps'

then I get a string out of range on transferring the database twice when I get to 106 rows of suppliers (there are 135) exception causes hang

full output:
C:\Program Files\ProffittCenterpro\ProffittCenter>java -jar proffittcenter.jar

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'till.Cashups' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)

at com.mysql.jdbc.Util.getInstance(Util.java:336)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2436)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1556)

at proffittcenter.DatabaseUpdate.execute(DatabaseUpdate.java:78)

at proffittcenter.Main.main(Main.java:348)

Exception in thread "AWT-EventQueue-0" java.lang.StringIndexOutOfBoundsException: String index out of range: 0

at java.lang.String.charAt(Unknown Source)

at proffittcenter.StringOps.firstCaps(StringOps.java:64)

at proffittcenter.Parser.parseBuffer(Parser.java:75)

at proffittcenter.Parser.execute(Parser.java:718)

at proffittcenter.SalesScreen.jMenuItem1ActionPerformed(SalesScreen.java:3324)

at proffittcenter.SalesScreen.access$1500(SalesScreen.java:68)

at proffittcenter.SalesScreen$FormListener.actionPerformed(SalesScreen.java:2924)

at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

at javax.swing.AbstractButton.doClick(Unknown Source)

at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)

at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at javax.swing.JComponent.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

C:\Program Files\ProffittCenterpro\ProffittCenter>

Ive emailed a zip of the csv im using

	Author	Topic: database check (Read 370 times)
0 Members and 1 Guest are viewing this topic.