[opencms-dev] Compatibility with Oracle v.11.2

[Georgi Naplatanov]

Hi Alex,

you can run junit test against Oracle DB. You have to do the following 
steps to do that.

1. open test/test.properties and uncomment the line with

db.product=oracle

the rest of file must be commented

2. In the file test/data/WEB-INF/config.oracle/opencms.properties
set JDBC URL, database user and password

3. run the following commands

$ ant bindist
$ ant single-unittest -Dtest=file.AllTests
$ ant single-unittest -Dtest=ade.publish.AllTests

If there are not problems (all tests are passed) you (probably) won't 
have problems with that version of Oracle DB server.

HTH

Best regards
Georgi

On 06/06/2013 01:01 PM, � wrote:
> Hi all,
>
> Whether OpenCms v8.5.1 is actually compatible or not with Oracle v11.2
> is not specified in the release notes of OCMS current version. As stated
> in the version notes:
>
> *Compatibility with Java versions, Servlet containers and Databases***
>
> *Please note: OpenCms version 8.5.1 requires Java 6 because of library
> dependencies. *
>
> OpenCms 8.5.1 has been written and tested for Java 6 and 7. We have
> tested only with ORACLEs version of the JDK. However, OpenCms has no
> dependencies to sun.* packages so it should in theory run with all
> compliant JVMs.
>
> We have tested this release on the Tomcat servlet engine. OpenCms works
> "out of the box" with Tomcat 7, which we recommend. Others have reported
> deploying OpenCms successfully on other servlet containers like JBoss,
> BEA, Websphere, Glassfish and Resin Professional.
>
> On the database side, we have tested with MySQL, Oracle, PostgreSQL, MS
> SQL Server, DB2 and HSQLDB. The automatic update wizard for OpenCms
> 8.5.1 supports MySQL, Oracle and PostgreSQL.
>
> Has anyone had any trouble running OpenCms using such version (v11.2) of
> Oracle databases?
>
> Thanks in advance,
>
> *�lex Rodr�guez Bacardit* <http://www.linkedin.com/in/alexrodba>
> Consultore-Business
> alex.rodriguez at vass.es <mailto:alex.rodriguez at vass.es>
>
> *VASS Consultor�a de Sistemas**
> *Tel: +34 93 182 0963
> Fax: +34 933 184 291
> Avinguda Diagonal 210, 4a planta
> 08018 Barcelona
> www.vass.es <http://www.vass.es/>
>
> Este correo electr�nico as� como los documentos adjuntos contienen
> informaci�n confidencial y reservada. Si ha recibido este mensaje por
> error siga las instrucciones contenidas en nuestro Aviso Legal
> <http://vass.es/es/aviso-legal>. Si no deseara recibir m�s
> comunicaciones por correo electr�nico comun�quelo en la siguiente
> direcci�n: general at vass.es <mailto:general at vass.es>
>
> PAntes de imprimir este mensaje, aseg�rese de que es necesario. El medio
> ambiente est� en nuestra mano.
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>