RE: [Classifier4j-devel] Training and Classifying

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

That means that PostgreSQL is case sensitive.

Please get the CVS version (in particular
<http://cvs.sourceforge.net/viewcvs.py/*checkout*/classifier4j/Classifier4J/
src/java/net/sf/classifier4J/bayesian/JDBCWordsDataSource.java?rev=1.14>) or
just apply the modification yourself:
<http://cvs.sourceforge.net/viewcvs.py/classifier4j/Classifier4J/src/java/ne
t/sf/classifier4J/bayesian/JDBCWordsDataSource.java?r1=1.13&r2=1.14>


Hopefully that will fix your problems.

Nick

> -----Original Message-----
> From: Neil Gandhi [mailto:np...@nt...]
> Sent: Wednesday, 19 May 2004 12:18 AM
> To: cla...@li...
> Subject: RE: [Classifier4j-devel] Training and Classifying
> Importance: Low
> 
> 
> Hi Nick,
> 
> I really appreciate the advice you are providing.
> 
> After running the code you provided, the following is output:
> 
> 	word_probability (in lower case) Result Set:
> 	TABLE_CAT = null
> 	TABLE_SCHEM = public
> 	TABLE_NAME = word_probability
> 	TABLE_TYPE = TABLE
> 	REMARKS = null
> 	End of Result Set
> 	WORD_PROBABILITY (in UPPER case) Result Set:
> 	End of Result Set
> 
> I had to comment out TYPE_CAT, TYPE_SCHEM, TYPE_NAME,
> SELF_REFERENCING_COL_NAME, REF_GENERATION
> Because an error occurred saying that these column names could not be
> found.
> 
> The Java API says: "Note: Some databases may not return 
> information for
> all tables."
> 
> What I understand from the above output is that when UPPER 
> case is used,
> the Result Set does not have any values.
> Do you agree?
> 
> Regards
> 
> Neil
> 
> > -----Original Message-----
> > From: cla...@li...
> [mailto:classifier4j-
> > dev...@li...] On Behalf Of Nick Lothian
> > Sent: 19 May 2004 00:54
> > To: 'cla...@li...'
> > Subject: RE: [Classifier4j-devel] Training and Classifying
> > 
> > >
> > > Hi Nick,
> > >
> > > > Is PostgreSQL case sensitive with respect to table names?
> > >
> > > PostgreSQL is not case-sensitive - I have tested this.
> > >
> > 
> > Are you sure about this? There seems to be a fair bit of discussion
> about
> > the inability to switch it off: 
> <http://forums.devshed.com/archive/t-
> > 44274>
> > 
> > > > If that doesn't help, can please send the result set
> > > returned from the
> > > > following code:
> > > >
> > > > DatabaseMetaData dbm = con.getMetaData();
> > > > ResultSet rs = dbm.getTables(null, null, "word_probability",
> null);
> > >
> > > I'm not too sure what you mean when you say to "send the
> > > result set" to
> > > you.
> > > What method should I call on the ResultSet.
> > >
> > > When I do:
> > > 	ResultSetMetaData rM = rs.getMetaData();
> > > 	String name = rM.getColumnName(2);
> > >
> > > The value of name is "table_schem".  Shouldn't it be one of
> > > the names of
> > > the columns in the word_probability table??
> > >
> > 
> > No. The getTables(..) call gets data about the tables that exist in
> the
> > database. See
> >
> <http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMeta
> Data.html#
> ge
> > tT
> >
> ables(java.lang.String,%20java.lang.String,%20java.lang.String
> ,%20java.l
> an
> > g.
> > String[])>
> > 
> > Could you please run code like
> > 
> > System.out.println("word_probability (in lower case) Result Set:");
> > DatabaseMetaData dbm = con.getMetaData();
> > ResultSet rs = dbm.getTables(null, null, "word_probability", null);
> > while (rs.next()) {
> > 	System.out.println("TABLE_CAT = " + rs.getString("TABLE_CAT"));
> > 	System.out.println("TABLE_SCHEM = " +
> rs.getString("TABLE_SCHEM"));
> > 	System.out.println("TABLE_NAME = " +
> rs.getString("TABLE_NAME"));
> > 	System.out.println("TABLE_TYPE = " +
> rs.getString("TABLE_TYPE"));
> > 	System.out.println("REMARKS = " + rs.getString("REMARKS"));
> > 	System.out.println("TYPE_CAT = " + rs.getString("TYPE_CAT"));
> > 	System.out.println("TYPE_SCHEM = " +
> rs.getString("TYPE_SCHEM"));
> > 	System.out.println("TYPE_NAME = " + rs.getString("TYPE_NAME"));
> > 	System.out.println("SELF_REFERENCING_COL_NAME = " +
> > rs.getString("SELF_REFERENCING_COL_NAME"));
> > 	System.out.println("REF_GENERATION = " +
> > rs.getString("REF_GENERATION"));
> > }
> > System.out.println("End of Result Set");
> > rs.close();
> > 
> > System.out.println("WORD_PROBABILITY (in UPPER case) Result Set:");
> > dbm = con.getMetaData();
> > rs = dbm.getTables(null, null, "WORD_PROBABILITY", null);
> > while (rs.next()) {
> > 	System.out.println("TABLE_CAT = " + rs.getString("TABLE_CAT"));
> > 	System.out.println("TABLE_SCHEM = " +
> rs.getString("TABLE_SCHEM"));
> > 	System.out.println("TABLE_NAME = " +
> rs.getString("TABLE_NAME"));
> > 	System.out.println("TABLE_TYPE = " +
> rs.getString("TABLE_TYPE"));
> > 	System.out.println("REMARKS = " + rs.getString("REMARKS"));
> > 	System.out.println("TYPE_CAT = " + rs.getString("TYPE_CAT"));
> > 	System.out.println("TYPE_SCHEM = " +
> rs.getString("TYPE_SCHEM"));
> > 	System.out.println("TYPE_NAME = " + rs.getString("TYPE_NAME"));
> > 	System.out.println("SELF_REFERENCING_COL_NAME = " +
> > rs.getString("SELF_REFERENCING_COL_NAME"));
> > 	System.out.println("REF_GENERATION = " +
> > rs.getString("REF_GENERATION"));
> > }
> > System.out.println("End of Result Set");
> > rs.close();
> > 
> > (Note that this hasn't been tested, but it should pretty close)
> > 
> > 
> > 
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: SourceForge.net Broadband
> > Sign-up now for SourceForge Broadband and get the fastest
> > 6.0/768 connection for only $19.95/mo for the first 3 months!
> > http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
> > _______________________________________________
> > Classifier4j-devel mailing list
> > Cla...@li...
> > https://lists.sourceforge.net/lists/listinfo/classifier4j-devel
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... 
> Oracle 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Classifier4j-devel mailing list
> Cla...@li...
> https://lists.sourceforge.net/lists/listinfo/classifier4j-devel
>