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.

Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)

4 posts in General Discussion Last posting was on 2010-05-20 16:17:03.0Z
CHRISTOS STAVRINOU Posted on 2010-05-18 08:50:19.0Z
Reply-To: "CHRISTOS STAVRINOU" <stavrinc@gmail.com>
From: "CHRISTOS STAVRINOU" <stavrinc@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)
Lines: 192
Organization: S.CHR SOFTWARE DEVELOPMENT
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_002D_01CAF680.F2AE81D0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bf254cb@forums-1-dub>
Date: 18 May 2010 01:50:19 -0700
X-Trace: forums-1-dub 1274172619 10.22.241.152 (18 May 2010 01:50:19 -0700)
X-Original-Trace: 18 May 2010 01:50:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8039
Article PK: 7063

Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)
 
When I try to connect to Sybase SQLAnywhere Web Edition Database from linux using jodbc.jar I get the following error.
 
Under windows everything works ok. I think is a problem with the driver? What is the ianywhere jdbc driver for Sybase SQLAnywhere Web Edition Database 11 under linux and what is the connection string.
 
The connection string I use and works ok under windows is
 
String MM_dok_DRIVER = "ianywhere.ml.jdbcodbc.jdbc3.IDriver";
String MM_dok_USERNAME = "DBA";
String MM_dok_PASSWORD = "sql";
String MM_dok_STRING = "jdbc:ianywhere:driver=sql anywhere 11;dbn=mydatabase;eng=mydatabase;links=tcpip;";
 
The error message that I get is
 
 
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
root cause
 
javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
 org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
 org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
root cause
 
java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
 java.lang.Runtime.loadLibrary0(Runtime.java:840)
 java.lang.System.loadLibrary(System.java:1047)
 ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
 ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
 java.lang.Class.forName0(Native Method)
 java.lang.Class.forName(Class.java:186)
 org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
 
Thank you.
 
 


Nathan Auch (Sybase) Posted on 2010-05-18 13:17:22.0Z
From: "Nathan Auch (Sybase)" <nauch@sybase.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100301 Fedora/3.0.3-1.fc12 Lightning/1.0b2pre Thunderbird/3.0.3
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)
References: <4bf254cb@forums-1-dub>
In-Reply-To: <4bf254cb@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-7; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bf29362$1@forums-1-dub>
Date: 18 May 2010 06:17:22 -0700
X-Trace: forums-1-dub 1274188642 10.22.241.152 (18 May 2010 06:17:22 -0700)
X-Original-Trace: 18 May 2010 06:17:22 -0700, vip152.sybase.com
Lines: 82
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8040
Article PK: 7064

Hi Christos,

It looks like Apache isn't able to find the libdbjodbc11.so that is part
of your SQL Anywhere install. You will need to configure your system to
so that Apache can find the SQL Anywhere libraries when it runs. One way
to do this is to add SQL Anywhere lib directory to the dynamic linker's
search path.

If your system has a directory named "/etc/ld.so.conf.d/" you can create
a file named "sqlany.conf" that contains the following line (Assuming
that you installed SQL Anywhere to the default location and you want to
use the 32-bit libraries):

/opt/sqlanywhere11/lib32

If your system does not have the "/etc/ld.so.conf.d/" directory, just
add the line directly to the "/etc/ld.so.conf" file.

After adding the path, you will need to refresh the linker cache by
running the "ldconfig" command. Finally restart Apache and retest your
connection to SQL Anywhere.

Nathan Auch
Sybase iAnywhere

On 05/18/2010 04:50 AM, CHRISTOS STAVRINOU wrote:
> Connectivity problem with Sybase SQLAnywhere Web Edition 11 and
> IANYWHERE jdbc driver under linux (jodbc.jar)
> When I try to connect to Sybase SQLAnywhere Web Edition Database from
> linux using jodbc.jar I get the following error.
> Under windows everything works ok. I think is a problem with the driver?
> What is the ianywhere jdbc driver for Sybase SQLAnywhere Web Edition
> Database 11 under linux and what is the connection string.
> The connection string I use and works ok under windows is
> String MM_dok_DRIVER = "ianywhere.ml.jdbcodbc.jdbc3.IDriver";
> String MM_dok_USERNAME = "DBA";
> String MM_dok_PASSWORD = "sql";
> String MM_dok_STRING = "jdbc:ianywhere:driver=sql anywhere
> 11;dbn=mydatabase;eng=mydatabase;links=tcpip;";
> The error message that I get is
> *org.apache.jasper.JasperException: javax.servlet.ServletException:
> java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
> **
> *root cause*
> **
> *javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no
> dbjodbc11 in java.library.path
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
> **
> *root cause*
> **
> *java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
> java.lang.Runtime.loadLibrary0(Runtime.java:840)
> java.lang.System.loadLibrary(System.java:1047)
> ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
> ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
> java.lang.Class.forName0(Native Method)
> java.lang.Class.forName(Class.java:186)
> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> *
> Thank you.


CHRISTOS STAVRINOU Posted on 2010-05-20 06:16:42.0Z
Reply-To: "CHRISTOS STAVRINOU" <stavrinc@gmail.com>
From: "CHRISTOS STAVRINOU" <stavrinc@gmail.com>
Newsgroups: ianywhere.public.general
References: <4bf254cb@forums-1-dub> <4bf29362$1@forums-1-dub>
Subject: Re: Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)
Lines: 347
Organization: S.CHR SOFTWARE DEVELOPMENT
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_002F_01CAF7FD.D72D57A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bf4d3ca@forums-1-dub>
Date: 19 May 2010 23:16:42 -0700
X-Trace: forums-1-dub 1274336202 10.22.241.152 (19 May 2010 23:16:42 -0700)
X-Original-Trace: 19 May 2010 23:16:42 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8042
Article PK: 7068

Now I get the error
 
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
root cause
 
javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
 org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
 org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
root cause
 
java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
 java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
 java.lang.Runtime.loadLibrary0(Runtime.java:840)
 java.lang.System.loadLibrary(System.java:1047)
 ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
 ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
 java.lang.Class.forName0(Native Method)
 java.lang.Class.forName(Class.java:186)
 org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 
 
> Hi Christos,
>
> It looks like Apache isn't able to find the libdbjodbc11.so that is part
> of your SQL Anywhere install. You will need to configure your system to
> so that Apache can find the SQL Anywhere libraries when it runs. One way
> to do this is to add SQL Anywhere lib directory to the dynamic linker's
> search path.
>
> If your system has a directory named "/etc/ld.so.conf.d/" you can create
> a file named "sqlany.conf" that contains the following line (Assuming
> that you installed SQL Anywhere to the default location and you want to
> use the 32-bit libraries):
>
> /opt/sqlanywhere11/lib32
>
> If your system does not have the "/etc/ld.so.conf.d/" directory, just
> add the line directly to the "/etc/ld.so.conf" file.
>
> After adding the path, you will need to refresh the linker cache by
> running the "ldconfig" command. Finally restart Apache and retest your
> connection to SQL Anywhere.
>
> Nathan Auch
> Sybase iAnywhere
>
> On 05/18/2010 04:50 AM, CHRISTOS STAVRINOU wrote:
>> Connectivity problem with Sybase SQLAnywhere Web Edition 11 and
>> IANYWHERE jdbc driver under linux (jodbc.jar)
>> When I try to connect to Sybase SQLAnywhere Web Edition Database from
>> linux using jodbc.jar I get the following error.
>> Under windows everything works ok. I think is a problem with the driver?
>> What is the ianywhere jdbc driver for Sybase SQLAnywhere Web Edition
>> Database 11 under linux and what is the connection string.
>> The connection string I use and works ok under windows is
>> String MM_dok_DRIVER = "ianywhere.ml.jdbcodbc.jdbc3.IDriver";
>> String MM_dok_USERNAME = "DBA";
>> String MM_dok_PASSWORD = "sql";
>> String MM_dok_STRING = "jdbc:ianywhere:driver=sql anywhere
>> 11;dbn=mydatabase;eng=mydatabase;links=tcpip;";
>> The error message that I get is
>> *org.apache.jasper.JasperException: javax.servlet.ServletException:
>> java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
>> **
>> *root cause*
>> **
>> *javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no
>> dbjodbc11 in java.library.path
>> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
>> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
>> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
>> **
>> *root cause*
>> **
>> *java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
>> java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
>> java.lang.Runtime.loadLibrary0(Runtime.java:840)
>> java.lang.System.loadLibrary(System.java:1047)
>> ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
>> ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
>> java.lang.Class.forName0(Native Method)
>> java.lang.Class.forName(Class.java:186)
>> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> *
>> Thank you.
>


Nathan Auch (Sybase) Posted on 2010-05-20 16:17:03.0Z
From: "Nathan Auch (Sybase)" <nauch@sybase.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100301 Fedora/3.0.3-1.fc12 Lightning/1.0b2pre Thunderbird/3.0.3
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Connectivity problem with Sybase SQLAnywhere Web Edition 11 and IANYWHERE jdbc driver under linux (jodbc.jar)
References: <4bf254cb@forums-1-dub> <4bf29362$1@forums-1-dub> <4bf4d3ca@forums-1-dub>
In-Reply-To: <4bf4d3ca@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-7; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bf5607f$1@forums-1-dub>
Date: 20 May 2010 09:17:03 -0700
X-Trace: forums-1-dub 1274372223 10.22.241.152 (20 May 2010 09:17:03 -0700)
X-Original-Trace: 20 May 2010 09:17:03 -0700, vip152.sybase.com
Lines: 140
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8043
Article PK: 7071

Hi Christos,

It looks like Tomcat is still not finding the SQL Anywhere libraries.
Can you verify that the bitness of library path you put in
/etc/ld.so.conf matches the bitness of java used for your Tomcat server?

I'm not very familiar with Tomcat, but there is probably a configuration
that lets you specify a library path or a way of setting environment
variables. If so, you can set the LD_LIBRARY_PATH environment variable
to point to the libraries in your SQL Anywhere install.

Nathan Auch
Sybase iAnywhere

On 05/20/2010 02:16 AM, CHRISTOS STAVRINOU wrote:
> Now I get the error
> org.apache.jasper.JasperException: javax.servlet.ServletException:
> java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> root cause
> javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no
> dbjodbc11 in java.library.path
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> root cause
> java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
> java.lang.Runtime.loadLibrary0(Runtime.java:840)
> java.lang.System.loadLibrary(System.java:1047)
> ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
> ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
> java.lang.Class.forName0(Native Method)
> java.lang.Class.forName(Class.java:186)
> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> > Hi Christos,
> >
> > It looks like Apache isn't able to find the libdbjodbc11.so that is part
> > of your SQL Anywhere install. You will need to configure your system to
> > so that Apache can find the SQL Anywhere libraries when it runs. One way
> > to do this is to add SQL Anywhere lib directory to the dynamic linker's
> > search path.
> >
> > If your system has a directory named "/etc/ld.so.conf.d/" you can create
> > a file named "sqlany.conf" that contains the following line (Assuming
> > that you installed SQL Anywhere to the default location and you want to
> > use the 32-bit libraries):
> >
> > /opt/sqlanywhere11/lib32
> >
> > If your system does not have the "/etc/ld.so.conf.d/" directory, just
> > add the line directly to the "/etc/ld.so.conf" file.
> >
> > After adding the path, you will need to refresh the linker cache by
> > running the "ldconfig" command. Finally restart Apache and retest your
> > connection to SQL Anywhere.
> >
> > Nathan Auch
> > Sybase iAnywhere
> >
> > On 05/18/2010 04:50 AM, CHRISTOS STAVRINOU wrote:
> >> Connectivity problem with Sybase SQLAnywhere Web Edition 11 and
> >> IANYWHERE jdbc driver under linux (jodbc.jar)
> >> When I try to connect to Sybase SQLAnywhere Web Edition Database from
> >> linux using jodbc.jar I get the following error.
> >> Under windows everything works ok. I think is a problem with the driver?
> >> What is the ianywhere jdbc driver for Sybase SQLAnywhere Web Edition
> >> Database 11 under linux and what is the connection string.
> >> The connection string I use and works ok under windows is
> >> String MM_dok_DRIVER = "ianywhere.ml.jdbcodbc.jdbc3.IDriver";
> >> String MM_dok_USERNAME = "DBA";
> >> String MM_dok_PASSWORD = "sql";
> >> String MM_dok_STRING = "jdbc:ianywhere:driver=sql anywhere
> >> 11;dbn=mydatabase;eng=mydatabase;links=tcpip;";
> >> The error message that I get is
> >> *org.apache.jasper.JasperException: javax.servlet.ServletException:
> >> java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> >>
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
> >>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
> >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
> >> **
> >> *root cause*
> >> **
> >> *javax.servlet.ServletException: java.lang.UnsatisfiedLinkError: no
> >> dbjodbc11 in java.library.path
> >>
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
> >>
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
> >> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:141)
> >> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> >>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)*
> >> **
> >> *root cause*
> >> **
> >> *java.lang.UnsatisfiedLinkError: no dbjodbc11 in java.library.path
> >> java.lang.ClassLoader.loadLibrary(ClassLoader.java:1681)
> >> java.lang.Runtime.loadLibrary0(Runtime.java:840)
> >> java.lang.System.loadLibrary(System.java:1047)
> >> ianywhere.ml.jdbcodbc.jdbc3.IDriver.try_load(IDriver.java:265)
> >> ianywhere.ml.jdbcodbc.jdbc3.IDriver.<clinit>(IDriver.java:233)
> >> java.lang.Class.forName0(Native Method)
> >> java.lang.Class.forName(Class.java:186)
> >> org.apache.jsp.dokimi.tabular_jsp._jspService(tabular_jsp.java:78)
> >> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> >>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
> >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
> >> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> >> *
> >> Thank you.
> >