I've done the run-war in both dev and prod modes. No external configs.
================================
This is the contents of the Config.groovy in it's current incarnation:
The place where I'm getting funky is in the uvm and rnt section at the bottom.
Config.groovy:
// locations to search for config files that get merged into the main config
// config files can either be Java properties files or ConfigSlurper scripts
// grails.config.locations = [ "classpath:${appName}-config.properties",
// "classpath:${appName}-config.groovy",
// "file:${userHome}/.grails/${appName}-config.properties",
// "file:${userHome}/.grails/${appName}-config.groovy"]
// if (System.properties["${appName}.config.location"]) {
// grails.config.locations << "file:" + System.properties["${appName}.config.location"]
// }
grails.project.groupId = appName // change this to alter the default package name and Maven publishing destination
grails.mime.file.extensions = true // enables the parsing of file extensions from URLs into the request format
grails.mime.use.accept.header = false
grails.mime.types = [ html: ['text/html','application/xhtml+xml'],
xml: ['text/xml', 'application/xml'],
text: 'text/plain',
js: 'text/javascript',
rss: 'application/rss+xml',
atom: 'application/atom+xml',
css: 'text/css',
csv: 'text/csv',
all: '*/*',
json: ['application/json','text/json'],
form: 'application/x-www-form-urlencoded',
multipartForm: 'multipart/form-data'
]
// URL Mapping Cache Max Size, defaults to 5000
//grails.urlmapping.cache.maxsize = 1000
// What URL patterns should be processed by the resources plugin
grails.resources.adhoc.patterns = ['/images/*', '/css/*', '/js/*', '/plugins/*']
// The default codec used to encode data with ${}
grails.views.default.codec = "none" // none, html, base64
grails.views.gsp.encoding = "UTF-8"
grails.converters.encoding = "UTF-8"
// enable Sitemesh preprocessing of GSP pages
grails.views.gsp.sitemesh.preprocess = true
// scaffolding templates configuration
grails.scaffolding.templates.domainSuffix = 'Instance'
// Set to false to use the new Grails 1.2 JSONBuilder in the render method
grails.json.legacy.builder = false
// enabled native2ascii conversion of i18n properties files
grails.enable.native2ascii = true
// packages to include in Spring bean scanning
grails.spring.bean.packages = []
// whether to disable processing of multi part requests
grails.web.disable.multipart=false
// request parameters to mask when logging exceptions
grails.exceptionresolver.params.exclude = ['password']
// enable query caching by default
grails.hibernate.cache.queries = true
// set per-environment serverURL stem for creating absolute links
environments {
development {
grails.logging.jul.usebridge = true
}
production {
grails.logging.jul.usebridge = false
// TODO: grails.serverURL = "
http://www.changeme.com"
}
}
// log4j configuration
log4j = {
// Example of changing the log pattern for the default console
// appender:
//
//appenders {
// console name:'stdout', layout:pattern(conversionPattern: '%c{2} %m%n')
//}
error 'org.codehaus.groovy.grails.web.servlet', // controllers
'org.codehaus.groovy.grails.web.pages', // GSP
'org.codehaus.groovy.grails.web.sitemesh', // layouts
'org.codehaus.groovy.grails.web.mapping.filter', // URL mapping
'org.codehaus.groovy.grails.web.mapping', // URL mapping
'org.codehaus.groovy.grails.commons', // core / classloading
'org.codehaus.groovy.grails.plugins', // plugins
'org.codehaus.groovy.grails.orm.hibernate', // hibernate integration
'org.springframework',
'org.hibernate',
'net.sf.ehcache.hibernate'
}
uvm{
queries{
student_info='''
select SPRIDEN_PIDM, SPRIDEN_ID, SPRIDEN_LAST_NAME, SPRIDEN_FIRST_NAME, SPRIDEN_MI
, SPBPERS_PREF_FIRST_NAME, spbpers_confid_ind, spbpers_birth_date, gwbntid_netid
, SPRADDR_STREET_LINE1, SPRADDR_STREET_LINE2, SPRADDR_STREET_LINE3, SPRADDR_STREET_LINE4
, SPRADDR_CITY, SPRADDR_STAT_CODE,SPRADDR_ZIP
-- Get CSO first, else get most recent 'student' email address
, NVL((select goremal_email_address from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code = 'CSO')
,(select goremal_email_address from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code NOT IN ('FAP', 'AUTH', 'FWSS', 'PY')
and goremal_activity_date = (select max(goremal_activity_date) from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code NOT IN ('FAP', 'AUTH', 'FWSS', 'PY') ))) "GOREMAL_EMAIL_ADDRESS"
--Dummy for testing because AIST is full of crap data.....
-- , SPRIDEN_FIRST_NAME || '.' || SPRIDEN_LAST_NAME || '-' || gwbntid_netid || '@uvm.edu' "GOREMAL_EMAIL_ADDRESS"
, CASE WHEN gwbntid_netid is null then null ELSE gwbntid_netid || '@uvm.edu' END "alternateEmail"
from spriden, spbpers, gwbntid, spraddr
where spriden_change_ind is null
and SPRIDEN_ENTITY_IND = 'P'
and spriden_pidm = ?
and spriden_pidm = spbpers_pidm
and spriden_pidm = gwbntid_pidm (+)
and spraddr.rowid = rowidtochar(swf_addr_row(spriden_pidm, 'AP,AL', sysdate))
'''
student_email='''
select goremal_emal_code, goremal_email_address from goremal
where goremal_pidm = ? and goremal_status_ind = 'A'
'''
//student_pidm="select spriden_pidm from spriden where spriden_id = ? and spriden_change_ind is null"
student_pidm="select gb_common.f_get_pidm(?) pidm from dual"
fetch_population = '''
select glbextr_key from glbextr
where glbextr_application = ? and glbextr_selection = ?
and glbextr_creator_id = ? and glbextr_user_id = ?
'''
}
}
rnt{
uid = "IDID"
pwd = "PWD"
appid = "MLM Tester"
buff_size = 500
}
Snippet from render(text: grailsApplication.config, contentType: "text/plain", encoding: "UTF-8") when doing a run-app from the command line:
(Sorry it is verbose) but the uvm={queries={student_info= query is wrong as is the rnt.buff_size
log4j=Config$_run_closure2@27222045, uvm={queries={student_info=
select SPRIDEN_PIDM, SPRIDEN_ID, SPRIDEN_LAST_NAME, SPRIDEN_FIRST_NAME, SPRIDEN_MI
, SPBPERS_PREF_FIRST_NAME, spbpers_confid_ind, spbpers_birth_date, gwbntid_netid
, SPRADDR_STREET_LINE1, SPRADDR_STREET_LINE2, SPRADDR_STREET_LINE3, SPRADDR_STREET_LINE4
, SPRADDR_CITY, SPRADDR_STAT_CODE,SPRADDR_ZIP
-- Get CSO first, else get most recent 'student' email address
-- , NVL((select goremal_email_address from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code = 'CSO')
-- ,(select goremal_email_address from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code NOT IN ('FAP', 'AUTH', 'FWSS', 'PY')
-- and goremal_activity_date = (select max(goremal_activity_date) from goremal where goremal_pidm = spriden_pidm and goremal_status_ind = 'A' and goremal_emal_code NOT IN ('FAP', 'AUTH', 'FWSS', 'PY') ))) "GOREMAL_EMAIL_ADDRESS"
--Dummy for testing because AIST is full of crap data.....
, SPRIDEN_FIRST_NAME || '.' || SPRIDEN_LAST_NAME || '-' || gwbntid_netid || '@uvm.edu' "GOREMAL_EMAIL_ADDRESS"
, CASE WHEN gwbntid_netid is null then null ELSE gwbntid_netid || '@uvm.edu' END "alternateEmail"
from spriden, spbpers, gwbntid, spraddr
where spriden_change_ind is null
and SPRIDEN_ENTITY_IND = 'P'
and spriden_pidm = ?
and spriden_pidm = spbpers_pidm
and spriden_pidm = gwbntid_pidm
and spraddr.rowid = rowidtochar(swf_addr_row(spriden_pidm, 'AP,AL', sysdate))
......
}}, rnt={uid=MartyM, pwd=password, appid=MLM Tester, buff_size=3}, dataSource=.......
================================
If I do a find in the project for "and spriden_pidm = gwbntid_pidm" and it finds grails-app/conf/Config.groovy and target/classes/Config$_run_closure3_closure7.class. and the do have the (+) in the text.
I recognize the data that is showing in the run-app. But that was another project (and an old version of the config in that project as well.
Locked
