Re: Big Crash

[E M]

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.