Its not always your site says anything to you

But mine did…It said ‘XDB’.

It was my grails application.This is the login window Firefox showed be gleefully with the message

The site says XDB

IE played dumb(er) – It too presented a login screen – but had a simpler message

XDB

I was in the process of trying a few things in Grails – making those cool domain classes and controllers when it happened. It was working a few minutes ago and then boom !!! it stopped.
And since I am so new to Grails- I thought maybe I had messed up something.

Surprisingly google didn’t get many results either.

Anyway it was enough to tell me the problem was with Oracle

And since I was at that time creating a new Oracle Database on my laptop- <snap> that made perfect sense. (Though I was simply creating a new database instance and not fiddling with the one that my app was using)

Once I stopped and restarted all the Oracle listeners -the problem went away.

So moral of the story ? If the site says XDB- restart your Oracle instance.

There may be more elegant solutions out there- but this is what worked for me

 

Grails quick-start example is a neat way to start off with Grails.

It will show you how to connect to HSQLDB and gets a quick and elementary web app up and running in no time.

But soon, I wanted to get on with the “real” stuff- Oracle

These are the changes I did to connect with Oracle (and errors I encountered on the way).

But first the Version disclaimer

Groovy:1.6.2

Grails: 1.1

Oracle::9.2.0.6.0
A) Changed the DataSource.groovy as follows

dataSource {
pooled = true
driverClassName = “oracle.jdbc.driver.OracleDriver”
username = “user”
password = “password”
dialect=’org.hibernate.dialect.Oracle9Dialect’

}

environments {
development {
dataSource {
dbCreate = “create-drop” // one of ‘create’, ‘create-drop’,'update’
url = “jdbc:oracle:thin:@myservername:1521:mysid”
}
}
// Left test and Production as they were….

}
B) Dropped the oracle driver jar file in the lib folder under the grails- app folder

Bingo !!! That’s it !!!

I got only one error-  (see at the end of this post) And this maybe specific to Oracle 9i.

The fix was to add this line to the  data source.groovy

dialect=’org.hibernate.dialect.Oracle9Dialect’

(If you are using a higher version of Oracle- you may need to use a different Dialect)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dialectDetector’: Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Unsupported feature
at java.security.AccessController.doPrivileged(Native Method)
… 24 more
Caused by: org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Unsupported feature
… 25 more
Caused by: java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4442)
… 25 more
2009-04-27 10:57:39,450 [main] ERROR mortbay.log  – Failed startup of context

 

Today I installed Grails on my work laptop.

And then set to try the quick-start example.

I soon ran into a problem when I tried to create my application using the command

grails create-app MyApp

I got the following error

The syntax of the command is incorrect

I spent some time trying to debug the grails.bat file – but soon fell back on time-tested strategy. If someone has solved it- Google will know about it !!!

And it turns out -I had not installed Groovy !!!

Hmmm – I would have thought either Grails should have had groovy bundled with it or at least politely warned me that I do not have Groovy installed.

And whatever happened to the good old message NoClasssDefFoundError ???

Anyways- once I got Groovy - things went pretty smoothly

And I had my simple app- up and ready in no time.

I also did the following…
Setup up my GROOVY_HOME and GRAILS_HOME
Setup the path to include %GROOVY_HOME%\bin and %GRAILS_HOME%\bin

I know – I would have discovered this beforehand- had I taken the time to read the readme.txt – but I think Grails team could have done a better job by prompting with a better message

© 2011 Technology Cafe Suffusion theme by Sayontan Sinha