OK, I am using JDBC with servlets already, but am struggling with one
interesting database issue. How can I search "unstructured fields", i.e.,
let us say, I want to search a description of a book that I have in the
database. My best guess, after some "suffering" was that I would record
this information to a text file, perhaps or text file database and then link
it back to "structured information". Is there any better way to do it?
Thanks for ideas!
-- Edas
----- Original Message -----
From: Henner Zeller <[EMAIL PROTECTED]>
To: Java-Servlets <[EMAIL PROTECTED]>
Sent: Friday, May 28, 1999 11:17 PM
Subject: [OffTopic] Re: Oracle connections
>
> Hi,
> On Fri, 28 May 1999, Ross J.P. Ethier wrote:
> RJPE |If this is the type 4 driver supplied by Oracle, it seems to only
handle 50
> RJPE |uses per connection and then the connection blows up!
>
> We use these type 4 drivers (JDBC-thin) on a production server and we
> can use one connection for serveral 100k transactions in a connection
> pool.
> We had problems with errors like 'too many open cursors'-errors or
> the like first (I think that is what you mean with 'connection blows up').
> But this seems to be a bug in ResultSet and Statment handling of oracle.
> If you consequently close your ResultSets and Statemets (which you should
> do anyway) after use, the type 4 drivers are quite stable.
> To make sure that we close rsets and statements we utilize the finally
> clause auf java:
> ----
> ResultSet rset=null;
> Statement stmt=null;
> try {
> stmt = new Statement();
> rset = ..
> // do processing here
> }
> catch () {
> }
> finally {
> if (rset != null) rset.close();
> if (stmt != null) stmt.close();
> }
> -----
>
> ciao,
> -hen
> ---
> Henner Zeller [EMAIL PROTECTED]
> PGP pub key [77F75B39]: finger [EMAIL PROTECTED]
>
> "One difference between SuSE and Red Hat is that the former operates in a
> country where people don't sue each other over coffee being too hot."
> Linus Torvalds
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
