<br><br><div class="gmail_quote">On Tue, Aug 24, 2010 at 9:55 AM, Panu Suominen <span dir="ltr"><<a href="mailto:panu.j.m.suominen@gmail.com" target="_blank">panu.j.m.suominen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
We have postgresql database using UTF-8 charset and I had problems<br>
doing queries against the database using umlaut characters.<br>
It looked like there was no character conversion done to the<br>
statements going to opendbx api. Or is it that I just did not find it?<br>
<br></blockquote><div><br>Hi and welcome!<br><br>I think there is no conversion in OpenDBX nor in SqueakDBX. <br>Anyway, I attach Norbert (OpenDBX author). Maybe he can help you with this.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
However I implemented a little fix that encodes strings going and<br>
coming from OpenDBX and mechanism that queries the<br>
encoding database uses and attaches this information to the connection.<br>
Unfortunately the charset query is currently only implemented for<br>
postgresql (show client_encoding).<br>
Where should I post these changes? Directly to squeaksource?<br></blockquote><div><br>Yes. So that I can see it. Do you know if it breaks compatibility with other databases or OS? because SqueakDBX classes like DBXConnection should be cross-backend.<br>
<br>If you want to can use another new package with your commit.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Also is there a connection pooling facility for SqueakDBX or Glorp?<br>
<font color="#888888"><br></font></blockquote><div><br>Yes, several. <br><br>-Check GlorpDBX-ConnectionPool-JohnToohey.4 in SqueakDBX repo. <br>I am not sure if he could have time to document it...but if he did I can include it in the website.<br>
<br>-GlorpSeaside is another package but I don't remember were is it.<br><br>-Ramon Leon did: <a href="http://onsmalltalk.com/making-a-connection-pool-for-glorp-in-seaside">http://onsmalltalk.com/making-a-connection-pool-for-glorp-in-seaside</a>,<br>
<br>- Esteban Lorenzano said<br>My Pool implementation can be download from here:<br><br><a href="http://www.squeaksource.com/Officious">http://www.squeaksource.com/Officious</a> (package name: Pool)<br><br>it is a very small, very simple (and probably buggy) implementation.<br>
Here are some example of it's use:<br><br><br> pool := (Pool creator: [ self createSession ])<br> maxObjects: 10;<br> maxRetries: 3;<br> waitTimeInMilliseconds: 50;<br>
yourself.<br><br> session := pool borrow.<br> ... your glorp code...<br> pool release: session.<br><br><br>Cheers<br><br>Mariano<br><br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<font color="#888888">
<br>
--<br>
Panu<br>
_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org" target="_blank">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
</font></blockquote></div><br>