[python-sybase] newbie problem
Laurent VASSEUR
vasseur at titus.u-strasbg.fr
Tue, 14 Jan 2003 16:05:08 +0100
--=====================_-650450538==_.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
Ok, it solved the problem.
Thanks
Laurent
A 16:49 14/01/2003 +0200, vous avez =E9crit :
>Hi,
>
>You need to close the cursor before you can commit your work:
>
>db.begin()
>c=3Ddb.cursor()
>c.callproc('sp_help')
>c.close()
>db.commit()
>
>works for me.
>
>Have fun,
> Shai.
>
>-----Original Message-----
>From: Laurent VASSEUR [mailto:vasseur@titus.u-strasbg.fr]
>Sent: Tuesday, January 14, 2003 10:44
>To: python-sybase@object-craft.com.au
>Subject: [python-sybase] newbie problem
>
>
>hi,
>
>I've just installed the Sybase module on solaris 2.7 / python 2.2. I tried
>the following program to test it, but it fails...
>
>#!/bin/env python
>import Sybase
>Sybase._ctx.debug =3D 1
>import sys
>
>db=3DSybase.connect('DB','USR', 'PWD', database=3D'test')
>c=3Ddb.cursor()
>
>db.begin()
>c.callproc('sp_help')
>db.commit()
>
>c.close ()
>db.close ()
>sys.exit()
>
>I get the following output :
>
>ct_con_alloc(ctx0, &conn) -> CS_SUCCEED, conn0 ct_con_props(conn0, CS_SET,=
=20
>CS_USERNAME, "USR", CS_NULLTERM, NULL) ->
>CS_SUCCEED
>ct_con_props(conn0, CS_SET, CS_PASSWORD, "PWD", CS_NULLTERM, NULL) ->
>CS_SUCCEED
>servermsg_cb
>ct_connect(conn0, "DB", CS_NULLTERM) -> CS_SUCCEED ct_options(conn0,=20
>CS_SET, CS_OPT_CHAINXACTS, 1, CS_UNUSED, NULL) -> CS_SUCCEED=20
>ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd0 ct_command(cmd0,=20
>CS_LANG_CMD, "use test", CS_NULLTERM, CS_UNUSED) -> CS_SUCCEED
>ct_send(cmd0) -> CS_SUCCEED
>servermsg_cb
>ct_results(cmd0, &result) -> CS_SUCCEED, CS_CMD_SUCCEED ct_results(cmd0,=20
>&result) -> CS_SUCCEED, CS_CMD_DONE ct_results(cmd0, &result) ->=20
>CS_END_RESULTS, CS_FALSE
>ct_cmd_drop(cmd0) -> CS_SUCCEED
>ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd1 ct_cmd_alloc(conn0, &cmd) ->=
=20
>CS_SUCCEED, cmd2 ct_command(cmd2, CS_LANG_CMD, "begin transaction",=20
>CS_NULLTERM, CS_UNUSED)
>-> CS_SUCCEED
>ct_send(cmd2) -> CS_SUCCEED
>ct_results(cmd2, &result) -> CS_SUCCEED, CS_CMD_SUCCEED ct_results(cmd2,=20
>&result) -> CS_SUCCEED, CS_CMD_DONE ct_results(cmd2, &result) ->=20
>CS_END_RESULTS, CS_FALSE
>ct_cmd_drop(cmd2) -> CS_SUCCEED
>ct_command(cmd1, CS_RPC_CMD, "sp_help", CS_NULLTERM, CS_UNUSED) ->=
CS_SUCCEED
>ct_send(cmd1) -> CS_SUCCEED
>ct_results(cmd1, &result) -> CS_SUCCEED, CS_ROW_RESULT ct_res_info(cmd1,=20
>CS_NUMDATA, &value, CS_UNUSED, NULL) -> CS_SUCCEED, 3 ct_describe(cmd1, 1,=
=20
>&fmt) -> CS_SUCCEED, datafmt0=3D[name:"Name"
>type:CS_CHAR_TYPE status:CS_UPDATABLE format:CS_FMT_UNUSED count:0
>maxlength:30]
>ct_bind(cmd1, 1, &datafmt0->fmt=3D[name:"Name" type:CS_CHAR_TYPE
>status:CS_UPDATABLE format:CS_FMT_UNUSED count:1 maxlength:30],
>databuf0->buff, databuf0->copied, databuf0->indicator) -> CS_SUCCEED,
>databuf0->databuf0
>ct_describe(cmd1, 2, &fmt) -> CS_SUCCEED, datafmt1=3D[name:"Owner"
>type:CS_CHAR_TYPE status:48 format:CS_FMT_UNUSED count:0 maxlength:30]=20
>ct_bind(cmd1, 2, &datafmt1->fmt=3D[name:"Owner" type:CS_CHAR_TYPE status:48
>format:CS_FMT_UNUSED count:1 maxlength:30], databuf1->buff,
>databuf1->copied, databuf1->indicator) -> CS_SUCCEED, databuf1
>ct_describe(cmd1, 3, &fmt) -> CS_SUCCEED, datafmt2=3D[name:"Object_type"
>type:CS_CHAR_TYPE status:48 format:CS_FMT_UNUSED count:0 maxlength:22]=20
>ct_bind(cmd1, 3, &datafmt2->fmt=3D[name:"Object_type" type:CS_CHAR_TYPE
>status:48 format:CS_FMT_UNUSED count:1 maxlength:22], databuf2->buff,
>databuf2->copied, databuf2->indicator) -> CS_SUCCEED, databuf2
>ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd3
>ct_command(cmd3, CS_LANG_CMD, "commit transaction", CS_NULLTERM, CS_UNUSED)
>-> CS_SUCCEED
>clientmsg_cb
>ct_send(cmd3) -> CS_FAIL
>Traceback (most recent call last):
> File "t.py", line 11, in ?
> db.commit()
> File "/usr/local/lib/python2.2/site-packages/Sybase.py", line 696, in=
=20
> commit
> self.execute('commit transaction')
> File "/usr/local/lib/python2.2/site-packages/Sybase.py", line 724, in
>execute
> status =3D cmd.ct_send()
> File "/usr/local/lib/python2.2/site-packages/Sybase.py", line 141, in
>_clientmsg_cb
> raise DatabaseError(_fmt_client(msg))
>Sybase.DatabaseError: Layer: 1, Origin: 1
>ct_send(): couche api utilisateur: erreur externe: Impossible d'appeler
>cette routine car une autre structure de commande est en attente de=20
>r=E9sultats. clientmsg_cb
>ct_cmd_drop(cmd3) -> CS_FAIL
>ct_cancel(conn0, NULL, CS_CANCEL_ALL) -> CS_SUCCEED
>ct_cmd_drop(cmd1) -> CS_SUCCEED
>ct_con_props(conn0, CS_GET, CS_CON_STATUS, &value, CS_UNUSED, NULL) ->
>CS_SUCCEED, CS_CONSTAT_CONNECTED
>ct_close(conn0, CS_FORCE_CLOSE) -> CS_SUCCEED
>ct_con_drop(conn0) -> CS_SUCCEED
>
>
>The error in english is : "user api layer: external error: This routine
>cannot be called because another command structure has results pending." I=
=20
>have the same pb if I perform an insert + select in the same transaction.
>Any idea on what is going wrong ?
>
>Note: in order to compile the module, I had to add the library "itl" to
>EXTRA_LIBS. My installation was done whith :
>"python setup.py build_ext -U WANT_BULKCOPY"
>
>
>Thanks,
>Laurent
>
>_______________________________________________
>Python-sybase mailing list
>Python-sybase@object-craft.com.au=20
>https://object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase
Laurent VASSEUR
Ing=E9nieur d=E9veloppement IGBMC
vasseur@igbmc.u-strasbg.fr
--=====================_-650450538==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
Ok, it solved the problem. <br>
Thanks<br>
<br>
Laurent<br>
<br>
A 16:49 14/01/2003 +0200, vous avez =E9crit :<br>
<blockquote type=3Dcite class=3Dcite cite>Hi,<br>
<br>
You need to close the cursor before you can commit your work:<br>
<br>
db.begin()<br>
c=3Ddb.cursor()<br>
c.callproc('sp_help')<br>
c.close()<br>
db.commit()<br>
<br>
works for me.<br>
<br>
Have fun,<br>
<x-tab> </x-tab>Shai.<br>
<br>
-----Original Message-----<br>
From: Laurent VASSEUR
[<a href=3D"mailto:vasseur@titus.u-strasbg.fr" eudora=3D"autourl">mailto:vas=
seur@titus.u-strasbg.fr</a>]
<br>
Sent: Tuesday, January 14, 2003 10:44<br>
To: python-sybase@object-craft.com.au<br>
Subject: [python-sybase] newbie problem<br>
<br>
<br>
hi,<br>
<br>
I've just installed the Sybase module on solaris 2.7 / python 2.2. I
tried <br>
the following program to test it, but it fails...<br>
<br>
#!/bin/env python<br>
import Sybase<br>
Sybase._ctx.debug =3D 1<br>
import sys<br>
<br>
db=3DSybase.connect('DB','USR', 'PWD', database=3D'test')<br>
c=3Ddb.cursor()<br>
<br>
db.begin()<br>
c.callproc('sp_help')<br>
db.commit()<br>
<br>
c.close ()<br>
db.close ()<br>
sys.exit()<br>
<br>
I get the following output :<br>
<br>
ct_con_alloc(ctx0, &conn) -> CS_SUCCEED, conn0 ct_con_props(conn0,
CS_SET, CS_USERNAME, "USR", CS_NULLTERM, NULL) -> <br>
CS_SUCCEED<br>
ct_con_props(conn0, CS_SET, CS_PASSWORD, "PWD", CS_NULLTERM,
NULL) -> <br>
CS_SUCCEED<br>
servermsg_cb<br>
ct_connect(conn0, "DB", CS_NULLTERM) -> CS_SUCCEED
ct_options(conn0, CS_SET, CS_OPT_CHAINXACTS, 1, CS_UNUSED, NULL) ->
CS_SUCCEED ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd0
ct_command(cmd0, CS_LANG_CMD, "use test", CS_NULLTERM,
CS_UNUSED) -> CS_SUCCEED<br>
ct_send(cmd0) -> CS_SUCCEED<br>
servermsg_cb<br>
ct_results(cmd0, &result) -> CS_SUCCEED, CS_CMD_SUCCEED
ct_results(cmd0, &result) -> CS_SUCCEED, CS_CMD_DONE
ct_results(cmd0, &result) -> CS_END_RESULTS, CS_FALSE<br>
ct_cmd_drop(cmd0) -> CS_SUCCEED<br>
ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd1 ct_cmd_alloc(conn0,
&cmd) -> CS_SUCCEED, cmd2 ct_command(cmd2, CS_LANG_CMD,
"begin transaction", CS_NULLTERM, CS_UNUSED) <br>
-> CS_SUCCEED<br>
ct_send(cmd2) -> CS_SUCCEED<br>
ct_results(cmd2, &result) -> CS_SUCCEED, CS_CMD_SUCCEED
ct_results(cmd2, &result) -> CS_SUCCEED, CS_CMD_DONE
ct_results(cmd2, &result) -> CS_END_RESULTS, CS_FALSE<br>
ct_cmd_drop(cmd2) -> CS_SUCCEED<br>
ct_command(cmd1, CS_RPC_CMD, "sp_help", CS_NULLTERM, CS_UNUSED)
-> CS_SUCCEED<br>
ct_send(cmd1) -> CS_SUCCEED<br>
ct_results(cmd1, &result) -> CS_SUCCEED, CS_ROW_RESULT
ct_res_info(cmd1, CS_NUMDATA, &value, CS_UNUSED, NULL) ->
CS_SUCCEED, 3 ct_describe(cmd1, 1, &fmt) -> CS_SUCCEED,
datafmt0=3D[name:"Name" <br>
type:CS_CHAR_TYPE status:CS_UPDATABLE format:CS_FMT_UNUSED count:0 <br>
maxlength:30]<br>
ct_bind(cmd1, 1, &datafmt0->fmt=3D[name:"Name"
type:CS_CHAR_TYPE <br>
status:CS_UPDATABLE format:CS_FMT_UNUSED count:1 maxlength:30], <br>
databuf0->buff, databuf0->copied, databuf0->indicator) ->
CS_SUCCEED, <br>
databuf0->databuf0<br>
ct_describe(cmd1, 2, &fmt) -> CS_SUCCEED,
datafmt1=3D[name:"Owner" <br>
type:CS_CHAR_TYPE status:48 format:CS_FMT_UNUSED count:0 maxlength:30]
ct_bind(cmd1, 2, &datafmt1->fmt=3D[name:"Owner"
type:CS_CHAR_TYPE status:48 <br>
format:CS_FMT_UNUSED count:1 maxlength:30], databuf1->buff, <br>
databuf1->copied, databuf1->indicator) -> CS_SUCCEED,
databuf1<br>
ct_describe(cmd1, 3, &fmt) -> CS_SUCCEED,
datafmt2=3D[name:"Object_type" <br>
type:CS_CHAR_TYPE status:48 format:CS_FMT_UNUSED count:0 maxlength:22]
ct_bind(cmd1, 3, &datafmt2->fmt=3D[name:"Object_type"
type:CS_CHAR_TYPE <br>
status:48 format:CS_FMT_UNUSED count:1 maxlength:22], databuf2->buff,
<br>
databuf2->copied, databuf2->indicator) -> CS_SUCCEED,
databuf2<br>
ct_cmd_alloc(conn0, &cmd) -> CS_SUCCEED, cmd3<br>
ct_command(cmd3, CS_LANG_CMD, "commit transaction",
CS_NULLTERM, CS_UNUSED) <br>
-> CS_SUCCEED<br>
clientmsg_cb<br>
ct_send(cmd3) -> CS_FAIL<br>
Traceback (most recent call last):<br>
File "t.py", line 11, in ?<br>
db.commit()<br>
File
"/usr/local/lib/python2.2/site-packages/Sybase.py", line 696,
in commit<br>
self.execute('commit transaction')<br>
File
"/usr/local/lib/python2.2/site-packages/Sybase.py", line 724,
in <br>
execute<br>
status =3D cmd.ct_send()<br>
File
"/usr/local/lib/python2.2/site-packages/Sybase.py", line 141,
in <br>
_clientmsg_cb<br>
raise DatabaseError(_fmt_client(msg))<br>
Sybase.DatabaseError: Layer: 1, Origin: 1<br>
ct_send(): couche api utilisateur: erreur externe: Impossible d'appeler
<br>
cette routine car une autre structure de commande est en attente de
r=E9sultats. clientmsg_cb<br>
ct_cmd_drop(cmd3) -> CS_FAIL<br>
ct_cancel(conn0, NULL, CS_CANCEL_ALL) -> CS_SUCCEED<br>
ct_cmd_drop(cmd1) -> CS_SUCCEED<br>
ct_con_props(conn0, CS_GET, CS_CON_STATUS, &value, CS_UNUSED, NULL)
-> <br>
CS_SUCCEED, CS_CONSTAT_CONNECTED<br>
ct_close(conn0, CS_FORCE_CLOSE) -> CS_SUCCEED<br>
ct_con_drop(conn0) -> CS_SUCCEED<br>
<br>
<br>
The error in english is : "user api layer: external error: This
routine <br>
cannot be called because another command structure has results
pending." I have the same pb if I perform an insert + select in the
same transaction. <br>
Any idea on what is going wrong ?<br>
<br>
Note: in order to compile the module, I had to add the library
"itl" to <br>
EXTRA_LIBS. My installation was done whith :<br>
"python setup.py build_ext -U WANT_BULKCOPY"<br>
<br>
<br>
Thanks,<br>
Laurent<br>
<br>
_______________________________________________<br>
Python-sybase mailing list<br>
Python-sybase@object-craft.com.au
<a href=3D"https://object-craft.com.au/cgi-bin/mailman/listinfo/python-sybas=
e"=
eudora=3D"autourl">https://object-craft.com.au/cgi-bin/mailman/listinfo/pyt=
hon-sybase</a></blockquote>
<x-sigsep><p></x-sigsep>
<font face=3D"Book Antiqua, Bookman"><br>
<x-tab> </x-tab>Laurent
VASSEUR <br>
</font><font face=3D"Palatino Linotype" color=3D"#008080">Ing=E9nieur
d=E9veloppement IGBMC <br>
vasseur@igbmc.u-strasbg.fr</font> <br>
<br>
</html>
--=====================_-650450538==_.ALT--