Win a copy of Head First Android this week in the Android forum!
    Bookmark Topic Watch Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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 DBCP
  • c3p0
  • Vibur DBCP



  • CategoryFaq
     
    You showed up just in time for the waffles! And this tiny ad:
    Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
      Bookmark Topic Watch Topic
    • New Topic