On Nov 28, 12:48 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > In gluon/sql.py there are these lines: > > try: > from com.ziclix.python.sql import zxJDBC > import java.sql > from org.sqlite import JDBC > drivers.append('zxJDBC') > logger.warning('zxJDBC support is experimental') > is_jdbc = True > except: > logger.debug('no zxJDBC driver') > is_jdbc = False > > somehow the exception is raised.
I see the message 'zxJDBC support is experimental' printed at the console. I don't know why but now I have a different error: Traceback (most recent call last): File "/media/pierreth-backup/work/web2py/gluon/main.py", line 425, in wsgibase serve_controller(request, response, session) File "/media/pierreth-backup/work/web2py/gluon/main.py", line 425, in wsgibase serve_controller(request, response, session) File "/media/pierreth-backup/work/web2py/gluon/main.py", line 187, in serve_controller run_models_in(environment) File "/media/pierreth-backup/work/web2py/gluon/compileapp.py", line 351, in run_models_in restricted(code, environment, layer) File "/media/pierreth-backup/work/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/media/pierreth-backup/work/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/media/pierreth-backup/work/web2py/applications/welcome/models/ db.py", line 15, in <module> db = DAL('sqlite://storage.sqlite') # if not, use SQLite or other DB File "/media/pierreth-backup/work/web2py/gluon/sql.py", line 4064, in DAL return SQLDB(uri, pool_size=pool_size, folder=folder, File "/media/pierreth-backup/work/web2py/gluon/sql.py", line 4064, in DAL return SQLDB(uri, pool_size=pool_size, folder=folder, File "/media/pierreth-backup/work/web2py/gluon/sql.py", line 1211, in __init__ self._pool_connection(lambda dbpath=dbpath: zxJDBC.connect(java.sql.DriverManager.getConnection('jdbc:sqlite:'+dbpath))) File "/media/pierreth-backup/work/web2py/gluon/sql.py", line 893, in _pool_connection self._connection = f() File "/media/pierreth-backup/work/web2py/gluon/sql.py", line 1211, in <lambda> self._pool_connection(lambda dbpath=dbpath: zxJDBC.connect(java.sql.DriverManager.getConnection('jdbc:sqlite:'+dbpath))) SQLException: java.sql.SQLException: No suitable driver found for jdbc:sqlite:/media/pierreth-backup/work/web2py/applications/welcome/ databases/ge.sqlite The file '/media/pierreth-backup/work/web2py/applications/welcome/ databases/ge.sqlite' does not exists in the directory.