A problem I seem to keep to getting asked for help with is how to persist XML data to a relational database. (I’ve now been asked to help on at least four different projects where this has become something of an issue/blocker although strangely I’ve never actually needed to do this myself) The context of […]
Author Archives: admin.ian
Orbeon upgrade
Notes on upgrading from Orbeon Forms 3.8 to 3.9 Need to change theme.xsl as follows: From:<!– Copy body attributes –> <xsl:apply-templates select=”/xhtml:html/xhtml:body/@*”/> <xsl:apply-templates select=”/xhtml:html/xhtml:body/node()”/> <xsl:for-each select=”/xhtml:html/xhtml:head/xhtml:script”> <xsl:element name=”xhtml:{local-name()}” namespace=”{namespace-uri()}”> <xsl:apply-templates select=”@*|node()”/> </xsl:element> </xsl:for-each> To: <!– Body –> <xsl:apply-templates select=”/xhtml:html/xhtml:body”/> <!– Handle post-body scripts if present. They can be placed here by oxf:resources-aggregator –> <xsl:apply-templates select=”/xhtml:html/xhtml:script”/> […]
Ubuntu virtual box unable to log in
Rather carelessly I filled up my root partition and was therefore unable to login as I kept getting thrown back to the login screen The solution was to boot from the original ubuntu iso image via the virtual box settings and ‘Try Ubuntu’ From there it’s possible to mount /dev/sda1 and delete some files to […]
Problems connected to local mysql
Symptom:Running `mysql` gives:ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) Running `mysql -h “hostname”` works Fix:Add the following to /etc/hosts.allowmysqld:127.0.0.1:ALLOW
Drupal 7 installation on shared cpanel hosting
To cut a long story short I needed to ensure that the following lines were present in public_html/php.ini extension=pdo.soextension=pdo_sqlite.soextension=sqlite.soextension=pdo_mysql.so
Setting up VirtualBox
In Settings/Network select Bridged Adapter if you want to be able to connect to the vm In Settings/Display increase the amount of video memory apt-get updateapt-get upgradeapt-get install dkms reboot Then use the file manager to select/mount the additions so that they can be installed
Maven settings for deployment using scp
Create a file settings.xml in ~/.m2 that’s C:Documents and Settingsiwright.m2 in my case using cygwin on XP Create a server entry with the necessary info e.g. if using ssh<servers> <server> <id>cggh</id> <username>iwright</username> <privateKey>C:Documents and Settingsiwright.sshid_rsa</privateKey> <passphrase>mypassphrase</passphrase> <directoryPermissions>775</directoryPermissions> <filePermissions>664</filePermissions> </server> </servers> Note that if you are using cygwin then you will probably need to copy your […]
Using Roo on an existing database
Creating a web application to update an existing database with Roo is extremely simple… project –topLevelPackage org.cggh.quac –projectName quac –java 6persistence setup –provider HIBERNATE –database MYSQL –databaseName drupal_users –userName drupal6 –password drupal6database introspect –schema drupal_usersdatabase reverse engineer –package ~.model –schema drupal_userscontroller all –package ~.web Some notes:Make sure that the database has foreign keys set upIf […]
Tomcat JNDI configuration for auto redeploy
With thanks to http://www.mail-archive.com/users@tomcat.apache.org/msg74521.html Although it’s deprecated putting the context in server.xml seems to work quite nicely however if you want to auto deploy e.g. on a CI server then you need to get a bit cleverer…. Don’t keep the application in the appBase – locate it outside of Tomcat’s directory structure, and use the […]
Fun with classloaders
Class loaders are one of those things which work most of the time and you don’t have to worry about but when they go wrong they can be a bit of a nuisance to sort out. When you are running a java application in a application server there are several class loaders in play e.g. […]