mysql-cocoa-users Mailing List for MySQL Objective C API for Cocoa (Page 8)
Brought to you by:
sergecohen
Menu
▾
▴
mysql-cocoa-users — The mysql-cocoa users mailing list
You can subscribe to this list here.
| 2002 |
Jan
(2) |
Feb
|
Mar
(14) |
Apr
(5) |
May
(23) |
Jun
(8) |
Jul
(13) |
Aug
(5) |
Sep
|
Oct
(1) |
Nov
(11) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(9) |
Feb
(6) |
Mar
(13) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(5) |
Aug
(11) |
Sep
(18) |
Oct
(1) |
Nov
(15) |
Dec
(2) |
| 2004 |
Jan
(3) |
Feb
(3) |
Mar
(8) |
Apr
(1) |
May
(2) |
Jun
(3) |
Jul
(15) |
Aug
(36) |
Sep
(5) |
Oct
|
Nov
(6) |
Dec
(2) |
| 2005 |
Jan
(1) |
Feb
(11) |
Mar
(1) |
Apr
(6) |
May
|
Jun
(7) |
Jul
(3) |
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2006 |
Jan
(9) |
Feb
(5) |
Mar
(2) |
Apr
(1) |
May
(9) |
Jun
(2) |
Jul
(1) |
Aug
(4) |
Sep
|
Oct
(1) |
Nov
|
Dec
(2) |
| 2007 |
Jan
(23) |
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Denise K. <dke...@ma...> - 2004-01-16 15:13:12
|
We are observing that some text fields are having their content replaced with the string "(null)" and wondered if this has been observed by anyone else using mysql cocoa ? BTW I have not been able to access the list archive to search on this topic. Denise Harrington Ketcham Technology Integration Group Center for Instructional Technologies Division of Instructional Innovation and Assessment http://www.utexas.edu/academic/diia/ 475-6089 University of Texas at Austin |
|
From: Camille Goureau-S. <ca...@lu...> - 2004-01-09 17:26:20
|
You should place the file : libmysqlclient.dylib in /usr/local/lib/mysql/ The file should have been set elsewhere by the installator of mysql. try under terminal : find . -name 'libmysqlclient.dylib' -print Hope this helps. Camille Le vendredi, 9 jan 2004, =E0 15:27 Europe/Paris, Roberto a =E9crit : > I've embedden SMySQL.framework (SMySQL_bundled.framework) into my =20 > application, and copy SMySQL.framework (SMySQL.framework) into =20 > Library/Frameworks/ > > When I Compile the App., it works fine, but then, when I starts it =20 > returns: > > dyld: =20 > /Users/Metrika/Desktop/Projects/mysqlDemo/build/mysqlDemo.app/=20 > Contents/MacOS/mysqlDemo can't open library: =20 > /usr/local/lib/mysql/libmysqlclient.11.dylib (No such file or =20 > directory, errno =3D 2) > > mysqlDemo has exited due to signal 5 (SIGTRA etc... > > I've got Mysql installed. > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Perforce Software. > Perforce is the Fast Software Configuration Management System offering > advanced branching capabilities and atomic changes on 50+ platforms. > Free Eval! http://www.perforce.com/perforce/loadprog.html > _______________________________________________ > Mysql-cocoa-users mailing list > Mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users > |
|
From: Roberto <ro...@me...> - 2004-01-09 14:27:13
|
I've embedden SMySQL.framework (SMySQL_bundled.framework) into my application, and copy SMySQL.framework (SMySQL.framework) into Library/Frameworks/ When I Compile the App., it works fine, but then, when I starts it returns: dyld: /Users/Metrika/Desktop/Projects/mysqlDemo/build/mysqlDemo.app/Contents/ MacOS/mysqlDemo can't open library: /usr/local/lib/mysql/libmysqlclient.11.dylib (No such file or directory, errno = 2) mysqlDemo has exited due to signal 5 (SIGTRA etc... I've got Mysql installed. |
|
From: Marc de B. <ma...@ka...> - 2003-12-29 13:29:57
|
Hi, i'm trying to use the SMySQL_bundled on Mac OS X 10.3.2 with Xcode 1.1 and the source code from CocoaMySQL to test the stuff. When using build i get 4 errors. => so i tried to make my own app build ok, until i add the SMySQL_bundled.framework then i get the following error. --------- dyld: /Volumes/Gothic_Drive/Users/marcdebl/Documents/Book-Keeper/build/Book- Keeper.app/Contents/MacOS/Book-Keeper can't open library: @executable_path/../Frameworks/SMySQL_bundled.framework/Versions/A/ SMySQL_bundled (No such file or directory, errno = 2) Book-Keeper has exited due to signal 5 (SIGTRAP). --------- have to say i'm pretty new to Xcode and that stuff Marc |
|
From: yo c. <kee...@ho...> - 2003-12-03 20:55:42
|
Solved : I was just no enough patient ! After one minut of delay, I can get the MySQL error and work with its return value. Thank you again for your work ! _________________________________________________________________ Dialoguez en direct et gratuitement avec vos amis sur http://g.msn.fr/FR1001/866 MSN Messenger ! |
|
From: Serge C. <ser...@us...> - 2003-11-30 17:02:19
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Rob, It's me again,=0D =0D After the first test in XCode, I realised and corrected the error =0D you're having.=0D The correction is to have the proper English.lproj folder which is =0D missing from the distribution....=0D =0D A new distribution is coming very soon (before tomorrow)... which =0D should solve this problem (and comes with a small bonus, a embrio of =0D API for GUI applicatio using SMySQL).=0D =0D Serge.=0D =0D PS: To Giavanni, this is my only experience with XCode so far, so more =0D= will come later.=0D =0D =0D =0D Le 13 nov. 03, =E0 06:44, Rod Kirkpatrick a =E9crit :=0D =0D > Serge=0D >=0D > Hope you can help please=0D >=0D > Background=0D > I cant program - Im trying to learn Cocoa. I can only learn something =0D= > if there is a useful end to the lesson. All I want to be able to do is = =0D > some simple interfaces to a MySQL DB.=0D > I have a copy of SMySQL_src_2.2.1 and have tried to compile the =0D > bundled version of the framework. This is selected as the target.=0D >=0D > The problem is that when I compile I get an error=0D > Missing file or directory: English.lproj/InfoPlist.strings=0D >=0D > Im using OSX 10.3.1 and XCode 1.0=0D >=0D > Rod=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (Darwin) iD8DBQE/yiKO5EPeG5y7WPsRAi/sAKD6lIDZe5DBsfBZMmpIrO+xrb+AnQCg05DQ 9tOvLBa7XCZojZ4UwvIHUHk=3D =3Do/TU -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-11-30 16:58:52
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Jonathan,=0D =0D As other mails send today, sorry for answering this late, I guess you =0D= gathered the info you were looking for somewhere else already, in the =0D= opposite case (and also to help future users facing the same pb, and =0D= looking in archives)... The solution is to run ranlib on the =0D libmysqlclient.a that is distributed with the code:=0D =0D in the terminal, cd to the directory where libmysqlclient.a stands and =0D= issue:=0D =0D ranlib libmysqlclient.a=0D =0D That should do.=0D =0D Serge.=0D =0D =0D Le 13 nov. 03, =C3=A0 03:59, Jonathan McGuire a =C3=A9crit :=0D =0D > Hi,=0D >=0D > So I know how to program in Cocoa and would love to try and help you =0D= > out. Unfortunently my understanding of building the this framework so = =0D > I can use it is lacking. Guess I need to learn more about how building = =0D > and stuff work. Anyways when I try to build the 2.2.1 src files from =0D= > the dmg I get a error about the InfoPlist.strings file being missing. = =0D > After unchecking that file form the build list i get these warnings =0D= > and 1 error.=0D >=0D > Building target =E2=80=9CSMySQL_static=E2=80=9D with build style = =E2=80=9CDevelopment=E2=80=9D =0D > (optimization:level =E2=80=980=E2=80=99, debug-symbols:on) =E2=80=94 = (1 error, 5 warnings)=0D > /usr/bin/gcc-3.3 -c =0D > -F/Users/jonathan/Desktop/SMySQL_src_2.2.1/build =0D > -I/Users/jonathan/Desktop/SMySQL_src_2.2.1/build/include -Imysql_bins = =0D > -arch ppc -fno-common -fpascal-strings -O0 -Wmost =0D > -Wno-four-char-constants -Wno-unknown-pragmas -pipe =0D > "-fmessage-length=3D0" -g -pg =0D > -Wp,-header-mapfile,/Users/jonathan/Desktop/SMySQL_src_2.2.1/build/ =0D= > SMySQL.build/SMySQL_static.build/SMySQL_static.hmap "-faltivec" =0D= > "-fno-coalesce" MCPConnection.m -o =0D > /Users/jonathan/Desktop/SMySQL_src_2.2.1/build/SMySQL.build/ =0D > SMySQL_static.build/Objects-normal/ppc/MCPConnection.o=0D > MCPConnection.m:164:2: warning: #warning What happens when inited =0D > twice the NSObject?=0D > MCPConnection.m:197:2: warning: #warning What happens when inited =0D > twice the NSObject?=0D > MCPConnection.m:259:2: warning: #warning What to do if one of the =0D > string is a nil pointer?=0D > MCPConnection.m:305:2: warning: #warning Should throw an exception, =0D= > illegal string pointer (nil)=0D > MCPConnection.m:164:2: warning: #warning What happens = when inited =0D > twice the NSObject?=0D > MCPConnection.m:197:2: warning: #warning What happens = when inited =0D > twice the NSObject?=0D > MCPConnection.m:259:2: warning: #warning What to do if = one of the =0D > string is a nil pointer?=0D > MCPConnection.m:305:2: warning: #warning Should throw an = exception, =0D > illegal string pointer (nil)=0D > /usr/bin/gcc-3.3 -o =0D > /Users/jonathan/Desktop/SMySQL_src_2.2.1/build/ =0D > SMySQL_static.framework/Versions/A/SMySQL_static =0D > "-L/Users/jonathan/Desktop/SMySQL_src_2.2.1/build" "-Lmysql_bins" =0D= > "-F/Users/jonathan/Desktop/SMySQL_src_2.2.1/build" -filelist =0D > /Users/jonathan/Desktop/SMySQL_src_2.2.1/build/SMySQL.build/ =0D > SMySQL_static.build/Objects-normal/LinkFileList "-lmysqlclient" =0D > "-framework" "Cocoa" "-lz.1.1.3" "-arch" "ppc" "-prebind" =0D > "-Wl,-single_module" "-dynamiclib" "-compatibility_version" "2.0.0" =0D= > "-current_version" "2.2.1" "-pg" "-seg1addr" "0x08800000" =0D > -install_name "`echo =0D > "~/Library/Frameworks/SMySQL_static.framework/Versions/A/ =0D > SMySQL_static" | /usr/bin/sed 's!//*!/!g'`"=0D > ld: table of contents for archive: mysql_bins/libmysqlclient.a is out = =0D > of date; rerun ranlib(1) (can't load from it)=0D > ld: warning prebinding disabled because dependent library: =0D > /System/Library/Frameworks/AppKit.framework/Versions/C/AppKit can't be = =0D > searched=0D > /usr/bin/libtool: internal link edit command failed=0D > ld: table of contents for archive: = mysql_bins/libmysqlclient.a is =0D > out of date; rerun ranlib(1) (can't load from it)=0D > ld: warning prebinding disabled because dependent = library: =0D > /System/Library/Frameworks/AppKit.framework/Versions/C/AppKit can't be = =0D > searched=0D >=0D > I'd really like to try out your frame work but I can't figure out how = =0D > to get a project setup using it :( guess I need to reread some of my =0D= > Cocoa books. I'm using panther and Xcode and I have mysql installed on = =0D > my system (I used the mysql package offered by the MySQL site).=0D >=0D > Jonathan=0D >=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (Darwin) iD8DBQE/yiG+5EPeG5y7WPsRAhwLAKDTWMOdG+HPhuPmgJH+sCHHaDDGQwCg+f46 FwzsodASZ5dPUo20J996Kds=3D =3DdDI2 -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-11-30 16:48:57
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Jason;=0D =0D Sorry for answering that late...=0D I would definitely be interested in getting your makefile and changes, =0D= so that I can incorporate those to the SMySQL framework.=0D Indeed I was also wondering if you would be interested to join the dev. =0D= group for SMySQL (not much work), so that you can help me make sure =0D that future releases are also working on GNUStep.=0D =0D Tell me what you think.=0D =0D Serge.=0D =0D PS: I'm a bit in a 'professional' rush at the moment, so please forgive =0D= me if I'm not responding in short times.=0D =0D =0D Le 27 nov. 03, =E0 23:31, Jason Clouse a =E9crit :=0D =0D > Serge,=0D >=0D > I have successfully gotten SMySQL to build on GNUstep with Red Hat =0D > Linux 9.0. I can give you some makefiles and minor changes to roll =0D= > into your distribution so it will build on GNUstep out-of-the-box. =0D= > Would you be willing to include them?=0D >=0D > Yours,=0D > Jason Clouse=0D >=0D >=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (Darwin) iD8DBQE/yh9r5EPeG5y7WPsRAqtKAKCN1VO8a75lTjZXgDRw2vpGxEK4FgCg2G9F pAvZgUkiDizommEldJSxEww=3D =3D0qs5 -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-11-30 16:46:00
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Rod;=0D =0D I've just put my hands on 10.3, so before I was completely unable to =0D help on that respect...=0D I'm going to try building the framework in the close future... and I'll =0D= try to keep you posted.=0D =0D I'll come back to you soon, if not, don't hesitate to ask me again.=0D =0D Serge.=0D =0D =0D =0D Le 13 nov. 03, =E0 06:44, Rod Kirkpatrick a =E9crit :=0D =0D > Serge=0D >=0D > Hope you can help please=0D >=0D > Background=0D > I cant program - Im trying to learn Cocoa. I can only learn something =0D= > if there is a useful end to the lesson. All I want to be able to do is = =0D > some simple interfaces to a MySQL DB.=0D > I have a copy of SMySQL_src_2.2.1 and have tried to compile the =0D > bundled version of the framework. This is selected as the target.=0D >=0D > The problem is that when I compile I get an error=0D > Missing file or directory: English.lproj/InfoPlist.strings=0D >=0D > Im using OSX 10.3.1 and XCode 1.0=0D >=0D > Rod=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (Darwin) iD8DBQE/yh6s5EPeG5y7WPsRAm1uAJ4/WcbkIKsQJwHZkh4uIh1yU9o8OwCgn4Kt CfIJb7bgqccQW8MIsArg0es=3D =3DQzNn -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-11-30 16:43:38
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Ulf;=0D =0D I'm planning to stick to whatever is in beta from MySQL... In another =0D= way, as soon as 4.1 will be beta, I'll take care of making sure that =0D the framework is compatible with it.=0D In the mean time the problem for me is that I have very few time to =0D devote to SMySQL untill new year, I hope to have a bit more time in =0D January, so maybe I'll start working on that in January, even if 4.1 is =0D= still alpha then.=0D Support for utf-8 will need a few modification to the framework, but =0D indeed not too much as utf-8 is one of the natively supported string =0D format for Cocoa (so basically I'll just have to make sure that the =0D framework understand that incoming and outgoing string should be UTF-8 =0D= encoded).=0D =0D Hope this answer is helpfull.=0D =0D Serge.=0D PS: I'm really sorry not to have time to take care of that now... If it =0D= is an absolute requirement for you (you can not wait Jan), than I can =0D= propose to help you do it (telling you where to look in the code)... or =0D= at least try to see if I can do in an hour or so.=0D =0D =0D Le 25 nov. 03, =E0 11:21, Ulf K=FC=DFner a =E9crit :=0D =0D > Hi,=0D >=0D > I've been browsing your site looking for support of the new mysql 4.1a = =0D > Version. I'm testing that in order to get internationalisation using =0D= > utf8 in our databases. While mysql is still pretty much alpha, I =0D > noticed that cocoamysql, using your framework, cannot handle 4.1 =0D > connections correctly.=0D > I wonder if you are already do, or are planning, to support 4.1?=0D >=0D > Kind regards,=0D > Ulf.=0D >=0D >=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (Darwin) iD8DBQE/yh4r5EPeG5y7WPsRArCxAKDNdSGR3PWrgjFP9KStRRGp+t9/lgCeMnY/ Tezo0dBt1YGCKzVVqDuNDOo=3D =3DF/0Y -----END PGP SIGNATURE----- |
|
From: yo c. <kee...@ho...> - 2003-11-28 21:55:08
|
Hello, Thanks for your powerfull Frameworks ! I have just one problem, everything is ok if the MySQL server runs but, for testing when I call initToHost with another IP as host or if the MySQL server is down, initToHost hangs. It does not return. Have I to call it on a Thread with NSThread for exemple to test if the isConnected is set to YES or NO or am I missed something somewhere ? keefaz _________________________________________________________________ MSN Search, le moteur de recherche qui pense comme vous ! http://search.msn.fr/ |
|
From: Lorenz T. <lor...@gm...> - 2003-11-21 13:19:43
|
Hi,
Try something like the following to get the binary data:
imageData =3D [[NSData alloc] initWithContentsOfFile:fileName];
Then write it to the db like you have written:
sql =3D [NSString stringWithFormat:@"insert into fota (foto) values=20
('%@');",[conn prepareBinaryData:imageData]];
Regards,
Lorenz
On Wednesday, Nov 19, 2003, at 05:13 Europe/Rome,=20
mys...@li... wrote:
> To: mys...@li...
> From: leszek <le...@ev...>
> Date: Tue, 18 Nov 2003 23:32:46 +0100
> Subject: [Mysql-cocoa-users] Hello! Anybody?
>
> Hi,
> I'm writing COCOA app with SmySQL and I need to store some JPEGS in
> blob field.
> I tried this code:
> (...)
> mini =3D [bitmap representationUsingType:NSJPEGFileType =
properties:nil];
> (...)
> if ([conn isConnected]) {
> [conn selectDB:@"test"];
> sql =3D [NSString stringWithFormat:@"insert into fota (foto)
> values ('%@');",[conn prepareBinaryData:mini]];
> [polaczenie queryString:sql];
>
> ...and data looks truncated (bad Huffman code - says mysql).
>
> What's is going wrong? Data in 'mini' are correct - test procedure can
> render image in ImageView - from database - no way!
>
> Any help will be appreciated.
>
> regards
> Leszek Nie
>
>
>
>
> --__--__--
--=20
lorenz textor
** sh **
eigerstrasse 21
8200 schaffhausen
tf 052 - 624 27 91
** zh **
schimmelstrasse 5
8003 z=FCrich
tf 043 - 333 00 19
**
mobile 076 - 531 71 74
email lo...@te...
--=20
lorenz textor
** sh **
eigerstrasse 21
8200 schaffhausen
tf 052 - 624 27 91
** zh **
schimmelstrasse 5
8003 z=FCrich
tf 043 - 333 00 19
**
mobile 076 - 531 71 74
email lo...@te...=
|
|
From: Lorenz T. <lor...@gm...> - 2003-11-21 09:53:07
|
Hi,
Try something like the following to get the binary data:
imageData =3D [[NSData alloc] initWithContentsOfFile:fileName];
Then write it to the db like you have written:
sql =3D [NSString stringWithFormat:@"insert into fota (foto) values=20
('%@');",[conn prepareBinaryData:imageData]];
Regards,
Lorenz
On Wednesday, Nov 19, 2003, at 05:13 Europe/Rome,=20
mys...@li... wrote:
> To: mys...@li...
> From: leszek <le...@ev...>
> Date: Tue, 18 Nov 2003 23:32:46 +0100
> Subject: [Mysql-cocoa-users] Hello! Anybody?
>
> Hi,
> I'm writing COCOA app with SmySQL and I need to store some JPEGS in
> blob field.
> I tried this code:
> (...)
> mini =3D [bitmap representationUsingType:NSJPEGFileType =
properties:nil];
> (...)
> if ([conn isConnected]) {
> [conn selectDB:@"test"];
> sql =3D [NSString stringWithFormat:@"insert into fota (foto)
> values ('%@');",[conn prepareBinaryData:mini]];
> [polaczenie queryString:sql];
>
> ...and data looks truncated (bad Huffman code - says mysql).
>
> What's is going wrong? Data in 'mini' are correct - test procedure can
> render image in ImageView - from database - no way!
>
> Any help will be appreciated.
>
> regards
> Leszek Nie
>
>
>
>
> --__--__--
--=20
lorenz textor
** sh **
eigerstrasse 21
8200 schaffhausen
tf 052 - 624 27 91
** zh **
schimmelstrasse 5
8003 z=FCrich
tf 043 - 333 00 19
**
mobile 076 - 531 71 74
email lo...@te...
|
|
From: leszek <le...@ev...> - 2003-11-18 22:32:40
|
Hi,
I'm writing COCOA app with SmySQL and I need to store some JPEGS in
blob field.
I tried this code:
(...)
mini = [bitmap representationUsingType:NSJPEGFileType properties:nil];
(...)
if ([conn isConnected]) {
[conn selectDB:@"test"];
sql = [NSString stringWithFormat:@"insert into fota (foto)
values ('%@');",[conn prepareBinaryData:mini]];
[polaczenie queryString:sql];
...and data looks truncated (bad Huffman code - says mysql).
What's is going wrong? Data in 'mini' are correct - test procedure can
render image in ImageView - from database - no way!
Any help will be appreciated.
regards
Leszek Nie
|
|
From: Jason M. <jas...@ya...> - 2003-11-15 21:46:18
|
OK, I figured it out. :-) Removed CC references in the target. Jason --- Jason McInnes <jas...@ya...> wrote: > I've made a change to MCPConnection.m (to fix a > suspected bug I sent an email about previously). > However, i can't seem to get the framework to > compile. > Here is what looks like the relevant build output: > > CompileC > /Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o > > /usr/bin/gcc-3.3 -c > -F/Users/jmcinnes/Documents/build > -I/Users/jmcinnes/Documents/build/include > -Imysql_bins > -arch ppc -fno-common -fpascal-strings -O3 -Wmost > -Wno-four-char-constants -Wno-unknown-pragmas -pipe > -precomp-trustfile > /Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/TrustedPrecomps.txt > -Wp,-header-mapfile,/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/SMySQL_static.hmap > "-faltivec" "-fno-coalesce" MCPConnection.m > -o > /Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o > > /bin/sh: /usr/bin/gcc-3.3: No such file or directory > ...failed CompileC > /Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o > ... > > I know next to nothing about how the applications > actually get built. Can anyone tell me why I'm > running > into this build problem? > > Jason > > > ===== > Jason McInnes > 2 Degrees > Cell: 206.849.3680 > Email: jas...@ya... > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > > > ------------------------------------------------------- > This SF. Net email is sponsored by: GoToMyPC > GoToMyPC is the fast, easy and secure way to access > your computer from > any Web browser or wireless device. Click here to > Try it Free! > https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl > _______________________________________________ > Mysql-cocoa-users mailing list > Mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users ===== Jason McInnes 2 Degrees Cell: 206.849.3680 Email: jas...@ya... __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree |
|
From: Jason M. <jas...@ya...> - 2003-11-15 21:05:38
|
I've made a change to MCPConnection.m (to fix a
suspected bug I sent an email about previously).
However, i can't seem to get the framework to compile.
Here is what looks like the relevant build output:
CompileC
/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o
/usr/bin/gcc-3.3 -c
-F/Users/jmcinnes/Documents/build
-I/Users/jmcinnes/Documents/build/include -Imysql_bins
-arch ppc -fno-common -fpascal-strings -O3 -Wmost
-Wno-four-char-constants -Wno-unknown-pragmas -pipe
-precomp-trustfile
/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/TrustedPrecomps.txt
-Wp,-header-mapfile,/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/SMySQL_static.hmap
"-faltivec" "-fno-coalesce" MCPConnection.m -o
/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o
/bin/sh: /usr/bin/gcc-3.3: No such file or directory
...failed CompileC
/Users/jmcinnes/Documents/build/SMySQL.build/SMySQL_static.build/Objects-normal/ppc/MCPConnection.o
...
I know next to nothing about how the applications
actually get built. Can anyone tell me why I'm running
into this build problem?
Jason
=====
Jason McInnes
2 Degrees
Cell: 206.849.3680
Email: jas...@ya...
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
|
|
From: Jason M. <jas...@ya...> - 2003-11-15 21:02:26
|
Hi. I've been using the framework and it's excellent.
But I've run into a problem which I think is caused by
a memory leak...
Basically, I'm writing a batch application that has to
do thousands of inserts.
In MCPConnection.m:
- (MCPResult *) queryString:(NSString *) query
{
MCPResult *theResult = [MCPResult alloc];
/*****snip*****/
if ((theQueryCode = mysql_query(mConnection,
theCQuery)) == NULL) {
if (mysql_field_count(mConnection) != 0) {
theResult = [theResult
initWithMySQLPtr:mConnection encoding:mEncoding];
}
else {
// NSLog (@"Query worked but gives no
output\n");
// [theResult init];
return nil;
}
}
/*****snip*****/
It looks like theResult is alloc'd, but if the result
is the empty set (like in an insert), nil is returned,
but theResult is never autoreleased or released.
I ran my program through ObjectAlloc and there are
many MCPResults left over form my multiple inserts.
They don't take up much space, but as I said, my
program does thousands of inserts and they build up
over time causing a crash.
Let me know if I'm wrong here. But right now this
looks like the major bug du jour in my program...
Jason
=====
Jason McInnes
2 Degrees
Cell: 206.849.3680
Email: jas...@ya...
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
|
|
From: Lorenz T. <lo...@te...> - 2003-11-10 12:55:31
|
Hi Chris,
Try something like the following:
1. Add the compiled framework to your project.
2. If you want the framework be included in your executable, add a copy
files build phase for the framework.
3. Import the framework header file in your class header file:
#import <SMySQL/SMySQL.h>
4. Put code similar to the following in your awakeFromNib method (I'm
still working with an old version of the framework, but the following
code should work in v2):
// set up the mysql connection
MCPConnection *mySQLConnection;
mySQLConnection = [[MCPConnection alloc] initToHost:@"yourHost"
withLogin:@"yourLogin"
password:@"yourPassword"
usingPort:@"theMySQLPort"];
// select the db
[mySQLConnection selectDB:@"yourDB"];
// perform the query
NSArray *theResult;
theResult = [mySQLConnection getAllRowsFromQuery:@"SELECT * FROM
yourTable" asType:MCPTypeArray];
// put the result in your textfield, so e.g. ...
int i;
NSMutableString *theString = [NSMutableString string];
for ( i = 0 ; i < [theResult count] ; i++ ) {
[theString appendString:[[theResult objectAtIndex:i]
componentsJoinedByString:@"\t"]];
[theString appendString:@"\n"];
}
[yourTextField setStringValue:theString];
Hope that helps. Feel free to send me an email when you have more
questions!
- Lorenz
On Monday, Nov 10, 2003, at 05:13 Europe/Rome,
mys...@li... wrote:
> To: mys...@li...
> From: chris <ch...@th...>
> Date: Sun, 9 Nov 2003 11:16:44 -0800
> Subject: [Mysql-cocoa-users] Getting out the starting gate
>
> I'm trying to get even the most basic returns from MySQL and having
> difficulty getting results. How would I say at awakeFromNib to put
> into my text field the contents of a table?
>
> --chris
|
|
From: John G. <jo...@jl...> - 2003-11-10 09:45:45
|
Just a quick reply for you, it doesn't really matter where you are trying to extract data from the=20= database, awakeFromNib, init or even you own custom methods, the=20 process is basically the same: The framework contains two primary classes that work together MCPConnection which establishes and maintains the connection to the=20 database (you issue SQL queries to an open MCPConnection) and MCPResult which manages access to a result set from a query issued=20= to the MCPConnection. The process typically follows the following logic 1) Establish a connection to a mySQL database (it can be local or=20 remote) eg. MCPConnection *theConnec =3D [MCPConnection alloc]; theConnec =3D [theConnec initToHost::albert.com withLogin:@"toto"=20 password:@"albert" port:0]; [theConnec selectDB:@"db1"]; 2) execute a query which will return a MCPResult object theRes =3D [theConnec queryString:@"select * from table1"]; 3) finally process each line returned in the result while (theDict =3D [theRes fetchRowAsDictionary]) { // do something } 4) finally release all your objects which will free all the cached=20 values etc. Look in the documentation that comes with the framework for=20 MCPConnection and MCPResuly, these contain example code snippets that=20 contain everything you need to get going if you are familiar with SQL=20 (that is where I got the code snippets from above) hope this helps JOhn =A0=A0=A0=A0 On Sunday, November 9, 2003, at 07:16 PM, chris wrote: > I'm trying to get even the most basic returns from MySQL and having=20 > difficulty getting results. How would I say at awakeFromNib to put=20 > into my text field the contents of a table? > > --chris > > > > ------------------------------------------------------- > This SF.Net email sponsored by: ApacheCon 2003, > 16-19 November in Las Vegas. Learn firsthand the latest > developments in Apache, PHP, Perl, XML, Java, MySQL, > WebDAV, and more! http://www.apachecon.com/ > _______________________________________________ > Mysql-cocoa-users mailing list > Mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users > |
|
From: chris <ch...@th...> - 2003-11-09 21:16:59
|
I'm trying to get even the most basic returns from MySQL and having difficulty getting results. How would I say at awakeFromNib to put into my text field the contents of a table? --chris |
|
From: John B. <ter...@ma...> - 2003-10-03 01:41:56
|
Hello Everyone,
I'm at the point of having to ask for help. This is my latest error
problem. I can't get set up as a user, at all. TIA
[John-Blumers-Computer:/usr/local/mysql] johnblumer% echo mysql_connect
('localhost', 'john blumer', 'password removed');
Badly placed ()'s.
|
|
From: Serge C. <ser...@us...> - 2003-09-26 18:29:16
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi;=0D =0D Sorry to answer so late... having problem with my POP.=0D =0D Indeed the init method exist (and is a bit documented), and is there =0D exactly for the use you want to make of it...=0D Unfortunately as I'm not using it I've never realised that it got =0D broken at some point (from what I understand of your previous posts).=0D =0D =46rom your previous posts, I understand the problem comes from the =0D mysql_character_set_name function of the libmysqlclient library...=0D I have to sort that out (together with the bug in =0D SMySQL_bundled/SMySQL.h header...).=0D =0D Thanks a lot for your feed back, that helps me a lot to make thing =0D easier for future users (at least I hope it'll get easier).=0D =0D Serge.=0D =0D Le vendredi, 26 sep 2003, =E0 02:29 Europe/Amsterdam, Ezat Hashim a = =E9crit =0D :=0D =0D > Serge:=0D >=0D > I was having a problem with your 'init' for MCPConnection. I think =0D > that it would be good to be able to split-up the method:=0D >=0D > initToHost:withLogin:password:usingPort:=0D >=0D > to:=0D >=0D > init=0D > connectToHost:withLogin:password:usingPort:=0D >=0D > In this way I can create an MCPConnection object and let it float =0D > around until I want to connect it to something. I was having a problem = =0D > with the current 'init' as it appeared to be crashing my app. I can =0D= > send it to you if you wish.=0D >=0D >=0D > Ezat=0D >=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/dIUy5EPeG5y7WPsRAiw1AKDrsQJhIYY35+3jKfOYhgfji4p8MwCeJgdZ WllIdtG4F897wzQtgel5r0I=3D =3DNdv+ -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-09-26 18:17:01
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi;
I realise now what the problem is. The framework provides a init (with=20=
NO argument) method, so that you can have an object inited and use it=20
only later (using the connectTo:... method).
As I never used this method myself, I never realise that it got broken=20=
at some point (it is not using the same mysql API function to get the=20
encoding used).
Indeed, I think that I have documented a bit the method, saying it is=20
there so that one can set 'special' features for the connection BEFORE=20=
doing the connection... but I never needed such things, and never got a=20=
feature request, so it happily stayed in the TODO queue without moving=20=
further at any time. This is going to change as I want to provide the=20
possibility to use SSL for connecting to the DB server.
In short: You found a bug, thanks a lot for reporting it. I'll try to=20
fix it soon, in the mean time the easiest for you is to use John's tip.
I also realise that I have to make the corresponding part of the=20
documentation more clear.
Thanks again (Ezat & John), for pointing the bug to me.
Serge.
Le vendredi, 26 sep 2003, =E0 11:28 Europe/Amsterdam, John Guy a =E9crit =
:
> no problem :)
>
> would be worth forwarding this on to the list (which I have done now=20=
> anyway).
>
> then let serge have your app code to look at.
>
> There IS an init method by the way, just that it doesn't seem to be=20
> initialising the encoding variable (internal to the framework)
>
> JOhn
>
> On Friday, September 26, 2003, at 12:25 AM, Ezat Hashim wrote:
>
>> You were absolutely right! Thanks!
>>
>> The app bombed because (I guess) there is no 'init' method per se. I=20=
>> have made the changes as you suggested and things seem to be working=20=
>> now. Do you think that I should ask Serge to look at his 'init' to=20
>> see what went wrong (I assume there is an init).?
>>
>>
>> On Thursday, September 25, 2003, at 08:05 AM, John Guy wrote:
>>
>>> Hiya,
>>>
>>> had a very quick look, can't see anything that looks obviously =
wrong.
>>>
>>> I am a little busy, and also I just realised I am still using the=20
>>> older version of the framework so I can't compile your code :(
>>>
>>> BUT
>>>
>>> I have noticed that you are doing a very simple
>>> dbQuery=3D[[MCPConnection alloc] init];
>>> in your DataController init method.
>>>
>>> Looking at the documentation it implies that you wouldn't normally=20=
>>> use a simple init, so maybe there is some problem in the Framework.
>>>
>>> This is the code I always use when setting up my connections etc.
>>>
>>> -(bool)loginToServer:(NSString*)server
>>> user:(NSString*)user
>>> password:(NSString*)pass
>>> selectDatabase:(NSString*)db
>>> {
>>> if (dbConnection =3D [[MCPConnection alloc]
>>> initToHost:server withLogin:user password:pass usingPort:0])
>>> {
>>> if ([dbConnection selectDB:db])
>>> {
>>> loggedIn =3D TRUE;
>>> return(TRUE);
>>> }
>>> }
>>> //TODO setting loggedIn may be redundent since a valid dbConnection=20=
>>> object
>>> // means the same
>>> loggedIn =3D FALSE;
>>> return(FALSE);
>>> } // loginToServer()
>>>
>>> as you can see I use the initToHost methods which I think Serge has=20=
>>> been using in his examples originally. So maybe this is setting up=20=
>>> the encoding better (again I haven't got the time to check the=20
>>> Framework source code at the moment - sorry).
>>>
>>> Why not try using the initToHost method and see if this fixes you=20
>>> problem.
>>> Easiest way to check is change your
>>> dbQuery=3D[[MCPConnection alloc] init];
>>> to
>>> dbQuery=3D [MCPConnection alloc];
>>>
>>> in the DataController init method
>>>
>>> then use the initToHost method in your establishConnectionToServer:=20=
>>> method in place of the call to connectWithLogin.
>>>
>>> hope this helps, also out of interest which method were you in when=20=
>>> you got the error exception in your debugger (which of your=20
>>> methods?) this may help tell Serge which method was bombing out
>>>
>>> let me know how you get on.
>>>
>>> JOhn
>>>
>>>
>>> On Thursday, September 25, 2003, at 11:46 AM, Ezat Hashim wrote:
>>>
>>>> Gee Thanks! I have attached my small app.
>>>> <SMySQLTester.2.tar.gz>
>>>> On Thursday, September 25, 2003, at 05:42 AM, John Guy wrote:
>>>>
>>>
- ----------------------------------------------------
Serge Cohen
GPG Key ID: 9CBB58FB
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)
iD8DBQE/dII95EPeG5y7WPsRAsnFAKDWQPAmWNwHdgBFj4XJgA7HDtAhPACeJm/B
9mASE5/sCjBMxRRsrQpxJfg=3D
=3DNF8Z
-----END PGP SIGNATURE-----
|
|
From: John G. <jo...@jl...> - 2003-09-26 09:27:06
|
no problem :)
would be worth forwarding this on to the list (which I have done now
anyway).
then let serge have your app code to look at.
There IS an init method by the way, just that it doesn't seem to be
initialising the encoding variable (internal to the framework)
JOhn
On Friday, September 26, 2003, at 12:25 AM, Ezat Hashim wrote:
> You were absolutely right! Thanks!
>
> The app bombed because (I guess) there is no 'init' method per se. I
> have made the changes as you suggested and things seem to be working
> now. Do you think that I should ask Serge to look at his 'init' to see
> what went wrong (I assume there is an init).?
>
>
> On Thursday, September 25, 2003, at 08:05 AM, John Guy wrote:
>
>> Hiya,
>>
>> had a very quick look, can't see anything that looks obviously wrong.
>>
>> I am a little busy, and also I just realised I am still using the
>> older version of the framework so I can't compile your code :(
>>
>> BUT
>>
>> I have noticed that you are doing a very simple
>> dbQuery=[[MCPConnection alloc] init];
>> in your DataController init method.
>>
>> Looking at the documentation it implies that you wouldn't normally
>> use a simple init, so maybe there is some problem in the Framework.
>>
>> This is the code I always use when setting up my connections etc.
>>
>> -(bool)loginToServer:(NSString*)server
>> user:(NSString*)user
>> password:(NSString*)pass
>> selectDatabase:(NSString*)db
>> {
>> if (dbConnection = [[MCPConnection alloc]
>> initToHost:server withLogin:user password:pass usingPort:0])
>> {
>> if ([dbConnection selectDB:db])
>> {
>> loggedIn = TRUE;
>> return(TRUE);
>> }
>> }
>> //TODO setting loggedIn may be redundent since a valid dbConnection
>> object
>> // means the same
>> loggedIn = FALSE;
>> return(FALSE);
>> } // loginToServer()
>>
>> as you can see I use the initToHost methods which I think Serge has
>> been using in his examples originally. So maybe this is setting up
>> the encoding better (again I haven't got the time to check the
>> Framework source code at the moment - sorry).
>>
>> Why not try using the initToHost method and see if this fixes you
>> problem.
>> Easiest way to check is change your
>> dbQuery=[[MCPConnection alloc] init];
>> to
>> dbQuery= [MCPConnection alloc];
>>
>> in the DataController init method
>>
>> then use the initToHost method in your establishConnectionToServer:
>> method in place of the call to connectWithLogin.
>>
>> hope this helps, also out of interest which method were you in when
>> you got the error exception in your debugger (which of your methods?)
>> this may help tell Serge which method was bombing out
>>
>> let me know how you get on.
>>
>> JOhn
>>
>>
>> On Thursday, September 25, 2003, at 11:46 AM, Ezat Hashim wrote:
>>
>>> Gee Thanks! I have attached my small app.
>>> <SMySQLTester.2.tar.gz>
>>> On Thursday, September 25, 2003, at 05:42 AM, John Guy wrote:
>>>
>>
>> |
|
From: Ezat H. <drh...@cc...> - 2003-09-25 01:37:35
|
In looking over the source files for SMySQL I seem to have the InfoPlist missing in the version that I have downloaded. Is there a download with one included or am I supposed to generate one somehow? Ezat |
