In reply to own message: ----------Original Message---------
> Running MX6.1 standalone, XP, Apache > > Client wants to use Interbase/Firebird as his datasource. > > I've installed a JDBC driver (hopefully correctly), and a simple > cfquery selecting a single field from a table works fine. > > However, when trying to access an Interbase/Firebird stored procedure > using <cfstoredproc>, we get Java NullPointerException error > (ostensibly from the line <cfprocresult name="foo_result">. > > The stored proc itself runs fine in the Interbase GUI, and will also > run in CF if I use an ODBC connection with the Easysoft driver, but I > cannot get this JDBC driver to produce any result set. > > Is there something that I have missed, perhaps, from the <cfstoredproc>? > > <cfstoredproc datasource="#request.DSN#" procedure="foo" > returncode="yes"> > <cfprocresult name="foo_result"> > </cfstoredproc> > If the returncode is changed to 'no', or removed, it will work, but only produces a single row of data, instead of 22. Bloody weird! I think we're going back to the (paid-for) Easysoft ODBC driver.... Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
