[opencms-dev] new build for JPA driver

[Yves Glodt]

On Tuesday 31 March 2009, Georgi Naplatanov wrote:
> Hello Yves.
>
> I use Debian too :), but testing with Firebird 2.1 superserver.

Good choice ;-)

With these instructions (I just modified the database path and filename) it 
worked, the setup is currently finishing. The reason might be the 
"defaultResultSetHoldable"-parameter...?

Thanks for your help!!
Yves

> I make the following steps to install OpenCms with Firebird.
>
> 1. creating database manually
> 	$ isql-fb -user SYSDBA -password masterkey
> 	SQL> create database '/var/lib/firebird/2.1/data/opencms' page_size 16834
> ;
>
> 2. start your JSP container
> 3. Fill parameters for the installer
> 	User name  - SYSDBA
> 	password - masterkey
> 	JDBC driver class name - org.firebirdsql.jdbc.FBDriver
> 	Connection String - jdbc:firebirdsql://localhost
> 	Database -
> /var/lib/firebird/2.1/data/opencms?defaultResultSetHoldable=true
>
> That is all.
>
> There is a screenshot
> http://os.oles.biz/opencms/jpa-driver/screenshots/firebird-2.1.jpg
>
> Best regards
> Georgi
>
> Yves Glodt wrote:
> > Hello Georgi,
> >
> > I try to install the new release with Firebird 2.0 on debian lenny, but I
> > fail... Can you tell me the exact parameters for "connection string" and
> > "database" in the setup wizard?
> >
> > Whatever I tried, I failed with the following errormessages:
> >
> > Error connecting to database using:
> > "jdbc:firebirdsql://localhost://storage/firebird/opencms.fdb".
> >
> > or
> >
> > Error connecting to database using:
> > "jdbc:firebirdsql://localhost:/storage/firebird/opencms.fdb".
> >
> > Somehow the installer tries to append the "database" parameter to the
> > "connection string" param.
> >
> > I tried to foolish the installer by putting
> > jdbc:firebirdsql://localhost:/storage/firebird as "connection string" and
> > opencms.fdb as "database", which it then concatenated well but it still
> > produced an error (the second of the both above to be precise)
> >
> > Note: As far as I can see the jaybird driver is included in your
> > packages, so I did not install it to the tomcat libs folder.
> >
> > And idea what goes wrong here?
> >
> > Best regards and thanks for your effort!
> > yves
> >
> > On Tuesday 31 March 2009, Georgi Naplatanov wrote:
> >> Hello, list.
> >>
> >> There is a new build for JPA driver for OpenCms 7.0.5.
> >> https://sourceforge.net/project/showfiles.php?group_id=241958&package_id
> >>=29 4665&release_id=672367
> >>
> >>
> >> The changes are related to performance increase. The driver's
> >> performance is closer to traditional SQL drivers than previous builds.
> >>
> >> For those who wants to upgrade from previous version of JPA driver,
> >> should do the following:
> >>
> >>  - replace opencms.jar from binary distribution
> >>  - replace openjpa-1.2.0.jar with openjpa-1.2.1.jar
> >>  - replace WEB-INF/classes/META-INF/persistence.xml file from binary
> >> distribution and setup jdbc and cache properties
> >>
> >> The source code is available in the SVN repository.
> >>
> >> Best regards
> >> Georgi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090331/b1d31ef7/attachment.htm>