<br><br><div class="gmail_quote">On Tue, May 19, 2009 at 11:09 AM, Stefan Izota <span dir="ltr"><<a href="mailto:stefan.izota@gmail.com">stefan.izota@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Mariano,<br>
<br>
I did not find any SqueakDBX mailing list so I decided to mail you a small problem I have.<br>
</blockquote><div><br>No, we don't have our own mailing list, but I think sending your question to squeak-dev or pharo list is ok.<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I tried to test SqueakDBX on latest Squeak (3.10.2-7179) and Pharo (10309 updated to 10310) images. I also used the latest VMs.<br>
I compiled postgreSQL and SQLite back-ends on Windows XP using MinGW.<br>
The dll-s resulted are: libopendbx-1.dll, libopendbxplus-1.dll, libpgsqlbackend-1.dll, libsqlite3backend-1.dll. I copied them to the VMs directories.<br>
<br>
For postgreSQL i used:<br>
<br>
| conn connectionSettings result aRow |<br>
connectionSettings := DBXConnectionSettings<br>
host: 'localhost'<br>
port: '5432'<br>
database: 'StDatabase'<br>
userName: 'postgres'<br>
userPassword: 'akimbo'.<br>
conn := DBXConnection platform: DBXPostgresPlatform new settings: connectionSettings.<br>
conn connect.<br>
conn open.<br>
<br>
result := conn execute: 'insert into sttask (taskname) VALUES (''stefan'') '.<br>
result := conn execute: 'select * from stuser'.<br>
aRow := result nextRow.<br>
aRow inspect.<br>
<br>
conn close.<br>
conn disconnect.<br>
<br>
and everything worked fine.</blockquote><div><br><br>I am glad to know it is working :)<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
For SQLite i used:<br>
<br>
| conn connSettings result rows |<br>
<br>
connSettings := DBXConnectionSettings new<br>
host: 'D:\sqlite\db\';<br>
database: 'test.db'.<br>
<br>
connSettings inspect.<br>
<br>
conn := DBXConnection<br>
platform: DBXSqlitePlatform new<br>
settings: connSettings.<br>
conn connect.<br>
conn open.<br>
<br>
result := conn execute: 'select * from users'.<br>
rows := result rows.<br>
rows inspect.<br>
<br>
conn close.<br>
conn disconnect.<br>
<br>
and I got DBXFatalError: FATAL OpenDBX: Operation is not available (on both images).<br>
</blockquote><div><br><br>Yes. This is a bug I discover in OpenDBX. Norbert (the author) has fix it and comitted in SVN. So, you can do two things:<br><br>1) checkout from svn: <a href="https://libopendbx.svn.sourceforge.net/svnroot/libopendbx/trunk/">https://libopendbx.svn.sourceforge.net/svnroot/libopendbx/trunk/</a><br>
And compile again as you did the first time. This fix will be then in OpenDBX 1.4.1 (which is not released yet)<br><br>2) I will send you the dll I compile by myself if you want it. <br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I can open/modifiy the SQLite db using <a href="http://sqliteadmin.orbmu2k.de/" target="_blank">http://sqliteadmin.orbmu2k.de/</a> just fine.<br>
<br>
Do you have any idea what am I doing wrong?</blockquote><div><br>Nothing. Your code is perfect. Our fault. <br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
Regards,<br><font color="#888888">
Stefan</font></blockquote><div><br><br>I hope this helps.<br><br>Mariano <br></div></div><br>