Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Groovy SQL Problem

 
Sabarish Venkat
Ranch Hand
Posts: 136
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you gregg i will try it out and one more problem am facing am using a query like this

but am getting error alone how to resolve it. how i can use the where clause without changing the sql.eachRow statement
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll have to show the complete error message. But typically, that should be written like this:



Another note, the thread I split this from was about Grails. If you're doing this in a Grails app, you're making it too hard. You should do:

 
Sabarish Venkat
Ranch Hand
Posts: 136
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you so much gregg
 
Ashish Agre
Ranch Hand
Posts: 73
Java Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Another note, the thread I split this from was about Grails. If you're doing this in a Grails app, you're making it too hard. You should do:

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic