- Pharo-dev - lists.pharo.org

Re: [Pharo-project] ODBC: table names and column names/types?

by Mariano Martinez Peck

You can use the native MySQL driver if you want to do what Benoit St-Jean said. SqueakDBX with MySQL doesn't work yet under Windows, but there is a lot of people asking about that, so I think we must get MySQL another round :( Is somewhere a C (under Windows) guru here? Because the problem is: I can compile OpenDBX with the MySQL client library in Windows but in runtime, when I try to run the OpenDBX tests, I have a crash :( And In windows I cannot see even the stack...If there is someone capable to help me, please send me a private email. I will really appreciate the help. Best, Mariano 2009/9/1 Benoit St-Jean <bstjean(a)yahoo.com> > Which version of MySQL? Since version 4.1, there's all you need in the > "INFORMATION_SCHEMA" database, in the "TABLES" table. But because of some > bug in 4.1, query against that database sometimes caused the server to > crash. I'd recommend that method only for 5.x and upwards. > > ----------------- > Benoit St-Jean > Yahoo! Messenger: bstjean > Blog: lamneth.wordpress.com > A standpoint is an intellectual horizon of radius zero. > (Albert Einstein) > > ------------------------------ > *From:* "Schwab,Wilhelm K" <bschwab(a)anest.ufl.edu> > *To:* "Pharo-project(a)lists.gforge.inria.fr" < > Pharo-project(a)lists.gforge.inria.fr> > *Sent:* Tuesday, September 1, 2009 6:58:49 AM > > *Subject:* Re: [Pharo-project] ODBC: table names and column names/types? > > Primarily MySQL running on Windows (Linux as soon as reasonable to do so) > accessed from both Windows and Linux. There will also be the occaisional > .mdb file. > > > ------------------------------ > *From:* pharo-project-bounces(a)lists.gforge.inria.fr [mailto: > pharo-project-bounces(a)lists.gforge.inria.fr] *On Behalf Of *Mariano > Martinez Peck > *Sent:* Tuesday, September 01, 2009 3:18 AM > *To:* Pharo-project(a)lists.gforge.inria.fr > *Subject:* Re: [Pharo-project] ODBC: table names and column names/types? > > > > On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <bschwab(a)anest.ufl.edu>wrote: > >> I looked through it in MC, but did not see anything obvious. Even then, I >> doubt it is a workable choice for me because regardles of what X and - mean >> in their doumention, one of the DBMS/OS pairs I need is not supported. >> >> > > Hi Bill! Which is the combination of your RDBMS / OS ? > > Regards from the ESUG :) > > Mariano > > > >> >> -----Original Message----- >> From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto: >> pharo-project-bounces(a)lists.gforge.inria.fr] On Behalf Of Esteban A. >> Maringolo >> Sent: Monday, August 31, 2009 6:38 PM >> To: Pharo-project(a)lists.gforge.inria.fr >> Subject: Re: [Pharo-project] ODBC: table names and column names/types? >> >> Hello Bill, >> >> 2009/8/31 Schwab,Wilhelm K <bschwab(a)anest.ufl.edu>: >> > Hello all, >> > >> > Is there anything available for Pharo that gives schema information >> about a database? >> >> Doesn't SqueakDBX do that? >> >> Regards, >> >> Esteban A. Maringolo >> >> _______________________________________________ >> Pharo-project mailing list >> Pharo-project(a)lists.gforge.inria.fr >> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project >> >> _______________________________________________ >> Pharo-project mailing list >> Pharo-project(a)lists.gforge.inria.fr >> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project >> > > > ------------------------------ > Make your browsing faster, safer, and easier with the new Internet > ExplorerÂ® 8. Optimized for Yahoo! *Get it Now for Free! *<http://downloads.yahoo.com/ca/internetexplorer/> > > _______________________________________________ > Pharo-project mailing list > Pharo-project(a)lists.gforge.inria.fr > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project >

Sept. 1, 2009

Re: [Pharo-project] ODBC: table names and column names/types?

by Benoit St-Jean

Which version of MySQL? Since version 4.1, there's all you need in the "INFORMATION_SCHEMA" database, in the "TABLES" table. But because of some bug in 4.1, query against that database sometimes caused the server to crash. I'd recommend that method only for 5.x and upwards. ----------------- Benoit St-Jean Yahoo! Messenger: bstjean Blog: lamneth.wordpress.com A standpoint is an intellectual horizon of radius zero. (Albert Einstein) ________________________________ From: "Schwab,Wilhelm K" <bschwab(a)anest.ufl.edu> To: "Pharo-project(a)lists.gforge.inria.fr" <Pharo-project(a)lists.gforge.inria.fr> Sent: Tuesday, September 1, 2009 6:58:49 AM Subject: Re: [Pharo-project] ODBC: table names and column names/types? Primarily MySQL running on Windows (Linux as soon as reasonable to do so) accessed from both Windows and Linux. There will also be the occaisional .mdb file. ________________________________ From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Mariano Martinez Peck Sent: Tuesday, September 01, 2009 3:18 AM To: Pharo-project(a)lists.gforge.inria.fr Subject: Re: [Pharo-project] ODBC: table names and column names/types? On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <bschwab(a)anest.ufl.edu> wrote: I > looked through it in MC, but did not see anything obvious. Even then, I > doubt it is a workable choice for me because regardles of what X and - mean in > their doumention, one of the DBMS/OS pairs I need is not supported. > > Hi Bill! Which is the combination of your RDBMS / OS ? Regards from the ESUG :) Mariano >-----Original Message----- >From: pharo-project-bounces(a)lists.gforge.inria.fr > [mailto:pharo-project-bounces@lists.gforge.inria.fr] > On Behalf Of Esteban A. Maringolo >Sent: Monday, August 31, 2009 6:38 > PM >To: Pharo-project(a)lists.gforge.inria.fr >Subject: > Re: [Pharo-project] ODBC: table names and column names/types? > >Hello > Bill, > >2009/8/31 Schwab,Wilhelm K <bschwab(a)anest.ufl.edu>: >> > Hello all, >> >> Is there anything available for Pharo that gives > schema information about a database? > >Doesn't SqueakDBX do > that? > >Regards, > >Esteban A. > Maringolo > >_______________________________________________ >Pharo-project > mailing list >Pharo-project(a)lists.gforge.inria.fr >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > >_______________________________________________ >Pharo-project > mailing list >Pharo-project(a)lists.gforge.inria.fr >http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > __________________________________________________________________ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.

Sept. 1, 2009

Re: [Pharo-project] ODBC: table names and column names/types?

by Benoit St-Jean

Hi, If I recall correctly, nothing was implemented in regards to getting a list of tables. But implementing a method calling the ODBC SQLTables function to get such a list shouldn't be so hard. But normally, you can get the same result by executing a SQL statement querying the catalog of the RDBMS. Which database are you using ? ----------------- Benoit St-Jean Yahoo! Messenger: bstjean Blog: lamneth.wordpress.com A standpoint is an intellectual horizon of radius zero. (Albert Einstein) ________________________________ From: "Schwab,Wilhelm K" <bschwab(a)anest.ufl.edu> To: "Pharo-project(a)lists.gforge.inria.fr" <Pharo-project(a)lists.gforge.inria.fr> Sent: Monday, August 31, 2009 9:00:05 PM Subject: Re: [Pharo-project] ODBC: table names and column names/types? I looked through it in MC, but did not see anything obvious. Even then, I doubt it is a workable choice for me because regardles of what X and - mean in their doumention, one of the DBMS/OS pairs I need is not supported. -----Original Message----- From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Esteban A. Maringolo Sent: Monday, August 31, 2009 6:38 PM To: Pharo-project(a)lists.gforge.inria.fr Subject: Re: [Pharo-project] ODBC: table names and column names/types? Hello Bill, 2009/8/31 Schwab,Wilhelm K <bschwab(a)anest.ufl.edu>: > Hello all, > > Is there anything available for Pharo that gives schema information about a database? Doesn't SqueakDBX do that? Regards, Esteban A. Maringolo _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project __________________________________________________________________ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/

Sept. 1, 2009

Re: [Pharo-project] [ANN] Smalltalks 2009 - Third Smalltalk Conference of Argentina

by csrabak＠bol.com.br

Sept. 1, 2009

[Pharo-project] [ OT] ESUG videos?

by Torsten Bergmann

Not as good as beeing there but the presentations are available here: http://vst.ensm-douai.fr/ESUG2009Media Have fun Torsten -- Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate fÃ¼r nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02

Sept. 1, 2009

Re: [Pharo-project] [ OT] ESUG videos?

by Esteban Lorenzano

cool :) On 2009-09-01 06:20:39 -0300, Damien Cassou <damien.cassou(a)gmail.com> said: > On Mon, Aug 31, 2009 at 5:13 PM, Esteban > Lorenzano<estebanlm(a)gmail.com> wrote: >> Sorry for the Off-Topic, but couldn't go to ESUG, and I'm eager to >> watch almost every presentation on it... >> Will it be possible? > > We are filming most talks.

Sept. 1, 2009

Re: [Pharo-project] Don't ask me how to reproduce this one :)

by Andrew Tween

Hi Bill, Using a freshly downloaded pharo1.0-10418-BETAdev09.08.3.image , under Windows Vista, it fails after the 19th save. (which seems to makes sense, since there are two font faces being displayed, and I know that the max number of open file handles before failure is 37. 19 x 2 = 38, which is > 37) Cheers, Andy . > From: bschwab(a)anest.ufl.edu > To: Pharo-project(a)lists.gforge.inria.fr > Date: Tue, 1 Sep 2009 07:01:53 -0400 > Subject: Re: [Pharo-project] Don't ask me how to reproduce this one :) > > > Damien, Andy, > > That's a fair question. Do we have any idea how many saves should be required to cause the failure? > > Bill > > > -----Original Message----- > From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Damien Cassou > Sent: Tuesday, September 01, 2009 4:43 AM > To: Pharo-project(a)lists.gforge.inria.fr > Subject: Re: [Pharo-project] Don't ask me how to reproduce this one :) > > On Mon, Aug 31, 2009 at 8:42 PM, Schwab,Wilhelm K<bschwab(a)anest.ufl.edu> wrote: > > I periodically see a degradation of anti-aliased fonts, and have no idea what causes it. Given my recent adventures in to startup/shutdown, I suppose it could be due to a problem there?? It seems to be triggered by saving the image w/o quitting. This recent occurance was different in that I started noting that the text in browsers looked different to me, perhaps just that the method name was not bold?? Something was not quite right, but the text still looked to be rendered well. Shortly thereafter, the full breakdown happened with everything rendered in an ugly font. It seems safe to save the image in this state, and exiting and re-loading the image fixes is. Any ideas? > > Bill, can you please tell us if Andy's fix fixes your problem? Write that on the tracker. > > Thank you > > -- > Damien Cassou > http://damiencassou.seasidehosting.st > > "Lambdas are relegated to relative obscurity until Java makes them popular by not having them." James Iry > > _______________________________________________ > Pharo-project mailing list > Pharo-project(a)lists.gforge.inria.fr > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > > _______________________________________________ > Pharo-project mailing list > Pharo-project(a)lists.gforge.inria.fr > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project _________________________________________________________________ Use Hotmail to send and receive mail from your different email accounts. http://clk.atdmt.com/UKM/go/167688463/direct/01/

Sept. 1, 2009

Re: [Pharo-project] Startup/shutdown

by Schwab,Wilhelm K

Damien, I'm still trying to figure out whether or not it should be lost :) Will do though. However, the real benefit will be to move all of the memory management to it or something like it. I am still a little surprised (or is it made suspicious by?) the fact that it appears to be possible to do with the information the image has now. Part of me wonders <somebody's gotta say it>why in the hell</somebody's gotta say it> nobody dealt with it years ago. Not having to litter code with extraneous network iniializations should be enough motivation to do something so simple, assuming it is indeed so simple. Bill -----Original Message----- From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Damien Cassou Sent: Tuesday, September 01, 2009 4:36 AM To: Pharo-project(a)lists.gforge.inria.fr Subject: Re: [Pharo-project] Startup/shutdown Hi Bill, if you don't want your code to be lost, please add it to the tracker. 2009/9/1 Schwab,Wilhelm K <bschwab(a)anest.ufl.edu>: > Andy, > > Hopefully this is the promised code. Â Getting this across town and through the layers of MS software has been interesting, to put it mildly. > > Bill > > > > _______________________________________________ > Pharo-project mailing list > Pharo-project(a)lists.gforge.inria.fr > http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project > -- Damien Cassou http://damiencassou.seasidehosting.st "Lambdas are relegated to relative obscurity until Java makes them popular by not having them." James Iry _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project

Sept. 1, 2009

Re: [Pharo-project] Don't ask me how to reproduce this one :)

by Schwab,Wilhelm K

Damien, Andy, That's a fair question. Do we have any idea how many saves should be required to cause the failure? Bill -----Original Message----- From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Damien Cassou Sent: Tuesday, September 01, 2009 4:43 AM To: Pharo-project(a)lists.gforge.inria.fr Subject: Re: [Pharo-project] Don't ask me how to reproduce this one :) On Mon, Aug 31, 2009 at 8:42 PM, Schwab,Wilhelm K<bschwab(a)anest.ufl.edu> wrote: > I periodically see a degradation of anti-aliased fonts, and have no idea what causes it. Â Given my recent adventures in to startup/shutdown, I suppose it could be due to a problem there?? Â It seems to be triggered by saving the image w/o quitting. Â This recent occurance was different in that I started noting that the text in browsers looked different to me, perhaps just that the method name was not bold?? Â Something was not quite right, but the text still looked to be rendered well. Â Shortly thereafter, the full breakdown happened with everything rendered in an ugly font. Â It seems safe to save the image in this state, and exiting and re-loading the image fixes is. Â Any ideas? Bill, can you please tell us if Andy's fix fixes your problem? Write that on the tracker. Thank you -- Damien Cassou http://damiencassou.seasidehosting.st "Lambdas are relegated to relative obscurity until Java makes them popular by not having them." James Iry _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project

Sept. 1, 2009

Re: [Pharo-project] ODBC: table names and column names/types?

by Schwab,Wilhelm K

Primarily MySQL running on Windows (Linux as soon as reasonable to do so) accessed from both Windows and Linux. There will also be the occaisional .mdb file. ________________________________ From: pharo-project-bounces(a)lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Mariano Martinez Peck Sent: Tuesday, September 01, 2009 3:18 AM To: Pharo-project(a)lists.gforge.inria.fr Subject: Re: [Pharo-project] ODBC: table names and column names/types? On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <bschwab(a)anest.ufl.edu<mailto:bschwab@anest.ufl.edu>> wrote: I looked through it in MC, but did not see anything obvious. Even then, I doubt it is a workable choice for me because regardles of what X and - mean in their doumention, one of the DBMS/OS pairs I need is not supported. Hi Bill! Which is the combination of your RDBMS / OS ? Regards from the ESUG :) Mariano -----Original Message----- From: pharo-project-bounces(a)lists.gforge.inria.fr<mailto:pharo-project-bounces@lists.gforge.inria.fr> [mailto:pharo-project-bounces@lists.gforge.inria.fr<mailto:pharo-project-bounces@lists.gforge.inria.fr>] On Behalf Of Esteban A. Maringolo Sent: Monday, August 31, 2009 6:38 PM To: Pharo-project(a)lists.gforge.inria.fr<mailto:Pharo-project@lists.gforge.inria.fr> Subject: Re: [Pharo-project] ODBC: table names and column names/types? Hello Bill, 2009/8/31 Schwab,Wilhelm K <bschwab(a)anest.ufl.edu<mailto:bschwab@anest.ufl.edu>>: > Hello all, > > Is there anything available for Pharo that gives schema information about a database? Doesn't SqueakDBX do that? Regards, Esteban A. Maringolo _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr<mailto:Pharo-project@lists.gforge.inria.fr> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project _______________________________________________ Pharo-project mailing list Pharo-project(a)lists.gforge.inria.fr<mailto:Pharo-project@lists.gforge.inria.fr> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project

Sept. 1, 2009