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

[Matthew T.Kromer]

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