Running DatabaseTest (folder part1.chapter02) from Eclipse, I get an
SQLException (invalid schema name) on the execution of the filmfestival
script.
hsqldb.jar is among the Referenced Libraries
filmfestival.script is in the resources.db folder
Below is the exception thrown:
Exception in thread "main" java.sql.SQLException: error in script file line:
2 invalid schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE
FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE
VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120)
DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT
NULL,DURATION INTEGER NOT NULL)]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.lowagie.database.HsqldbConnection.<init>(HsqldbConnection.java:34)
at part1.chapter02.CountryChunks.createPdf(CountryChunks.java:66)
at part1.chapter02.CountryChunks.main(CountryChunks.java:45)
Caused by: org.hsqldb.HsqlException: error in script file line: 2 invalid
schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE
FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE
VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120)
DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT
NULL,DURATION INTEGER NOT NULL)]
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
at org.hsqldb.persist.Log.processScript(Unknown Source)
at org.hsqldb.persist.Log.open(Unknown Source)
at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
... 8 more
Caused by: org.hsqldb.HsqlException: invalid schema name: SYSTEM_SCHEMA
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getSchemaHsqlName(Unknown Source)
at org.hsqldb.Session.getSchemaHsqlName(Unknown Source)
at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
at org.hsqldb.StatementSchema.getResult(Unknown Source)
at org.hsqldb.StatementSchema.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
... 17 more
--
View this message in context:
http://itext-general.2136553.n4.nabble.com/Invalid-schema-name-executing-filmfestival-script-tp3648190p3648190.html
Sent from the iText - General mailing list archive at Nabble.com.
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
iText-questions mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/itext-questions
iText(R) is a registered trademark of 1T3XT BVBA.
Many questions posted to this list can (and will) be answered with a reference
to the iText book: http://www.itextpdf.com/book/
Please check the keywords list before you ask for examples:
http://itextpdf.com/themes/keywords.php
