RE: [Classifier4j-devel] JDBCWordsDataSource SQLException?

[Nick L. <nl...@es...>]

Actually I don't think I've heard of that problem before.

What version of MySQL are you using? I've only tested with v4.

Another possibility is case-sensitivity. I did recieve a patch that fixed an
alledged case-sensitivity problem, but I never found out what database it
was for or any other details, so I haven't applied it. 

That patch modified the line

ResultSet rs = dbm.getTables(null, null, "WORD_PROBABILITY", null);

to 

ResultSet rs = dbm.getTables(null, null, "word_probability", null);

so that might be worth trying. Please post back if you try it and it works.

Nick

> -----Original Message-----
> From: Brent L Johnson [mailto:br...@bj...]
> Sent: Wednesday, 31 December 2003 2:51 PM
> To: cla...@li...
> Subject: [Classifier4j-devel] JDBCWordsDataSource SQLException?
> Importance: Low
> 
> 
> Im sure this is a fairly common question but I didn't see
> it in the mailing list archives.
> 
> Im using MySQL and when I first create a JDBCWordsDataSource it
> creates a table 'word_probability'.  But when I run it after that
> I get the following exception:
> 
> net.sf.classifier4J.bayesian.WordsDataSourceException: 
> Problem creating
> table
> 	at
> net.sf.classifier4J.bayesian.JDBCWordsDataSource.createTable(J
> DBCWordsDa
> taSource.java:252)
> 	at
> net.sf.classifier4J.bayesian.JDBCWordsDataSource.<init>(JDBCWo
> rdsDataSou
> rce.java:100)
> 	at
> com.li.sentinel.agent.classify.Classifier.main(Classifier.java:32)
> Caused by: java.sql.SQLException: General error,  message from server:
> "Table 'word_probability' already exists"
> ...
> 
> Even though the table exists it looks like the following line
> of code isn't finding the table?  In JDBCWordsDataSource.java(233):
> 
> ResultSet rs = dbm.getTables(null, null, "WORD_PROBABILITY", null);
> 
> I get an empty resultset apparently.  This is when using 0.5.  Any
> ideas?
> 
> Thanks,
> 
> - Brent
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign 
> up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell 
> to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> _______________________________________________
> Classifier4j-devel mailing list
> Cla...@li...
> https://lists.sourceforge.net/lists/listinfo/classifier4j-devel
>