|
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, |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
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: 814 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:)