Register / Login
Win a copy of
Clojure in Action
this week in the
JDBC and Relational Databases
WAS 6.1 DataSource 5 Char Problem
posted 8 years ago
I have the following Problem with my Result i'm getting from the database.
I'm using WAS 6.1 a V5 DataSource from it, on the other end i have a Oracle 10g Database.
The Problem is that i'm executing a Query on a Table with a CHAR(20) column.
The Result of the Query if i execute it on a DB-Cleint looks: 'R'
In my SourceCode after executing the Query i get a
: 'R '.
So the complete length of the CHAR-Column is filled up with blanks.
I think this is done by the ResultSetProxy, the class which is used bye the DataSource is:
The Problem occured on changing the DataSources from Version 4 to Version 5
If anybody have an idea how i can get solve this Problem without any Trims, thanks in advance.
It is sorta covered in the
JavaRanch Style Guide
Problem with executeQuery
problem with accessing resultset from multiple tables
How can a TextField get focus?
How to get a row count
How to query a value typed object