MySQL order by field in Criteria API

Here I have a simple example showing how to implement MySQL's order by field in Criteria API for MySQL DBMS.

MySQL fulltext search with JPA

Example on how to write JPQL or Criteria API queries for DB functions with 'unusual' signatures, like MySQL's FTS function - match against.

Some useful Alfresco queries

I would like to share some of SQL queries for Alfresco database which could be useful.

Connect to alfresco database

For better understanding of Alfresco sometimes it's needed to see Alfresco tables. Here I'm showing how to connect to Alfresco Postgre database on a server and to h2 database during development.

Wipe alfresco database

Here I'm showing how to wipe alfresco database.