Posts tagged as:

Database

Sharing data between applications

July 24, 2009

Sometimes applications need access to data from another application. Here is one approach you could take:

Define a view in the database that owns the data - this view should expose the data that the external application needs
Grant select permissions so that the external application can select from the view
Create a synonym in the external applications [...]

Read the full article →

Oracle version information

July 31, 2008

When making support requests it is always helpful to include version information about the product in question. Rather than just stating ‘version X’ I like to get the software to display the version information and just copy and paste it - this way there can be no confusion, and there may even be extra useful [...]

Read the full article →

grails-p6spy-0.2

September 19, 2007

This information is out of date - please see http://grails.org/plugin/p6spy for the current documentation.
Grails 0.6 was recently released, and this new version included changes to the way the DataSource is defined. So, to make my grails-p6spy-plugin compatible with 0.6, here is a new release:
grails-p6spy-0.2.zip
P6Spy lets you monitor the JDBC queries by proxying your database driver. [...]

Read the full article →

Grails P6Spy plugin

June 29, 2007

This information is out of date - please see http://grails.org/plugin/p6spy for the current documentation.
I wanted to have a go at creating a Grails plugin so I thought I’d write one to make it easy to add P6Spy to your Grails application. The experience was very good. The structure and distribution mechanism is excellent and the [...]

Read the full article →