[CPS-users] Adding contacts database

[Georges Racinet]

Le 22 janv. 2007, à 20:12, Mário Valente a écrit :

>
>
>   OK, I'm now using DB2 on the portuguese
>  Ministry of Justice mainframe, running on z/OS.
>
>   Can you help with the original problem/question?

This is much tougher. The only solution I've heard of is the following:

Assuming IBM does provide an ODBC driver for the platform you run CPS 
on (don't know about z/OS, the iSeries version is the only one I used), 
then you can configure an ODBC driver manager and access the driver 
manager through egenix' Zope mxODBC DA's adapter. You should end up 
with a connector object to which you can bind a CPS SQLDirectory. You 
should perhaps experiment this last part with something easier, like 
the one Florent suggested, or postgresql with 
http://wiki.zope.org/zope2/ZPsycopgDA.

Remarks:
  - if you have no experience in the ODBC world, try and have someone 
who does help you for this part. Error codes are completely obscure 
(google is your friend but you have to be patient)
  - I didn't try the Zope DA adapter, and relied instead on pure mxODBC 
python library, since my needs were somewhat simpler (vocabularies 
extracted from the DB). Both are commercial products (per Zope instance 
licence for the former)
  - the iSeries access ODBC driver comes with a version of unixODBC. I 
could'nt get mxODBC to hook to iODBC in that context, but had success 
with unixODBC, after I had upgraded the provided one to a more recent 
version.
  - don't forget to configure the charset.

>   Thanks.

Well, lots of work, good luck !

PS: check egenix and unixODBC mailing-lists, as obviously ODBC 
discussions don't belong here.


>
>   -- MV
>
>
> -----Mensagem original-----
> De: Florent Guillaume [mailto:fg at nuxeo.com]
> Enviada: sábado, 20 de Janeiro de 2007 21:27
> Para: Mário Valente
> Cc: cps-users at lists.nuxeo.com
> Assunto: Re: [CPS-users] Adding contacts database
>
> On 17 Jan 2007, at 14:49, Mário Valente wrote:
>> On 1/12/07, Mário Valente <mvalente at itij.mj.pt> wrote:
>>>>   Right. Why should I need an aditional piece of software to
>>>> manage?
>>>
>>> Well, if you want to store it in an SQL database, then you need an
>>> SQL database to store it in.
>>
>>   Thats why I'm using Gadfly. Within Zope.
>
> Please be aware that Gadly is a "toy" database, putting things in 
> memory, without concurrency and with very limited SQL support compared 
> to the standard. And it's slow. Its only advantaged is that it's only 
> coded in python so doesn't require any external setup.
>
> You'd be better off using at least sqlite, which is "light" but much 
> more serious and efficient.
> There's a Zope DA for it (untested by ourselves), http://www.zope.org/ 
> Members/nakagami/ZSQLiteDA
>
> Florent
>
>
> --
> Florent Guillaume, Director of R&D, Nuxeo Open Source Enterprise 
> Content Management (ECM)
> http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87
>
>
>
>
>
> _______________________________________________
> cps-users mailing list
> cps-users at lists.nuxeo.com
> http://lists.nuxeo.com/mailman/listinfo/cps-users
>