<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Droid Sans'; font-size:10pt; font-weight:400; font-style:normal;">On Tuesday 31 March 2009, Georgi Naplatanov wrote:<br>
> Hello Yves.<br>
><br>
> I use Debian too :), but testing with Firebird 2.1 superserver.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Good choice ;-)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>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...?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Thanks for your help!!<br>
Yves<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>> I make the following steps to install OpenCms with Firebird.<br>
><br>
> 1. creating database manually<br>
> $ isql-fb -user SYSDBA -password masterkey<br>
> SQL> create database '/var/lib/firebird/2.1/data/opencms' page_size 16834<br>
> ;<br>
><br>
> 2. start your JSP container<br>
> 3. Fill parameters for the installer<br>
> User name - SYSDBA<br>
> password - masterkey<br>
> JDBC driver class name - org.firebirdsql.jdbc.FBDriver<br>
> Connection String - jdbc:firebirdsql://localhost<br>
> Database -<br>
> /var/lib/firebird/2.1/data/opencms?defaultResultSetHoldable=true<br>
><br>
> That is all.<br>
><br>
> There is a screenshot<br>
> http://os.oles.biz/opencms/jpa-driver/screenshots/firebird-2.1.jpg<br>
><br>
> Best regards<br>
> Georgi<br>
><br>
> Yves Glodt wrote:<br>
> > Hello Georgi,<br>
> ><br>
> > I try to install the new release with Firebird 2.0 on debian lenny, but I<br>
> > fail... Can you tell me the exact parameters for "connection string" and<br>
> > "database" in the setup wizard?<br>
> ><br>
> > Whatever I tried, I failed with the following errormessages:<br>
> ><br>
> > Error connecting to database using:<br>
> > "jdbc:firebirdsql://localhost://storage/firebird/opencms.fdb".<br>
> ><br>
> > or<br>
> ><br>
> > Error connecting to database using:<br>
> > "jdbc:firebirdsql://localhost:/storage/firebird/opencms.fdb".<br>
> ><br>
> > Somehow the installer tries to append the "database" parameter to the<br>
> > "connection string" param.<br>
> ><br>
> > I tried to foolish the installer by putting<br>
> > jdbc:firebirdsql://localhost:/storage/firebird as "connection string" and<br>
> > opencms.fdb as "database", which it then concatenated well but it still<br>
> > produced an error (the second of the both above to be precise)<br>
> ><br>
> > Note: As far as I can see the jaybird driver is included in your<br>
> > packages, so I did not install it to the tomcat libs folder.<br>
> ><br>
> > And idea what goes wrong here?<br>
> ><br>
> > Best regards and thanks for your effort!<br>
> > yves<br>
> ><br>
> > On Tuesday 31 March 2009, Georgi Naplatanov wrote:<br>
> >> Hello, list.<br>
> >><br>
> >> There is a new build for JPA driver for OpenCms 7.0.5.<br>
> >> https://sourceforge.net/project/showfiles.php?group_id=241958&package_id<br>
> >>=29 4665&release_id=672367<br>
> >><br>
> >><br>
> >> The changes are related to performance increase. The driver's<br>
> >> performance is closer to traditional SQL drivers than previous builds.<br>
> >><br>
> >> For those who wants to upgrade from previous version of JPA driver,<br>
> >> should do the following:<br>
> >><br>
> >> - replace opencms.jar from binary distribution<br>
> >> - replace openjpa-1.2.0.jar with openjpa-1.2.1.jar<br>
> >> - replace WEB-INF/classes/META-INF/persistence.xml file from binary<br>
> >> distribution and setup jdbc and cache properties<br>
> >><br>
> >> The source code is available in the SVN repository.<br>
> >><br>
> >> Best regards<br>
> >> Georgi</p></body></html>