Dear iText,
I am following the 'iText in Action' 2nd addition book.
My computer is a Dual CPU system running Windows-7 Pro.
The CLASSPATH is -> C:\Program
Files\Java\jdk1.7.0_01\bin;F:\iText\lib\iText.jar;
->
F:\iText\lib\hsqldb.jar;F:\iText\src\;F:\iText\resources\db\;
The PATH is -> Path=C:\Program Files (x86)\PhotoEd\;C:\Windows\system32;
->
C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1
.0\;
-> C:\Program Files (x86)\aPDFl\;C:\Program
Files\7-Zip\;C:\Windows\System32\;
-> C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program
Files\Prio;
-> C:\Program Files\Java\jdk1.7.0_17\bin;
I am currently using Java 64-bit.
But, may have to go down to Java 32-bit to keep some older apps working.
I was slowly working thru most of the errors until I ran into
a group of errors that complain about a query select statement.
This is my first encounter with HSQLDB.
Please see source code lines 87 and 182 which are having a problem.
I am hopeing someone could give some pointers on how to get this to work.
Follows are the error message and the bits of source code that
seems to be the problem.
Thanks.
Sincerely,
Ed Zuris.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = =
While in a DOS window
F:\iText\src>
F:\iText\src> java part3.chapter12.HelloWorldCompression
Exception in thread "main" java.sql.SQLException: Table not found in
statement
[SELECT DISTINCT mc.country_id, c.country, count(*) AS c FROM film_country]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at
part3.chapter12.HelloWorldCompression.createPdf(HelloWorldCompression.java:8
7)
at
part3.chapter12.HelloWorldCompression.main(HelloWorldCompression.java:182)
F:\iText\src>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = =
Looking at the source code using Textpad
083 // step 4
084 // Create database connection and statement
085 DatabaseConnection connection = new
HsqldbConnection("filmfestival");
086 Statement stm = connection.createStatement();
087 ResultSet rs = stm.executeQuery(
088 "SELECT DISTINCT mc.country_id, c.country, count(*) AS c "
089 + "FROM film_country c, film_movie_country mc "
090 + "WHERE c.id = mc.country_id "
091 + "GROUP BY mc.country_id, country ORDER BY c DESC");
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = =
Looking at the source code using Textpad
179 public static void main(String[] args) throws IOException,
DocumentException, SQLException
180 {
181 HelloWorldCompression hello = new HelloWorldCompression();
182 hello.createPdf(RESULT1, -1);
183 hello.createPdf(RESULT2, 0);
184 hello.createPdf(RESULT3, 1);
185 hello.createPdf(RESULT4, 2);
186 hello.createPdf(RESULT5, 3);
187 hello.compressPdf(RESULT2, RESULT6);
188 hello.decompressPdf(RESULT6, RESULT7);
189 }
190 }
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= = =
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
iText-questions mailing list
iText-questions@lists.sourceforge.net
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
