Re: Big Crash
Posted by: E M
Date: February 25, 2005 11:51PM

Okay, I am still learning this.

I have several questions, please bear with me:
1. I got the tip from another forum to simply create 1 connection and leave it OPEN for the duration of the application (which in my case is years idealistically). Is this a bad idea?
2. Should I create a new connection for each operation and always close it when I'm done, like in your example?
3. How do I use PreparedStatements as they are tied to a particular connection. Should I redefine them each time I create a new connection?
4. What connection pools or utilities can I use? As it will probably save me alot of time. All I really want to do is pass Statements and PreparedStatements to it and recieve back a recordset or exce├Âtion without too much hastle.

Options: ReplyQuote

Written By
February 24, 2005 10:04AM
February 24, 2005 11:23AM
February 24, 2005 02:19PM
February 24, 2005 02:33PM
February 24, 2005 05:34PM
February 25, 2005 01:36AM
February 25, 2005 11:04AM
Re: Big Crash
February 25, 2005 11:51PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.