SQL Exception attempting to substitute MySQL for Derby on ODE

[david_mclure <da...@mclures.net>]

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.

Re: SQL Exception attempting to substitute MySQL for Derby on ODE

[david_mclure <da...@mclures.net>]

Hi Tammo,

Ah, good point.  I didn't even notice the version number in the schema
filename.  Odd that it seemed to fix a problem I was having running Beta 3
to an external MySQL database however?

So anyway, I assume these generated schemas you are referring (in the case
of hibernate for example) are the ones I see in the resulting
dao-hibernate-db\target directory after I build - correct?  Or is this the
hibernate schema for the JBI implementation?

For the record, I am attempting to run the axis2-war version of ODE against
an external database (MySQL for starters, but ideally DB2).  I had been
running a Beta 3 build most recently to see if it runs any cleaner, but it
sounds like maybe I should stick to Beta 2 for now (until Beta 3 is
released)?

Thanks

David McLure



Tammo van Lessen wrote:
> 
> David,
> 
> david_mclure wrote:
>> I am finding that the initial problem I mentioned anyway, was due to the
>> following missing schema item: Integer EXEC_STATE_COUNTER  in the posted
>> sql
>> file on the ODE web site:
>> http://ode.apache.org/war-deployment.data/ode_openjpa_mysql-1.3.2.sql.
>> 
>> Could it be that the schema which is checked into the
>> trunk on the Carbon subversion repository is actually the correct schema
>> to
>> be using for ODE 2 Beta 3, and it simply has yet to be published on the
>> ODE
>> web page?
> 
> As indicated by the filename, the schema you were referring to is for
> ODE 1.3.2. The version in the WSO2 repository is probably better for ODE
> 2.0. However, since ODE 2 beta 3 is not yet released, I suggest to build
> ODE and take the generated schemas.
> 
> HTH,
>   Tammo
> 
> -- 
> Tammo van Lessen - http://www.taval.de
> 
> 

-- 
View this message in context: http://old.nabble.com/SQL-Exception-attempting-to-substitute-MySQL-for-Derby-on-ODE-tp27772399p28029464.html
Sent from the Apache Ode User mailing list archive at Nabble.com.

Re: SQL Exception attempting to substitute MySQL for Derby on ODE

[Tammo van Lessen <tv...@gmail.com>]

David,

david_mclure wrote:
> I am finding that the initial problem I mentioned anyway, was due to the
> following missing schema item: Integer EXEC_STATE_COUNTER  in the posted sql
> file on the ODE web site:
> http://ode.apache.org/war-deployment.data/ode_openjpa_mysql-1.3.2.sql.
> 
> Could it be that the schema which is checked into the
> trunk on the Carbon subversion repository is actually the correct schema to
> be using for ODE 2 Beta 3, and it simply has yet to be published on the ODE
> web page?

As indicated by the filename, the schema you were referring to is for
ODE 1.3.2. The version in the WSO2 repository is probably better for ODE
2.0. However, since ODE 2 beta 3 is not yet released, I suggest to build
ODE and take the generated schemas.

HTH,
  Tammo

-- 
Tammo van Lessen - http://www.taval.de

Re: SQL Exception attempting to substitute MySQL for Derby on ODE

[david_mclure <da...@mclures.net>]

I am finding that the initial problem I mentioned anyway, was due to the
following missing schema item: Integer EXEC_STATE_COUNTER  in the posted sql
file on the ODE web site:
http://ode.apache.org/war-deployment.data/ode_openjpa_mysql-1.3.2.sql.

When I began searching the web for possible information on
'EXEC_STATE_COUNTER', I ran across the Carbon wso2.org product
(http://wso2.org/library/carbon ) and noticed that there is a good deal of
Carbon/ODE integration activity these days.  Furthermore, I found the Carbon
schema posted and noticed that it is actually very similar looking to the
ODE schema, but it also seems to have a fix for the missing
EXEC_STATE_COUNTER column (among other things).  Here is the published trunk
of the Carbon schema :

https://wso2.org/repos/wso2/trunk/carbon/products/bps/modules/distribution/sql/mysql.sql

I tried using this schema to ODE with hibernate on a local MySQL database
and it seems to work!  Could it be that the schema which is checked into the
trunk on the Carbon subversion repository is actually the correct schema to
be using for ODE 2 Beta 3, and it simply has yet to be published on the ODE
web page?


-- 
View this message in context: http://old.nabble.com/SQL-Exception-attempting-to-substitute-MySQL-for-Derby-on-ODE-tp27772399p28015930.html
Sent from the Apache Ode User mailing list archive at Nabble.com.