Could you recommend a good debugger? I'm not using an IDE. But, as you pointed out, the invoke() method in DbUtils is pretty simple, so I'm not sure how this would help, and I'm relectant to try debugging the Driver code...
-----Original Message----- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:53 AM To: Jakarta Commons Users List Subject: RE: [DBUtils] SqlNullCheckedResultSet not replacing nulls --- "Anderson, James H [IT]" <[EMAIL PROTECTED]> wrote: > Is there any good doc on Java reflexion anywhere? I suppose I could pour > over the javadoc, but from the looks of it that would take days, and I > just don't have the time. Reflection isn't that tough to figure out but it might be faster to step through the DbUtils code in your debugger to find out exactly why the getNull* methods aren't getting called. David > > Thanks, > > jim > > -----Original Message----- > From: David Graham [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 9:18 AM > To: Jakarta Commons Users List > Subject: Re: [DBUtils] SqlNullCheckedResultSet not replacing nulls > > > Your code looks correct. What JDBC driver are you using? The > implementation of SqlNullCheckedResultSet is dependent on > ResultSet.wasNull() being implemented properly. Of course, it might be > a > bug in DbUtils but the test cases pass for this class (unless the tests > have bugs too :-). > > Here's the relevant method from DbUtils: > http://jakarta.apache.org/commons/dbutils/xref/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSet.html#354 > > There's not a lot of logic there that could go wrong. > > David > > --- "Anderson, James H [IT]" <[EMAIL PROTECTED]> wrote: > > In the following code snippet, SqlNullCheckedResultSet is not > replacing > > nulls, neither for String nor Date results. > > > > Anyone have an idea what's wrong? > > > > Thanks, > > > > jim > > > > [...] > > > > try { > > Class.forName("com.mysql.jdbc.Driver").newInstance(); > > conn = DriverManager.getConnection(url, user, pswd); > > > > MapListHandler mlh = new MapListHandler() { > > public Object handle (ResultSet rs) { > > SqlNullCheckedResultSet wrapper = new > > SqlNullCheckedResultSet(rs); > > wrapper.setNullString("--n/a--"); > > wrapper.setNullDate(today); > > rs = > > ProxyFactory.instance().createResultSet(wrapper); > > Object returnVal = null; > > try { > > System.out.println("*** HERE ***"); > > returnVal = super.handle(rs); > > } catch (Exception e) { > > System.out.println(e.getMessage()); > > } > > return returnVal; > > } > > }; > > > > QueryRunner run = new QueryRunner(); > > List result = (List) run.query(conn, query, mlh); > > Iterator it1 = result.iterator(); > > while (it1.hasNext()) { > > Map map = (Map) it1.next(); > > Set keys = map.keySet(); > > Iterator it = keys.iterator(); > > while (it.hasNext()) { > > String key = (String) it.next(); > > System.out.println(key + ": " + map.get(key)); > > } > > System.out.println(); > > } > > } catch (Exception e) { > > System.out.println(e.getMessage()); > > e.printStackTrace(); > > } finally { > > > > org.apache.commons.dbutils.DbUtils.commitAndCloseQuietly(conn); > > } > > } > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Photos: High-quality 4x6 digital prints for 25� > http://photos.yahoo.com/ph/print_splash > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25� http://photos.yahoo.com/ph/print_splash --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
