Has anyone had any luck using the documentation (
http://ode.apache.org/user-guide.html#UserGuide-Examples ) to replace Derby
with MySQL for the [Tomcat-based] Web Application version of ODE?
Using the instructions outlined above, I attempted to replace Derby with
MySQL to see if this would fix any of the process cleanup related issues we
are currently seeing ( Derby is a key suspect in this investigation based on
comments in Jira ODE-666 ).
I am currently connecting to the database OK, and I can see the deployed
processes displayed from the "Processes" tab, but when I submit a
HelloWorld2 soap test and then click on the Instances tab, I am seeing the
following error pop-up display in place of what would ordinarily be the list
of process instances :
"Exception occured in loadInstanceInfo(): java.lang.RuntimeException:
Invocation of method listAllInstances in management interface failed:
Exception while listing instances:
org.apache.openjpa.persistence.PersistenceException: Unknown column
't0.EXEC_STATE_COUNTER' in 'field list' {prepstmnt 9366902 SELECT t0.ID,
t0.DATE_CREATED, t0.EXEC_STATE_COUNTER, t0.EXECUTION_STATE, t0.FAULT_ID,
t0.INSTANTIATING_CORRELATOR_ID, t0.LAST_ACTIVE_TIME, t0.LAST_RECOVERY_DATE,
t0.PREVIOUS_STATE, t0.PROCESS_ID, t0.ROOT_SCOPE_ID, t0.SEQUENCE,
t0.INSTANCE_STATE FROM ODE_PROCESS_INSTANCE t0} [code=1054,
state=42S22][object Element]"
Thanks
David McLure
p.s. Forgive me if this has already been discussed - I did a partial search
with no luck finding anything on this...
--
View this message in context:
http://old.nabble.com/SQL-Exception-attempting-to-substitute-MySQL-for-Derby-on-ODE-tp27772399p27772399.html
Sent from the Apache Ode User mailing list archive at Nabble.com.
