zxJDBC |
Database Connectivity in JPython |
|
What is zxJDBC?The zxJDBC package provides a nearly 100% Python DB API 2.0 compliant interface for database connectivity in JPython. It is implemented entirely in Java and makes use of the JDBC API. This means any database capable of being accessed through JDBC, either directly or using the ODBC-JDBC bridge, can be manipulated using zxJDBC.I originally started writing zxJDBC because I was tired of not having database connectivitiy from within JPython. I was used to the mxODBC package and really wanted the same level of functionality within Java. I started by implementing as closely as possible the Python DB API and then extended it with the features of the mxODBC package I used most frequently, until I implemented almost all of the same features. I tried to follow the same naming convention as mxODBC so scripts could execute in either C or JPython without concern to the implementation language. Where I have deviated from mxODBC has been an oversight on my part. In the process, I also learned a tremendous amount about how the JPython runtime works. I want to take this opportunity to thank all who have worked on it because I can't imagine developing without it! Above all else, I want to here if this package is useful. It's been incredibly useful for me, so please feel free to email me with questions or suggestions at bzimmer@ziclix.com |