Re: database connection missing

If you specifically want to use ZSQL Methods, then you'll need to add
Products.ZMySQLDA to your egg list. The ZSQL adapters are database-specific.

Alternatively, you can directly use MySQL-Python or use SQL Alchemy. The
downside of directly using MySQL-Python is that you won't have the
excellent database connection pooling and caching, so you may end up with
lots of connections.

If you want to script with an alternative mechanism, you'll probably need
to mark some modules as safe for scripting with restricted Python. See
https://github.com/collective/collective.localfunctions for example code
for that.


On Fri, Mar 13, 2015 at 11:41 AM, Chuck Theobald <[email protected]> wrote:

> Plone 4.3.3
>
> When trying to add a Z SQL Method, i get the message show below. Yet I
> cannot find zope sql database connection in the list of available
> elements. I've added MySQL-Python and z3c.saconfig to buildout.cfg and
> re-run buildout, but no good.
>
> My goal is to make queries to an existing database on another server to
> populate a ploneformgen selection list.
>
>
>   Add SQL Method
>
> There are no SQL database connections. You need to add a Zope SQL
> database connection before you can create a Zope SQL Method.
>
> --
> Chuck Theobald
> System Administrator
> The Robert and Beverly Lewis Center for Neuroimaging
> University of Oregon
> P: 541-346-0343
> F: 541-346-0345
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Plone-Users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/plone-users
>

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/

_______________________________________________
Plone-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/plone-users