In-memory databases with Railo

create-table.cfm

<cftry>
	<cfquery name="create" datasource="inmemory">
		CREATE TABLE testTable (
			testID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),
			test VARCHAR(50)
		)
    </cfquery>
<cfcatch type="any">
    <!--- Well this sucks.  Now our application can't do anything. --->
</cfcatch>
</cftry>

test-query.cfm

<cfquery name="insert" datasource="inmemory">
	INSERT INTO testTable (test)
	VALUES(<cfqueryparam value="foo" cfsqltype="cf_sql_varchar" />)
</cfquery>
<cfquery name="select" datasource="inmemory">
	SELECT * FROM testTable
</cfquery>
<cfdump var="#select#">