[opencms-dev] new build for JPA driver

[Georgi Naplatanov]

Hello Yves.

I use Debian too :), but testing with Firebird 2.1 superserver.

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
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> 
> _______________________________________________
> 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