msado15 ClassNotFoundException; JDBC 100% CPU 
Author Message
 msado15 ClassNotFoundException; JDBC 100% CPU

[snip]

Quote:
>..., when I attempt to run it though, it bogs down the client system. It
>causes the IE4 process to use 100% of the CPU.      If I bring up the Java
>console, I can see the ODBC trace, so I know that its actually getting data
>(1 SQLFetch followed by a SQLGetData for each record in the recordset). It's
>just very slow and consumes an awful lot of CPU.

Both jdbc tracing (activated in your source by
java.sql.DriverManager.setLogStream ... ) and odbc tracing
(which is controlled through  control panel / odbc manager) are
very CPU- and I/O intensive.

This may be a stupid question, but are you sure both traces are
OFF when you measure performance ?

--
Kees Nuyt; Rotterdam; Netherlands

+--HI, I'm a signature virus :-)?Copy me into your sign to join in. ---+



Fri, 02 Mar 2001 03:00:00 GMT
 msado15 ClassNotFoundException; JDBC 100% CPU

Quote:

>Thanks for responding.      That was, in fact, the problem.  I thought maybe it
>was the trace since I would see it when I had the Java console up.  I was
>using a code snippet that I didn't fully understand.  It did invoke the
>setLogStream method.  

I'm glad you found it.

Quote:
>Most of what I know so I've gathered from a number of web pages.  Would you
>recommend any good books on java that discuss JDBC.  I was poking around the
>book store the other day but didn't find anything that didn't just gloss over
>it.

I don't have too much experience with jdbc myself. Up to now the
only documentation I used is the Sun JDK 1.1.6 docs, which
covers jdbc basics quite well. It can be obtained from the Sun
website as a separate downloads, somewhere at
http://java.sun.com/products/jdk/

After installation ..../docs/guide/jdbc/index.html leads you to
the JDBC guide and the JDBC API Reference.

I'm sorry I don't have more pointers at this time.
Also this newsgroup is a good source for ideas.

Regards,

--
Kees Nuyt; Rotterdam; Netherlands

+--HI, I'm a signature virus :-)?Copy me into your sign to join in. ---+



Sat, 03 Mar 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. 100% CPU Utilization on Database Box with Microsoft JDBC Driver

2. SQL Server Hogs 100% CPU

3. after changing login password (local), CPU always 100% !!

4. CPU Usage Hits 100%

5. Access ODBC link to SQL Database causes 100% CPU

6. CLUSSVC.exe - CPU at 100%

7. Help: CPU Usage 100% (Performance issue)

8. CPU Usage 100% When Query Plan Shows Table Spool

9. MORE DETAILS - SQL with AS400/DB2 via CA R4.4 - CPU 100%

10. msmdsrv.exe 100 % CPU - Freeze

11. 100% CPU Utilization on Dual P3 1.4Ghz

12. SQL Query Analyzer using 100% Cpu on client


 
Powered by phpBB® Forum Software