Skip to content

Ingres command line RPM installation

11-Aug-10

I have been repeatedly installing different builds of the Ingres 10 beta for testing with the Ingres Hibernate dialect and in my quest to be lazy I have been performing minimal installs by hand.  My recent post Ingres Package Install Ain’t Misbehavin mentions the change in behaviour of a manual package installation that I fell foul of.  I was looking around for references to a command line package installation, but unfortunately I couldn’t find any,  so I wrote some notes Command line RPM installation as an aide mémoire.

Ingres doc search plug-in updated

09-Aug-10

Following on from the post Ingres documentation site relaunched I’ve updated the search plug-in and created the Ingres doc search plug-in page.

Ingres package install ain’t misbehavin

04-Aug-10

In recent development to improve/overhaul the Ingres rpm installation and set-up some of the set-up process was moved from the rpm packages into the installation RC script and a %posttrans scriptlet was used to perform some of the preparatory set-up steps.  Unfortunately, the %posttrans scriptlet was not being triggered on some versions of Linux and it was decided to remove %posttrans from the preparatory set-up stage as well as the RC script.

As a consequence if installing packages by-hand (not using the express install script or the GUI installer) the set-up process will not be run on any versions of Linux.  Post installation configuration is initiated by running either:

service ingresXX configure [response file name]

or

service IngresXX start

  • XX should be replaced with the instance code in the package name used to install with II by default.
  • A response file name should be supplied with configuration values that differ from the default.

Ingres Documentation site relaunched

03-Aug-10

A couple of days ago the new and improved documentation site was launched http://docs.ingres.com/ to allow the pages to be indexed by Google and now also includes a handy feedback mechanism.

I created a simple Google gadget to create a document search query that can be added to your iGoogle home page. It took a couple of failed attempts to get it submitted to the Google gadget directory, but the Ingres Doc Search link can be used to install it directly.

Cloudy with Ingres VectorWise

29-Jun-10

As follow-up to the UK IUA 2010 and the video of the Ingres VectorWise demonstration the Ingres Emerging Technologies Team has created an Amazon Machine Image (AMI) with a pre-installed evaluation copy of Ingres VectorWise.

The Ingres Community wiki page has some simple instructions to get started.  As a guideline to the cost, I ran the image for a week and could probably run it for about 21 weeks to match the cost of a similarly specified bare metal machine.  I uploaded data to Amazon Simple Storage Service (S3) to reduce the cost of moving the data set and removing the need to run a machine for the transfer.

Fast track your Ingres VectorWise evaluation with the AMI.

Vectorise your data

25-Jun-10

I mentioned in a previous post UK IUA 2010 that Ingres announced the release of Ingres VectorWise.   During the announcement was a live demonstration using the Ingres Database Workbench; recorded for posterity.

UK IUA 2010

10-Jun-10

This year’s IUA conference; a crammed packed one day event with 5 streams of sessions with keynotes from Ingres‘ CEO Roger Burkhardt, Novell‘s Director of Product Management Dr. Gerald Pfeifer and Talend‘s François Mero.

Ingres announced the release of Ingres VectorWise with a “see it to believe it” live demonstration; identical analytical queries run on a closed source DBMS (DBX) on 50 million rows and Ingres VectorWise on 100 million rows of data. Don’t hold your breath for DBX returning in around 52 seconds, but don’t blink with Ingres VectorWise or you’ll miss it returning in just under 2 seconds. Analytical queries with large data sets are the target and the audience was encouraged to try it out for themselves using their own data and sharing their “vectorised” findings.

In conjunction with the Ingres VectorWise announcement; Novell showed SuSE Studio with ability to create SuSE JeOS (Just enough Operating System) appliances that include Ingres; Talend announced the availability of a set of Ingres VectorWise connectors for Talend.

Joe Kronk and Emma McGrattan provided a debriefing for this year’s pre-conference code sprint. 30 people attended 4 focus areas, Ingres server, migration wizard toolkit, management tools and OpenROAD.

Rick van der Lans, winner of last year’s Ingres Community Award, presented the award to this year’s winner Karl Schendel. Congratulations Karl.

The conference provided many informative sessions and an ideal environment for networking.

Mark 07/Jun/2011 in your calendars for next year’s conference.

Debugging the Hibernate project with Eclipse

16-May-10

Trying to debug projects made using Apache Maven has not been something achieved with any success.

Having been working at the periphery of the Hibernate source and submitting simple patches for the Ingres dialect and some tests I am now in a position to start debugging some of the issues discovered whilst testing. I have been dabbling with building maven projects from Eclipse using m2eclipse, but have not managed to perform source level debugging. I found this article Dealing with the Eclipse IDE that provides some clues on how it is done.

Essentially it involves a remote debug session from a container project to a running maven goal configured to listen.

Versions

The versions of software that I’ve been playing with

  • Eclipse Galileo ~SR1 – Build id: 20090920-1017
  • Eclipse Helios M5 – Build id: 20100204-0846 (I started to install the m2eclipse plugin and import the projects, but needs more work)
  • Ingres 9.3.1 (int.lnx/106)
  • java version “1.6.0_16″
  • mvn Apache Maven 2.2.1 (r801777; 2009-08-06 20:16:01+0100)
  • Apache Ant version 1.7.1 compiled on June 27 2008
  • Hibernate 3.5.0-Final
  • Path: .
    URL: http://anonsvn.jboss.org/repos/hibernate/core/tags/hibernate-3.5.0-Final
    Repository Root: http://anonsvn.jboss.org/repos/hibernate
    Repository UUID: 1b8cb986-b30d-0410-93ca-fae66ebed9b2
    Revision: 19149
    Node Kind: directory
    Schedule: normal
    Last Changed Author: steve.ebersole@jboss.com
    Last Changed Rev: 19148
    Last Changed Date: 2010-03-31 18:38:55 +0100 (Wed, 31 Mar 2010)

These notes assume that the software has been installed and configured. For example, the Maven local repository location is available and that the Maven remote repository is accessible.

Installing m2eclipse

The article Dealing with the Eclipse IDE includes links on how to install m2eclipse, but in summary, to install new software in Eclipse use the built-in update manager:

  • Using the menus select
    • Help > Install New Software
    • In the dialog add the URL http://m2eclipse.sonatype.org/sites/m2e
    • Check the boxes of the packages that should be installed
      • NB” Version 0.9.8 should be un-installed before upgrading to 0.10.

Import the Hibernate project

Once the m2eclipse extensions have been installed into Eclipse the preparation for importing the Hibernate Project Object Model (POM) XML file into the IDE is complete. Importing the Hibernate project is optional and is only required if you intend to build Hibernate from Eclipse. The remote Java application perspective will connect to either a command line invoked maven process or an Eclipse invoked maven process.

  • Start Eclipse
    • Create a new workspace for the Hibernate project.
  • Using the menu File > Import
    • Select Maven > Existing Maven Projects
    • Click Next and use the browse button to specify the root directory of the Hibernate source code, this is the directory in which the top level pom.xml file exists.
    • The sub-projects appear in the tree view in addition to the hierarchy beneath the top level project.
  • Import Exisiting Maven Project

The initial import and build of the workspace can take a while.

Create a Surefire Debug Configuration

Create a run configuration for a specific test class for debugging. In this example the filter.DynamicFilterTest has been cut down into filter.IngresDynamicFilterTest.

  • Select the menu Run > Run configuration option or from the context menu using a right click.
  • In the Run Configuration dialog select ”maven” and create a new configuration
    • Enter a name for the configuration
    • Surefire Debug
    • Set the base directory to the test suite directory by browsing the file system
    • Set the goals
    • test -Dmaven.surefire.debug
    • Use a JDBC profile if one is required and has been configured
    • Set the ”test” parameter to a specific test class intended for debugging
      • test=org.hibernate.test.filter.IngresDynamicFilterTest
  • Maven Test Run Configuration

Create a Debugging Container Project

The container java project does not contain any source and is used as the launch point for a remote debugging configuration.

  • Using the File->New->Project->Java Project (or equivalent)
  • Set the project name in the wizard
  • Project Name: Maven Debug and finish
  • In order to debug a maven project a container project is used to connect to maven in debug mode.

    Create Container Project from Ray Fan on Vimeo.

  • Use the Run->Debug Configurations menu to create a configuration for the Remote Java Application
    • Set the nameName: Maven
    • Keep all the existing settings and apply
    • Debug Remote Application

    • Select the Source tab and add source
      • File System Directory and browse to the Hibernate route source directory
      • Select the Search subfolders check box
      • Apply and close

      Add Source Folders

  • Use the Run > Debug Configurations menu to duplicate the Maven configuration for the Remote Java Application
    • Set the name
      • Name: Maven Debug
    • Change the port value
      • Port: 5005
    • Apply and close
    • Remote Application Maven Surefire Configuration

Set breakpoints and start the test

At least one breakpoint should be set in the source prior to the run configuration Surefire Debug is started

  • Browse the source tree in the package explorer to the test class
  • Set a breakpoint
  • Use the Run->Run Configurations menu and select the Maven->Surefire Debug configuration
    • Click debug to start maven
  • Eclipse breakpoint setting and starting maven from Ray Fan on Vimeo.

    Using Eclipse to browse the project source and set a breakpoint prior to starting maven to run the test.

    Start the debugger

  • Use the Debug->Debug Configurations menu and select the Maven Debug remote debugging configuration
    • Click debug to start the debugging session
    • Switch to the debugging perspective when prompted
    • Once execution of the test starts the breakpoint set previously should be hit
  • Starting to debug from Ray Fan on Vimeo.

    Starting to debug, switching perspective and hitting the breakpoint.

Hibernate 3.5.0-Final released

01-Apr-10

Today, Hibernate 3.5.0 completes its development cycle and is announced as Final. I joined this party late in the day and I’m still working through some of the test results from earlier candidate releases. I’ve submitted a few patches and they’ve been accepted and some have even made it into this Final release.

Most notably, I extended the work started by Enrico Schenk in introducing additional Ingres dialects. There are now three possible dialects.

  • IngresDialect – for use with Ingres II 9.2
  • Ingres9Dialect – for use with Ingres II 9.3
  • Ingres10Dialect – for use with Ingres II 10.0 – at the moment this is a place holder and uses the 9.3 dialect

The Ingres9Dialect switches uses the ISO date/time types and functions for mapping to their Hibernate equivalents. This changes the behaviour from the IngresDialect which used ingresdate type and functions.

Further changes to Ingres9Dialect will include the introduction of auto-increment columns; a whole host of additions will be required for the Ingres10Dialect and not forgetting the inclusions from the Ingres GeoSpatial project.
A list of new features introduced into each release is published on the “Ingres New Features Per Release” page.

Eclipsecon 2010 – day4

01-Apr-10

Another session packed day kicked off by a rousing keynote from Robert C. Martin of Object Mentor Inc. entitled “Software Professionalism and the Art of Saying “No”. Robert touted a common sense approach to developing tests and software (and the order is important here). Being in the software industry for so long most/all of his generic quotes from management sounded very familiar and after each one Chris and I looked at each other and smiled.

The day continued with the same intensity as the preceding 3 days culminating in the closing session where the conference was wrapped up and the winners of prizes announced. Unexpectedly, I won a prize (looking like a real geek) for voter feedback; having been to many conferences I liked the system of soliciting feedback at Eclipsecon, making use of the +1, 0, -1 voting system.

This was my first ever Eclipsecon and the Eclipse Foundation Conference Committee organized a fantastic event in my opinion. Now I’ll have to try and get to Eclipse Summit Europe, just to see how they follow that.