• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Schema's in Grails

 
mohan pemm
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have just started learning grails. As per my database design, I had to retrieve data from different databases.
Ex: select a.*, b.* from db1.myTable1 a, db2.myTable2 b.

Where do I specify the schema or daabase settings? Is it in ApplicationDataSource.groovy?

My ApplicationDataSource.groovy file contents are:

class ApplicationDataSource {
static mapping =
{
table 'db1.myTable'
}
//String dbCreate = "update" // one of 'create', 'create-drop','update'
String url = "jdbcracle:thin:@localhost:1521:CMDDB1"
String driverClassName = "oracle.jdbc.OracleDriver"
String username = "username"
String password = "password"
}


Regards
PVM
 
mohan pemm
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

In the above query posted, I would like to know where and how do we specify the database names.

Regards,
PVM
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic