U
user3131560
Guest
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...
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...