Karthikeyan Dharmarajan

Greenhorn
+ Follow
since Jun 21, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Karthikeyan Dharmarajan

Originally posted by Bruce Jin:
Thanks Kathy for the tip.
This thread started 3 years ago and technology has advanced since then!
The tag solution is better I think.


========
test

19 years ago

Originally posted by Bruce Jin:
Thanks Kathy for the tip.
This thread started 3 years ago and technology has advanced since then!
The tag solution is better I think.



test
19 years ago

Originally posted by David O'Meara:
1. With regard to acquiring a dbconnection and holding onto it...is this an appropriate use within a servlet? Or is there some side effect to using the same database connection within a servlet environment.
Sounds like a poor design, particularly if a database connection (or several) are associated with a single servlet. There is raraely a reason not to use a connection pool.

2. Has anyone had a problem like this before? Is it a problem with msaccess or the jdbc-odbc driver?
Or possibly both. Access is a poor choice of dtabase and there are better free alternatives that will be more consistent and stable. Also, the Jdbc-Odbc bridge is a a bit of a hack and I'm not sure it has ever really been supported by Sun - it was released as a quick and easy starter for JDBC, but none of the initial bugs have ever been fixed. And there are many.

3. Am I missing something?
Hypersonic or MySQL? Possibly not quite the answer you were looking for, but starting with a better DB will save you a world of hurt in the long run. Hypersonic is extremely light and MySQL is missing a couple of features, but both are extremely useable and have good JDBC drivers.

Dave.

19 years ago
test
19 years ago