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)
where Type = 'v'
AND SCHEMA_ID = 'dbo'
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).