[OT] re: need help

[Josh Rayls <jr...@crunchtime.com>]

You can use CLOBs and BLOBs with the thin driver according this example:

http://www.experts-exchange.com/Databases/Oracle/Q_20358143.html

Configure a datasource in Tomcat, so that you don't create a connection like
you do below. You should have a call like so:

DataSource ds = ctx.lookup("myDataSource");
ds.getConnection();

Try those items out.  That should get you started.

-Josh

-----Original Message-----
From: Sergey Livanov [mailto:sergey.livanov@ukrpost.net]
Sent: Tuesday, April 22, 2003 4:56 PM
To: Josh Rayls
Subject: 


Thank y  for answer !
Questions:

1.  Why are you using the OCI driver instead of the thin driver?
    I try use CLOB field.   
   Oracle JDBC drivers notes that only OCI8 drivers supports LOBs
2.  Why are you not using a datasource?
    Than I will use DataSource.
    DriverManager.registerDriver ( new ... ) ;
   and   Connection con=DriverManager.gerConnection (
"jdbc:oracle:oci8:@DS", "user", "psw"  )
3.  What app server?
     Apache Tomcat 4.0.1

--
Укрпост - продвинутая почта. http://www.ukrpost.net/
IMAP POP3 NNTP RSSNews Unicode.