*
The moose likes JDBC and the fly likes Connecting to the progress database using jdbc to retrieve the infirmation from the table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to the progress database using jdbc to retrieve the infirmation from the table" Watch "Connecting to the progress database using jdbc to retrieve the infirmation from the table" New topic
Author

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

Mythily Mr
Greenhorn

Joined: Jul 19, 2011
Posts: 4
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Mythily Mr
Greenhorn

Joined: Jul 19, 2011
Posts: 4
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to the progress database using jdbc to retrieve the infirmation from the table
 
Similar Threads
How to insert/Retrieve object as Blob to/from database table?
JDBC: What is the concrete class that implements the jdbc interfaces
Result set not showing the latest data
Making ResultSet unEditable
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection