About Oracle Driver

[jcosano]

Changing to Oracle:

Reading documentacion seems that is not complete…

I put ojdbc5.jar in "setup\files\dependencies\libs", and schema creates… but after I have this error:

[deploy-bar] ### Cause: java.sql.SQLException: No suitable driver found for jdbc :oracle:thin:@….
[deploy-bar]    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
[deploy-bar]    at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:81)
[deploy-bar]    at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:32)
[deploy-bar]    at org.activiti.engine.impl.db.DbSqlSession.<init>(DbSqlSession.java:55)‍‍‍‍‍

Any idea?

[frederikherema1]

Did you put the driver in before you ran the demo.start (or install)?
If not, try running 'demo.stop demo.clean cfg.create demo.start', this makes sure the libs are copied to the right location (in this case, the example libs)

[jcosano]

Same error after:

'demo.stop demo.clean cfg.create demo.start'

and "ojdbc5.jar" is in "setup\files\dependencies\libs"

In fact, schema is created fine… error is after…

[frederikherema1]

Can you check if the ojdbc5.jar is present in the folowing dir:
distro/workspace/activiti-engine-examples/libs-rumtime
or

distro/workspace/activiti-engine-examples/libs-test
If not, put it in one of those folders in order to get it on the ant task deploy-bar's classpath.

[jcosano]

Ok…
Now works fine…

I put file under
distro/workspace/activiti-engine-examples/libs-test
Thanks!!

[heymjo]

FYI i just ran into the same thing with 5.2, caused by 2 minor issues IMO

1) The documentation is incomplete, where it says

Copy the downloaded ojdbc5.jar to setup/files/dependencies/libs/ This filename is

the name of the file is actually missing. It should be named objdbc5.jar and nothing else, for me this was not obvious since i had copied a jdbc driver from my local m2 repo and it was named completely different

2) setup/files/dependencies/libs.engine.test.txt contains this


drools-api-5.1.1.jar
drools-compiler-5.1.1.jar
drools-core-5.1.1.jar
ecj-3.5.1.jar
geronimo-jta_1.1_spec-1.1.1.jar
h2-1.2.132.jar
hamcrest-core-1.1.jar
jtds-1.2.4.jar
junit-4.8.1.jar
mockito-core-1.8.2.jar
mvel2-2.0.16.jar
mysql-connector-java-5.1.6.jar
objenesis-1.0.jar
postgresql-8.4-701.jdbc4.jar
subethasmtp-smtp-1.2.jar
subethasmtp-wiser-1.2.jar
ojdbc5.jar

Note that the files are in alphabetical order, except for ojdbc5.jar. Now when i modify this file and put ojdbc5.jar in its correct alphabetical place, just after objenesis-1.0.jar, then (for a reason far beyond my imagination) it works


drools-api-5.1.1.jar
drools-compiler-5.1.1.jar
drools-core-5.1.1.jar
ecj-3.5.1.jar
geronimo-jta_1.1_spec-1.1.1.jar
h2-1.2.132.jar
hamcrest-core-1.1.jar
jtds-1.2.4.jar
junit-4.8.1.jar
mockito-core-1.8.2.jar
mvel2-2.0.16.jar
mysql-connector-java-5.1.6.jar
objenesis-1.0.jar
ojdbc5.jar
postgresql-8.4-701.jdbc4.jar
subethasmtp-smtp-1.2.jar
subethasmtp-wiser-1.2.jar

HTH
Jorg

[frederikherema1]

Jorg,

Thanks for pointing that out in the userguide, I'll fix it on trunk!
The dependencies.txt is used to copy the libs to the right place using ant, the order doesn't matter I would presume…

[heymjo]

my bad, the ordering indeed does not matter !

It is still necessary though to manually copy the ojdbc5.jar to workspace\activiti-engine-examples\libs-test\

Cheers
Jorg

[frederikherema1]

Hemyo,

Once the libs are copied to the examples, this isn't copied anymore when calling demo.start/demo.install, since the libs are already present (the folders that is). So if the ojdbc5.jar wasn't present the first time you ran the demo,  it won't be copied agian. You force fix this by deleting the libs-test and libs-runtime and running the demo.install again.

[hawkeyeerik]

Thanks jcosano and frederikheremans, setting up Activiti 5.2 from scratch was much smoother with this knowledge than 5.1 did 😄

I had to create the libs-test folder, too, for anyone looking for it in the distribution.