Coding

JBoss Seam: rich:dataTable with huge datasets

Tagged:

Have you ever wanted to implement Seam's rich:DataList but the search results could be in the tens or hundreds of thousand of records?  Well, I did recently run into that exact issue.  For the first attempt I tried to use the standard binding method, but knew it could never work in a production environment.

JBoss Seam not rendering any tags?

Tagged:

If you ever run into the weird situation where you use JBoss Seam with Facelets and everything seems to be working, except the page does not render any tag - no matter whether it is s, h, f, a4j, rich or ui (the common abbreviations for them), then have a look at faces-config.xml.  I once made the simple mistake of calling the file faces_config.xml, effectively the same as not having that file.  However since it WAS there and did look almost like faces-config.xml, I missed it for 3 hours.

IE6 border not showing

Tagged:

I hate IE6. I hate IE. But especially IE6, since it plays magic tricks on you when you want to apply borders in some scenarios. Thanks to this link I fixed the issue.

Hard to spot bugs

Tagged:

It took me a full 10 minutes to track down this stupid bug.  It is not intuitive.  I guess it is the penalty one pays for terseness:

          vCostEntry.getCost().put(vDBField, Utils.makeProperString(vExportToExcel).equals("DISCOUNT")?((int)Utils.getDouble(vRawAmount)):GetIntFromFormattedCurrency(vRawAmount));

Some definitions to explain above:

 

  public Map<String, Integer> getCost() {

    return mCost;

MDAC, Collation and UAC

Tagged:

I have been struggling on and off with EasyFrom DBConvert converting a Paradox 4 database to MySQL.  I would get this error intermittently:

[800A0CB3] Object or provider is not capable of performing requested operation.

Subtle bugs in Java

Tagged:

 I recently uncovered a bug that troubled me for about 30 minutes.  This bug was introduced in the Javaconfig framework, as I was extending support for more overloaded methods by "copying the pattern".  But it proved that in this case, following a pattern does not always work.

Inductive reasoning states that if element 1 is the same as 2 and 3 and 4 and ... n, element n+1 will most probably be the same as well.  However inductive reasoning is rather evil when writing software as it is not mathematically sound. 

Microsoft may suck, but for development they rock.

Tagged:

Compare this official documentation on the exit value of a process for Java:

JavaDoc for Process.exitValue

with Microsoft's:

MSDN for Process.exitCode

I am sorry but Java still lags waaaay behind Microsoft when it comes to good API documentation and development support.

I HATE Microsoft Access

Tagged:

Tonight I spent 3 hours trying to get a simple, basic SQL query to work in Microsoft Access 2003.  The SQL query runs perfectly in Microsoft SQL Server 2005, however when run through the VB code in Access via the DAO layer it kept on failing with a syntax error.  Obviously the error message did not point out the cause of the error.  Since the SQL was perfectly valid and not complex, I was baffled.

Here is the basic query I had written:

Frustrations

Tagged:

So you do some DBA work and one day realised that the worst has come true - the replication is just so broken you have to start all over. Usually there is always some kind of ground level when working with computers. If a program is badly broken try reinstalling it. If that does not work try reinstalling the OS maybe. If that does not work buy a new computer etc.

I had this situation on a system I am playing DBA on. Slony-I was badly broken so I had to restart from scratch. My ground zero was to drop the database and start over... But... what if you can't???