I'm trying to set up my web app to be able to use GORM to access an existing oracle database. It seems to work in some ways but I'm getting the following error:
Error 500: Executing action [list] of controller [timesheet.LeaveRequestController] caused exception: could not execute
query; SQL [select this_.REQ_ID as REQ1_0_0_, this_.version as version0_0_, this_.REQ_APPROVED as REQ3_0_0_,
this_.REQ_APPROVED_BY as REQ4_0_0_, this_.REQ_APPROVED_DT as REQ5_0_0_, this_.REQ_COMMSERV_CODE as
REQ6_0_0_, this_.REQ_DESC as REQ7_0_0_, this_.REQ_DONATE_TO as REQ8_0_0_, this_.REQ_END as REQ9_0_0_,
this_.REQ_LEAVE_CODE as REQ10_0_0_, this_.REQ_PIDM as REQ11_0_0_, this_.REQ_START as REQ12_0_0_,
this_.REQ_USER_ID as REQ13_0_0_ from LREQUEST this_ where (this_.REQ_USER_ID=?)]; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query
Servlet: grails
URI: /TimeSheet/grails/leaveRequest/list.dispatch
Exception Message: ORA-00904: "THIS_"."VERSION": invalid identifier
Caused by: ORA-00904: "THIS_"."VERSION": invalid identifier
Class: LeaveRequestController
At Line: [25]
Line 25 is:
userLeaveRequestList = LeaveRequest.findAllWhere(userName: session?.getAttribute(CASFilter.CAS_FILTER_USER))
I think the issue may be with how I mapped my domain classes:
String pidm, approvedBy, description, userName, donateTo
Date startDate, endDate, approvedDate
LeaveType leaveType
CommunityServiceType communityServiceType
Boolean approved
static mapping = {
table 'LREQUEST'
id column: 'REQ_ID', index:'APPCLASSPHOTOS.LREQUEST_SEQ'
pidm column: 'REQ_PIDM'
startDate column: 'REQ_START'
endDate column: 'REQ_END'
description column: 'REQ_DESC'
leaveType column: 'REQ_LEAVE_CODE'
communityServiceType column: 'REQ_COMMSERV_CODE'
donateTo column: 'REQ_DONATE_TO'
userName column: 'REQ_USER_ID'
approvedBy column: 'REQ_APPROVED_BY'
approvedDate column: 'REQ_APPROVED_DT'
approved column: 'REQ_APPROVED'
}
Am I correctly mapping the ID value?
Thanks for any aid.
Locked
