I have been informed to use:
jdbc:oracle:thin:scott/tiger@server_name:1521:oracle_sid
whare scott/tiger is username/password
It seems to work!
Lars Travers wrote:
>
> 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
