mysql-cocoa-users — The mysql-cocoa users mailing list

[Mysql-cocoa-users] (no subject)

[joe <jo...@ke...>]

Is there any documentation for this?

[Mysql-cocoa-users] MCPKit missing files?

[Adhamh F. <ad...@ma...>]

When I download the src to MCPKit 3.0.1 I get a bunch of missing  
files in Xcode?. Is there any resolution to this?  Is there access to  
the 3.0 repository?  Is this project dead?

Thanks,

Adhamh

[Mysql-cocoa-users] Documents don't match the dmg

[Bruce M. <usb...@ma...>]

Hi, I just joined this list because it looks like you are doing what  
I have done, in a sense. I didn't create Cocoa API for MySQL, but I  
wrote an API if you will for SuperCard to access MySQl known as an  
external.

A little info about externals,as I may reference it from time to  
time. An externals can be thought of as a plug-in although it is  
embedded into the datafork of a SuperCard project. It has the ability  
to extend the features of SuperCard.

Ok with that said, I stumbled across your Cocoa API and since I am  
working on updating my external I thought what better way to do it  
than with a Cocoa version of my external which will be Universal.

Ok so I downloaded the "Framework" (MCPKit_src_3.0.1.dmg) but the  
file it says in the docs, to place into my xCode project,  
SMySQL_bundled.framework, is not included. So when I opened the and  
try to compile it states file info.plist does not exists. I did read  
about this happening to someone else, but didn't see the solution.  
Your help would be greatly appreciated.

Bruce Martin
The Martin Solution
br...@ma...

Re: [Mysql-cocoa-users] Bug with blob in framework or in my code ?

[Eric V. <ev...@cl...>]

The problem is solved (thanks to Hayden Stainsby)

The data must be converted from hexa to NSData

A new function "decodeBinaryData" may be very useful !

--------

- (NSMutableData*)decodeBinaryData:(NSData*)data
{
	int				i, theLength;
	const char		*thumbnailHex;
	char			*buffer;
	NSMutableData	*thumbnailData =3D [[[NSMutableData alloc] init] =
=20
autorelease];

	thumbnailHex =3D [data bytes];
	theLength =3D [data length];
	buffer =3D (char *)calloc(sizeof(char),(theLength/2));
	int index =3D 0;
	for (i =3D 0 ; i < theLength ; i +=3D 2)
	{
		char aByte, tChar[2];
		=09
		tChar[0] =3D thumbnailHex[i];
		tChar[1] =3D thumbnailHex[i+1];
		=09
		tChar[0] -=3D 0x30;
		if (tChar[0] >=3D 0x0a)
		{
			tChar[0] -=3D 0x07;
		}
		=09
		tChar[1] -=3D 0x30;
		if (tChar[1] >=3D 0x0a)
		{
			tChar[1] -=3D 0x07;
		}
		=09
	=09
		aByte =3D tChar[0] << 4;
		aByte =3D aByte | (tChar[1]);
		=09
		buffer[index] =3D aByte;
		index++;
	}
=09
	[thumbnailData appendBytes:buffer length:(theLength/2)];

	return thumbnailData;
}


Le 27 janv. 07 =E0 09:58, Eric VERDIN a =E9crit :

> Hello,
>
> I  try to save and read a picture in mysql.
> I use the standard version (4.1.22 and 5.0.27 of mysql package) with
> the same problem.
>
> ( http://sourceforge.net/mailarchive/forum.php?
> thread_id=3D31463383&forum_id=3D2800 )
>
> When i read the picture in mysql, the size is double !
>
> Do you have the same problem (blob with utf8 ?) ?
>
> Any help would be most appreciated.
> Thank you very much.
>
> Eric
>
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>

[Mysql-cocoa-users] Bug with blob in framework or in my code ?

[Eric V. <ev...@cl...>]

Hello,

I  try to save and read a picture in mysql.
I use the standard version (4.1.22 and 5.0.27 of mysql package) with  
the same problem.

( http://sourceforge.net/mailarchive/forum.php? 
thread_id=31463383&forum_id=2800 )

When i read the picture in mysql, the size is double !

Do you have the same problem (blob with utf8 ?) ?

Any help would be most appreciated.
Thank you very much.

Eric

Re: [Mysql-cocoa-users] universal binary distribution

[Jeff K. <kop...@gm...>]

There's a Universal version of CocoaMySQL that I've been using:
CocoaMySQL-SBG and it works great.

http://www.theonline.org/cocoamysql/



On 1/24/07, Camille GOUREAU-SUIGNARD <ca...@lu...> wrote:
> Hi,
>
> I just bought an intel macMini.
> I'm trying to switch my softs to it.
>
> I downloaded MCPKit_bin_3.0.1, and replaced the bundled framwork in
> my project.
> First problem, it keeps telling me that it has been compiled on a
> ppc. I thought 3.0.1 was UB. Am I wrong ?
>
> I downloaded MCPKit_src_3.0.1 and tried to compile the bundled
> flavour bu some files are missing:
> plists files
> prefix file.
>
> Where am I doing wrong ?
>
> Many thanks.
>
> Camille
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>


-- 
Jeff Kopmanis
kop...@gm...

Re: [Mysql-cocoa-users] universal binary distribution

[Camille GOUREAU-S. <ca...@lu...>]

> Until there is an official release, try this
>
> http://cocoamysql.sourceforge.net/downloads/ 
> MCPKit_bundled.framework.zip
It works great.

Thanks.

Camille


Et mon blog: www.lutin-ludique.com/bradype/

Re: [Mysql-cocoa-users] universal binary distribution

[Chris B. <cbl...@so...>]

Until there is an official release, try this

http://cocoamysql.sourceforge.net/downloads/MCPKit_bundled.framework.zip

Chris

On 24 Jan 2007, at 09:26, Camille GOUREAU-SUIGNARD wrote:

> Hi,
>
> I just bought an intel macMini.
> I'm trying to switch my softs to it.
>
> I downloaded MCPKit_bin_3.0.1, and replaced the bundled framwork in
> my project.
> First problem, it keeps telling me that it has been compiled on a
> ppc. I thought 3.0.1 was UB. Am I wrong ?
>
> I downloaded MCPKit_src_3.0.1 and tried to compile the bundled
> flavour bu some files are missing:
> plists files
> prefix file.
>
> Where am I doing wrong ?
>
> Many thanks.
>
> Camille
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users

Re: [Mysql-cocoa-users] universal binary distribution

[Serge C. <ser...@us...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there;

This is a long standing question... I really have to test that I did =20
nor screw-up the release, and make a good one.
What I am sure off, is that it works UB on my machine. Unfortunately =20
I don't have a 'clean' machine, so I might miss a few mandatory files =20=

in the release (which never shows up when I'm trying the release =20
version on my mac).

I'll try to take care of that in the 2 coming days !

With all my excuses for the troubles caused by the bug in the release.

Serge.


Le 24 janv. 07 =E0 10:26, Camille GOUREAU-SUIGNARD a =E9crit :

> Hi,
>
> I just bought an intel macMini.
> I'm trying to switch my softs to it.
>
> I downloaded MCPKit_bin_3.0.1, and replaced the bundled framwork in
> my project.
> First problem, it keeps telling me that it has been compiled on a
> ppc. I thought 3.0.1 was UB. Am I wrong ?
>
> I downloaded MCPKit_src_3.0.1 and tried to compile the bundled
> flavour bu some files are missing:
> plists files
> prefix file.
>
> Where am I doing wrong ?
>
> Many thanks.
>
> Camille
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFFtyzr5EPeG5y7WPsRAkDaAJ9cJwHpmljtrQP4VIXMu31tOVggnQCg5mCE
SiQZzT9fDBPPmpgMZPG21L0=3D
=3DO/1h
-----END PGP SIGNATURE-----

[Mysql-cocoa-users] universal binary distribution

[Camille GOUREAU-S. <ca...@lu...>]

Hi,

I just bought an intel macMini.
I'm trying to switch my softs to it.

I downloaded MCPKit_bin_3.0.1, and replaced the bundled framwork in  
my project.
First problem, it keeps telling me that it has been compiled on a  
ppc. I thought 3.0.1 was UB. Am I wrong ?

I downloaded MCPKit_src_3.0.1 and tried to compile the bundled  
flavour bu some files are missing:
plists files
prefix file.

Where am I doing wrong ?

Many thanks.

Camille

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Steve S. <sst...@ma...>]

>> I called MySQL Headquarters in the U.S. and their pricing structure
>> is done on a per server basis. So, as far as I can tell, Serge does
>> not need to pay any fees to MySQL because he is not actually using
>> the framework on a specific implementation. However anyone using the
>> framework needs to pay MySQL approx. 425 GBP per server to use the
>> framework, on-top of whatever serge is charging.

That doesn't make a huge amount of sense as the one responsible for  
licensing is the one running MySQL on the server; i.e. the server's  
owner.

If you write a tool that can be used against multiple servers, and  
you have to pay a license fee per server, in addition to the one paid  
by the server's owner, that would be double-dipping by MySQL and that  
doesn't make any sense.

S

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Serge C. <ser...@m4...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Chris;

Thanks for your efforts, I'll have a quick check directly myself (I =20
really need to be sure before getting any-further), and will try to =20
get this in writing (at least as a mail). I'll post my results here =20
(might take a day or two).

Then I guess I'll have to decide for myself what I'll charge you =20
guys ;-) (most likely a free licence of the soft you're releasing, =20
and a small extra ?)

If anyone wants to make comments on that, feel free (either to the =20
list or to me directly : ser...@us...).

Thanks again Chris for taking the trouble of making the first check !

Serge.

Le 23 janv. 07 =E0 12:03, Chris Blackburn a =E9crit :

> Hey everyone,
>
> I called MySQL Headquarters in the U.S. and their pricing structure
> is done on a per server basis. So, as far as I can tell, Serge does
> not need to pay any fees to MySQL because he is not actually using
> the framework on a specific implementation. However anyone using the
> framework needs to pay MySQL approx. 425 GBP per server to use the
> framework, on-top of whatever serge is charging.
>
> Chris

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFFtfue5EPeG5y7WPsRAmOQAJ0ea63yDHolVTcdrhQJNUcCZcM+4ACggLbe
lODkt+IjEhV4bcMxRHo8a4M=3D
=3DPNoe
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Chris B. <cbl...@so...>]

Hey everyone,

I called MySQL Headquarters in the U.S. and their pricing structure  
is done on a per server basis. So, as far as I can tell, Serge does  
not need to pay any fees to MySQL because he is not actually using  
the framework on a specific implementation. However anyone using the  
framework needs to pay MySQL approx. 425 GBP per server to use the  
framework, on-top of whatever serge is charging.

Chris

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Serge C. <ser...@us...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Steve;

Unfortunately, even the 'Core C' library is under GPL since at least =20
4.0.
Before they had a bit of a unusual licence scheme, closer to LGPL.

Serge.

Le 23 janv. 07 =E0 03:34, Steve Steiner a =E9crit :

> On Jan 22, 2007, at 8:27 PM, Serge Cohen wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hello there;
>>
>> Indeed I'd be more than happy to provide a 'usable' licence for the
>> framework... The trouble is that MySQL is GPL (NOT LGPL), so to be
>> able to provide any-one with a non-GPL licence I have to have a
>> licence myself, and you (as a dev. releasing a non-GPL software using
>> MySQL) need to get a licence for every soft you sale (one lic. per
>> copy as far as I understand).
>
> Isn't the core MySQL 'C' library LGPL?
>
> There are certainly enough commercial products out there based on =20
> it...
>
> S
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFFtcMg5EPeG5y7WPsRAgKAAJ4tb9szV6s2+rs/Cs0LtAYtBJf8zQCfW17I
tCQ8r8zOyDOT1E2wNwj3L0E=3D
=3D5zvC
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Steve S. <sst...@ma...>]

On Jan 22, 2007, at 8:27 PM, Serge Cohen wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello there;
>
> Indeed I'd be more than happy to provide a 'usable' licence for the
> framework... The trouble is that MySQL is GPL (NOT LGPL), so to be
> able to provide any-one with a non-GPL licence I have to have a
> licence myself, and you (as a dev. releasing a non-GPL software using
> MySQL) need to get a licence for every soft you sale (one lic. per
> copy as far as I understand).

Isn't the core MySQL 'C' library LGPL?

There are certainly enough commercial products out there based on it...

S

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Serge C. <ser...@m4...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello there;

Indeed I'd be more than happy to provide a 'usable' licence for the =20
framework... The trouble is that MySQL is GPL (NOT LGPL), so to be =20
able to provide any-one with a non-GPL licence I have to have a =20
licence myself, and you (as a dev. releasing a non-GPL software using =20=

MySQL) need to get a licence for every soft you sale (one lic. per =20
copy as far as I understand).

Now this means that I'm not going into this trouble unless someone =20
tells me (with good confidence) that he's planning to do these effort =20=

for himself... And the price I'll ask for 'commercial' (ie. non-GPL) =20
licence will be close to what MySQL asks me for getting a licence for =20=

myself ...

If you are still interested, don't hesitate to mail me.

Waiting for replies/comments;
Cheers;

Serge.

PS : Indeed this will also be a good incentive to upgrade/maintain a =20
bit more all the framework!

Le 22 janv. 07 =E0 22:36, Kelly Hawk a =E9crit :

> yup, that's my understanding. the LGPL is better (the extra L is =20
> for "library"), as it is intended for frameworks, and allows a =20
> commercial application to link to the framework without your =20
> linking application coming under GPL. But having worked with =20
> corporate atty's on both the GPL and LGPL, even the LGPL has flaws =20
> and, for example, Apple won't use code coming from either license =20
> type unless its willing to Darwin everything related to it. There =20
> have been revisions to these licenses over time, so my information =20
> may be out of date.
>
> On Jan 22, 2007, at 1:19:08 PM, Chris Blackburn wrote:
>
>> Hi,
>>
>> I just read that the mysql-cocoa framework is licensed under the =20
>> GPL. This means that the following clause is implied: -
>>
>> You must cause any work that you distribute or publish, that in =20
>> whole or in part contains or is derived from the Program or any =20
>> part thereof, to be licensed as a whole at no charge to all third =20
>> parties under the terms of this License.
>>
>> This effectively means that it is illegal to derrive commercial =20
>> software from the framework. Is this the intention of the author? =20
>> If so then is there a way I can license the framework for use in =20
>> some commercial software?
>>
>> Thanks
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFFtWSU5EPeG5y7WPsRAgWcAJ4wlHeql1Au+ffXlHt2uS1jipbeLQCg8X8y
YTxFm4fMlLquyql/C1+bFhA=3D
=3DfFoP
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] GPL and Mysql-cocoa

[Kelly H. <kh...@po...>]

yup, that's my understanding. the LGPL is better (the extra L is for  
"library"), as it is intended for frameworks, and allows a commercial  
application to link to the framework without your linking application  
coming under GPL. But having worked with corporate atty's on both the  
GPL and LGPL, even the LGPL has flaws and, for example, Apple won't  
use code coming from either license type unless its willing to Darwin  
everything related to it. There have been revisions to these licenses  
over time, so my information may be out of date.

On Jan 22, 2007, at 1:19:08 PM, Chris Blackburn wrote:

> Hi,
>
> I just read that the mysql-cocoa framework is licensed under the  
> GPL. This means that the following clause is implied: -
>
> You must cause any work that you distribute or publish, that in  
> whole or in part contains or is derived from the Program or any  
> part thereof, to be licensed as a whole at no charge to all third  
> parties under the terms of this License.
>
> This effectively means that it is illegal to derrive commercial  
> software from the framework. Is this the intention of the author?  
> If so then is there a way I can license the framework for use in  
> some commercial software?
>
> Thanks
>
> Chris
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users

[Mysql-cocoa-users] GPL and Mysql-cocoa

[Chris B. <cbl...@so...>]

Hi,

I just read that the mysql-cocoa framework is licensed under the GPL.  
This means that the following clause is implied: -

You must cause any work that you distribute or publish, that in whole  
or in part contains or is derived from the Program or any part  
thereof, to be licensed as a whole at no charge to all third parties  
under the terms of this License.

This effectively means that it is illegal to derrive commercial  
software from the framework. Is this the intention of the author? If  
so then is there a way I can license the framework for use in some  
commercial software?

Thanks

Chris

Re: [Mysql-cocoa-users] Save and Read NSImage in mysql

[Eric V. <ev...@cl...>]

Has anybody had similar problems with the new framework and blob ?

Thank you in advance for your help.

Eric

[Mysql-cocoa-users] Save and Read NSImage in mysql

[Eric V. <ev...@cl...>]

Hi,

i use the new version of the framework (3.01) to store int, varchar,  
float and text without problem.

When i write a picture in a longblob (with a good max packet size)  
and read it, my data length is double.

I have the following code  to save picture :

	MCPConnection	*connection;
	MCPResult		*result;
	NSString 		*nomFichier;
	NSImage			*image;
	NSData			*tiffData;
	NSString		*query;
	int				index, error;
     NSArray			*names;
     NSDictionary	*row;

	nomFichier = [[NSString alloc] initWithString:@"~/Pictures/Mars.gif"];
	nomFichier = [nomFichier stringByExpandingTildeInPath];
	image = [[NSImage alloc] initWithContentsOfFile:nomFichier];
	tiffData = [image TIFFRepresentation];
  	// 9402 bytes

	string = [connection prepareBinaryData:tiffData];
	index = 1;
	query = [[NSString alloc] initWithFormat:@"Insert into %@ (%@, %@)  
VALUES ('%@', %d);",
											@"nomTable",
											@"nomColonne",
											@"nombre",
											string,
											index];
		
	result = [connection queryString:query];


and the following code  to read picture :


     query = [[NSString alloc] initWithFormat:@"SELECT nomColonne  
FROM nomTable WHERE nombre = %d;",
									  		 index];
	
	result = [connection queryString:query];
     names = [result fetchFieldNames];
     error = [connexion getLastErrorID];
     if (error == 0)
     {
	
         row = [result fetchRowAsDictionary];
		tiffData = [row objectForKey:[names objectAtIndex:0]];
		// 18804 bytes
	}

I use 5.0.27 (32 and 64 bits PPC version) version with the same result.

Thank you in advance for your help,

Eric

Re: [Mysql-cocoa-users] NSImage problem

[Eric V. <ev...@cl...>]

The max packet size was really the problem !

Thanks for your answer Max.

Le 8 janv. 07 =E0 18:34, Eric VERDIN a =E9crit :

> Thanks for you answer.
>
> The max packet size (max_allowed_packet) was 1M and my data size 2,8M.
>
> Now my max packet size is 5M but i have the same error !
>
> 2007-01-08 18:26:57.083 SQLTest[398] Problem in queryString error =20
> code is : 1, query is (truncated) : Insert into nomTable =20
> (nomColonne) VALUES ('<4d4d002a 002acbbe 5562a455 62a45562 a45562a4 =20=

> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562-
> 2007-01-08 18:26:57.083 SQLTest[398] Error message is : MySQL =20
> server has gone away
>
> Eric
>
>
> Le 7 janv. 07 =E0 18:33, Max Frazer a =E9crit :
>
>> If everything else works but longblobs, more than likely you =20
>> simply need to increase your max packet size in your mysql cnf file.
>>
>> http://www.vbulletin.com/forum/showthread.php?t=3D103786
>>
>> -Max
>>

Re: [Mysql-cocoa-users] NSImage problem

[Eric V. <ev...@cl...>]

The max packed size was really the problem !

Thaks for your answer Max

Le 8 janv. 07 =E0 18:34, Eric VERDIN a =E9crit :

> Thanks for you answer.
>
> The max packet size (max_allowed_packet) was 1M and my data size 2,8M.
>
> Now my max packet size is 5M but i have the same error !
>
> 2007-01-08 18:26:57.083 SQLTest[398] Problem in queryString error =20
> code is : 1, query is (truncated) : Insert into nomTable =20
> (nomColonne) VALUES ('<4d4d002a 002acbbe 5562a455 62a45562 a45562a4 =20=

> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
> 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
> 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
> a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562-
> 2007-01-08 18:26:57.083 SQLTest[398] Error message is : MySQL =20
> server has gone away
>
> Eric
>
>
> Le 7 janv. 07 =E0 18:33, Max Frazer a =E9crit :
>
>> If everything else works but longblobs, more than likely you =20
>> simply need to increase your max packet size in your mysql cnf file.
>>
>> http://www.vbulletin.com/forum/showthread.php?t=3D103786
>>
>> -Max
>>
>>
>> On Jan 7, 2007, at 3:40 AM, Eric VERDIN wrote:
>>
>>> Hi,
>>>
>>> i use the new version of the framework (3.01) to store int, =20
>>> varchar, float and text without problem.
>>> But i can't insert an image in a longblob.
>>>
>>> I have an 2006 Error (MySQL server has gone away) with 4.1.22 or =20
>>> 5.0.27 version.
>>>
>>> ****************************************
>>>
>>> #import <Cocoa/Cocoa.h>
>>> #import <Foundation/Foundation.h>
>>> #import <MCPKit_bundled/MCPResult.h>
>>> #import <MCPKit_bundled/MCPConnection.h>
>>>
>>> int main(int argc, char *argv[])
>>> {
>>>
>>> 	NSAutoreleasePool		*pool =3D [[NSAutoreleasePool =
alloc] init];
>>> 	MCPConnection			*connection;
>>> 	MCPResult				*result;
>>> 	NSImage					*image;
>>> 	NSData					*tiffData;
>>> 	NSString				*string;
>>> 	NSString				*query;
>>> 	NSString				*nomFichier;
>>> 	int						erreur;
>>> 	NSString				*message;
>>>
>>> 	nomFichier =3D [[NSString alloc] initWithString:@"~/Pictures/=20
>>> Berlan_1.png"];
>>> 	nomFichier =3D [nomFichier stringByExpandingTildeInPath];
>>> 	image =3D [[NSImage alloc] initWithContentsOfFile:nomFichier];
>>> 	tiffData =3D [image TIFFRepresentation];
>>> =09
>>> 	connection =3D [[MCPConnection alloc] initToHost:@"localhost" =20=

>>> withLogin:@"" password:@"" usingPort:0];
>>> 	if (connection !=3D nil)
>>> 	{
>>> =09
>>> 		[connection selectDB:@"test_image"];
>>>
>>> 		string =3D [connection prepareBinaryData:tiffData];
>>> 		query =3D [[NSString alloc] initWithFormat:@"Insert into =
%@ (%@) =20
>>> VALUES ('%@');",
>>> 										=
		@"nomTable",
>>> 										=
		@"nomColonne",
>>> 										=
		tiffData];
>>> 	=09
>>> 		result =3D [connection queryString:query];
>>> 		erreur =3D [connection getLastErrorID];
>>> 		message =3D [connection getLastErrorMessage];
>>> =09
>>> 		[connection release];
>>> 		[nomFichier release];
>>> 		[query release];
>>> 		[image release];
>>> 		[tiffData release];
>>> 		=09
>>> 	}
>>> =09
>>> 	[pool release];
>>> 	return 0;
>>>
>>> }
>>>
>>> ****************************************
>>>
>>> Thank you in advance for your help,
>>>
>>> Eric
>>> --------------------------------------------------------------------=20=

>>> -----
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to =20=

>>> share your
>>> opinions on IT & business topics through brief surveys - and earn =20=

>>> cash
>>> http://www.techsay.com/default.php?=20
>>> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV__________________________=
____=20
>>> _________________
>>> Mysql-cocoa-users mailing list
>>> Mys...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>>
>> ---------------------------------------------------------------------=20=

>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to =20
>> share your
>> opinions on IT & business topics through brief surveys - and earn =20
>> cash
>> http://www.techsay.com/default.php?=20
>> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV___________________________=
____=20
>> ________________
>> Mysql-cocoa-users mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV____________________________=
____=20
> _______________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users

[Mysql-cocoa-users] embedded database server

[Brian W. <bri...@fc...>]

Hi all,
      I am trying to embed the database server and database in my app  
to make life easier for the users.  So, first off, I was wondering if  
anyone's done this and has any words of wisdom.  I have downloaded  
version 3.0.1of the source, and done what Kelly has instructed and I  
get 50 warnings and 2 errors

(the errors are   "Undefined symbols:" and "internal link edit  
command failed", both of which are under the heading "Linking .../ 
MCPKit_src_3.0.1/build/MCPKit.build/Release/MCPKit_bundled.build/ 
Objects-normal/i386/MCPKit_bundled (2 errors) )

I am using MySQL 5.0 and gcc 4.0 (if that helps).  If anyone has any  
information on correcting these build errors, as well as including  
libmysqld.a so I can embed the database server, it would be most  
appreciated.  Thanks!
--
Brian Weitzner

Re: [Mysql-cocoa-users] NSImage problem

[Eric V. <ev...@cl...>]

Thanks for you answer.

The max packet size (max_allowed_packet) was 1M and my data size 2,8M.

Now my max packet size is 5M but i have the same error !

2007-01-08 18:26:57.083 SQLTest[398] Problem in queryString error =20
code is : 1, query is (truncated) : Insert into nomTable (nomColonne) =20=

VALUES ('<4d4d002a 002acbbe 5562a455 62a45562 a45562a4 5562a455 =20
62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 =20
62a45562 a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 =20
a45562a4 5562a455 62a45562 a45562a4 5562a455 62a45562 a45562a4 =20
5562a455 62a45562 a45562a4 5562a455 62a45562-
2007-01-08 18:26:57.083 SQLTest[398] Error message is : MySQL server =20
has gone away

Eric


Le 7 janv. 07 =E0 18:33, Max Frazer a =E9crit :

> If everything else works but longblobs, more than likely you simply =20=

> need to increase your max packet size in your mysql cnf file.
>
> http://www.vbulletin.com/forum/showthread.php?t=3D103786
>
> -Max
>
>
> On Jan 7, 2007, at 3:40 AM, Eric VERDIN wrote:
>
>> Hi,
>>
>> i use the new version of the framework (3.01) to store int, =20
>> varchar, float and text without problem.
>> But i can't insert an image in a longblob.
>>
>> I have an 2006 Error (MySQL server has gone away) with 4.1.22 or =20
>> 5.0.27 version.
>>
>> ****************************************
>>
>> #import <Cocoa/Cocoa.h>
>> #import <Foundation/Foundation.h>
>> #import <MCPKit_bundled/MCPResult.h>
>> #import <MCPKit_bundled/MCPConnection.h>
>>
>> int main(int argc, char *argv[])
>> {
>>
>> 	NSAutoreleasePool		*pool =3D [[NSAutoreleasePool =
alloc] init];
>> 	MCPConnection			*connection;
>> 	MCPResult				*result;
>> 	NSImage					*image;
>> 	NSData					*tiffData;
>> 	NSString				*string;
>> 	NSString				*query;
>> 	NSString				*nomFichier;
>> 	int						erreur;
>> 	NSString				*message;
>>
>> 	nomFichier =3D [[NSString alloc] initWithString:@"~/Pictures/=20
>> Berlan_1.png"];
>> 	nomFichier =3D [nomFichier stringByExpandingTildeInPath];
>> 	image =3D [[NSImage alloc] initWithContentsOfFile:nomFichier];
>> 	tiffData =3D [image TIFFRepresentation];
>> =09
>> 	connection =3D [[MCPConnection alloc] initToHost:@"localhost" =20=

>> withLogin:@"" password:@"" usingPort:0];
>> 	if (connection !=3D nil)
>> 	{
>> =09
>> 		[connection selectDB:@"test_image"];
>>
>> 		string =3D [connection prepareBinaryData:tiffData];
>> 		query =3D [[NSString alloc] initWithFormat:@"Insert into =
%@ (%@) =20
>> VALUES ('%@');",
>> 										=
		@"nomTable",
>> 										=
		@"nomColonne",
>> 										=
		tiffData];
>> 	=09
>> 		result =3D [connection queryString:query];
>> 		erreur =3D [connection getLastErrorID];
>> 		message =3D [connection getLastErrorMessage];
>> =09
>> 		[connection release];
>> 		[nomFichier release];
>> 		[query release];
>> 		[image release];
>> 		[tiffData release];
>> 		=09
>> 	}
>> =09
>> 	[pool release];
>> 	return 0;
>>
>> }
>>
>> ****************************************
>>
>> Thank you in advance for your help,
>>
>> Eric
>> ---------------------------------------------------------------------=20=

>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to =20
>> share your
>> opinions on IT & business topics through brief surveys - and earn =20
>> cash
>> http://www.techsay.com/default.php?=20
>> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV___________________________=
____=20
>> ________________
>> Mysql-cocoa-users mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>
> ----------------------------------------------------------------------=20=

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV____________________________=
____=20
> _______________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users

Re: [Mysql-cocoa-users] NSImage problem

[Max F. <ins...@ma...>]

If everything else works but longblobs, more than likely you simply  
need to increase your max packet size in your mysql cnf file.

http://www.vbulletin.com/forum/showthread.php?t=103786

-Max


On Jan 7, 2007, at 3:40 AM, Eric VERDIN wrote:

> Hi,
>
> i use the new version of the framework (3.01) to store int,  
> varchar, float and text without problem.
> But i can't insert an image in a longblob.
>
> I have an 2006 Error (MySQL server has gone away) with 4.1.22 or  
> 5.0.27 version.
>
> ****************************************
>
> #import <Cocoa/Cocoa.h>
> #import <Foundation/Foundation.h>
> #import <MCPKit_bundled/MCPResult.h>
> #import <MCPKit_bundled/MCPConnection.h>
>
> int main(int argc, char *argv[])
> {
>
> 	NSAutoreleasePool		*pool = [[NSAutoreleasePool alloc] init];
> 	MCPConnection			*connection;
> 	MCPResult				*result;
> 	NSImage					*image;
> 	NSData					*tiffData;
> 	NSString				*string;
> 	NSString				*query;
> 	NSString				*nomFichier;
> 	int						erreur;
> 	NSString				*message;
>
> 	nomFichier = [[NSString alloc] initWithString:@"~/Pictures/ 
> Berlan_1.png"];
> 	nomFichier = [nomFichier stringByExpandingTildeInPath];
> 	image = [[NSImage alloc] initWithContentsOfFile:nomFichier];
> 	tiffData = [image TIFFRepresentation];
> 	
> 	connection = [[MCPConnection alloc] initToHost:@"localhost"  
> withLogin:@"" password:@"" usingPort:0];
> 	if (connection != nil)
> 	{
> 	
> 		[connection selectDB:@"test_image"];
>
> 		string = [connection prepareBinaryData:tiffData];
> 		query = [[NSString alloc] initWithFormat:@"Insert into %@ (%@)  
> VALUES ('%@');",
> 												@"nomTable",
> 												@"nomColonne",
> 												tiffData];
> 		
> 		result = [connection queryString:query];
> 		erreur = [connection getLastErrorID];
> 		message = [connection getLastErrorMessage];
> 	
> 		[connection release];
> 		[nomFichier release];
> 		[query release];
> 		[image release];
> 		[tiffData release];
> 			
> 	}
> 	
> 	[pool release];
> 	return 0;
>
> }
>
> ****************************************
>
> Thank you in advance for your help,
>
> Eric
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users