f



Oracle 9.2 vs. Oracle 9.2.0.4. - Strange ResultSet behaviour

I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4
client version.

The 9.2 version behaves as expected. 
My problem only occurs with the 9.2.0.4. version. 
If I try to process the ResultSet of database query and the selected
column data includes leading blanks, the 9.2.0.4 seems to trim these
leading blanks.

Is this behaviour known or am I doing something wrong ?
<code snippet>

ResultSet result = null;
Connection con = null;
Statement stmt = null;
Vector vec = new Vector();
try {
        con = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
        stmt = con.createStatement();
        result = stmt.executeQuery("SELECT DATA FROM
CPTMESSAGEDATA";);
        while (result.next()) {
                vec.add(result.getString("DATA"));
        }
        con.close();
	stmt.close();

} catch (SQLException e) {
        
}        
</code snippet>
CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values
like:
" @20013     @E123      @G123      @          @      @        "
" @3700167         @43186           @B50_300   @1 @20013     @1   @OK 
"

Any help is appreciated.

Alex
0
s
5/14/2004 10:56:40 AM
comp.lang.java.databases 3049 articles. 0 followers. samyaksulabh (16) is leader. Post Follow

0 Replies
1057 Views

Similar Articles

[PageSpeed] 26

Reply: