JDBCTemplate

[muhammadowais]

We are using JDBCTemplate (Spring) with MySQL as database and AES Encryption.
Our client is using special ASCII characters. That encrypts and decrypts correctly as a query. However when we display it on Web the ASCII characters shows question marks ? for ASCII (espacially for extended ASCII) character.
================================================== =====
SOURCE
================================================== =====
public SqlRowSet getReportFollowUpForProcessing(Integer reportId) {
DataFetchQueries dataFetch = new DataFetchQueries();
String sql = (String) dataFetch.GET_FOLLOWUP_REPORT_FOR_PROCESSING(repor tId);
return jdbcTemplate.queryForRowSet(sql);
}================================================== =====
we open it by using
rowset.getObject("COLUMN-NAME");

PLEASE HELP ME TO ELEMIATE THE PROBLEM

Thanking you in advance

[karldmoore]

And what happens if you use plain old JDBC?

[muhammadowais]

And what happens if you use plain old JDBC?

It works fine

[karldmoore]

Interesting, I'm not sure what the JdbcTemplate would do to break this. Is it possible to see the code you are running? A TestCase would be nice as well. If you wrap this in [code] [ /code] tags, it will make it sooooo much easier to read!

[muhammadowais]

public SqlRowSet getReportFollowUpForProcessing(Integer reportId) {
   DataFetchQueries dataFetch = new DataFetchQueries();
   String sql = (String) dataFetch.GET_FOLLOWUP_REPORT_FOR_PROCESSING(repor tId);
   return jdbcTemplate.queryForRowSet(sql);
}

================================================== =====
we open it by using

rowset.getObject("COLUMN-NAME");

[wpoitras]

Can you post the equivalent JDBC code?