[exo-jcr-commits] exo-jcr SVN: r1772 - jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/config.
Author: tolusha
Date: 2010-02-12 06:29:46 -0500 (Fri, 12 Feb 2010)
New Revision: 1772
Modified:
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/config/JDBCConfigurationPersister.java
Log:
EXOJCR-489: change field type form VARBINARY to IMAGE for Sybase & translate to
uppercase filed NAME in query
Modified:
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/config/JDBCConfigurationPersister.java
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/config/JDBCConfigurationPersister.java 2010-02-12
10:25:59 UTC (rev 1771)
+++
jcr/trunk/exo.jcr.component.core/src/main/java/org/exoplatform/services/jcr/impl/config/JDBCConfigurationPersister.java 2010-02-12
11:29:46 UTC (rev 1772)
@@ -173,7 +173,7 @@
}
else if (DBConstants.DB_DIALECT_SYBASE.equalsIgnoreCase(dialect))
{
- binType = "VARBINARY(255)";
+ binType = "IMAGE";
}
else if (DBConstants.DB_DIALECT_INGRES.equalsIgnoreCase(dialect))
{
@@ -270,7 +270,7 @@
if (isDbInitialized(con))
{
- PreparedStatement ps = con.prepareStatement("SELECT * FROM " +
configTableName + " WHERE name=?");
+ PreparedStatement ps = con.prepareStatement("SELECT * FROM " +
configTableName + " WHERE NAME=?");
ps.setString(1, CONFIGNAME);
ResultSet res = ps.executeQuery();