2.0 RC6 generateChangeLog with MSSQL 2008 R2

General Discussion
1

Hello,

I am trying to run generateChangeLog against a SQL 2008 R2 installation and it is failing trying to run this command on the DB:

    SELECT OBJECT_DEFINITION(OBJECT_ID) FROM sys.objects where Type = 'v' AND UPPER(name)='VIEWNAME' AND SCHEMA_ID = 'dbo'

Exception:
Caused by: java.sql.SQLException: Conversion failed when converting the varchar value ‘dbo’ to data type int.

The issue here is that SCHEMA_ID on sys.objects is an int, not a string.  the dbo schema is represented by a 1…

I did some quick searches on google, this forum and JIRA and didn’t see anything that related.

I am using jtds-1.2.5 to connect to SQL and I have tried this with 2.0RC6.

This command runs fine under 1.9.5, however it only seems to grab the dbo schema (but I think that is a known issue).

Jim

2

I think this shoudl be fixed in the RC7 when it comes out (possibly today or tonight)

Nathan