SqueakDBX July 2009

squeakdbx@lists.squeakfoundation.org

6 participants
9 discussions

Re: [SqueakDBX] Problem with Czech characters
by Mariano Martinez Peck 20 Jul '09

20 Jul '09

On Mon, Jul 20, 2009 at 8:50 AM, Michal Perutka <michal.perutka(a)gmail.com>wrote: > Hi, > > I have solved my problem - I installed full Oracle Client (with Czech > language support :), unzipping Oracle Instant Client simply wasn't enough. Michal: I am glad you solved the problem :) > > > *"Did you have any problem?" > * > Yes, I had troubles with building OpenDBX from source (with MinGW and MSYS) > - I couldn't get liboraclebackend-1.dll (and still can't - only > libopendbx-1.dll and libopendbxplus-1.dll). I am interesting to know which is the real problem. I mean, a lot of people want to use dll directly as you finally did but I want to identify the problems when compiling. If you read this link: http://wiki.squeak.org/squeak/6129 and this: http://www.assembla.com/spaces/Proyecto-Proyecto/documents/cW1J8Mx40r3Rq-eJ… you will se that in the pdf I describe all the things I did to compile Oracle. If you have a couple of minutes, could you try it? If it doesn't work, can you tell which was the problem? For what you said I imagined you could do ./configure, make and make install but the liboraclebackend-1.dll wasn't generated. If this is the case, send us the output of ./configure, make and make install. Thanks! Mariano > But I solved this by downloading Windows DLLs from OpenDBX web pages. > > Anyway, thank you very much. > > Michal > > 2009/7/19 Mariano Martinez Peck <marianopeck(a)gmail.com> > > >> >> On Sat, Jul 18, 2009 at 7:24 PM, Michal Perutka <michal.perutka(a)gmail.com >> > wrote: >> >>> Hello, >>> >>> I started to test SqueakDBX yesterday (Squeak 3.10.2, OpenDBX 1.4.1, >>> Windows XP, Oracle DB) and finally I was able to get my first result set: >>> >> >> Hi! Welcome to SqueakDBX. We hope we can help you :) >> You say "and finally I was able to get my first result". Did you have any >> problem? We would love to know it so that to fix it or at least to document >> it. We want to make our wiki the most useful possible. >> >> > >> >> >>> >>> connectionSettings := DBXConnectionSettings >>> host: 'oracledb2.srs.cz' >>> port: '1521' >>> database: 'ISMON' >>> userName: 'xxx' >>> userPassword: 'xxx'. >>> >>> conn := DBXConnection >>> platform: DBXOraclePlatform new >>> settings: connectionSettings. >>> >>> conn connect. >>> conn open. >>> result := conn execute: 'select name from users order by name'. >>> DBXTranscript show: result. >>> conn close. >>> conn disconnect. >>> >>> But I have two problems: >>> - all czech characters are converted to ASCII (diacritical marks are >>> removed) >> >> >> mmmmm I have a couple of cuestions about this: >> >> 1) The database is also in a Windows? or other OS ? >> >> 2) Can you send me an example of those czech characters ? perhaps a record >> of the user table? >> >> 3) I remember that in Oracle you can specify the encoding of the database. >> which is the encoding of the one you are trying to use? >> >> 4) Can you perfectly send queries and inserts using czech characters >> using a SQL client like sqlplus or SLQDeveloper ? >> >> >> >>> >>> - order of names is bad >>> >> >> This is weird. Cannot do it right now, but in case we don't have a unit >> test for this, I will do it and see if I can reproduce it here. If there is >> a bug, it will be fixed :) >> > >> >>> >>> Does SqueakDBX support national character sets and sorting ? >> >> >> Sorting for sure. Perhaps there is a little bug but this is supported. >> >> National character, I have to investigate it a bit. There are several >> "things" here: >> >> - Database support >> - Native C client library support >> - OpenDBX >> - Squeak has a lot of problems with encoding yet >> - SqueakDBX >> >> However, my latin amercian characters like: >> >> 'éçèéçè', >> 'éçèéçèéçèéçè', ' >> 'äöüäöü' >> 'äöüäöüäöüäöü' >> >> are working well. >> >> When you answer me your questions I can ask openDBX author and also make >> some tests. >> >> Best, >> >> Mariano >> >> >> >> >>> >>> Michal >>> >>> >>> _______________________________________________ >>> SqueakDBX mailing list >>> SqueakDBX(a)lists.squeakfoundation.org >>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx >>> >>> >> >

1 0

Re: [SqueakDBX] Problem with Czech characters
by Michal Perutka 20 Jul '09

20 Jul '09

Hi, and thanks. I installed full Oracle Client (with Czech language support) and now I have in register NLS_LANG=CZECH_CZECH REPUBLIC.EE8MSWIN1250. And it works. Of course, in Squeak I have to convert from CP1250. Michal 2009/7/19 Germán Palacios <gfpalacios(a)gmail.com> Hi Michal,I think that you have an oracle configuration problem. Make sure > that your window register have: > NLS_NCHAR_CHARACTERSET UTF8 > NS_LANG AMERICAN_AMERICA.UTF8 > > see this site: > http://www.orafaq.com/forum/t/54946/0/ > > > > On Sat, Jul 18, 2009 at 19:24, Michal Perutka <michal.perutka(a)gmail.com>wrote: > >> Hello, >> >> I started to test SqueakDBX yesterday (Squeak 3.10.2, OpenDBX 1.4.1, >> Windows XP, Oracle DB) and finally I was able to get my first result set: >> >> connectionSettings := DBXConnectionSettings >> host: 'oracledb2.srs.cz' >> port: '1521' >> database: 'ISMON' >> userName: 'xxx' >> userPassword: 'xxx'. >> >> conn := DBXConnection >> platform: DBXOraclePlatform new >> settings: connectionSettings. >> >> conn connect. >> conn open. >> result := conn execute: 'select name from users order by name'. >> DBXTranscript show: result. >> conn close. >> conn disconnect. >> >> But I have two problems: >> - all czech characters are converted to ASCII (diacritical marks are >> removed) >> - order of names is bad >> >> Does SqueakDBX support national character sets and sorting ? >> >> Michal >> >> >> _______________________________________________ >> SqueakDBX mailing list >> SqueakDBX(a)lists.squeakfoundation.org >> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx >> >> > > > -- > Germán >

1 0

Re: [SqueakDBX] Problem with Czech characters
by Michal Perutka 20 Jul '09

20 Jul '09

Hi, I have solved my problem - I installed full Oracle Client (with Czech language support :), unzipping Oracle Instant Client simply wasn't enough. *"Did you have any problem?" * Yes, I had troubles with building OpenDBX from source (with MinGW and MSYS) - I couldn't get liboraclebackend-1.dll (and still can't - only libopendbx-1.dll and libopendbxplus-1.dll). But I solved this by downloading Windows DLLs from OpenDBX web pages. Anyway, thank you very much. Michal 2009/7/19 Mariano Martinez Peck <marianopeck(a)gmail.com> > > On Sat, Jul 18, 2009 at 7:24 PM, Michal Perutka <michal.perutka(a)gmail.com>wrote: > >> Hello, >> >> I started to test SqueakDBX yesterday (Squeak 3.10.2, OpenDBX 1.4.1, >> Windows XP, Oracle DB) and finally I was able to get my first result set: >> > > Hi! Welcome to SqueakDBX. We hope we can help you :) > You say "and finally I was able to get my first result". Did you have any > problem? We would love to know it so that to fix it or at least to document > it. We want to make our wiki the most useful possible. > > > > >> >> connectionSettings := DBXConnectionSettings >> host: 'oracledb2.srs.cz' >> port: '1521' >> database: 'ISMON' >> userName: 'xxx' >> userPassword: 'xxx'. >> >> conn := DBXConnection >> platform: DBXOraclePlatform new >> settings: connectionSettings. >> >> conn connect. >> conn open. >> result := conn execute: 'select name from users order by name'. >> DBXTranscript show: result. >> conn close. >> conn disconnect. >> >> But I have two problems: >> - all czech characters are converted to ASCII (diacritical marks are >> removed) > > > mmmmm I have a couple of cuestions about this: > > 1) The database is also in a Windows? or other OS ? > > 2) Can you send me an example of those czech characters ? perhaps a record > of the user table? > > 3) I remember that in Oracle you can specify the encoding of the database. > which is the encoding of the one you are trying to use? > > 4) Can you perfectly send queries and inserts using czech characters using > a SQL client like sqlplus or SLQDeveloper ? > > > >> >> - order of names is bad >> > > This is weird. Cannot do it right now, but in case we don't have a unit > test for this, I will do it and see if I can reproduce it here. If there is > a bug, it will be fixed :) > > >> >> Does SqueakDBX support national character sets and sorting ? > > > Sorting for sure. Perhaps there is a little bug but this is supported. > > National character, I have to investigate it a bit. There are several > "things" here: > > - Database support > - Native C client library support > - OpenDBX > - Squeak has a lot of problems with encoding yet > - SqueakDBX > > However, my latin amercian characters like: > > 'éçèéçè', > 'éçèéçèéçèéçè', ' > 'äöüäöü' > 'äöüäöüäöüäöü' > > are working well. > > When you answer me your questions I can ask openDBX author and also make > some tests. > > Best, > > Mariano > > > > >> >> Michal >> >> >> _______________________________________________ >> SqueakDBX mailing list >> SqueakDBX(a)lists.squeakfoundation.org >> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx >> >> >

1 0

Problem with Czech characters
by Michal Perutka 19 Jul '09

19 Jul '09

Hello, I started to test SqueakDBX yesterday (Squeak 3.10.2, OpenDBX 1.4.1, Windows XP, Oracle DB) and finally I was able to get my first result set: connectionSettings := DBXConnectionSettings host: 'oracledb2.srs.cz' port: '1521' database: 'ISMON' userName: 'xxx' userPassword: 'xxx'. conn := DBXConnection platform: DBXOraclePlatform new settings: connectionSettings. conn connect. conn open. result := conn execute: 'select name from users order by name'. DBXTranscript show: result. conn close. conn disconnect. But I have two problems: - all czech characters are converted to ASCII (diacritical marks are removed) - order of names is bad Does SqueakDBX support national character sets and sorting ? Michal

3 3

[Q] Binary package for plugin?
by "S.J.Chun" 08 Jul '09

08 Jul '09

Hi, are there any prebuilt binary packages for squeakdbx plugin? (especially for linux and windows) thanks in advance.

4 4

OpenDBX vs ODBC / MsSQLServer
by Claudio Campos 07 Jul '09

07 Jul '09

Dear Mariano, What are the advantages of OpenDBX vs ODBC? How is the integration with Pharo? Glorp? Are there examples for ms sql server ? Thanks in advance, Claudio Campos

2 1

Re: Re: [SqueakDBX] SqueakDBX Error(Cannot use integer as pointer)
by Mariano Martinez Peck 07 Jul '09

07 Jul '09

Excellent! Just to know....which OS do you use? did you compile it or use the binaries? Cheers, Mariano On Mon, Jul 6, 2009 at 10:21 PM, "S.J.Chun" <chunsj(a)embian.com> wrote: > Thank you, it works now :)

1 0

Re: Re: [SqueakDBX] SqueakDBX Error(Cannot use integer as pointer)
by "S.J.Chun" 07 Jul '09

07 Jul '09

Thank you, it works now :)

1 0

SqueakDBX Error(Cannot use integer as pointer)
by "S.J.Chun" 07 Jul '09

07 Jul '09

Hi, I've tested with squeak 3.10.2 with ffi and squeakdbx 1.0 but encountered following error: Cannot use integer as pointer at apiInitialize: handle backend: backend host: host port: port which seems to related with FFI. My test code is; | cs c | cs _ DBXConnectionSettings host: 'localhost' port: 3306 database: 'test' userName: 'root' userPassword: 'test'. c _ DBXConnection platform: DBXSqlitePlatform new settings: cs. c connect. c open. c close. c disconnect.

2 2

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX July 2009