Updating db via xml
Updating db via xml
The problem with using JDBC in a high-load environment is that it can become overwhelmed with requests, and begin dropping them or delaying them, causing a bottleneck in the architecture that slows down the entire application.To avoid this situation, Tomcat uses a technique called connection thread pooling, implemented through a technology called Commons DBCP.
Download the binary distribution appropriate for your platform, extract the JAR file, and copy it to "$CATALINA_HOME/lib".is a file contained in either a block's or package's directory, that defines one or more database tables.These are then created when a block or package is installed.Need to configure My SQL / JDBC on more than one Tomcat instance?Tcat allows you to save common configurations and apply them to any instance instantly. Use Tcat to manage their configurations as a group.We strongly recommend you use the second option, as this will allow you to make changes to your database configuration without restarting your entire server, and also make your application more portable.
The Resource element is used to define the JNDI/JDBC resource, as well as set connection pooling attributes.Before we start setting up the My SQL connection, let's take a quick look at the framework Tomcat uses to handle database connections, a technology called Java Database Connectivity, or JDBC.JDBC provides an abstraction layer between Java applications and database servers, so that an application's code does not need to be altered in order for it to communicate with multiple database formats.Tomcat makes it easy to use this technology by allowing it to be defined as a JNDI Resource, and handling the actual transaction of the connections itself.If this still seems confusing, don't worry - we'll go over all of the steps required to get these technologies working for you in the next section.This is an integer (and not set to auto_increment.) This key maps to an entry in Concrete5's core Blocks table, and is used to join your block-specific data to Concrete5 data about the block (metadata, its positioning, versions, etc...) Now that you've got your shell, you can begin adding fields that you will need for your block.