Posts

Showing posts from January, 2011

Setting up Grails project on Oracle XE database

If you have some code already working on another database, say Postgres, and you want to set it up on Oracle XE database, there are some things to consider. You have to change the application data source (conf/DataSource.groovy) and move the Oracle jdbc driver to /lib - all that is explained pretty well here . Basically the result will be something like this: You might have some troubles with the url, here is a little explanation: I'm running the XE database on my local host, hence the host is: 127.0.0.1. 1521 is the default database listener port for Oracle XE XE is the default SID for Oracle XE Oracle XE and port setup While we are talking about ports. The default http interface port for Oracle XE management through APEX is 8080 and it might be in collision with other software you are running, like our grails app. You can read on here to find out the way to check default ports and those set on your configuration and also how to change them. Oracle XE and reserve