topic Re: About Oracle Driver in Alfresco Archive

About Oracle Driver

jcosano — Tue, 14 Dec 2010 09:25:56 GMT

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 racle:thin:@….[deploy-bar] at org.apache.ibat

Re: About Oracle Driver

frederikherema1 — Tue, 14 Dec 2010 09:31:26 GMT

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)

Re: About Oracle Driver

jcosano — Tue, 14 Dec 2010 09:47:08 GMT

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…

Re: About Oracle Driver

frederikherema1 — Tue, 14 Dec 2010 09:51:39 GMT

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.

Re: About Oracle Driver

jcosano — Tue, 14 Dec 2010 09:58:02 GMT

Ok…
Now works fine…

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

Re: About Oracle Driver

heymjo — Tue, 01 Feb 2011 15:42:10 GMT

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

Re: About Oracle Driver

frederikherema1 — Tue, 01 Feb 2011 16:13:57 GMT

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…

Re: About Oracle Driver

heymjo — Wed, 02 Feb 2011 09:22:23 GMT

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

Re: About Oracle Driver

frederikherema1 — Wed, 02 Feb 2011 09:36:44 GMT

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.

Re: About Oracle Driver

hawkeyeerik — Fri, 04 Feb 2011 16:31:43 GMT

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.