Hi I changed to the native database driver sajdbc4.jar and its corresponding lib-/res-files. For a few SQL statements I get now following error (only the number of TEMP_number changes).
These SQL statements worked for years in production with jconn3.jar and jconn4.jar drivers. The SQL statements in our IDE (Servoy) is an embedded one. When I rewrite it to a Query Builder statement (also an option), the error disappears. The resulting SQL statement in both cases are the same, but there must be a difference in handling this by the drivers. What problem could be associated with this? Of course I would be soothing if both versions of the SQL statement would work. Database version is 17.0.8.4003 Regards, |
As connections via jConnect call the sp_tsql_environment system procedure by default whereas the SA JDBC driver does not, you could look whether some of the Transact-SQL compatibility options do make a difference here.
Thanks a lot for your explanation, Volker. It was how the SQL was sent from within the code (of my IDE, i. e. Servoy) application which made the problem. I could solve it.
So feel free then to turn your comment into an answer and mark it as accepted - that shows the question is answered:)