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
  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.
  2. 0

    man you don't even know how to...

    Oracle Community | 6 years ago | 843833
    java.io.FileNotFoundException: C:\glassfishv3\glassfish\docs\javaee-tutor ial\examples\examples\common\sql\javadb\tutorial.sql (The system cannot find the path specified)
  3. 0

    failure in pre-compiling JSP's

    Oracle Community | 2 decades ago | 3004
    java.io.FileNotFoundException: /cemr2/dev1/app/examples/jsp/tagext/quote/WEB-INF/_tmp_war_quote/examples/jsp/tagext/ sql/_showcode.java (No such file or directory)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with apache commons telnet library - Java Programming - KnowCoding.com

    knowcoding.com | 1 year ago
    java.io.FileNotFoundException: /Library/glassfishv3/glassfishv3/glassfish/domains/domain1/eclipseApps/LaFamily/files (Is a directory)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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