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.

zero-install client JDK1.1 vs JDK1.02 using Netscape Browser

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-15 18:12:05.0Z
Marvin Gersho Posted on 1997-04-07 15:57:44.0Z
Message-ID: <33492788.3CAE@dlj.com>
Date: Mon, 07 Apr 1997 11:57:44 -0400
From: Marvin Gersho <mgersho@dlj.com>
Reply-To: mgersho@dlj.com
Organization: Donaldson, Lufkin, & Jenrette
X-Mailer: Mozilla 3.01 (WinNT; U)
MIME-Version: 1.0
Subject: zero-install client JDK1.1 vs JDK1.02 using Netscape Browser
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 52
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1053
Article PK: 252807

I am trying to create a setup with a Sun Webserver going against
SYBASE System 11 and zero-install clients on Windows NT.

My code needs to be in JDK1.1 and I am using a Netscape 3.1 browser.

The problem is that Netscape 3.1 does not officially support JDK1.1,
but most 1.1 code will work in it if no new features are used.

However, it does not seem to have the java.sql package built in.
I therefore tried importing jdbc.sql insteadd of java.sql.
But it seems like it is still looking for java.sql.
Here is the code that sets the connection:

private synchronized static void setConnection() {
if (con_ == null)
try {
if (prop_.get("user") == null)
prop_.put("user","daily_user");
if (prop_.get("password") == null)
prop_.put("password","daily_user");
if (prop_.get("proxy") == null)
prop_.put("proxy","oas:8000");
url_ = new String("jdbc:sybase:Tds:agency:5555");
con_ = DriverManager.getConnection(url_,prop_);
} catch (SQLException sqle) {
System.out.println("Connection to database failed!");
System.out.println(sqle);
}

This gives me the following error:

AppAccelerator(tm) 1.0.2a for Java, x86 version.
Copyright (c) 1996 Borland International. All Rights Reserved.
VERIFIER ERROR
com/sybase/jdbc/SybDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;:
Cannot find class java/sql/Connection
Can't find class SybDriver
java.lang.ClassNotFoundException: com/sybase/jdbc/SybDriver
java.lang.ClassNotFoundException: com/sybase/jdbc/SybDriver
at YieldCurve.retrieveAllDates(Compiled Code)
at PricingInfo.populatePricingDate(Compiled Code)
at PricingInfo.<init>(Compiled Code)
at BondPricingPanel.<init>(Compiled Code)
at TestApplet.init(Compiled Code)
at netscape.applet.EmbeddedAppletFrame.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)
Connection to database failed!
jdbc.sql.SQLException: No suitable driver

Any suggestions would be appreciated.

Thanks,
Marvin Gersho


David Clegg Posted on 1997-04-15 17:20:51.0Z
Message-ID: <3353B8F3.1113F525@sybase.com>
Date: Tue, 15 Apr 1997 10:20:51 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: mgersho@dlj.com
Subject: Re: zero-install client JDK1.1 vs JDK1.02 using Netscape Browser
References: <33492788.3CAE@dlj.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 61
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1006
Article PK: 252757

You need to load the "jdbc.sybase.jdbc.SybDriver" class, not the
"com.sybase.jdbc.SybDriver" which is being called below. Also
change all your import "java.sql.*" to "jdbc.sql.*" and you should
be able to get this running.

dave

> I am trying to create a setup with a Sun Webserver going against
> SYBASE System 11 and zero-install clients on Windows NT.
>
> My code needs to be in JDK1.1 and I am using a Netscape 3.1 browser.
>
> The problem is that Netscape 3.1 does not officially support JDK1.1,
> but most 1.1 code will work in it if no new features are used.
>
> However, it does not seem to have the java.sql package built in.
> I therefore tried importing jdbc.sql insteadd of java.sql.
> But it seems like it is still looking for java.sql.
> Here is the code that sets the connection:
>
> private synchronized static void setConnection() {
> if (con_ == null)
> try {
> if (prop_.get("user") == null)
> prop_.put("user","daily_user");
> if (prop_.get("password") == null)
> prop_.put("password","daily_user");
> if (prop_.get("proxy") == null)
> prop_.put("proxy","oas:8000");
> url_ = new String("jdbc:sybase:Tds:agency:5555");
> con_ = DriverManager.getConnection(url_,prop_);
> } catch (SQLException sqle) {
> System.out.println("Connection to database failed!");
> System.out.println(sqle);
> }
>
> This gives me the following error:
>
> AppAccelerator(tm) 1.0.2a for Java, x86 version.
> Copyright (c) 1996 Borland International. All Rights Reserved.
> VERIFIER ERROR
> com/sybase/jdbc/SybDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;:
> Cannot find class java/sql/Connection
> Can't find class SybDriver
> java.lang.ClassNotFoundException: com/sybase/jdbc/SybDriver
> java.lang.ClassNotFoundException: com/sybase/jdbc/SybDriver
> at YieldCurve.retrieveAllDates(Compiled Code)
> at PricingInfo.populatePricingDate(Compiled Code)
> at PricingInfo.<init>(Compiled Code)
> at BondPricingPanel.<init>(Compiled Code)
> at TestApplet.init(Compiled Code)
> at netscape.applet.EmbeddedAppletFrame.run(Compiled Code)
> at java.lang.Thread.run(Compiled Code)
> Connection to database failed!
> jdbc.sql.SQLException: No suitable driver
>
> Any suggestions would be appreciated.
>
> Thanks,
> Marvin Gersho


Eric Giguere Posted on 1997-04-15 18:12:05.0Z
From: "Eric Giguere" <giguere@watcom.com>
Subject: Re: zero-install client JDK1.1 vs JDK1.02 using Netscape Browser
References: <33492788.3CAE@dlj.com> <3353B8F3.1113F525@sybase.com>
Organization: Sybase, Inc. (Waterloo)
Message-ID: <01bc49d9$28d3c7b0$7f791fac@giguere>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.jdbcconnect
Date: Tue, 15 Apr 1997 14:12:05 -0400
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:999
Article PK: 252750


David Clegg <davec@sybase.com> wrote in article
<3353B8F3.1113F525@sybase.com>...
> You need to load the "jdbc.sybase.jdbc.SybDriver" class, not the
> "com.sybase.jdbc.SybDriver" which is being called below. Also
> change all your import "java.sql.*" to "jdbc.sql.*" and you should
> be able to get this running.

For those interested in why you have to do so under Java 1.02, see

http://www.watcom.on.ca/devnotes/java/jdbc_and_applets.html
--
Eric Giguere / Software Engineer / Powersoft Languages Divison
giguere@watcom.com -- it's French, in English "jeeg-air"!