Problems with BIRT (JAVA)

[mandres1]

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

[chris_keating]

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

[chris_keating]

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:

libdbjdbc17.dylib
libdbtasks17_r.dylib
libdbicu17_r.dylib
libdbicudt17.dylib
libdbrsa17_r.dylib
dblg[LL]17.res

[mandres1]

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