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:. |
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