Strange behaviour when accessing Oracle 8i table from servlet

[Pol Williams]

Hi there,

First a little background, I'm using jdk 1.6. I've got a 2 column table in an Oracle 8i DB that holds a very simple code to word map. There are no strange characters. Both columns are varchar.

From my desktop machine, when I execute the the following:

   

        OracleDataSource ods = new OracleDataSource();

        ods.setDriverType("thin");
        ods.setServerName("DBserver.db");
        ods.setDatabaseName("DB");
        ods.setPortNumber(1527);
        ods.setUser("user");
        ods.setPassword("password");

        Connection connection = ods.getConnection();
        Statement stmt = connection.createStatement();
        ResultSet res = stmt.executeQuery(SQL);

        CachedRowSet crs = new CachedRowSetImpl();
        crs.populate(res);
        while (crs.next()) {
            System.out.println("ID: " + crs.getString(1) +
                               ",  Name: " + crs.getString(2));
        } 

Everything works fine, and I get the results I expect (both return values for getString(1) and getString(2) are exactly as they are stored in the table)

HOWEVER:

When I execute the same exact code in a servlet sitting on a Tomcat server (I'm using a simple applet servlet model to access the table and return a response to the applet), crs.getString(int) returns strings like: 0x53, 0x54, 0x4E and so on.

I am unsure what this means, and would be grateful for any assistance. I am wondering where to start to troubleshoot the problem.

[Sagar Rohankar]

Looks like the characters getting displayed as hexadecimal numbers, Where you get the hexadecimals, on a console (when you print them using, Sysout) OR on a Applet ?

[Pol Williams]

Sagar Rohankar wrote:Looks like the characters getting displayed as hexadecimal numbers, Where you get the hexadecimals, on a console (when you print them using, Sysout) OR on a Applet ?

Thanks for the reply, this output happens when I send it to the applet, or when I log the output from the servlet to a log file. Any ideas why?

[ken zhu]

did you try to remove below code:

CachedRowSet crs = new CachedRowSetImpl(); 

OR

just output to jsp page to check the strange issue.

[Sagar Rohankar]

Pol Williams wrote:this output happens when I send it to the applet, or when I log the output from the servlet to a log file. Any ideas why?

A silly guess, It may be possible that the values coming from the database are inserted/converted as hexadecimals. Look at the rows data.