|
Could you please tell me in which section of eclipse I could configure this? I have tried different options but it keeps throwing me the following error: An internal error occurred during: "Test connection". no dbjdbc17 in java.library.path: /Users/mandres/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:. |
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 Mar '23, 08:03
question was seen: 249 times
last updated: 28 Apr '23, 08:32
Have you configured the environment using sa_config.sh (assuming bash)? The native libraries and resource file(s) that are required by the SQLA JDBC driver are:
libdbjdbc17.so.1 libdbtasks17_r.so.1 libdbicu17_r.so.1 libdbicudt17.so.1 libdbrsa17_r.so.1 dblg[LL]17.res
I just read your addition to an older thread where you indicate that you are on MacOS. Same question about sourcing the environment and ensuring it is visible to Eclipse should be addressed. And the libraries for MacOS are:
Thanks for your answer, but the problem persists. I share the steps I followed.
1 - Setting variables for MacOS . /Applications/SQLAnywhere17/System/bin64/sa_config.sh
2 - Define the variable SQLANY_API_DLL export SQLANY_API_DLL=/Applications/SQLAnywhere17/System/lib64/libdbcapi_r.dylib
After these two steps, my local and production web app (RubyOnRails) can be connected with SQLAnywhere..
Trying to connect from BIRT (Java) to build reports, I followed these steps:
1 - Modify the eclipse.ini file with the following line:
-Djava.library.path=/Applications/SQLAnywhere17/System/lib64/libdbjdbc17.dylib:/Applications/SQLAnywhere17/System/lib64/libdbtasks17_r.dylib:/Applications/SQLAnywhere17/System/lib64/libdbicu17_r.dylib:/Applications/SQLAnywhere17/System/lib64/libdbicudt17.dylib:/Applications/SQLAnywhere17/System/lib64/libdbrsa17_r.dylib:/Applications/SQLAnywhere17/System/lib64/dblg[LL]17.res
Trying to test the connection, it returns this message
An internal error occurred during: "Test connection". no dbjdbc17 in java.library.path: /Applications/SQLAnywhere17/System/lib64/libdbjdbc17.dylib:/Applications/SQLAnywhere17/System/lib64/libdbtasks17_r.dylib:/Applications/SQLAnywhere17/System/lib64/libdbicu17_r.dylib:/Applications/SQLAnywhere17/System/lib64/libdbicudt17.dylib:/Applications/SQLAnywhere17/System/lib64/libdbrsa17_r.dylib:/Applications/SQLAnywhere17/System/lib64/dblg[LL]17.res
The connection URL is the following:
Driver Class: sap.jdbc4.sqlanywhere.IDriver ( v4.0) Database URL: jdbc:sqlanywhere:UserID=user;Password=12345678;Host=produccion.cajamed.com.py:8033;ServerName=cmpu;DatabaseName=cmpu