|
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, |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 15 Nov '18, 04:07
question was seen: 746 times
last updated: 21 Nov '18, 11:12
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:)