Configure the CData JDBC Driver for CSV in a Connection Pool in Tomcat

The CData JDBC Drivers support standard JDBC interfaces to integrate with Web applications running on the JVM. This article details how to connect to CSV data from a connection pool in Tomcat.

Connect to CSV Data through a Connection Pool in Tomcat

1. Copy the CData JAR and CData .lic file to $CATALINA_HOME/lib. The CData JAR is located in the lib subfolder of the installation directory.
2. Add a definition of the resource to the context. Specify the JDBC URL here.

   The DataSource property must be set to a valid local folder name.

   Also, specify the IncludeFiles property to work with text files having extensions that differ from .csv, .tab, or .txt. Specify multiple file extensions in a comma-separated list. You can also set Extended Properties compatible with the Microsoft Jet OLE DB 4.0 driver. Alternatively, you can provide the format of text files in a Schema.ini file.

   Set UseRowNumbers to true if you are deleting or updating in CSV. This will create a new column with the name RowNumber which will be used as key for that table.

   Built-in Connection String Designer

   For assistance in constructing the JDBC URL, use the connection string designer built into the CSV JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

   java -jar cdata.jdbc.csv.jar

   Fill in the connection properties and copy the connection string to the clipboard.

   You can see the JDBC URL specified in the resource definition below.

   <Resource name="jdbc/csv" auth="Container" type="javax.sql.DataSource" driverClassName="cdata.jdbc.csv.CSVDriver" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" url="jdbc:csv:DataSource=MyCSVFilesFolder;" maxActive="20" maxIdle="10" maxWait="-1" />

   To allow a single application to access CSV data, add the code above to the context.xml in the application's META-INF directory.

   For a shared resource configuration, add the code above to the context.xml located in $CATALINA_BASE/conf. A shared resource configuration provides connectivity to CSV for all applications.

3. Add a reference to the resource to the web.xml for the application. CSV data JSP jdbc/CSV javax.sql.DataSource Container
4. Initialize connections from the connection pool: Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/CSV"); Connection conn = ds.getConnection();

More Tomcat Integration

The steps above show how to connect to CSV data in a simple connection pooling scenario. For more use cases and information, see the JNDI Datasource How-To in the Tomcat documentation.