Subject:[SQLServer JDBC Driver]Value can not be converted to requested type. Author:guy-francis vella Date:09 May 2009 04:15 AM
Evening All
I created an xquery to extract code (see attached) from a ledger (in an sql db) for importation via xml into a different system. The query worked fine and now i am looking to use the same query for another ledger (in the same sql db, but using some different tables).
The only differences are the name of the ledger specific tables and a few minor variations in column type (i.e. int rather than float) but nothing major. However I get the following error. I realise it likely to be something in the data, but i have no idea what and the full error (see attached) isn't helping me locate it.
I'm going to rewrite my code from scratch tomorrow, but was hoping someone might have come across something similar and have an idea why to be more specific in my troubleshooting.
Subject:[SQLServer JDBC Driver]Value can not be converted to requested type. Author:guy-francis vella Date:10 May 2009 01:00 AM
Ok: If I create a new view (with exactly the same data as the view causing the issues) then this problem goes away. Somewhere MSSQL, Java or Stylus is caching the structure of the view as it was originally.
For now I can get round this by simply renaming all my views. However; another option would be nice for future reference, especially since there is every chance that i will be tweaking my data as I go along.
Tried rebooting SQL: No change
Tried rebooting locally: No change