[Z3-sqlos] sqlos and mysqldbda

[Fabio Tranchitella]

* 2007-02-19 07:39, Sam Young wrote:
> Hi,

Hi!

> Now, when I try to integrate my app (simple object, simple container)
> I'm getting the following after adding a new container in ZMI. When I
> try to get the sampleapp working again, I get a similar error during
> table creation. If I'm not mistaken, the check for need_unicode is
> part of SQLObject. The "self" in self.need_unicode is seemingly being
> called on MySQLAdapter in sqlos, causing the error.

MySQLAdapter shouldn't be used directly by SQLObject objects, but instead
they should use a ConnectionDescriptor descriptor which will map those
attribute look-ups to the inner object, the mysqldbda instance.

> Has anyone seen this before? I'm glad to provide more information from
> configuration or the classes themselves.

If you could isolate your problem in a sample application, then I could
debug it locally to understand where the problem is. I remember that
I had the very same error sometime ago and it was a configuration error,
but I do not remember what was wrong exactly.

> I hear PostgreSQL is easier to integrate with sqlos, but I'm not sure
> that will be an option in my case.

I think sqlos is quite database agnostic, it is just that usually the
postgresql integration is more tested than the MySQL one.

Thanks,

-- 
Fabio Tranchitella                         http://www.kobold.it
Free Software Developer and Consultant     http://www.tranchitella.it
_____________________________________________________________________
1024D/7F961564, fpr 5465 6E69 E559 6466 BF3D 9F01 2BF8 EE2B 7F96 1564