You are not logged in.
Pages: 1
Hi, I'm back.
I am trying to create a HSQLDB database manually, but I came across a question. Does Ametys expect table names to be all capital or case sensitive? HSQLDB treats all unquoted identifiers as capital, so I have to use quotes to make HSQLDB use case-sensitive names. For example,
CREATE TABLE Users (
login varchar(64) PRIMARY KEY NOT NULL,
firstname varchar(64) default NULL,
lastname varchar(64) NOT NULL,
email varchar(64) DEFAULT NULL
);
This command creates a table
Okay, I'll open a feature request ticket and attach my patches.
I found that my patches only fix validation queries for HSQLDB. There are more work to be done with group and rights management.
Hi,
I succeeded in making CMS work with HSQLDB. To allow Ametys to handle HSQLDB database, I hacked two files in the Ametys codes: DataSourceExtensionPoint.java and ConnectionHelper.java. Here are the patches.
I hope somebody review the patches, test them and accept them into the upstream source.
Ken
Hi, Nicolas
The reason why I want to use HSQLDB instead is that I believe HSQLDB is a bit quicker than Derby and more lightweight than other databases.
As far as I know, HSQLDB is compatible with Apache Commons DBCP library. Is there a way to configure DBCP for CMS?
Ken
I don't know why attachements are not showing up. So I pasted the SQL script at the following link.
I hope somebody try it and see if it works with Ametys
Ken
Hi,
I like HSQLDB and want to use it with Ametys. I created a database using the attached SQL script. I configured CMS to use the HSQLDB database. But when I tried to create a new user, Ametys gives me "Error: Server failed (code 500)".
How do I set up HSQLDB database for use with Ametys?
Ken
More information on the error follows:
Could not create a validated object, cause: ValidateObject failed
java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1191)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at org.ametys.runtime.datasource.ConnectionHelper.getConnection(ConnectionHelper.java:98)
at org.ametys.runtime.plugins.core.user.jdbc.ModifiableJdbcUsersManager.add(ModifiableJdbcUsersManager.java:153)
at org.ametys.runtime.plugins.core.user.ui.actions.EditAction.act(EditAction.java:110)
Thanks Raphaël and Cédric
It's nice to know that I can choose which database to use for Ametys repository. I am thinking of using MySQL or HSQLDB for the repository. I'll probably have to change repository.xml.
I'm wondering if there's a way to convert the existing derby repository to MySQL.
Ken
Thanks, Cédric
I'll use the scripts you posted in the meantime.
I have another question. I am curious about the database used for the content repository. Is it flat-file database, derby or some other database? I hope I could use MySQL for the repository, too.
Ken
Hi, Cédric
Thanks for your answer. I'll use a single database for all 3 occasions. Can I just use the database scripts included in Ametys to create the database? The scripts don't seem to create tables for page cache statistics.
Ken
Hello,
I am trying to install Ametys 3.5 and have questions about the databases used in Ametys 3.5. In the back office configuration page, I see 3 separate databases to fill in: Kernel, monitoring and front-office. Can somebody tell me what I should enter for each database? Please see the attachment.
Thanks.
Ken
Pages: 1