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

Sybase 16.0 - Unable to start portal with Tomcat JDBC pool provider

    Details

    • Fix Priority:
      4
    • Databases:
      Sybase ASE 16

      Description

      Sybase 16.0 Setup:

      portal-ext.properties
      jdbc.default.liferay.pool.provider=tomcat
      jdbc.default.driverClassName=com.sybase.jdbc4.jdbc.SybDriver
      jdbc.default.url=jdbc:sybase:Tds:{IPAddressHere}:5000/lportal
      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
      
      
      sp_configure 'default sortorder id', 50, 'utf8'
      go
      
      sp_logiosize "8"
      go
      
      *Run create-sybase.sql*
      

      Expected Result: Portal starts without error.

      Actual Result: Portal fails to start since it's unable to login to db. Note that portal starts with the same setup except using hikaricp as the pool provider.
      SybaseStartup.txt

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

        Attachments

          Activity

            People

            Assignee:
            brian.lee Brian Lee
            Reporter:
            brian.lee Brian Lee
            Participants of an Issue:
            Recent user:
            Esther Sanz
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              5 years, 17 weeks, 1 day ago

                Packages

                Version Package
                7.0.1 CE GA2