Getting a TEXT field from the database

[gladz]

I am using a MySQL database and I have a field of datatype TEXT. I am programming in Java and I get my record set using a CachedRowSet object. I am trying to get the value of the field using the getString function but it's not working. Does the CachedRowSet not support the TEXT datatype? How can I get that field?

 

[laffreuxthomas]

Hello !

I don't know for CachedRowSet, but this code works with TEXT fields of MySQL 3.23 + MyODBC + the bridge odbc-jdbc

      ResultSet rs = myPreparedStatement.executeQuery();
      int columnCount = rs.getMetaData().getColumnCount();
      while (rs.next()) {
        for(int i=1; i <= columnCount; i++) {
          String s = rs.getString(i);
        }
      }
      rs.close();
      myPreparedStatement.close();

I hope that info will help you.

Thomas ---
A free GUI for your database:

http://www.sashipamelba.com