I want to know how to count the result of sql from oracle9i.
For example,
"Select * from student where course_id='101'"
if the result is two ppls, how can i retrieve this value

I am a newbie to both Oracle and Tomcat. I am trying to access oracle
9.1 from Tomcat 5.0.16 using a simple HttpServlet. But when I try to
start the server, I get
 java.net.BindException: Address already in use: JVM_Bind:8080 error.

TRACE 41834:
    java/lang/StringBuffer.copy(StringBuffer.java:Compiled method)
    java/lang/StringBuffer.setLength(StringBuffer.java:Compiled method)
    oracle/jdbc/driver/OracleSql.parse(OracleSql.java:Compiled method)

I'm building a data entry application using Java servlets.
I had hoped to use drop down boxes to provide the user with
data entry selections pulled from a database into an html
form, but am now questioning, given the latency with which

I am using Tomcat5 and Oracle 9i and having trouble trying to connect
to my database using JNDI.
The Context tag in server.xml looks like this.
<Context path="" docBase="ROOT" debug="1">

I'm having trouble setting ut a datasource in a context I've created
with the administration tool.
After I've filled in _the correct_ values in the fields, I get this
error when trying to click the "Data Source" link under the context:

Has anybody noticed the memory leaks due to the class loader,Jar
handling parts of Java?
The heap profiling that I did for my Java process reports huge leaks
in these areas.

Is is safe to return a ResultSet from a member function of my class?
Can it cause memory leaks?

I'm trying to make the database connectivity in my web app more
efficient. I've set up a Tomcat JNDI datasource and I was wondering if
I still needed to use the connection pooling or if it does it
automatically when you're using the datasource?

Does anyone know why my mysql connection pool config in the
cocoon.xconf file isn't working??   I'm rather new with cocoon.
Everything works if I set the connection in my xsp file, but if I just
make a connection pool call in xsp with <esql:pool>abc</esql:pool>  I

I have seen invalid cursor states when I've forgotten to call
rs.next() before trying to retrieve values from a query, but I've
never seen it when just calling executeQuery()! Anyone have any ideas
about this? Here are the details:

General database and jdbc question, lets imagine I have a CLOB and each
clob contains 30-40k worth of data, per record. What techniques can I
use to search through the clob.
Can I do select * from blah where CLOB_FIELD like '%some_text%' or

I am searching a free type IV jdbc-driver to the Microsoft SQL-Server
and to mySQL, which gives me the database-auto-generated-key back.
OR
Did you have a solution to get the auto-generated-key from the database,

we have a java application that inserts a value (1.4 as a double) into a
SQL Server table column (via an sp) that is of type money.  no problem
there.  another part of the application retreives that information (via
an sp) as a double.  the resultant number is (1.39).