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

asked 15 Mar '23, 08:03

mandres's gravatar image

mandres
71125
accept rate: 50%

converted 25 Apr '23, 15:41

2

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

(25 Apr '23, 17:19) Chris Keating
2

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
(25 Apr '23, 17:24) Chris Keating

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

(28 Apr '23, 08:30) mandres
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×78

question asked: 15 Mar '23, 08:03

question was seen: 219 times

last updated: 28 Apr '23, 08:32