Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to Create DATABASECHANGELOGLOCK table #111

Open
pradeepviswa opened this issue Oct 25, 2021 · 1 comment
Open

Failed to Create DATABASECHANGELOGLOCK table #111

pradeepviswa opened this issue Oct 25, 2021 · 1 comment

Comments

@pradeepviswa
Copy link

pradeepviswa commented Oct 25, 2021

I am using Sybase IQ database.
in Properties file:
driver: com.sybase.jdbc4.jdbc.SybDriver
url: jdbc:sybase.Tds:{host:port}/{dbname}
defaultSchemaName: asany

Liquibase CLI Version: 4.5.0

While executing liquibase command, I am able to establish connection with Database. I can see this message:
[liquibae.database] Connection has been created
WARNING [liquibae.database] Unknown database: SQP IQ

After few messages I get this error:
SEVERE [liquibase.integration] SQL Anywhere Error -131: Syntax error near 'BOOLEAN' on line 1 [FailedSQL: (102) CREATE TABLE asany.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]

┆Issue is synchronized with this Jira Bug by Unito

@pradeepviswa
Copy link
Author

Note: Initially when I tried without specifying defaultSchemaName in property file that time I was getting this error.

[liquibase.database] Error getting default schema
liquibase.exception.DatabaseException: Error executing SQL call current_schema: SQL Anywhere Error -265: Procedure 'current_schema' not found

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant