Re: index a mysql database -blob field

2010-01-30 Thread luciusvorenus
Ps. I use tomcat 6 chrislusf wrote: > > For blob, it is not so simple since BLOB could contain different file > types, like HTML, pdf, word, zip file type. > So besides getting results out via resultSet.getBlob() function, you > will need to convert the binary stream into simple text strin

Re: index a mysql database -blob field

2010-01-30 Thread luciusvorenus
i try with dbsight and when a try to type && retype my passwort: """Can not read Server Configuration file(WEB-INF/data/xsearch-config.xml). You may avoid this by manually extract the war file." I already extract the war file ... Thank u Chris chrislusf wrote: > > For blob, it is not so si

Re: index a mysql database -blob field

2010-01-29 Thread Chris Lu
For blob, it is not so simple since BLOB could contain different file types, like HTML, pdf, word, zip file type. So besides getting results out via resultSet.getBlob() function, you will need to convert the binary stream into simple text strings. DBSight free version already can read the blog

Re: index a mysql database -blob field

2010-01-29 Thread Ian Lea
Search google for converting mysql BLOBs to text. Or look at the ResultSet stream methods in conjunction with the Field constructors that take Readers. Maybe something like new Field(txt, new InputStreamReader(rs.getBinaryStream(txt)) -- Ian. On Fri, Jan 29, 2010 at 6:10 PM, luciusvorenus w