ODBC vs JDBC storedproc query result

i'm stuck... :(

here it is...

my storedproc in interbase 6.X ...

CREATE PROCEDURE WA_STUDLIST (
ILAST VARCHAR(15) CHARACTER SET NONE)
RETURNS (
OCOURSE CHAR(25) CHARACTER SET NONE,
OYEAR CHAR(15) CHARACTER SET NONE,
OMIDDLE CHAR(15) CHARACTER SET NONE,
OFIRST CHAR(25) CHARACTER SET NONE,
OLAST CHAR(15) CHARACTER SET NONE,
OID VARCHAR(7) CHARACTER SET NONE)
AS
begin
for select id,last, first, middle, course, syear from enlist where last starting :ilast order by last, first, middle
into :oid, :olast, :ofirst, :omiddle, :ocourse, :oyear

/* Procedure Text */
do suspend;
end


my CF coding....


<cfstoredproc procedure="wa_studlist" datasource="SIS" returncode="no">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#searchstring#">
<cfprocresult name="studlist">
</cfstoredproc>

<cfdump var="#studlist#" label="Student">


if i set the datasource via ODBC, assuming my searchstring 'SMIT', it will return rows (more that one) starting SMIT. but via JDBC with the same input parameter, it will only return one row.

here's my JDBC connection...

JDBC URL -> jdbc:firebirdsql://sis/d:\\sis.gdb
Driver Class -> org.firebirdsql.jdbc.FBDriver

it seems that current seetings wont allow STOREDPROC to return 2 or more rows... any ideas?

thank you in advance.

tron

Not sure, it may be an issue with the JDBC driver for Firebird? I haven't used Firebird or Interbase so I really don't have much to offer on this one.

yes you're maybe right, anyways, ill just settle for standard query for the time being, i was hoping for storedproc for faster query and good security. how fast is it really when using storedproc compared to select?

tnx again kite , it is so cool being a member here