Lukasz Engel wrote: > Hi all, > > I am trying to run swamp 1.5 on Mandriva 2006. > (I've built and installed rpm based on slightly modified suse srpm) > I have encountered strange problem, probably not in swamp itself, but I > am not J2EE/tomcat/etc guru and don't know where to ask... > > Swamp starts, but when I enter login/password (corrent values) on login > form, login fails and in logs I can see: > > 20.06 12:21:12 [ERROR] Login Error: java.sql.SQLException: Syntax error > or access violation, message from server: "You have an > error in your SQL syntax; check the manual that corresponds to your > MySQL server version for the right syntax to use near '12:21:11, > LAST_LOGIN = 2006-06-20 12:21:11, PERMSTORAGE = '' WHERE USER_ID = 1' at > line 1" > 20.06 12:21:12 [ERROR] ************************************************ > 8<---------------------- > No other errors in logs. > This happens after successfull password check (wrong user or password > case does not generate error above) > I am using default (mysql database) SWAMP user storage. > It looks like somewhere-generated-SQL doesn't quote datetime values and > this confuses mysql server (?)
It seems that the datetime value gets written unquoted in the SQL statement which is not valid I think. Could you please try with the just released SWAMP 1.5.1 which comes with its own mysql-connector version 3.1.12. > BTW. village package provided in swamp sources required oracle JDBC (?!) > classes, until I installed them I had unresolved oracle.sql.CLOB class ... > I've checked and the only place in tomcat any DB is configured is > webswamp database set as mysql, no references to oracle. This has not been a problem here, but I removed the oracle patch from the village lib included in the latest release. So it should be fixed. Greetings -- Thomas Schmidt (tschmidt [at] suse.de) SUSE Linux Products GmbH :: Research & Development :: Internal Tools "Computers are useless. They can only give you answers.", Pablo Picasso _______________________________________________ swamp-devel mailing list swamp-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/swamp-devel http://swamp.sf.net
