summaryrefslogtreecommitdiff
path: root/connectivity
diff options
context:
space:
mode:
authorLionel Elie Mamane <lionel@mamane.lu>2013-12-17 12:14:15 +0100
committerLionel Elie Mamane <lionel@mamane.lu>2013-12-17 12:16:24 +0100
commitedbbc471bcd9db9b366c32e9d16d965460cd3960 (patch)
treeb3340aad032c37d06aeb6c4ebbf6fdf031dfba49 /connectivity
parent9203ae338fdbcaf614be8436172e05a24fd7d754 (diff)
HSQLDB: correct syntax of change password from MySQL to HSQLDB
Change-Id: Iacf60c456912f2e38c7a082e48c45164e79c1097
Diffstat (limited to 'connectivity')
-rw-r--r--connectivity/source/drivers/hsqldb/HUser.cxx9
1 files changed, 6 insertions, 3 deletions
diff --git a/connectivity/source/drivers/hsqldb/HUser.cxx b/connectivity/source/drivers/hsqldb/HUser.cxx
index 0dfcd2cefa30..e1c2a757d64a 100644
--- a/connectivity/source/drivers/hsqldb/HUser.cxx
+++ b/connectivity/source/drivers/hsqldb/HUser.cxx
@@ -272,10 +272,13 @@ void SAL_CALL OHSQLUser::changePassword( const OUString& /*oldPassword*/, const
Reference<XDatabaseMetaData> xMeta = m_xConnection->getMetaData();
- OUString sAlterPwd = "SET PASSWORD FOR " +
- ::dbtools::quoteName(xMeta->getIdentifierQuoteString(), m_Name) +
- "@\"%\" = PASSWORD('" + newPassword + "')";
+ if( m_Name != xMeta->getUserName() )
+ {
+ ::dbtools::throwGenericSQLException("HSQLDB can only change password of the current user.", *this);
+ }
+ OUString sAlterPwd = "SET PASSWORD " +
+ ::dbtools::quoteName(xMeta->getIdentifierQuoteString(), newPassword);
Reference<XStatement> xStmt = m_xConnection->createStatement();
if ( xStmt.is() )