Well, finally I didn't find out why this syntax error happens, but I found a
workaround.

(Caused by: java.util.concurrent.ExecutionException: <0.9.7-incubating
nonfatal general error>
org.apache.openjpa.persistence.PersistenceException:
Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT,
t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM
STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+)
ORDER BY t1.DU ASC} [code=30000, state=42X01])

The "(+)" is generated when a native join is used in an Oracle database, but
it's not the case because I didn't set an Oracle database for Apache ODE, I
just used the default configuration with an embedded Derby database. 

I tried the same tomcat, the same ode.war and the same BPEL process and the
same JVM in Windows and it worked.
Then the problem is with the environment.
I suppose that since there's an ORACLE_HOME environment variable and the
username in Linux is "oracle", and the owner of the files is "oracle", maybe
openjpa wrongly supposed that I was working with an Oracle database. I don't
have time to make a deeper research in this, Christmas is close.

As a workaround I ran an external Derby database in the same server, created
the ode-axis2.properties, and set the JNDI definition and it worked.

Thanks for your help anyway!

Iván Rivera

-- 
View this message in context: 
http://www.nabble.com/Deployment-of-%3Cbpelprocess%3E-failed%2C-aborting-for-now..-DbError-tp14339737p14441799.html
Sent from the Apache Ode User mailing list archive at Nabble.com.

Reply via email to