ii haven't been able to connect to Oracle with the username and passwd in
the URL. THis is the only way i've found:
Connection connection = DriverManager.getConnection(url, username,
password);
Joe Niski | Senior Software Engineer/Internet Architect
503.548.2176
CYBERSIGHT
strategy . marketing . design . technology
los angeles . portland . san francisco . toronto
> -----Original Message-----
> From: Lars Travers [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 10:48 AM
> To: JRun-Talk
> Subject: session persistence
>
>
> 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:@h
> ost: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
