Connecting Railo Express to Oracle XE

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

Advertisement