[opencms-dev] new build for JPA driver

[Georgi Naplatanov]

Hello Yves.

Good news.

> 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...?

Probably yes. JPA driver do not work without this parameter with Firebird.

Best regards
Georgi

Yves Glodt wrote:
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> 
> _______________________________________________
> 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/mailman/listinfo/opencms-dev