Re: [Liquibase-user] Error generating changelog

2009-04-23 Thread rynam0
BTW: I am currently running version 1.9.2... I see that there is a 1.9.3 version available so I will try that before checking out the code to investigate for myself. Thanks. rynam0 wrote: > > Hello: > I am attempting to generate my initial changelog on a SQLServer 2005 > db and have come

Re: [Liquibase-user] Error generating changelog

2009-04-23 Thread rynam0
Hi: Running 1.9.3 did not make a difference in regards to the previous error and I am also seeing some logging in regards to some Table-valued Functions while attempting to generate an initial changelog. I'm seeing the following for many different columns and the functions do in fact exist so

Re: [Liquibase-user] Error generating changelog

2009-04-23 Thread Voxland, Nathan
Sorry for the delay answering. Your root problem is that liquibase.database.AbstractDatabase line 1142 needs to be changed from return "PK_" + tableName.toUpperCase(); to return "PK_" + escapeTableName(null, tableName).toUpperCase(); I'll probably not do a 1.9.4 release just for that, so if y

Re: [Liquibase-user] Error generating changelog

2009-04-23 Thread Voxland, Nathan
Sorry, that was not right. The problem is actually in the isColumnAutoIncrement method. The line numbers are off, but I'm not sure how it is getting the problem you are seeing. We have the following statement running: selectRS = getConnection().createStatement().executeQuery("SELECT " + escapeCol

[Liquibase-user] Specify default charset fro creates

2009-04-23 Thread Sven Haiges
Hi all, I got some issue with being unable to specify the charset with the CREATE table statement. We use liquibase to generate the SQL so we see the CREATE TABLE () DEFAULT CHARSET=utf8; is missing. To resolve this, I first used soem manuel SQL like this (for MySQL): ALTER TABLE `MacSmsJournal`

Re: [Liquibase-user] Specify default charset fro creates

2009-04-23 Thread Voxland, Nathan
It is not currently, ou'll have to specify your createTable statement using as well. Can you set utf8 as the default in your database config? Nathan From: Sven Haiges [mailto:sven.hai...@googlemail.com] Sent: Thursday, April 23, 2009 1:20 PM To: liquibase-user@lists.sourceforge.n

Re: [Liquibase-user] Specify default charset fro creates

2009-04-23 Thread Sven Haiges
I am experimenting to create an empty table, then use manual sql to change the default charset and later add columns to it. this should work, but I will let you know later. On Thu, Apr 23, 2009 at 11:28 AM, Voxland, Nathan < nvoxl...@intelligentinsites.com> wrote: > It is not currently, ou’ll ha

Re: [Liquibase-user] Specify default charset fro creates

2009-04-23 Thread Ben Wolfe
We create the database with the default set to utf8 and then don't have to specify the character set when creating tables: create database xxx default character set utf8; Ben Sven Haiges wrote: > I am experimenting to create an empty table, then use manual sql to > change the default charset