RE: [Classifier4j-devel] JDBCWordsDataSource SQLException?

[Brent L J. <br...@bj...>]

That did indeed fix the problem.

Thanks,

- Brent

> 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
> > 
> 
> 
> -------------------------------------------------------
> 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
> 
> 
>