The driver has to be accessible from the same classloader as tomcat-jdbc.jar username (String) The connection username to be passed to our JDBC driver to establish a connection. driverClassName (String) The fully qualified Java class name of the JDBC driver to be used.

Starting in MySQL-4.1, 'schema' is an alias for 'database', but it doesnt act like a SQL-standard schema, so we dont support the concept in the JDBC driver. To do so in Java with JDBC, you can call the getCatalogs() method of the DatabaseMetaData class. (String) The default catalog of connections created by this pool. For legacy reasons (including compatibility with ODBC, and SQL Server), JDBCs concept of 'catalog' maps to MySQLs concept of 'databases'.

This is the javadoc description of argument 'catalog' to () in Sun JDK 1.4.2 and 1.5.0:Ĭatalog - a catalog name must match the catalog name as it is stored in this database '' retrieves those without a catalog null means that the catalog name should not be used to narrow the searchīut looking at the 3.1.10 source code of, that is not how it is implemented:ĭatabasePart = ' FROM ' + this. Setup a MySQL database: Create a directory data/ where we’ll store MySQL dump files with the pre-cleaned books data for the books table, as well as the triggers for the books table (on create, update, and delete), and a newarrivals table with books we will add to our catalog to simulate new records, and the table booksjournal. Sometimes we need to get all database names (schemas or catalogs) available in the database server.

Mysql jdbc catalog