Issues
- Throwing exception when i use java.sql.Types.VARBINARY/VARLONGBINARY as datatype to connect oracle as well as postgresqlCONTRIB-20
- Extract Configuration.configure(filename) to HibernateDatabaseCONTRIB-19Resolved issue: CONTRIB-19
- returned error when updating database by using standalone ideCONTRIB-18Resolved issue: CONTRIB-18
- Error Updating Database: org.eclipse.datatools.enablement.mysql.catalog.MySqlCatalogDatabase cannot be cast to org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDatabaseCONTRIB-17Resolved issue: CONTRIB-17
- hibernate 4 and java7 supportCONTRIB-16Resolved issue: CONTRIB-16
- SET IDENTITY_INSERT for table fails when IDENTITY column doesn't existCONTRIB-14
- HibernateDatabaseSnapshotGenerator is missing unique columns defined using @Column annotationCONTRIB-13Resolved issue: CONTRIB-13
- DbUnit integrationCONTRIB-12
- Oracle Extension AddCheck cannot be used against 10.2 because of an escaping errorCONTRIB-11Resolved issue: CONTRIB-11
- Null pointer in JdbcDatabaseSnapshotGenerator with hibernate integrationCONTRIB-10Resolved issue: CONTRIB-10
- liquibase does not process DEFAULT values correctlyCONTRIB-9
- ability to access the XMLReaderCONTRIB-7
- L-GPL License showed instead of Apache LicenseCONTRIB-6Resolved issue: CONTRIB-6
- Oracle Extensions do not work with liquibase 2.0rc5CONTRIB-5Resolved issue: CONTRIB-5
- Added NVARCHAR SupportCONTRIB-3Resolved issue: CONTRIB-3Nathan Voxland
- Contribution : Slf4JLogger for liquibaseCONTRIB-4
- Patch to mssql extension (IDENTITY INSERT) to work with trunk code (2.0 rc2)CONTRIB-2Resolved issue: CONTRIB-2
- Missing srouce files for Oracle ExtensionCONTRIB-1Resolved issue: CONTRIB-1
18 of 18
1. new database has been created
CREATE DEFAULT d_FALSE as 0
GO
CREATE DEFAULT d_TRUE as 1
GO
CREATE TABLE column_with_default
(
column_with_default bit NOT NULL
);
go
sp_bindefault 'd_FALSE', 'column_with_default.column_with_default'
go
2. liquibase has been started using the following command:
#!/bin/tcsh
set lb=/cygdrive/c/Software/liquibase/2.0.1/liquibase
set driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
set url="jdbc:sqlserver://localhost:1433;database=vn;integratedSequrity=true"
set user="vn"
set password=golive
set driver_cp="./sqljdbc-3.0.jar"
$lb --driver=${driver} \
--classpath="${driver_cp}" \
--url="${url}" \
--username="${user}" \
--password=${password} \
--changeLogFile="./localhost.vn.xml" \
generateChangeLog
It outputs the following messages:
liquibase.exception.DatabaseException: java.text.ParseException: Unknown bit value: CREATE DEFAULT d_FALSE as 0
Liquibase Home is not set.
Liquibase Home: /cygdrive/c/Software/liquibase/2.0.1
INFO 05.05.11 15:33:liquibase: Reading tables for vn @ jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificat
e=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCou
nt=true;encrypt=false;disableStatementPooling=true;databaseName=vn;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
INFO 05.05.11 15:33:liquibase: Reading views for vn @ jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate
=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCoun
t=true;encrypt=false;disableStatementPooling=true;databaseName=vn;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
INFO 05.05.11 15:33:liquibase: Reading foreign keys for vn @ jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCert
ificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpd
ateCount=true;encrypt=false;disableStatementPooling=true;databaseName=vn;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
INFO 05.05.11 15:33:liquibase: Reading primary keys for vn @ jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCert
ificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpd
ateCount=true;encrypt=false;disableStatementPooling=true;databaseName=vn;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
INFO 05.05.11 15:33:liquibase: Reading columns for vn @ jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertifica
te=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCo
unt=true;encrypt=false;disableStatementPooling=true;databaseName=vn;applicationName=Microsoft SQL Server JDBC Driver; (Default Schema: dbo) ...
Liquibase Update Failed: Unknown bit value: CREATE DEFAULT d_FALSE as 0
SEVERE 05.05.11 15:33:liquibase: Unknown bit value: CREATE DEFAULT d_FALSE as 0
liquibase.exception.DatabaseException: java.text.ParseException: Unknown bit value: CREATE DEFAULT d_FALSE as 0
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.getColumnTypeAndDefValue(JdbcDatabaseSnapshotGenerator.java:402)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumn(JdbcDatabaseSnapshotGenerator.java:202)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:335)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
at liquibase.diff.Diff.compare(Diff.java:63)
at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:145)
at liquibase.integration.commandline.Main.doMigration(Main.java:624)
at liquibase.integration.commandline.Main.main(Main.java:116)
Caused by: java.text.ParseException: Unknown bit value: CREATE DEFAULT d_FALSE as 0
at liquibase.database.typeconversion.core.AbstractTypeConverter.convertToCorrectObjectType(AbstractTypeConverter.java:105)
at liquibase.database.typeconversion.core.AbstractTypeConverter.convertDatabaseValueToObject(AbstractTypeConverter.java:28)
at liquibase.database.typeconversion.core.MSSQLTypeConverter.convertDatabaseValueToObject(MSSQLTypeConverter.java:34)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.getColumnTypeAndDefValue(JdbcDatabaseSnapshotGenerator.java:400)
... 8 more