FAQ/Database

Preface

This page is to discuss database error and DBCP. Until more content can appear here, here are some links to the mail archives to perform some searches:

• database

• datasource

• oracle

• mysql

• dbpool

Other Links of interest:

• JNDI Datasource HOW-TO

Other notes:

• Do not use JDBC-ODBC bridge bundled with Sun's JDK with Tomcat. It was never meant for a production server environment. If you ask a question about it, everyone will tell you to not use it. If you do need to use ODBC, there are 3rd party drivers which do a pretty good job at being thread safe.

• If you use the oracle thin driver, be sure to rename it to a jar file from a zip file. Tomcat only auto-magically loads files ending in .jar placed in a lib directory. It ignores all other file extensions.