Tag Archives: Databases

You Know a JDBC Driver Sucks When…

Posted on May 5, 2006 by Brandon Harper

…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 Boolean data type, Databases, driver, Java Database Connectivity, Java platform, jdbc, said driver | 2 Comments

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

Posted on July 6, 2005 by Brandon Harper

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 Data structures, Database management systems, Databases, Java, Java Database Connectivity, Java platform, JDBC driver, Microsoft SQL Server, Recordset, Serialization, WDDX | 1 Comment

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

Posted on February 2, 2005 by Brandon Harper

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 Communication, Computing, Data management, Databases, Globally Unique Identifier, Identifiers, Identity column, Insert, Select, SQL, SQL keywords | 7 Comments

Transparent SQL Server Encryption

Posted on December 14, 2004 by Brandon Harper

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 Business/Finance, Computer science, Cryptographic software, Cryptography, Database, Database management systems, Database theory, Databases, Disk encryption theory, encryption, Storage, Technology/Internet | Leave a comment

JDBC Problems: “String Index Out of Range” Error

Posted on March 17, 2004 by Brandon Harper

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 →