RE: [Classifier4j-devel] Training and Classifying

[Neil G. <np...@nt...>]

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/DatabaseMetaData.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