database check

[Andy B]

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

[Andy B]

problem continues this morning after new download.:

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.



C:\Documents and Settings\Andrew>cd c:\program files\proffittcenterpro\proffittcenter



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>