[ZCM] [ZC] 1099/ 2 Resolve "DCOracle2 fetch problem"

[Collector: Zope Bugs, Features, and Patches ...]

Issue #1099 Update (Resolve) "DCOracle2 fetch problem"
 Status Resolved, Database/bug critical
To followup, visit:
  http://zope.org/Collectors/Zope/1099

==============================================================
= Resolve - Entry #2 by zopematt on Oct 28, 2003 10:10 am

 Status: Pending => Resolved

This NULL result repsonse is most likely fixed in the latest CVS versions; check out the latest CVS copy and build from source, the problem should go away.
________________________________________
= Request - Entry #1 by Anonymous User on Oct 28, 2003 3:08 am

hi,

has anyone incurred in such a condition?

I'm using python 2.2, DCOracle2 1.2 on a RedHat 7.3.
I'm trying to fetch some rows from Oracle (rel 8.1.6 on a HP/UX)
and there are differences in the way the cursor fetches the
recors (see dump below).
If I run a SELECT without WHERE clause it fetches a None field
in the seventh field (MAT1).
If, instead, I run the same query filtering the D field with a
WHERE clause I am able to fetch the VERY SAME record in the right manner
i.e. with the seventh field (MAT1) correctly containing the value 10.

any suggestion?

regards Marco Tasselli

Here follows an interactive session:

Python 2.2 (#1, Apr 12 2002, 15:29:57) [GCC 2.96 20000731
(Red Hat Linux 7.2 2.96-109)]
on linux2 Type "help", "copyright", "credits" or
"license" for more information.

>>> import DCOracle2
>>> db = DCOracle2.connect(pippo/pluto at tst)
>>> cur = db.cursor()
>>> cur.execute(SELECT COD, D, MR, LN, CS, GCL, MAT1, MAT2 FROM UFFA)
1
>>> rs = cur.fetchall()
>>> for riga in rs:
	... if riga[1] == '30910745':
		... print riga
		...
[309107450000000L, 30910745, 3, 5, 09, 0, None, '330']
>>>
>>>
>>> cur.execute("SELECT COD, D, MR, LN, CS, GCL, MAT1, MAT2 FROM UFFA WHERE D = '30910745'")
1
>>> rs = cur.fetchall()
>>> print rs
[[309107450000000L, 30910745, 3, 5, 09, 0, 10, '330']]
>>>
==============================================================