Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dynamically loading dbjodbc10.dll to work with iAnywhere driver

3 posts in General Discussion Last posting was on 2008-04-03 15:48:26.0Z
kogon Posted on 2008-04-03 09:57:01.0Z
Sender: 5ed8.47f3ad4e.1804289383@sybase.com
From: kogon@unhcr.org
Newsgroups: ianywhere.public.general
Subject: Dynamically loading dbjodbc10.dll to work with iAnywhere driver
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47f4a9ed.749c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Apr 2008 01:57:01 -0800
X-Trace: forums-1-dub 1207216621 10.22.241.41 (3 Apr 2008 01:57:01 -0800)
X-Original-Trace: 3 Apr 2008 01:57:01 -0800, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6794
Article PK: 5037

Hello all, excuse me if this has already been answered but I
can't find it if so.

We are using WebStart to deploy our Sybase database and have
been
using jConnect as our JDBC driver but it is quite slow so we
are
wanting to switch to the iAnywhere JDBC driver as it may
improve
performance. This works fine if Sybase is installed but we
would
like to dynamically distribute it and are having a problem
with
loading the required dbjodbc10.dll file as it is not in the
system path. The error we get is:

java.lang.UnsatisfiedLinkError: no dbjodbc10 in
java.library.path

We have tried dynamically setting the java.library.path
System
environment variable but it does not work (I guess this is
for
reference only), and also explicitly loading the DLL with a
call
to System.load(<full path to DLL>), which loads fine, but
then
we still get the UnsatisfiedLinkError.

Is anyone else having this problem and have they figured out
a
way to solve it? We would like to avoid having to have users
install Sybase locally as they may not have permissions to
do so
and we are deploying globally to remote regions so would
like to
do it all via WebStart.

Thanks in advance,

--Alex Kogon
kogon@unhcr.org


"Frank Ploessel" <fpl... Posted on 2008-04-03 15:09:26.0Z
Subject: Re: Dynamically loading dbjodbc10.dll to work with iAnywhere driver
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <47f4a9ed.749c.1681692777@sybase.com>
Content-Transfer-Encoding: 8bit
Message-ID: <op.t81i1wrlj0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Apr 2008 07:09:26 -0800
X-Trace: forums-1-dub 1207235366 10.22.241.152 (3 Apr 2008 07:09:26 -0800)
X-Original-Trace: 3 Apr 2008 07:09:26 -0800, vip152.sybase.com
Lines: 70
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6798
Article PK: 5036

Alex,

This is the downside of the iAnywhere driver: it is not a pure Java
driver, but uses the SQL Anywhere client. You will have to deliver the
some non-Java files to your clients as well. As far as I am aware, the
application has to find them, e. g. as they are in a directory contained
in the PATH; there is no full installation of the client necessary.
See
SQL Anywhere® Server - Programming
Deploying Databases and Applications
Deploying client applications
Deploying JDBC clients

in the documentation for a list of files, which links to

SQL Anywhere® Server - Programming
Deploying Databases and Applications
Deploying client applications
Deploying ODBC clients
ODBC driver required files

for further required files, depending on client OS.

Frank

On Thu, 03 Apr 2008 11:57:01 +0200, <kogon@unhcr.org> wrote:

> Hello all, excuse me if this has already been answered but I
> can't find it if so.
>
> We are using WebStart to deploy our Sybase database and have
> been
> using jConnect as our JDBC driver but it is quite slow so we
> are
> wanting to switch to the iAnywhere JDBC driver as it may
> improve
> performance. This works fine if Sybase is installed but we
> would
> like to dynamically distribute it and are having a problem
> with
> loading the required dbjodbc10.dll file as it is not in the
> system path. The error we get is:
>
> java.lang.UnsatisfiedLinkError: no dbjodbc10 in
> java.library.path
>
> We have tried dynamically setting the java.library.path
> System
> environment variable but it does not work (I guess this is
> for
> reference only), and also explicitly loading the DLL with a
> call
> to System.load(<full path to DLL>), which loads fine, but
> then
> we still get the UnsatisfiedLinkError.
>
> Is anyone else having this problem and have they figured out
> a
> way to solve it? We would like to avoid having to have users
> install Sybase locally as they may not have permissions to
> do so
> and we are deploying globally to remote regions so would
> like to
> do it all via WebStart.
>
> Thanks in advance,
>
> --Alex Kogon
> kogon@unhcr.org


Alex Kogon Posted on 2008-04-03 15:48:26.0Z
Sender: 5ed8.47f3ad4e.1804289383@sybase.com
From: Alex Kogon
Newsgroups: ianywhere.public.general
Subject: Re: Dynamically loading dbjodbc10.dll to work with iAnywhere driver
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47f4fc4a.7bde.1681692777@sybase.com>
References: <op.t81i1wrlj0bybf@bonw00164.internal.imsglobal.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Apr 2008 07:48:26 -0800
X-Trace: forums-1-dub 1207237706 10.22.241.41 (3 Apr 2008 07:48:26 -0800)
X-Original-Trace: 3 Apr 2008 07:48:26 -0800, 10.22.241.41
Lines: 88
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6801
Article PK: 5040

Hi Frank,

Thanks for the info. I did figure out a way to make it work
but it is pretty kludgey and I'm not sure it works on all
VMs.

We are going to see if iAnywhere really makes a significant
performance improvement to see whether it is worth
it...maybe someone has an elegant way of getting around the
path problem as well.

Best

--Alex

> Alex,
>
> This is the downside of the iAnywhere driver: it is not a
> pure Java driver, but uses the SQL Anywhere client. You
> will have to deliver the some non-Java files to your
> clients as well. As far as I am aware, the application
> has to find them, e. g. as they are in a directory
> contained in the PATH; there is no full installation of
> the client necessary. See
> SQL Anywhere® Server - Programming
> Deploying Databases and Applications
> Deploying client applications
> Deploying JDBC clients
>
> in the documentation for a list of files, which links to
>
> SQL Anywhere® Server - Programming
> Deploying Databases and Applications
> Deploying client applications
> Deploying ODBC clients
> ODBC driver required files
>
> for further required files, depending on client OS.
>
> Frank
>
> On Thu, 03 Apr 2008 11:57:01 +0200, <kogon@unhcr.org>
> wrote:
>
> > Hello all, excuse me if this has already been answered
> > but I can't find it if so.
> >
> > We are using WebStart to deploy our Sybase database and
> > have been
> > using jConnect as our JDBC driver but it is quite slow
> > so we are
> > wanting to switch to the iAnywhere JDBC driver as it may
> > improve
> > performance. This works fine if Sybase is installed but
> > we would
> > like to dynamically distribute it and are having a
> > problem with
> > loading the required dbjodbc10.dll file as it is not in
> > the system path. The error we get is:
> >
> > java.lang.UnsatisfiedLinkError: no dbjodbc10 in
> > java.library.path
> >
> > We have tried dynamically setting the java.library.path
> > System
> > environment variable but it does not work (I guess this
> > is for
> > reference only), and also explicitly loading the DLL
> > with a call
> > to System.load(<full path to DLL>), which loads fine,
> > but then
> > we still get the UnsatisfiedLinkError.
> >
> > Is anyone else having this problem and have they figured
> > out a
> > way to solve it? We would like to avoid having to have
> > users install Sybase locally as they may not have
> > permissions to do so
> > and we are deploying globally to remote regions so would
> > like to
> > do it all via WebStart.
> >
> > Thanks in advance,
> >
> > --Alex Kogon
> > kogon@unhcr.org
>