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.

[Q] unable to load JDBC driver in Servlet

4 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 21:49:29.0Z
Michiel Veen Posted on 1997-04-15 10:39:59.0Z
Message-ID: <33535AFF.1F21@tcf.nl>
Date: Tue, 15 Apr 1997 12:39:59 +0200
From: Michiel Veen <michiel@tcf.nl>
Reply-To: michiel@tcf.nl
Organization: The Connection Factory
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: [Q] unable to load JDBC driver in Servlet
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1014
Article PK: 252764

Hi,

I have written a servlet that takes a form submit, then queries a
database using JDBC. The problem is that I get the following
error/response from the servlet (I am using the JavaWebServer from sun)
when I try to load the driver (Jconnect from Sybase for jdk11):

*** SQLException caught ***

SQLState: 08001
Message: No suitable driver
Vendor: 0

To my knowledge this usually means that there is some kind of mismatch
between the java.sql.* and the JDBC driver.

The classpath has entries for the classes from Jconnect and jdk111 only.
I try the driver in a simple application and it works fine, so I presume
that Jconnect should work with jdk111.

Any insight is more than welcome.

--

#-- michiel@tcf.nl
#-- The Connection Factory b.v.
#-- http://www.tcf.nl


David Clegg Posted on 1997-04-16 17:39:24.0Z
Message-ID: <33550ECC.32B951BA@sybase.com>
Date: Wed, 16 Apr 1997 10:39:24 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: michiel@tcf.nl
Subject: Re: [Q] unable to load JDBC driver in Servlet
References: <33535AFF.1F21@tcf.nl>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:991
Article PK: 252746

This message means that either your jConnect driver is not loaded
into your application, or the URL you are passing to the driver
manager is messed up.

If you are using the free Trial version of jConnect, then you should
see a "nag" message on System.out when the driver is loaded -- if
you are not seeing that, that is your problem.

dave

> Hi,
>
> I have written a servlet that takes a form submit, then queries a
> database using JDBC. The problem is that I get the following
> error/response from the servlet (I am using the JavaWebServer from sun)
> when I try to load the driver (Jconnect from Sybase for jdk11):
>
> *** SQLException caught ***
>
> SQLState: 08001
> Message: No suitable driver
> Vendor: 0
>
> To my knowledge this usually means that there is some kind of mismatch
> between the java.sql.* and the JDBC driver.
>
> The classpath has entries for the classes from Jconnect and jdk111 only.
> I try the driver in a simple application and it works fine, so I presume
> that Jconnect should work with jdk111.
>
> Any insight is more than welcome.
>
> --
>
> #-- michiel@tcf.nl
> #-- The Connection Factory b.v.
> #-- http://www.tcf.nl


Ted Ott Posted on 1997-06-09 21:53:46.0Z
From: "Ted Ott" <otttu@worldnet.att.net>
Subject: Re: [Q] unable to load JDBC driver in Servlet
References: <33535AFF.1F21@tcf.nl> <33550ECC.32B951BA@sybase.com>
Organization: PrimalWare
Message-ID: <01bc751d$f236a4a0$680874cf@otttu.worldnet.att.net>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.jdbcconnect
Date: Mon, 09 Jun 1997 17:53:46 -0400
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:709
Article PK: 252461

I am having the same problem on NT. I get the "nag" message and have tried
as many versions of URL as I can think of. Are there any other Ideas?

David Clegg <davec@sybase.com> wrote in article
<33550ECC.32B951BA@sybase.com>...
> This message means that either your jConnect driver is not loaded
> into your application, or the URL you are passing to the driver
> manager is messed up.
>
> If you are using the free Trial version of jConnect, then you should
> see a "nag" message on System.out when the driver is loaded -- if
> you are not seeing that, that is your problem.
>
> dave
> > Hi,
> >
> > I have written a servlet that takes a form submit, then queries a
> > database using JDBC. The problem is that I get the following
> > error/response from the servlet (I am using the JavaWebServer from sun)
> > when I try to load the driver (Jconnect from Sybase for jdk11):
> >
> > *** SQLException caught ***
> >
> > SQLState: 08001
> > Message: No suitable driver
> > Vendor: 0
> >
> > To my knowledge this usually means that there is some kind of mismatch
> > between the java.sql.* and the JDBC driver.
> >
> > The classpath has entries for the classes from Jconnect and jdk111
only.
> > I try the driver in a simple application and it works fine, so I
presume
> > that Jconnect should work with jdk111.
> >
> > Any insight is more than welcome.
> >
> > --
> >
> > #-- michiel@tcf.nl
> > #-- The Connection Factory b.v.
> > #-- http://www.tcf.nl
>


David Clegg Posted on 1997-07-30 21:49:29.0Z
Message-ID: <33DFB6E9.2D50ED0@sybase.com>
Date: Wed, 30 Jul 1997 14:49:29 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Ted Ott <otttu@worldnet.att.net>
Subject: Re: [Q] unable to load JDBC driver in Servlet
References: <33535AFF.1F21@tcf.nl> <33550ECC.32B951BA@sybase.com> <01bc751d$f236a4a0$680874cf@otttu.worldnet.att.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 49
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:429
Article PK: 252180

It seems that the DriverManager you talk to is not the same
one that the jConnect driver registered with. You might try

DriverManager.registerDriver(
(Driver) (Class.forName("com.sybase.jdbc.SybDriver")
).newInstance());
To force loading into the right DriverManager.

dave

Ted Ott wrote:
>
> I am having the same problem on NT. I get the "nag" message and have tried
> as many versions of URL as I can think of. Are there any other Ideas?
>
> David Clegg <davec@sybase.com> wrote in article
> <33550ECC.32B951BA@sybase.com>...
> > This message means that either your jConnect driver is not loaded
> > into your application, or the URL you are passing to the driver
> > manager is messed up.
> >
> > If you are using the free Trial version of jConnect, then you should
> > see a "nag" message on System.out when the driver is loaded -- if
> > you are not seeing that, that is your problem.
> >
> > dave
> > > Hi,
> > >
> > > I have written a servlet that takes a form submit, then queries a
> > > database using JDBC. The problem is that I get the following
> > > error/response from the servlet (I am using the JavaWebServer from sun)
> > > when I try to load the driver (Jconnect from Sybase for jdk11):
> > >
> > > *** SQLException caught ***
> > >
> > > SQLState: 08001
> > > Message: No suitable driver
> > > Vendor: 0
> > >
> > > To my knowledge this usually means that there is some kind of mismatch
> > > between the java.sql.* and the JDBC driver.
> > >
> > > The classpath has entries for the classes from Jconnect and jdk111
> only.
> > > I try the driver in a simple application and it works fine, so I
> presume
> > > that Jconnect should work with jdk111.
> > >
> > > Any insight is more than welcome.
> > >
> > > --
> > >
> > > #-- michiel@tcf.nl
> > > #-- The Connection Factory b.v.
> > > #-- http://www.tcf.nl
> >