Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to the progress database using jdbc to retrieve the infirmation from the table

 
Mythily Mr
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Friends,

We have progress database 9.1B installed on the server.
i'm connecting to the progress database server from java jdbc connection.
I'm able to connect to the database and able to retrieve some of the data, But for some columns its giving error that

[JDBC Progress Driver]:Column FrnDetails in table PUB.GENCOND has value exceeding its max length or precision.

I checked in the database the variable datatype is varchar(1400) and the value in the field is not more than 700

I undestand that it is the normal problem in the progress database. But unable to find the solution.

Here is the code for connecting to the Progress database to retrieve the data from the database:

 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This looks like a database specific/driver problem. You might try
rs.getAsciiStream("FrnDetails");
instead of
rs.getString("FrnDetails");

Just a guess to work around whatever the length problem is.

And welcome to CodeRanch! I added code tags to make your code easier to read.
 
Mythily Mr
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the replay..

I tried that but with that also there is no change

Actually I'm able to retrieve some of the varchar column data correctly.

But only for the columns which are having varchar(1400) datatype getting this error.

But in that for one column I'm able to retrieve some values but after some rows I'm getting the same error.

Help me to solve this problem
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic