GeneralJdbcQuestions - Want to know what
JDBC is and where to get started?
JdbcConnectionQuestions - Need help resolving problems getting connections?
JdbcUsageQuestions - Problems using JDBC (once you have a connection)
OdbcJdbcQuestions - Questions specifically about the JDBC/ODBC Bridge
SqlJdbcQuestions - Questions about SQL itself
SqlBestPractices - Some advice on how to make the best use of SQL
Database-specific Questions and Answers
OracleFaq - Questions specific to the Oracle database
Q: What does the phrase "normal form" mean in the context of database design?
Practical database design, Part 2 and
An Introduction to Database Normalization are very readable articles that should get you started.
Q: What are techniques for preventing SQL injection?
Proper use of
PreparedStatement prevents SQL injection attacks.
Our
JDBC Forum has this interesting discussion on some of the ways to
prevent SQL injection
Connection pools
In most concurrent execution environments (like
servlet containers and app servers) DB access would be done via a connection pool. Mostly the server software would have one built in (like
Tomcat ships
with DBCP), but if for some reason you need to set up your own, here are some good choices:
Apache Commons DBCPc3p0Vibur DBCP
CategoryFaq