Tag Archives: sql

The simplest MySQL setup, ever

First of all: you have to install the server (I assume you use Debian / Ubuntu): apt-get install mysql-server Then you have to create database, user and password (for sake of simplicity, not security, name, login and password are the … Continue reading

Posted in en, pl | Tagged , | Leave a comment

Secure PostgreSQL setup on Debian/Ubuntu

PostgreSQL is an OpenSource database server that is sometimes slower, but more powerful when compared to MySQL for example. For typical MySQL user complicated authentication system of PostgreSQL may be a bit confusing (they expect just login/password) but it has … Continue reading

Posted in en | Tagged , | Leave a comment

SQL Error: 17006, SQLState: null Invalid column name in Hibernate

Recently I've got the following error during SQL named query execution: SQL Error: 17006, SQLState: null Invalid column name In order to track the problem down I enabled SQL logging and collected SQL query issued, then run it under SQL … Continue reading

Posted in en | Tagged , , | 3 Comments

Recreate Derby Database Under WebSphere

WebSphere uses SQL databases for internal managment of MQ queues (Derby database engine under the covers). Sometimes you need to reset their state. Here's the script that erase and recreate BPEDB database state (tested under WS 6.1.2): rm -rf $WID_HOME/pf/wps/databases/BPEDB … Continue reading

Posted in en | Tagged , , , | Leave a comment

Second Level Cache For SQL Queries Under Hibernate

Second level cache in Hibernate allows to greatly speed-up your application by minimizing number of SQL queries issued and serving some results from in-memory cache (with optional disk storage or distributed cache). You have option to plug in different cache … Continue reading

Posted in en | Tagged , , , , , | Leave a comment