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

JDBC pool provider uses the incorrect Sybase dialect

    Details

    • Fix Priority:
      3

      Description

      Sybase 16.0 Setup:

      portal-ext.properties
      jdbc.default.driverClassName=com.sybase.jdbc4.jdbc.SybDriver
      jdbc.default.url=jdbc:sybase:Tds:{IPAddressHere}:5000/lportal?charset=utf8
      jdbc.default.username=sa
      jdbc.default.password=password
      
      Create database
      use master
      go
      
      create database lportal
      go
      
      alter database lportal
      on default=1400
      go
      
      alter database lportal
      with override
      go
      
      master..sp_dboption lportal, 'allow nulls by default', true
      go
      
      master..sp_dboption lportal, 'select into/bulkcopy/pllsort', true
      go
      
      sp_configure 'select for update', 1
      go
      
      *Run create-sybase.sql*
      

      Expected Result: Pool provider detects the Sybase 16.0 dialect.

      Actual Result: Pool provider detects the Sybase 15.7 dialect.

      16:06:58,366 INFO  [localhost-startStop-1][DialectDetector:75] Determine dialect for Adaptive Server Enterprise 16.0
      16:06:58,404 INFO  [localhost-startStop-1][DialectDetector:148] Found dialect com.liferay.portal.dao.orm.hibernate.SybaseASE157Dialect
      

      Reproduced on:
      Tomcat 8.0.32 + Sybase ASE 16.0
      Portal ee-7.0.x Git Hash: 8b5e9f2a9e9a970406f13b555500e696b460e175

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 26 weeks, 5 days ago

                Packages

                Version Package