discuss

discuss@lists.mariadb.org

May 2023

11 participants
11 discussions

[Maria-discuss] howto c-connect bindings
by juerg oehler 06 May '23

06 May '23

hi I'm working with|mariadb|and|c-connect|prepared statements and run into crashes executing them once a while. i so addressed my problem to stakeoverflow <https://stackoverflow.com/questions/76170354/mariadb-howto-c-connect-bindin…> hoping to get more information for binding programs data structure to db interface. i did get an answer. but this answer does not go inline with your documentation <https://mariadb.com/kb/en/mariadb-connectorc-data-structures/#mysql_bind>. i so do have the option to follow your documentation or use the answer and run into crashes in either way. you might ask why i'm not just going with your documentation? your documentation is far to thin to get a reliable idea how bind structure is used and i do get proofed this by crashes. second i played with <my_bool * is_nulll Pointer which indicates if column is NULL (not used for parameters)> for parameters and behavior was not as documented. this is my motivation to bring my problem to this mailing list hopping someone can point me to a documentation i can rely on. i found a short and useful documentation in mysql with permissible in and out types <https://dev.mysql.com/doc/c-api/8.0/en/c-api-prepared-statement-type-codes.…> and statement data structures <https://dev.mysql.com/doc/c-api/8.0/en/c-api-prepared-statement-data-struct…>. can i use these informations to build 2 test applications one focusing on parameter (attachment) one focusing on result? currently i implemented MariaPrepUpd.c using mariadb documentation. i felt like flying blind and ended up in crashes - once a while. do you think i could use mysql documentation for improving bindings? or do you have a better option? (i studied your bulk example <https://mariadb.com/kb/en/bulk-insert-row-wise-binding/>. i even was using this example as base for first try an hit the wall by using STMT_INDICATOR_NTS. i then learned my problem is not just the example using STMT_ATTR_ARRAY_SIZE = 1.) my goal is to have a version of MariaPrepUpd.c i can use for any application for iteration 1 to n. thank you for short answer. have a great day. juerg(=george) oehler

1 0