Postgresql Single quotes!

Dear All,

Just wanted to share how we can incorporate single quote in postgresql plpgsql.

Say i want dynamic query like select id from emp where empname ilike 'Rahul Teni' and age > 25

name:='Rahul Teni'

query:= 'select id from emp where empname ilike' ||''''||name||''''||'and age >25'

I hope this helps and saves your lot's of time.

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect - oracle

Hi,

If you are getting following exception,

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect for database name [Oracle]!

at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:135)

at grails.web.container.EmbeddableServer$start.call(Unknown Source)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)

at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:287)

at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)

at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)

at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)

at _GrailsRun_groovy.runInline(_GrailsRun_groovy:115)

at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)

at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)

at RunApp$_run_closure1.doCall(RunApp.groovy:33)

at gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy)

at gant.Gant.withBuildListeners(Gant.groovy:344)

at gant.Gant.this$2$withBuildListeners(Gant.groovy)

at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)

at gant.Gant.dispatch(Gant.groovy:334)

at gant.Gant.this$2$dispatch(Gant.groovy)

at gant.Gant.invokeMethod(Gant.groovy)

at gant.Gant.processTargets(Gant.groovy:495)

at gant.Gant.processTargets(Gant.groovy:480)

It might be becuase your hibernate dialect for database oracle is not set properly.

You need to add this line dialect='org.hibernate.dialect.Oracle10gDialect' in your database configuration file for your grail application in datasource part.

Please take a note it must be added to datasource part not hibernate part.

I hope this helps.

Regards

Rahul Teni