Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-26081

Calendar portlet verify process only works in mysql and portgresql

Details

    Description

      After applying the LPS-25887 issue, the verify process throws an exception on some database servers. E.g. on MSSQL:
      Caused by: java.sql.SQLException: The data types ntext and varchar are incompatible in the not equal to operator.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
      at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at com.liferay.portal.verify.VerifyCalendar.verifyRecurrence(VerifyCalendar.java:111)
      at com.liferay.portal.verify.VerifyCalendar.doVerify(VerifyCalendar.java:42)
      at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)

      It looks like that the query is not okay for non-mysql and non-pgsql databases.

      Attachments

        Issue Links

          Activity

            People

              paul.piao Paul Piao (Inactive)
              zsolt.balogh Zsolt Balogh
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10 years, 23 weeks, 6 days ago

                Packages

                  Version Package
                  6.1.20 EE GA2
                  --Sprint 11/12
                  6.2.0 CE M2