[Zope-DB] DCOracle2 1.3beta executemany() dco2.DatabaseError

[Lee, Bryson]

I've built from the latest CVS tarball (DCOracle2 1.103, dco2 1.137) and added the setPrefetch(0) call, but I still get the same exception.

-Bryson 

-----Original Message-----
From: Matthew T. Kromer [mailto:matt at bane.mi.org] 
Sent: Friday, February 11, 2005 10:17 AM
To: Lee, Bryson
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] DCOracle2 1.3beta executemany() dco2.DatabaseError

Here's something to try - -turn off cursor prefetching with
cursor.setPrefetch(0)

Also, the latest cvs build of dco2.so is 1.137 or so, so you're running about 8 patches behind at your current code base.

On Feb 10, 2005, at 6:42 PM, Lee, Bryson wrote:

> With the following Python / DCOracle2 combination:
>
> Python sys.version =
> 2.3.3 (#1, Apr  7 2004, 09:31:28)
> [GCC 2.95.3 20010315 (release)]
>
> DCOracle2.version =
> 1.3 beta -- DCOracle2 1.99 (dco2: 1.129 -DORACLE8i -DUSEOBJECT -Dlinux
> -DNATIVENUMERIC=1 -D_REENTRANT )
>
> I get an exception if I call the executemany() method on a cursor if 
> the input record list has more than 12 items:
>
> dco2.DatabaseError: (1400, 'ORA-01400: cannot insert NULL into
> ("GLAST_ISOC"."V2HKVALCHFIELDS"."SOURCE")')
>
> If the list has 12 or fewer items, the call works perfectly well.
>
> Using the same code to process the same data-set under Python 2.2.2 
> and DCOracle2 1.2 / 1.95 / dco2 1.120, the executemany() call works 
> correctly regardless of the length of the input record list.
>
> Has anybody else seen this sort of behavior?
>
> I can supply a dco2.tracedump of the failed call, if that helps
>
> Regards,
>
> Bryson Lee
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db