Heri,
- Original Message -
From: ""H. Steuer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 03, 2002 11:49 AM
Subject: Re: C API problems with InnoDB
> Hello Mark,
>
> thanks for your answer. In fact the mysql shel
Heri,
"H. Steuer" schrieb:
>
> Hi Stefan,
>
> > Does the second shell actually perform those changes? In this case, I
> assume
> > it's got something to do with the isolation level / consistent read in
> > InnoDB tables. "shell1" sees all its changes immediately, "shell2" (the
> > application) h
Hi Stefan,
> Does the second shell actually perform those changes? In this case, I
assume
> it's got something to do with the isolation level / consistent read in
> InnoDB tables. "shell1" sees all its changes immediately, "shell2" (the
> application) has just a snapshot of the data at the time it
Hello Mark,
thanks for your answer. In fact the mysql shell where I update the row is
using AUTOCOMMIT=1.
Even after I issue a COMMIT manually the changes are not seen by the
application.
What I dont understand is that the program doing a SELECT has to issue an
COMMIT to have all data available.
M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
H. Steuer wrote:
Hello MySQL users,
I have a weired issue using the MySQL C API and InnoDB tables.
An application polls a database every 30 seconds. When the application
starts everything seems to be fine.
During the running of the application i chan
Dear Heri,
> I tracked down the problem and saw that its only happening if I set
> autocommit=0.
> If I run a second mysql shell I can see all changes immediately. Just the
> application itself doesnt.
Does the second shell actually perform those changes? In this case, I assume
it's got something
>Can someone give me a quick *complete* example code of setting up a
>connection, performing a small query, and reading back the result?
Any of the standard MySQL clients included in the source distribution
that are written in C provide examples. Some are more brief than others.
Another source
MYSQL_RES *results1;
MYSQL_ROW row;
MYSQL DBsession;
mysql_init ( &DBsession );
mysql_real_connect ( &DBsession, PRI_HOST_IP, PRI_USER_NAME,
PRI_USER_PASSWORD, PRI_DB_NAME, PRI_PORT_NO, "", 0 );
sprintf ( sql, "SELECT filepath FROM filepath WHERE charset = '%s' AND
location = '%s'",
Hi,
Attached is my test program while exercising the C API of the MySQL.
Of course I have replaced the host name, user name, password and database
name with dummy ones.
I am using RH 6.1. The MySQL version is 3.22.
Essentially you need to do
#include
...
main()
{
MYSQL mysql;
MYS
Sorry, I hit send before I was done...
> examples, sadly, just aren't very good. And there is no example for
> mysql_use_result(). (the example code uses mysql_store_result())
The syntax and proceedure for mysql_use_result is very very similar. My
advice: get it working with *store* and then
> Can someone give me a quick *complete* example code of setting up a
> connection, performing a small query, and reading back the result?
>
In windows install, there is an examples directory which contains mytest.c.
I can't say if this exists for Linux but I bet it does in some form. Why
don't
man ldconfig
If you are running Linux, add the library directory to ld.so.conf
and run ldconfig.
Your linker does not know about the libraries.
my limp wrote:
> can any one help me. I am trying to connect to mysql database via a c
> program. The program compiles fine but I keep on getting the
12 matches
Mail list logo
