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

              Assignee:
              paul.piao Paul Piao (Inactive)
              Reporter:
              zsolt.balogh Zsolt Balogh
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 24 weeks ago

                  Packages

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