Monthly Archives: May 2006

Exporting and Importing data within different databases

Copying data from Database to Database In keeping with my Mysql + Oracle theme, I’ll now explain how to use a very handy little library named DBUnit to import and export data. Exporting Data First off, download DBUnit. Then add … Continue reading

Posted in technical | Leave a comment

Connecting to a Mysql 5 DB, Oracle 10g DB in Java

Connecting to a database in Java It should be pretty easy right? Well it is, but difficult to troubleshoot. It will either work or won’t, and you won’t have a clue why not. So here’s a skeleton program that you … Continue reading

Posted in technical | Leave a comment

Centering blocks of text using CSS

Today I was trying to figure out how to center a block of text. What I wanted was a margin on the left, and a margin on the right of the same width. Sounds easy right? Well it is, if … Continue reading

Posted in technical | Leave a comment

Programming Ajax code in VB.NET

Ajax in VB.NET without Visual Studio! A couple of weeks back I wanted to try doing a bit of Ajax. ASP.NET (using VB) is my language of choice, which I thought would be widely supported. Not quite. Microsoft have a … Continue reading

Posted in technical | Leave a comment

Ajax

I’ve given Ajax.NET a shot for developing auto suggest dropdowns within an ASP.NET application. The thing worked marvelously – even without Visual Studio! All I had to do was compile the thing, (using csc.exe), stick the DLL into the bin … Continue reading

Posted in technical | Leave a comment

Oracle Sequences

Updating sequences that might be dodgy If you’ve copied data from another schema into a table of yours, you might have the problem where the sequence that you’re using for your Primary Key is now invalid. Here’s how to troubleshoot … Continue reading

Posted in technical | Leave a comment