Author: ngn
Date: Thu Jan 22 04:30:01 2009
New Revision: 736622
URL: http://svn.apache.org/viewvc?rev=736622&view=rev
Log:
Removing quotes around booleans to make statements work on some databases (like
MySQL)
Modified:
mina/ftpserver/trunk/core/src/test/java/org/apache/ftpserver/usermanager/impl/DbUserManagerTest.java
mina/ftpserver/trunk/distribution/res/conf/ftpd-full.xml
Modified:
mina/ftpserver/trunk/core/src/test/java/org/apache/ftpserver/usermanager/impl/DbUserManagerTest.java
URL:
http://svn.apache.org/viewvc/mina/ftpserver/trunk/core/src/test/java/org/apache/ftpserver/usermanager/impl/DbUserManagerTest.java?rev=736622&r1=736621&r2=736622&view=diff
==============================================================================
---
mina/ftpserver/trunk/core/src/test/java/org/apache/ftpserver/usermanager/impl/DbUserManagerTest.java
(original)
+++
mina/ftpserver/trunk/core/src/test/java/org/apache/ftpserver/usermanager/impl/DbUserManagerTest.java
Thu Jan 22 04:30:01 2009
@@ -63,9 +63,9 @@
manager.setDataSource(ds);
manager
- .setSqlUserInsert("INSERT INTO FTP_USER (userid, userpassword,
homedirectory, enableflag, writepermission, idletime, uploadrate, downloadrate,
maxloginnumber, maxloginperip) VALUES ('{userid}', '{userpassword}',
'{homedirectory}', '{enableflag}', '{writepermission}', {idletime},
{uploadrate}, {downloadrate}, {maxloginnumber}, {maxloginperip})");
+ .setSqlUserInsert("INSERT INTO FTP_USER (userid, userpassword,
homedirectory, enableflag, writepermission, idletime, uploadrate, downloadrate,
maxloginnumber, maxloginperip) VALUES ('{userid}', '{userpassword}',
'{homedirectory}', {enableflag}, {writepermission}, {idletime}, {uploadrate},
{downloadrate}, {maxloginnumber}, {maxloginperip})");
manager
- .setSqlUserUpdate("UPDATE FTP_USER SET
userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag='{enableflag}',writepermission='{writepermission}',idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate},maxloginnumber={maxloginnumber},
maxloginperip={maxloginperip} WHERE userid='{userid}'");
+ .setSqlUserUpdate("UPDATE FTP_USER SET
userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag={enableflag},writepermission={writepermission},idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate},maxloginnumber={maxloginnumber},
maxloginperip={maxloginperip} WHERE userid='{userid}'");
manager
.setSqlUserDelete("DELETE FROM FTP_USER WHERE userid =
'{userid}'");
manager
Modified: mina/ftpserver/trunk/distribution/res/conf/ftpd-full.xml
URL:
http://svn.apache.org/viewvc/mina/ftpserver/trunk/distribution/res/conf/ftpd-full.xml?rev=736622&r1=736621&r2=736622&view=diff
==============================================================================
--- mina/ftpserver/trunk/distribution/res/conf/ftpd-full.xml (original)
+++ mina/ftpserver/trunk/distribution/res/conf/ftpd-full.xml Thu Jan 22
04:30:01 2009
@@ -61,11 +61,11 @@
<insert-user>INSERT INTO FTP_USER (userid, userpassword,
homedirectory, enableflag, writepermission, idletime,
uploadrate,
downloadrate) VALUES ('{userid}', '{userpassword}',
'{homedirectory}',
- '{enableflag}', '{writepermission}', {idletime},
{uploadrate},
+ {enableflag}, {writepermission}, {idletime},
{uploadrate},
{downloadrate})
</insert-user>
<update-user>UPDATE FTP_USER SET
-
userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag='{enableflag}',writepermission='{writepermission}',idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate}
+
userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag={enableflag},writepermission={writepermission},idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate}
WHERE userid='{userid}'
</update-user>
<delete-user>DELETE FROM FTP_USER WHERE userid = '{userid}'
