Recently in ColdFusion Category

NOTE: This is a repost from my personal blog.

I used the drivers here: Precompiled JDBC SQLite drivers
The source is here, though it may not be the same: Source

I dropped the Linux JDBC and .so files into [cfmx7root]/lib/ and restarted ColdFusion. Then I created a database using SQLiteQuery on my Mac and added a table, column and single value. Then I copied the db file to a test folder on my server and just ran a select * from table.

My datasource setting is as follows:

JDBC URL: jdbc:sqlite:\var\www\html\sqlite_test\cfmltest Driver Class: org.sqlite.JDBC Driver Name: sqlitejdbc.jar

At that point, running the code threw an error that the table didn't exist. Permissions were all okay, so I executed a CREATE TABLE via the .cfm file with a different name, column and value. That table showed up. Turns out that the table I created on the Mac only shows up on the Mac via the GUI tool, and the table I created via CF only shows up for CF, even if I query the master table to get a table listing.

I'm thinking that has to be something to do with driver versions. If I get a chance to test further, I'll run some speed tests versus reading and writing files, XML, etc. to see what the speed is like. This is also obviously insecure, you don't want your db file to be readable by the web server.

UPDATE: now that CF8 includes the Derby java database, this is somewhat moot. Though it does give a way to interact with existing sqlite databases. I still don't know why some tables don't show up, again probably a version/driver issue.

The new Penn State Undergraduate Bulletin Online is going live, the previous site is slowly being phased out as links are changed to the new URL.

The site is built on ColdFusion 8, Red Hat Linux AS 4 and MySQL 5. I built the database and wrote the application logic, while the design and standards compliance was handled by Web and Media Design Solutions. The course data comes from the University Course Master, while the majors and other degree programs are HTML files with metadata in the db. I built a very simple CMS to allow the text stewards to maintain the programs and general information sections.

We've already had requests to integrate with other projects in ITS and share data with groups like the Registrar and Commonwealth Campuses. I think this is an excellent opportunity to model new ways of collaborating and especially exposing information in the University's enterprise infrastructure to the web and other channels. I think that we will start to see quite a few new projects in a similar vein in the coming months, as more departments and groups look for ways to share information and meet student needs (and demands).

I worked with quite a few talented and dedicated people on this project, including the sysadmins in my own group, Web and Media Design, AIS and Undergraduate Education. People like these make Penn State a great place to work.