Ticket #169 (new defect)

Opened 7 weeks ago

Error on baseline installation - Stored Procedures?

Reported by: dbs Owned by: ojacobson
Priority: major Milestone: CONGO 2.1.0
Component: Database Layer Version: 2.0
Keywords: Cc:

Description

org.springframework.beans.factory.BeanCreationException?: Error creating bean with name 'com.stonekeep.congo.database.OptionalSpringLiquibase?#0' defined in ServletContext? resource /WEB-INF/databaseInstallation.xml: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException?: Migration failed for change set classpath:/com/stonekeep/congo/structs/stored-procedures.changelog.xml::get_person_prop::dbs:

Reason: liquibase.exception.JDBCException: Error executing SQL CREATE FUNCTION get_person_prop (v_rid INT, v_cid INT, v_pname VARCHAR(100))

RETURNS VARCHAR(100)
BEGIN

DECLARE ret_val VARCHAR(100);
SELECT prop_value INTO ret_val

FROM reg_properties

WHERE prop_rid = v_rid

AND prop_cid = v_cid
AND prop_name = v_pname;

IF (ret_val IS NULL) THEN

SELECT prop_value INTO ret_val

FROM reg_properties

WHERE prop_rid = v_rid

AND prop_cid = 0
AND prop_name = v_pname;

END IF;

RETURN ret_val;

END:

Caused By: Error executing SQL CREATE FUNCTION get_person_prop (v_rid INT, v_cid INT, v_pname VARCHAR(100))

RETURNS VARCHAR(100)
BEGIN

DECLARE ret_val VARCHAR(100);
SELECT prop_value INTO ret_val

FROM reg_properties

WHERE prop_rid = v_rid

AND prop_cid = v_cid
AND prop_name = v_pname;

IF (ret_val IS NULL) THEN

SELECT prop_value INTO ret_val

FROM reg_properties

WHERE prop_rid = v_rid

AND prop_cid = 0
AND prop_name = v_pname;

END IF;

RETURN ret_val;

END:

Caused By: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Note: See TracTickets for help on using tickets.