java.io.FileNotFoundException: E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\examples\common\sql\javadb\delete.sql The problem here is that the folder examples is used twice. I fixed that in glassfishv3\glassfish\docs\javaee-tutorial\examples\bp-project\javadb.properties: Before: db.create.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/delete.sql After: db.create.src=${javaee.tutorial.home}/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/common/sql/${db.vendor}/delete.sql Now I get an SQLSyntaxErrorException: ... create-tables: [sql] connecting to jdbc:derby://localhost:1527/sun-appserv-samples;create=true; [sql] Loading org.apache.derby.jdbc.ClientDriver using a cached AntClassLoader. [sql] Executing resource: E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\common\sql\javadb\tutorial.sql [sql] SQL: CREATE TABLE WEB_BOOKSTORE_BOOKS (bookId VARCHAR(8), surname VARCHAR(24), firstName VARCHAR(24), tit le VARCHAR(96), price FLOAT, onSale SMALLINT, calendar_year INT, description VARCHAR(30), inventory INT) [sql] 0 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('201', 'Duke', '', 'My Early Years: Growing up on *7', 30.75, 0, 1995, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('202', 'Jeeves', '', 'Web Servers for Fun and Profit', 40.75, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('203', 'Masterson', 'Webster', 'Web Components for Web Develop ers', 27.75, 0, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('205', 'Novation', 'Kevin', 'From Oak to Java: The Revolution of a Language', 10.75, 1, 1998, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('206', 'Gosling', 'James', 'Java Intermediate Bytecodes', 30.9 5, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('207', 'Thrilled', 'Ben', 'The Green Project: Programming for Consumer Devices', 30.00, 1, 1998, 'What a cool book', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('208', 'Tru', 'Itzal', 'Duke: A Biography of the Java Evangeli st', 45.00, 0, 2001, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: CREATE TABLE BANK_SEQUENCE_GENERATOR ( GEN_KEY VARCHAR(255), GEN_VALUE NUMERIC(20) ) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_ACCOUNT ( ACCOUNT_ID NUMERIC(20) CONSTRAINT PK_ACCOUNT PRIMARY KEY, TYPE VARCHAR(24 ), DESCRIPTION VARCHAR(30), BALANCE NUMERIC(10,2), CREDIT_LINE NUMERIC(10,2), BEGIN_BALANCE NUMERIC(10,2), BEGIN_BALANCE _TIME_STAMP TIMESTAMP) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER ( CUSTOMER_ID NUMERIC(20) CONSTRAINT PK_CUSTOMER PRIMARY KEY, LAST_NAME VA RCHAR(30), FIRST_NAME VARCHAR(30), MIDDLE_INITIAL VARCHAR(1), STREET VARCHAR(40), CITY VARCHAR(40), STATE VARCHAR(2), ZI P VARCHAR(5), PHONE VARCHAR(16), EMAIL VARCHAR(30)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_TX ( TX_ID NUMERIC(20) CONSTRAINT PK_TX PRIMARY KEY, ACCOUNT_ID NUMERIC(20), TIME_S TAMP TIMESTAMP, AMOUNT NUMERIC(10,2), BALANCE NUMERIC(10,2), DESCRIPTION VARCHAR(30), CONSTRAINT FK_TX_ACCOUNT_ID FOREIG N KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER_ACCOUNT_XREF ( CUSTOMER_ID NUMERIC(20), ACCOUNT_ID NUMERIC(20), CONSTRAINT FK_BANK_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES BANK_CUSTOMER(CUSTOMER_ID), CONSTRAINT FK_BANK_ACCOUNT_ID FORE IGN KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) [sql] Failed to execute: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) BUILD FAILED java.sql.SQLSyntaxErrorException: Die Tabelle/Ansicht 'EJB_ORDER_SEQUENCE_GENERATOR' ist nicht vorhanden.

Oracle Community | taitruong | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    ant create-tables, table/view 'EJB_ORDER_SEQUENCE_GENERATOR' does not exist

    Oracle Community | 8 years ago | taitruong
    java.io.FileNotFoundException: E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\examples\common\sql\javadb\delete.sql The problem here is that the folder examples is used twice. I fixed that in glassfishv3\glassfish\docs\javaee-tutorial\examples\bp-project\javadb.properties: Before: db.create.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/delete.sql After: db.create.src=${javaee.tutorial.home}/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/common/sql/${db.vendor}/delete.sql Now I get an SQLSyntaxErrorException: ... create-tables: [sql] connecting to jdbc:derby://localhost:1527/sun-appserv-samples;create=true; [sql] Loading org.apache.derby.jdbc.ClientDriver using a cached AntClassLoader. [sql] Executing resource: E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\common\sql\javadb\tutorial.sql [sql] SQL: CREATE TABLE WEB_BOOKSTORE_BOOKS (bookId VARCHAR(8), surname VARCHAR(24), firstName VARCHAR(24), tit le VARCHAR(96), price FLOAT, onSale SMALLINT, calendar_year INT, description VARCHAR(30), inventory INT) [sql] 0 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('201', 'Duke', '', 'My Early Years: Growing up on *7', 30.75, 0, 1995, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('202', 'Jeeves', '', 'Web Servers for Fun and Profit', 40.75, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('203', 'Masterson', 'Webster', 'Web Components for Web Develop ers', 27.75, 0, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('205', 'Novation', 'Kevin', 'From Oak to Java: The Revolution of a Language', 10.75, 1, 1998, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('206', 'Gosling', 'James', 'Java Intermediate Bytecodes', 30.9 5, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('207', 'Thrilled', 'Ben', 'The Green Project: Programming for Consumer Devices', 30.00, 1, 1998, 'What a cool book', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('208', 'Tru', 'Itzal', 'Duke: A Biography of the Java Evangeli st', 45.00, 0, 2001, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: CREATE TABLE BANK_SEQUENCE_GENERATOR ( GEN_KEY VARCHAR(255), GEN_VALUE NUMERIC(20) ) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_ACCOUNT ( ACCOUNT_ID NUMERIC(20) CONSTRAINT PK_ACCOUNT PRIMARY KEY, TYPE VARCHAR(24 ), DESCRIPTION VARCHAR(30), BALANCE NUMERIC(10,2), CREDIT_LINE NUMERIC(10,2), BEGIN_BALANCE NUMERIC(10,2), BEGIN_BALANCE _TIME_STAMP TIMESTAMP) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER ( CUSTOMER_ID NUMERIC(20) CONSTRAINT PK_CUSTOMER PRIMARY KEY, LAST_NAME VA RCHAR(30), FIRST_NAME VARCHAR(30), MIDDLE_INITIAL VARCHAR(1), STREET VARCHAR(40), CITY VARCHAR(40), STATE VARCHAR(2), ZI P VARCHAR(5), PHONE VARCHAR(16), EMAIL VARCHAR(30)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_TX ( TX_ID NUMERIC(20) CONSTRAINT PK_TX PRIMARY KEY, ACCOUNT_ID NUMERIC(20), TIME_S TAMP TIMESTAMP, AMOUNT NUMERIC(10,2), BALANCE NUMERIC(10,2), DESCRIPTION VARCHAR(30), CONSTRAINT FK_TX_ACCOUNT_ID FOREIG N KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER_ACCOUNT_XREF ( CUSTOMER_ID NUMERIC(20), ACCOUNT_ID NUMERIC(20), CONSTRAINT FK_BANK_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES BANK_CUSTOMER(CUSTOMER_ID), CONSTRAINT FK_BANK_ACCOUNT_ID FORE IGN KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) [sql] Failed to execute: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) BUILD FAILED java.sql.SQLSyntaxErrorException: Die Tabelle/Ansicht 'EJB_ORDER_SEQUENCE_GENERATOR' ist nicht vorhanden.

    Root Cause Analysis

    1. java.io.FileNotFoundException

      E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\examples\common\sql\javadb\delete.sql The problem here is that the folder examples is used twice. I fixed that in glassfishv3\glassfish\docs\javaee-tutorial\examples\bp-project\javadb.properties: Before: db.create.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/examples/common/sql/${db.vendor}/delete.sql After: db.create.src=${javaee.tutorial.home}/common/sql/${db.vendor}/tutorial.sql db.delete.src=${javaee.tutorial.home}/common/sql/${db.vendor}/delete.sql Now I get an SQLSyntaxErrorException: ... create-tables: [sql] connecting to jdbc:derby://localhost:1527/sun-appserv-samples;create=true; [sql] Loading org.apache.derby.jdbc.ClientDriver using a cached AntClassLoader. [sql] Executing resource: E:\glassfishv3\glassfish\docs\javaee-tutorial\examples\common\sql\javadb\tutorial.sql [sql] SQL: CREATE TABLE WEB_BOOKSTORE_BOOKS (bookId VARCHAR(8), surname VARCHAR(24), firstName VARCHAR(24), tit le VARCHAR(96), price FLOAT, onSale SMALLINT, calendar_year INT, description VARCHAR(30), inventory INT) [sql] 0 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('201', 'Duke', '', 'My Early Years: Growing up on *7', 30.75, 0, 1995, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('202', 'Jeeves', '', 'Web Servers for Fun and Profit', 40.75, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('203', 'Masterson', 'Webster', 'Web Components for Web Develop ers', 27.75, 0, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('205', 'Novation', 'Kevin', 'From Oak to Java: The Revolution of a Language', 10.75, 1, 1998, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('206', 'Gosling', 'James', 'Java Intermediate Bytecodes', 30.9 5, 1, 2000, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('207', 'Thrilled', 'Ben', 'The Green Project: Programming for Consumer Devices', 30.00, 1, 1998, 'What a cool book', 20) [sql] 1 rows affected [sql] SQL: INSERT INTO WEB_BOOKSTORE_BOOKS VALUES('208', 'Tru', 'Itzal', 'Duke: A Biography of the Java Evangeli st', 45.00, 0, 2001, 'What a cool book.', 20) [sql] 1 rows affected [sql] SQL: CREATE TABLE BANK_SEQUENCE_GENERATOR ( GEN_KEY VARCHAR(255), GEN_VALUE NUMERIC(20) ) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_ACCOUNT ( ACCOUNT_ID NUMERIC(20) CONSTRAINT PK_ACCOUNT PRIMARY KEY, TYPE VARCHAR(24 ), DESCRIPTION VARCHAR(30), BALANCE NUMERIC(10,2), CREDIT_LINE NUMERIC(10,2), BEGIN_BALANCE NUMERIC(10,2), BEGIN_BALANCE _TIME_STAMP TIMESTAMP) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER ( CUSTOMER_ID NUMERIC(20) CONSTRAINT PK_CUSTOMER PRIMARY KEY, LAST_NAME VA RCHAR(30), FIRST_NAME VARCHAR(30), MIDDLE_INITIAL VARCHAR(1), STREET VARCHAR(40), CITY VARCHAR(40), STATE VARCHAR(2), ZI P VARCHAR(5), PHONE VARCHAR(16), EMAIL VARCHAR(30)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_TX ( TX_ID NUMERIC(20) CONSTRAINT PK_TX PRIMARY KEY, ACCOUNT_ID NUMERIC(20), TIME_S TAMP TIMESTAMP, AMOUNT NUMERIC(10,2), BALANCE NUMERIC(10,2), DESCRIPTION VARCHAR(30), CONSTRAINT FK_TX_ACCOUNT_ID FOREIG N KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: CREATE TABLE BANK_CUSTOMER_ACCOUNT_XREF ( CUSTOMER_ID NUMERIC(20), ACCOUNT_ID NUMERIC(20), CONSTRAINT FK_BANK_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES BANK_CUSTOMER(CUSTOMER_ID), CONSTRAINT FK_BANK_ACCOUNT_ID FORE IGN KEY (ACCOUNT_ID) REFERENCES BANK_ACCOUNT(ACCOUNT_ID)) [sql] 0 rows affected [sql] SQL: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) [sql] Failed to execute: INSERT INTO EJB_ORDER_SEQUENCE_GENERATOR VALUES ('VENDOR_PART_ID',1) BUILD FAILED java.sql.SQLSyntaxErrorException: Die Tabelle/Ansicht 'EJB_ORDER_SEQUENCE_GENERATOR' ist nicht vorhanden.

      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException()
    2. Apache Derby Client JDBC Driver
      Statement.execute
      1. org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      2. org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      3. org.apache.derby.client.am.Statement.execute(Unknown Source)
      3 frames
    3. Ant
      UnknownElement.execute
      1. org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)
      2. org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)
      3. org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:776)
      4. org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706)
      5. org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449)
      6. org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
      6 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    5. Ant
      Main.startAnt
      1. org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
      2. org.apache.tools.ant.Task.perform(Task.java:348)
      3. org.apache.tools.ant.Target.execute(Target.java:357)
      4. org.apache.tools.ant.Target.performTasks(Target.java:385)
      5. org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
      6. org.apache.tools.ant.Project.executeTarget(Project.java:1306)
      7. org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
      8. org.apache.tools.ant.Project.executeTargets(Project.java:1189)
      9. org.apache.tools.ant.Main.runBuild(Main.java:758)
      10. org.apache.tools.ant.Main.startAnt(Main.java:217)
      10 frames
    6. Apache Ant Launcher
      Launcher.main
      1. org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
      2. org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
      2 frames