Re: [GENERAL] Searching BLOB - Lucene setup & problem

2006-06-15 Thread John Sidney-Woollett
This is a bit off topic for the Postgres list... ;) Make sure you explicitly include the name of the Lucene jar file in your command line invocation, and any other directories that are required (normally your current working directory), so for Windows you'd use something like java -cp .;{pat

Re: [GENERAL] Searching BLOB - Lucene setup & problem

2006-06-15 Thread [EMAIL PROTECTED]
Hi John, I have had a read through the lucene website (http://lucene.apache.org/java/docs/index.html) and it sounds pretty good to me. I should be able to use this in conjuction with my JSP pages. This may sound quite dumb to anyone who develops in java, but I need a little help setting up the de

Re: [GENERAL] Searching BLOB

2006-06-13 Thread John Sidney-Woollett
Save yourself some effort and use Lucene to index a directory of your 300 word documents. I'm pretty sure that Lucene includes an extension to read Word documents, and you can use PDFBox to read/write PDF files. Marrying the searching and displaying of results to your web application should be triv

Re: [GENERAL] Searching BLOB

2006-06-13 Thread Florian G. Pflug
James Watson wrote: What I was hoping someone could help me out with was identifying the best possible solution to use. 1. How can I store the word doc's in the DB, would it be best to use a BLOB data type? You can use the column type "bytea", which can store (nearly) arbitrary amounts of binar