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 (?) I am using: MySQL-4.1.12-3.3.20060mdk, tomcat5-5.0.30-9.1mdk mysql-connector-java-3.0.11-1jpp (tried differed versions, but it didn't help) Any ideas ? 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. regards, -- Lukasz Engel _______________________________________________ swamp-devel mailing list swamp-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/swamp-devel http://swamp.sf.net
