• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

[Solved] Preparedstatement not returning any results

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
[Update]
Seemed that the data type of one of fields was CHAR and wasn't all the way up with appended with spaces, somehow a statement does this automatically.
Hans

Hi everyone,
I'm having some problems with one of my preparedStatements, which used to work fine some time ago, but now seem to be giving me a no result. The strange thing is that when I use a normal statement I get a result back, or if I use a another preparedStatement it works fine. The database is Oracle and the appserver is websphere 5, I'm not getting any exceptions just an empty resultset. I've there is anyone who can give me some insight I would be much appreciated!!
Regards,
Hans ter Wal
PS The are 10 spaces included in the T$ITEM But the browser only shows one
======= Statement 1 - the problem giving one =============
....
ps = c.prepareStatement(
"SELECT T$AMNT, T$PERC FROM TTDSLS911100 WHERE T$BDNO = ? AND ( T$ITEM = ? OR T$CPRG = ? ) AND T$STDT <= sysdate AND sysdate <= T$EDDT",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, "testbid");
ps.setString(2, " C1806A"); //10 spaces included in the T$ITEM
ps.setString(3, "237113");
rs = ps.executeQuery();
if (rs.first()) {
out.println("yeaha<br>");
} else {
out.println("grrrrrE<br>");
}
....
Result: grrrrrrE
======= Statement 2 - No problem statemen =============
...
stmt = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT T$AMNT, T$PERC FROM TTDSLS911100 WHERE T$BDNO = "testbid" AND ( T$ITEM = " C1806A" OR T$CPRG = "237113" ) AND T$STDT <= sysdate AND sysdate <= T$EDDT");//10 spaces included in the T$ITEM

if (rs.first()) {
out.println("yeaha<br>");
} else {
out.println("grrrrrE<br>");
}
...
Result: Yeaha
=================== Statement 3 no prob statement ========
...
ps = c.prepareStatement(
"SELECT TTIITM001100.T$VOOR FROM TTIITM001100 WHERE TTIITM001100.T$ITEM = ?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ps.setString(1, " C1806A");//10 spaces included in the T$ITEM
rs = ps.executeQuery();
if (rs.first()) {
out.println("yeaha<br>");
} else {
out.println("grrrrrE<br>");
}
...
Result: Yeaha
[ October 23, 2003: Message edited by: Hans ter Wal ]
[ October 24, 2003: Message edited by: Hans ter Wal ]
 
reply
    Bookmark Topic Watch Topic
  • New Topic