Re: [Jython-users] zxJDBC Question

[Chris C. <Chr...@in...>]

Jeff Levesque wrote:
> I've written an API in Python that works in both CPython for scripting 
> and Jython in combination with a GWT front end but I'm having issues 
> with some database results. It seems like something is caching the 
> database results when I'm using Jython. I've read through the 
> ConnectorJ documentation and tried disabling all the caching options I 
> could but it doesn't seem to have made any difference. Is it possible 
> zxJDBC is caching the results or just not passing options I set to 
> JDBC? Any help would be much appreciated.

It is more likely to be the JDBC driver (or dbms) doing the caching than 
zxjdbc (I've not seen zxjdbc do any caching, with defaults).

Can you switch drivers/backends to test that idea out? You could for 
instance be doing repeatable reads (transactions) or some other DBMS 
specific (rather than zxjdbc) thing.

Making a small 10 line script test case is your best bet.

Chris