I'm trying to set up the local.properties file so that when the jrun3 server is
restarted all session objects will be written to a database. The example I've
seen (in article "JRun Session Persistence" by Karl Moss) demonstrates this with
an odbc driver. However, I would like to try this with the oracle thin driver
which is what is currently installed. I have tried specifying the
JDBCConnectionURL in many ways, but I have not found the correct one. Does
anyone know exactly how to specify the
session.persistence.jdbc.JDBCConnectionURL for the case when the driver is
specified as
session.persistence.jdbc.JDBCDriver=oracle.jdbc.driver.OracleDriver ?

How do you specify the username and password?

I have tried this:
session.persistence.jdbc.JDBCConnectionURL=jdbc:oracle:thin:@host:1521:name

It doesn't work and I don't see how it could without specifying the username and
password. So, I've tried adding:

session.persistence.jdbc.JDBCUsername=username
session.persistence.jdbc.JDBCPassword=password

but, this also fails.

Does anyone know if the thin driver can be used for session persistence? Where
exactly is the documentation for this and its specification in the properties
file?

I very much appreciate any help with this.

Lars

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to