I have used the JSQLConnect drivers, and had no problems at all with SQL 2000.
http://www.jnetdirect.com/products.php?op=jsqlconnect You may want to try the DataDirect or even the M$ drivers, too. Larry On 3/6/06, Eric Williams <[EMAIL PROTECTED]> wrote: > I haven't tried straight JDBC yet, but I have tried different JDBC > drivers (Opta2000 and JTDS). > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Larry Meadors > Sent: Monday, March 06, 2006 4:18 PM > To: [email protected] > Subject: Re: Columns missing/duplicated in result set > > I am willing to bet money it's a driver issue. > > Have you tried the call with straight jdbc and seeing what you get? > > Larry > > > On 3/6/06, Eric Williams <[EMAIL PROTECTED]> wrote: > > OK, it looks like this has become a real problem for us. We're > > encountering some situations where NULL values are returned and it > > causes the next column down the line to appear NULL as well. Can this > be > > fixed? > > > > -----Original Message----- > > From: Eric Williams [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 06, 2006 2:26 PM > > To: [email protected] > > Subject: RE: Columns missing/duplicated in result set > > > > Thanks. I forgot to mention that I've tried this with 2 different JDBC > > drivers. > > > > Actually, I think I may have just fixed this by moving some columns > onto > > the end of the result set. I've noticed a problem before where if a > > column returns null, iBATIS will cause the column after it to be null, > > too. Apparently it was having a different impact here. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 06, 2006 2:10 PM > > To: [email protected] > > Subject: Re: Columns missing/duplicated in result set > > > > Hi Eric, I had what appears to be the same problem like this using the > > wrong jdbc drivers. I was using drivers for Oracle 9+ while the db was > > Oracle 7. I thought my sqlmap or result map was to blame but it was > > jdbc. Anyway, I'd look there first. > > > > Diran > > > > Eric Williams wrote: > > > > > Hi all, > > > > > > I have a stored proc in SQL Server 2000 that only ever returns one > > > row. I've tried using the select and procedure statements, with and > > > without result maps, but I'm getting duplicate and missing columns > no > > > matter what I do. > > > > > > If I execute the stored procedure against my DB, I'll get back rows > > > like "A, B, C, D, E, F". iBATIS always returns "A, A, B, B, D". > > > > > > It's always been doubling up columns on me for some reason, but now > > > columns are starting to disappear. This only happened after I > changed > > > the data-type of a column (this is one of the columns not showing > up, > > > but other unchanged columns have disappeared, too). > > > > > > My XML looks like this: > > > > > > <parameterMap id="productGetParameterMap" class="map"> > > > > > > <parameter property="id" jdbcType="GUID" javaType="java.util.UUID" > > > mode="IN"/> > > > > > > </parameterMap> > > > > > > <procedure id="productGet" > > > > > > parameterMap="productGetParameterMap" > > > > > > resultClass="com.test.Product"> > > > > > > {call productGet ?} > > > > > > </procedure> > > > > > > I've gone as far as using an explicit result map with column index > > > values, to no avail. > > > > > > Any help would be much appreciated! > > > > > > Thanks, > > > > > > Eric > > > > > > > > > > >
