OpenKM 5.0 beta + PostgreSQL problem.

[mateusz]

Hi,

I will describe in steps what kind of changes I did to run new installation of OpenKM 5.0 beta to explain how I get error: could not execute query.

1. Download and extract OpenKM 5.0 beta with JBoss4.2.3.
2. Create databases (pgadmin3):
- CREATE DATABASE okm_repo WITH OWNER openkm ENCODING UTF8;
- CREATE DATABASE okm_app WITH OWNER openkm ENCODING UTF8;
3. Add postgresql-8.4-701.jdbc4.jar to lib folder in server/default.
4. Edit files (like in PostgreSQL-OpenKM 5.0 on OpenKM wiki):
- repository.xml,
- OpenKM.cfg - hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect, hibernate.hbm2ddl=create,
- login-config.xml,
- openkm-ds.xml,
- server.xml - to run server on 80 port.
5. Run server.
6. Login using okmAdmin.
7. Change OpenKM.cfg - hibernate.hbm2ddl=none.
8. Checked Admin panel and after clicked MimeType I get mentioned error: could not execute query.
9. Upload document is working but of course types of document is not recognized.

Today I want to check LDAP, documents preview, mail configuration but on clean OpenKM 5.0 beta, if I get any errors I will create new post.

Thanks in advance,
Mateusz.

[jllort]

You can not see any mime type ? is that ?

[mateusz]

In short yes.

[PedroKowalski]

I am experiencing the same problem. With default HSQL it works just fine, but when I enable different DB (PostgreSQL in my case) the mime types are missing - uploading document's mime type cannot be recognized...

What can be the problem of such a situation?

[jllort]

Probably it's a problem we've got with PostgreSQL, because with MySql we're sure runs well. We'll investigate in a fresh installation.

[mateusz]

Hi,

Is there any progress toward solving this problem?

[pavila]

Fixed in subversion, so will be included in the next release. Thanks for reporting it.