I am trying to write iunit tests for a project I just moved to and I am trying to test out these queries with an in memory h2 database. I have it setup like this: [CODE] <jdbc:embedded-database type="H2" id="dataSource"> <jdbc:script location="cpc_schemaJJF.sql"/> <jdbc:script location="cpc_test-dataJJF.sql"/> </jdbc:embedded-database> [/CODE]
The query that I am attempting to test is: [CODE] SELECT PERMISSION_GRANT_SEQ, ROLE_EFFECTIVE_DT, ROLE_EXPIRATION_DT, grants.PERMISSION_SEQ, roles.ROLE_SEQ, ROLE_NAME, ROLE_DESCRIPTION, resources.GDS_RESOURCE_SEQ, RESOURCE_NAME, RESOURCE_DESC, rules.ACCESS_RULE_SEQ, RULE_NAME, RULE_DESC, locations.IORGM_DISPATCH_SEQ, IORG_NAME, views.DISPATCH_VIEW_SEQ, views.DISPATCH_VIEW_NAME FROM PERMISSION_GRANT grants, USER_ROLE userroles, ROLE roles, PERMISSION permissions, GDS_RESOURCE resources, ACCESS_RULE rules, IORGM_DISPATCH locations, DISPATCH_VIEW views WHERE userroles.user_id = ? and roles.role_seq = userroles.role_seq AND grants.role_seq(+) = roles.role_seq AND grants.PERMISSION_SEQ = permissions.PERMISSION_SEQ(+) and permissions.GDS_RESOURCE_SEQ = resources.GDS_RESOURCE_SEQ(+) and resources.RESOURCE_NAME = views.DISPATCH_VIEW_NAME(+) and permissions.ACCESS_RULE_SEQ = rules.ACCESS_RULE_SEQ(+) and permissions.IORGM_DISPATCH_SEQ = locations.IORGM_DISPATCH_SEQ(+) [/CODE] The problem is with the right outer join "grants.role_seq(+) = roles.role_seq". If I comment that line out all is good, if I leave that in there I get a syntax/grammar error. Does h2 not support this? or is something wrong here? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
