RE: Problems with prepared statements

Hi Ralf,

The first error you mentioned is due to the fact that you don't update
the columns of your table phpgw_addressbook in the order given by the CREATE 
TABLE statement that created the table. We are working on a solution for this 
problem.

A workaround for this is to use an update order according to the column order 
specified in the CREATE TABLE statement of phpgw_addressbook.

Regards,

Thomas Simenec
SAP Labs Berlin

-----Original Message-----
From: Ralf Becker [mailto:RalfBecker@xxxxxxxxxxxxxx] 
Sent: Freitag, 22. Oktober 2004 09:34
To: maxdb@xxxxxxxxxxxxxxx
Subject: Re: Problems with prepared statements

Hi all,

please let me know, if you need any other information, like the schema 
of the tables?

The error-messages are absolutly reproducable and I cant see any error 
in the queries - thought I can not test them with the query tool, as it 
does not allow prepared statements.

Thanks for any help or thoughts

Ralf

Ralf Becker schrieb:
> Hi,
> 
> The following to statements run well, before I started using prepared 
> statements. Now I get some error-messages:
> 
> 1) UPDATE phpgw_addressbook SET 
> bday=?,url=?,org_name=?,org_unit=?,n_given=?,n_family=?,n_middle=?,n_prefix=?,n_suffix=?,fn=?,email=?,email_type=?,email_home=?,email_home_type=?,title=?,tel_work=?,tel_home=?,tel_fax=?,tel_pager=?,tel_cell=?,tel_msg=?,tel_car=?,tel_video=?,tel_isdn=?,adr_one_street=?,adr_one_locality=?,adr_one_region=?,adr_one_postalcode=?,adr_one_countryname=?,adr_one_type=?,adr_two_street=?,adr_two_locality=?,adr_two_region=?,adr_two_postalcode=?,adr_two_countryname=?,adr_two_type=?,tz=?,pubkey=?,note=?,label=?,access=?,cat_id=?,tid=?,last_mod=?
>  
> WHERE id=3
> 
> Parameters: '9/67/23','','OUT 
> GmbH','','Birgit','Becker','','','','Birgit 
> Becker','','INTERNET','','INTERNET','','','0631 
> 26647','','','','','','','','','','','','','','','','','','','','0','keiner','keine','wie
>  
> Ralf','public','0','n','1097764302'
> 
> sapdb Error: S1000 ([MySQL MaxDB][LIBSQLOD SO][MaxDB] General 
> error;-9404 POS(1) System error: AK System error: VAK505 2)
> 
> 2) INSERT INTO phpgw_async 
> (async_id,async_next,async_times,async_method,async_data,async_account_id) 
> VALUES (?,?,?,?,?,?) UPDATE DUPLICATES
> 
> Parameters: 
> '##last-check-run##','0','a:0:{}','none','a:3:{s:6:"run_by";s:8:"fallback";s:5:"start";i:1097771503;s:3:"end";i:0;}',''
>  
> 
> 
> sapdb Error: 23000 ([MySQL MaxDB][LIBSQLOD SO] Integrity constraint 
> violation)
> 
> I need to use prepared statements, as some of the inserts into long 
> columns are too big, to run as regular statements. I also hoped for some 
> performance improvements.
> 
> Any help greatly appreciated :-)
> 
> Ralf
> 

-- 
eGroupWare Training ==> http://www.outdoor-training.de/egroupware

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=thomas.simenec@xxxxxxx

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx