The strCreatePartsTable is this:
The exception is this:Code:private static final String strCreatePartsTable = "create table APP.PARTS (" + " ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)," + " PARTCODE VARCHAR(30), " + " PARTNAME VARCHAR(30), " + " PARTDESCRIPTION VARCHAR(30), " + " PARTPRICE VARCHAR(20), " + " PARTQUANTITY VARCHAR(30), " + " PARTCOUNTRY VARCHAR(30), " + ")";
Code:init: deps-jar: compile-single: run-single: java.sql.SQLException: Table/View 'APP.PARTS' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) at DataFiles.PartsData.getListEntries(PartsData.java:229) at org.weces.partsData.PartsFrame.<init>(PartsFrame.java:36) at org.weces.partsData.PartsFrame.main(PartsFrame.java:162) Caused by: ERROR 42X05: Table/View 'APP.PARTS' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 5 more BUILD SUCCESSFUL (total time: 2 seconds)




Reply With Quote