At startup do you get: zxJDBC support is experimental or no zxJDBC driver or None.
Did you install the zxJDBC sqlite driver? It does not come with Jython. On Jun 23, 3:41 pm, Richard <[email protected]> wrote: > Hi Massimo, > > this is my setup: > > - latest stable web2py version R-1.96.4 (hg commit #2032), clean > checkout from repo > - Jython 2.5.2 > - set CLASSPATH=\path\to\jar\sqlitejdbc-v056.jar;%CLASSPATH% > - jython web2py.py -a pwd --nogui -p80 -f \path\to\web2py-src-dir > > This is the console output: > > No handlers could be found for logger "web2py.dal" > New installation: unable to create welcome.w2p fileweb2py Web > Framework > Created by Massimo Di Pierro, Copyright 2007-2011 > Version 1.96.4 (2011-06-07 15:03:19) > Database drivers available: pymysql, zxJDBC > Starting hardcron... > WARNING:web2py.cron:WEB2PY CRON: Disabled because no file locking > please visit: > http://127.0.0.1:80 > use "kill -SIGTERM 2808" to shutdown the web2py server > WARNING:web2py.cron:WEB2PY CRON: Disabled because no file locking > WARNING:web2py.cron:WEB2PY CRON: Disabled because no file locking > WARNING:web2py.cron:WEB2PY CRON: Disabled because no file locking > ... > > When accessing the welcome app via browser, I get this: > > Internal error > Ticket issued: unrecoverable > > ... and this shows up in the console: > > ERROR:web2py:Traceback (most recent call last): > File "c:\_work\_in\web2py\gluon\restricted.py", line 192, in > restricted > exec ccode in environment > File "c:\_work\_in\web2py\applications\welcome\models/db.py", line > 17, in <module> > db = DAL('sqlite://storage.sqlite') # if not, use SQLite or > other DB > File "c:\_work\_in\web2py\gluon\dal.py", line 3901, in __init__ > raise RuntimeError, "Failure to connect, tried %d times:\n%s" % > (attempts, error) > RuntimeError: Failure to connect, tried 5 times: > 'com.ziclix.python.sql.PyConnection' object has no attribute > 'create_function' > > I doesn't matter whether the OS is Linux or Windows XP. It does matter > whether it is Jython or Python, though. > > IMO the following three lines from the startup console output require > attention: > - No handlers could be found for logger "web2py.dal" > - New installation: unable to create welcome.w2p fileweb2py Web > Framework > - WARNING:web2py.cron:WEB2PY CRON: Disabled because no file locking > > I've debugged a little bit into the origins of the second line. The > root cause is still clear as mud to me, but I could give some hints. > > Regards, > Richard
