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.

sample applet executes...response time slow

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 21:22:24.0Z
Jeff Kusner Posted on 1997-06-03 00:20:39.0Z
From: "Jeff Kusner" <jkusner@ee.net>
Subject: sample applet executes...response time slow
Organization: Kusner & Family
Message-ID: <01bc6fbb$cfa07c20$8d00dece@jeff-kusner>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.jdbcconnect
Date: Mon, 02 Jun 1997 20:20:39 -0400
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:736
Article PK: 252489

allow me to repost this:


PART 1:
the sample applet loads quickly in both the host and client browsers
however the
sql execution is much too slow...approx 1 minute. (sql results are
immediate in wisql).

running jConnect 2.1 trial edition on nt4.0 running ms web server and
accessing sybase system 10 on a separate nt server
jdk1.1.1

browser on webserver is ie 3.0
client browser on win95 is ie 3.2 & netscape 3

created web alias of /jdbchome = c:\program files\sybase\jconnect

index.html contains:
<A HREF="/jdbchome/sample/gateway.html">Run a <B> Sample JDBC Applet
</B></A>

gateway.html contains:
<applet code=Isql.class codebase=/jdbchome/classes width=750 height=400>

<param name=proxy value="65.65.120.82:8000">
<param name=host value="valid ip address">
<param name=debug value="ALL">
<param name=port value="5000">
<param name=usedb value="valid dbname">
<param name=uid value="valid id">
<param name=pass value="valid password">
<param name=query value="select name from sysobjects where type='u' order
by 1">

PART 2:
another problem i encounter is if i change the proxy value from actual ip
address of web server to :
<param name=proxy value="localhost:8000">
i receive an error of: Unexpected Exception: java.lang.NullPointerException

ideas/thoughts/pointers please...

thanks
jeff


David Clegg Posted on 1997-07-30 21:22:24.0Z
Message-ID: <33DFB090.3243026B@sybase.com>
Date: Wed, 30 Jul 1997 14:22:24 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Jeff Kusner <jkusner@ee.net>
Subject: Re: sample applet executes...response time slow
References: <01bc6fbb$cfa07c20$8d00dece@jeff-kusner>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 48
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:433
Article PK: 252183

I've never seen performance problems like what you describe, but
I don't work from win95 much. I believe that there is a configuration
option for win95 that tells it to act more like a "server" machine
than whatever it thinks it is -- I've heard that this change helps
performance significantly. Unfortunately, I'm not enough of a
Windows-head to tell you what specific switch you throw or how you
get to it.

dave

Jeff Kusner wrote:
>
> allow me to repost this:
>
> PART 1:
> the sample applet loads quickly in both the host and client browsers
> however the
> sql execution is much too slow...approx 1 minute. (sql results are
> immediate in wisql).
>
> running jConnect 2.1 trial edition on nt4.0 running ms web server and
> accessing sybase system 10 on a separate nt server
> jdk1.1.1
>
> browser on webserver is ie 3.0
> client browser on win95 is ie 3.2 & netscape 3
>
> created web alias of /jdbchome = c:\program files\sybase\jconnect
>
> index.html contains:
> <A HREF="/jdbchome/sample/gateway.html">Run a <B> Sample JDBC Applet
> </B></A>
>
> gateway.html contains:
> <applet code=Isql.class codebase=/jdbchome/classes width=750 height=400>
>
> <param name=proxy value="65.65.120.82:8000">
> <param name=host value="valid ip address">
> <param name=debug value="ALL">
> <param name=port value="5000">
> <param name=usedb value="valid dbname">
> <param name=uid value="valid id">
> <param name=pass value="valid password">
> <param name=query value="select name from sysobjects where type='u' order
> by 1">
>
> PART 2:
> another problem i encounter is if i change the proxy value from actual ip
> address of web server to :
> <param name=proxy value="localhost:8000">
> i receive an error of: Unexpected Exception: java.lang.NullPointerException
>
> ideas/thoughts/pointers please...
>
> thanks
> jeff