"BB" == Brian Burton <Brian.Burton@nlynx.com> writes:
BB> Has anyone come up with a way to access a JDBC driver from BB> Zope? I have since several JPython solutions but I don't see BB> a way of executing JPython from Zope. Would the best way be BB> to write a Zope/Python DA that opens sockets to a JPython or BB> Java servlet that then talks to the JDBC driver? Sounds like BB> a bit of work. I bet it would be easier than you think. There are at least 2 python DB API compliant interfaces to JDBC that I know of. So you should be able to write a generic python/jpython server that talks to a DB API and returns the results to the client. This is similar to how sqlrelay works. I think you should even be able to send pickles of the data retults over the socket - because as far as I know jpython and python use the same pickle code. I would bet that it is gonna be god awful slow. Might be good enough for small return sets though. ^Roman