How to set up HXTT Text (CSV) with Coldfusion MX 6.1 Application Server?
For instance,your Coldfusion MX is installed at C:\CFusionMX\, and wish to use Text_JDBC30.jar. 1. Please copy Text_JDBC30.jar into C:/CFusionMX/wwwroot/WEB-INF/classes/. 2. Use http://yourhost:8500/CFIDE/administrator/index.cfm to enter the CFMX Administrator. 3. Go to the “Java and JVM” of Server Settings, http://yourhost:8500/CFIDE/administrator/settings/jvm.cfm page, and enter the full path, C:/CFusionMX/wwwroot/WEB-INF/classes/Text_JDBC30.jar, in the Class Path. Then, click “Submit Changes”. 4. Restart the CFMX Service. 5. Please go back to the administrator page, and go to the “Data Sources” of Data & Services, http://yourhost:8500/CFIDE/administrator/datasources/index.cfm page, and enter the name for the new datasource, for instance “TextTest”, and select “Other” for the driver. Then Click “Add”. 6. Enter the datasource information. JDBC URL is always in the format jdbc:text:[//[host:port]]/[DatabasePath], for instance jdbc:text:/c:/data. Driver class is always com.hxtt.sql.text