aspose file tools*
The moose likes JDBC and the fly likes getBoolean and boolean values in CSV file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getBoolean and boolean values in CSV file" Watch "getBoolean and boolean values in CSV file" New topic
Author

getBoolean and boolean values in CSV file

Mark Ashworth
Greenhorn

Joined: Nov 02, 2000
Posts: 11
Good Day,
I am trying to find out which character equates to a boolean true value. I have found out that `K` `F` `0` equates to false but for some reason `T` `1` `Y` or `S` do not equate to true. If also tried `TRUE` `true` `True` `-1` and the rest of the alphabet.
I am using the ODBC driver for text files which uses the Microsoft CSV/Excel driver.
Regards,
Mark Ashworth
Lee Wallen
Greenhorn

Joined: Jul 14, 2001
Posts: 10
1 appears to work. I have the fourth field defined as a byte.
The text file contents:
<pre>
Field1,Field2,Field3,1
this,is,a,0
this2,is2,a2,0
this3,is3,a3,1
</pre>
The sample code:
<code>
import java.sql.*;
public class TextReader
{
public static void main( String [] args ) {
Connection c = null;
Statement stmnt = null;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbcdbc:text_test", "", "" );
stmnt = c.createStatement();
String query = "select * from [test.txt];";
ResultSet rs = stmnt.executeQuery( query );
while( rs.next() )
{
System.out.print( rs.getString( "Field1" ) + "\t");
System.out.print( rs.getString( "Field2" ) + "\t");
System.out.print( rs.getString( "Field3" ) + "\t");
</code>
<em>
System.out.println( rs.getBoolean( "Field4" ) );
</em>
<code>
}
rs.close();
} catch( Exception e ) {
System.err.println( e );
} finally {
try {
stmnt.close();
c.close();
} catch( Exception e ) {
System.err.println( e );
}
} // end of try catch
} // end of main
}
</code>
Output of code:
<pre>
Field1 Field2 Field3 true
this is a false
this2 is2 a2 false
this3 is3 a3 true
</pre>

[This message has been edited by Lee Wallen (edited July 15, 2001).]
 
Consider Paul's rocket mass heater.
 
subject: getBoolean and boolean values in CSV file