Problems with JDBC 1.1 for SQL2005 and SQL Statement

Hi there,
we have a Application on a Bea Weblogic Server 8.1 SP6 and tried to use the
ms jdbc 1.1.1501.101 with a ms sql 2005 enterprise with sp1.
We have a sql statement that works fine with the jdbc for sql 2000 on a ms
sql 2000 enterpise. But now with the new jdbc aand the sql 2005 we retrieve
NULL instead of a recordset.

SELECT c.refsd,p.refparent,count(p.rowid) as counted
into #te
FROM sd_obj_ci_sd_cycle c INNER JOIN
sd_obj_ci_sd_pos p ON p.refciobjsdcycle = c.rowid
where refsd = 999999
group by c.refsd, p.refparent

SELECT p.absposnumber, p.absposindex, p.rowid, ci.id,
isnull(#te.counted,0) AS childs, ci.serial AS ci
, 0 AS maxrowid, dbo.funcScot_GetCIMaxDateTo_DateTime(ci.rowid) AS enddate
FROM sc_sdoc_main m INNER JOIN
sd_obj_ci_sd_cycle c ON m.rowid = c.refsd INNER JOIN
sd_obj_ci_sd_pos p ON p.refciobjsdcycle = c.rowid INNER JOIN
sd_obj_ci ci ON p.refciobj = ci.rowid left outer join
#te on m.rowid = #te.refsd and p.rowid = #te.refparent
WHERE (m.rowid = 999999) AND (p.refparent = 0)
ORDER BY p.absposindex

drop table #te


Can anybody help me ?

thanks
tim


.

Relevant Pages