Tag Archives: Databases

You Know a JDBC Driver Sucks When…

…you’re tempted to contact the database vendor providing the driver and open yet another ticket because you think this method in said driver returns an incorrect value: public boolean jdbcCompliant() { return true; } Although this one might be a … Continue reading

Posted in Databases, Languages | Tagged , , , , , , | 2 Comments

Troubleshooting “Invalid cast exception for WDDX recordset” in ColdFusion MX 7

Over the past few working days I’ve been making some minor enhancements / bug fixes to a reporting product currently in beta. Said product at a 50,000 foot view basically compiles a report into a massive structure which I then … Continue reading

Posted in Languages, Tips, Hacks, & Tricks | Tagged , , , , , , , , , , | 1 Comment

Returning the Value of a Uniqueidentifier after an Insert in SQL Server

Something I looked-up just to confirm what I already knew– there isn’t a way to automagically get the value of a GUID after inserting into SQL Server by using something similar to SELECT @@identity as you would with normal identity … Continue reading

Posted in Culture, Languages, Tips, Hacks, & Tricks | Tagged , , , , , , , , , , | 7 Comments

Transparent SQL Server Encryption

Handling encryption of SQL Server data on your own can get to be a huge pain, especially when someone starts asking for data out of the database such as “can you give me a report of all of our customers … Continue reading

Posted in Databases | Tagged , , , , , , , , , , , | Leave a comment

JDBC Problems: “String Index Out of Range” Error

This afternoon I’ve been checking out some JDBC drivers from one of our database vendors, and once I finally got them working in ColdFusion MX, I kept getting a “String index out of range” error, even on very simple queries. … Continue reading

Posted in Languages, Tips, Hacks, & Tricks | Tagged , , , , , , | 3 Comments