How to retrieve data in java from memo field using progress database

[user3131560]

How to retrieve data in java from memo field,i am using progress database.but its giving error:: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Column Doc_Desc in table PUB.GLDOCHDR has value exceeding its max length or precision.

wrote code like this sql:

selectSQL="select Doc_Desc from PUB.GLDOCHDR where Doc_Desc like '%:%' and Doc_Desc like '%@%'";


Retrieving data like this:

rs = stmt.executeQuery(selectSQL);
while( rs.next())
{
BufferedReader br = new BufferedReader(new InputStreamReader(rs.getAsciiStream("Doc_Desc")));

System.out.println(br.readLine());
}

Continue reading...