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

Startup fail on an empty database for Sybase 15.7

    Details

    • Flagged:
      Impediment
    • Fix Priority:
      5
    • OS:
      Solaris 11
    • JDK:
      Oracle Sun JDK 8
    • Application Servers:
      JBoss EAP 6.4
    • Databases:
      Sybase ASE 15.7

      Description

      I'm using the driver jconnect16 to connect to Sybase 15.7 but I'm not able to succeed the creation of the tables. I'm getting the following error, the log states that it is a warning but I believe it is an error.

      22:01:21,511 WARN [ServerService Thread Pool -- 92][BaseDB:461] Incorrect syntax near 'go'.: create table Account_ (_ mvccVersion decimal(20,0) default 0 not null,_ accountId decimal(20,0) not null primary key,_ companyId decimal(20,0),_ userId decimal(20,0),_ userName varchar(75) null,_ createDate bigdatetime null,_ modifiedDate bigdatetime null,_ parentAccountId decimal(20,0),_ name varchar(75) null,_ legalName varchar(75) null,_ legalId varchar(75) null,_ legalType varchar(75) null,_ sicCode varchar(75) null,_ tickerSymbol varchar(75) null,_ industry varchar(75) null,_ type_ varchar(75) null,_ size_ varchar(75) null_)go [Sanitized]

      The log attached has all the information of a clean try.

        Attachments

        1. liferay.2016-03-17.log
          307 kB
          Thiago Leão Moreira
        2. liferay.2016-03-21.log
          300 kB
          Thiago Leão Moreira

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 29 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 Beta 8