Rip's Domain

Connecting Railo Express to Oracle XE

Posted in CFWheels, Oracle, Railo by rip747 on October 3, 2010

Follow the instructions to installing Oracle XE and configure a database user.

1) Copy ojdbc14.jar from “C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib” to “C:\railo\lib”

NOTE: for some reason with the jetty version, you need to place the driver in:

<railo-dir>/lib/ext/railo-server/context/lib

2) Start Railo Express

3) Go into Server Administrator and choose to create a new datasource

4) When configuring the database, use the following:

Driver: Other – JDBC Driver
Class: oracle.jdbc.driver.OracleDriver
DSN: jdbc:oracle:thin:@localhost:1521:XE

Tagged with: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: