All posts in 'English posts'

Create reusable MySQL schema dumps

16-Sep-10

In case you need a MySQL schema transferred from one host to another and the schema names differ, you can ran into problems with a standard MySQL dump. Use the following statement to create a schema dump that contains all table and view definitions as well as all stored procedures without a reference to the […]

Read the complete article »

Oracle “sleep” procedure: DBMS_LOCK.SLEEP

07-Sep-10

There’s a nice little “sleep” procedure in Oracle: A procedure that stops the execution of the current thread for n seconds. Strangely, this method can be called in SQL*Plus like so: EXEC dbms_lock.sleep(10);exec dbms_lock.sleep(10); but not in another stored procedure or function like so CREATE OR REPLACE PROCEDURE FOOBAR AS BEGIN DBMS_LOCK.SLEEP(1); END; /CREATE OR […]

Read the complete article »

Preparing for Rails 2.3.9

06-Sep-10

As much as i wish to upgrade my Rails 2.3.x application Daily Fratze to the newest tag of the Rails 2.3.x branch, i cannot. First there was the epic fail of release 2.3.6, that broke all HTML Helpers and forced the Rails XSS protection upon us. This release was immediately followed by 2.3.7 and 2.3.8. […]

Read the complete article »

How to get UIDefaults in Java

If you’re loocking for Javas UIDefaults, use the UIManager class. This snippet gives you all installed UIDefaults: UIDefaults defaults = UIManager.getDefaults(); for(Enumeration e = defaults.keys(); e.hasMoreElements(); ){ String key = e.nextElement().toString(); System.out.println(key + " = " + defaults.get(key)); }UIDefaults defaults = UIManager.getDefaults(); for(Enumeration e = defaults.keys(); e.hasMoreElements(); ){ String key = e.nextElement().toString(); System.out.println(key + " […]

Read the complete article »

Oracle NLS-Lang Settings

13-Aug-10

To use SQL*Plus Windows correctly, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 If you prefer the command line client SQL*Plus, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8PC850

Read the complete article »