SQL Zone - The social network for developers

Quick Tip: Granting access to meta-data on MySQL

Volume4 — Sat, 22 Mar 2008 09:36:04 -0400

Ever seen this exception in your log files when working with MySQL as your database back-end? User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.

Microsoft SSDS - Dumb Name, Brilliant Idea

tim.negris — Wed, 19 Mar 2008 11:11:02 -0400

A Google News search for Microsoft SSDS, the SQL Server Data Services it announced last week, yields just six articles – SIX! A random nonsense search term probably returns more than six items.

Querying the File System - From ColdFusion to SQL Server

boyan — Mon, 17 Mar 2008 16:10:16 -0400

While looking for a solution of a different problem, I realized that SQL Server has a feature called extended stored procedures. Extended stored procedures, at least in SQL Server 2000, have to be written in C++ and compiled to a DLL. A good example of such a procedure is my previous article on Using Regular Expression in SQL Server. I am not going to get into how to write extended stored...

RESTful representation of "sakila" using GlassFish and NetBeans IDE

arungupta — Wed, 13 Feb 2008 16:35:08 -0500

"sakila" is the sample database shipped with MySQL (pronounced as my ess-kew-ell). In the context of Sun Microsystems announcing the agreement to acquire MySQL, I'd like to dedicate this entry to show how this sample database can be exposed as a RESTful Web service endpoint and deployed on GlassFish using

Greenplum Revs Internet-Scale Database

mog — Wed, 13 Feb 2008 10:16:48 -0500

Greenplum, the other (Postgres/Bizgres-based) open source database near and dear to Sun besides MySQL, this one capable of messaging a petabyte of data and buoyed by a recent $27 million infusion, has moved on to rev 3.0, a k a G3, claiming it can analyze vast amounts of business data 10 to 100 times faster than traditional data warehouse widgetry at a fraction of the cost.

Querying Active Directory Through SQL Server

boyan — Mon, 11 Feb 2008 14:55:57 -0500

Integrating your application with Active Directory (or another LDAP based directory) is a common requirement in many business applications. Almost every language has a way to query LDAP but little known is the approach of integrating SQL Server with your LDAP controller. This quick article will guide you through setting up and using LDAP queries through SQL Server 2000 with Active Directory as...

Get Business Days and Working Hours in a Month

boyan — Thu, 07 Feb 2008 21:28:00 -0500

In business applications, there often is a need to know the number of business days and/or hours in a month/year. There is a dozen ways to do this depending on your language but here is a SQL Server implementation.

Custom Date Formatting in SQL Server

boyan — Mon, 04 Feb 2008 08:41:12 -0500

Most people that use SQL Server are familiar with formatting dates inside SQL Server. The common approach is: convert(varchar, getdate(), 106) -- Displays a date in the format 25 Jan 2008That is all fine and good if your requirements are satisfied with the formats available inside SQL Server.

Why Microsoft Needs Yahoo: the Real Story

ijansch — Sun, 03 Feb 2008 13:52:34 -0500

So one day, Scott McNealy, founder and chairman of Sun, read in his morning newspaper how the use of Java was rapidly diminishing, courtesy of something called 'The LAMP Stack'. Furiously, he called his accountant.

Is LINQ leaving Java in the dust?

puredanger — Wed, 30 Jan 2008 11:51:34 -0500

Interesting story today asking whether LINQ has given .NET an edge over Java. LINQ is best-known as a way to embed SQL-like statements directly in code. However, it's really a much deeper technology that allows you effectively build DSL-like constructs in libraries that work as if they are part of the language. And that is undeniably powerful.

LiquiBase 1.5.0 Released

nv62013 — Tue, 29 Jan 2008 15:41:44 -0500

LiquiBase Core 1.5.0 is now available for download from http://www.liquibase.org/download. LiquiBase is an open source database version control and refactoring library that supports mulitple database types and integrates with many popular tools including Ant, Maven, Grails, Spring, IntelliJ and Eclipse.

If Microsoft Pushes It Out Much Further They Won’t Be Able To Call It SQL Server 2008

mog — Mon, 28 Jan 2008 13:57:50 -0500

Something has happened – or maybe didn’t happened – that has caused Microsoft to delay the release of SQL Server 2008 to the calendar three quarter. It offered no excuse. It was generally expected in the second quarter. Microsoft is still going to “launch” the database on February 27 along with Windows Server 2008 and Visual Studio 2008. It's promising a feature-complete CTP for the...

MySQL creator releases Maria, the new engine that will replace InnoDB

rick — Mon, 28 Jan 2008 07:56:18 -0500

A blog posting from MySQL founder and original developer, Michael "Monty" Widenius, announces the release of a major new database engine called Maria. Over two years in the making, the Maria engine appears to be the open source database leader's answer to the problem posed by Oracle's acquisition of InnoDB. Here's a list of major features of Maria:

Oracle Essentials

meera — Wed, 23 Jan 2008 11:26:43 -0500

Sun Backs Postgres House on Heels of MySQL Acquisition

mog — Tue, 22 Jan 2008 18:19:07 -0500

The ink was still drying on Sun’s billion-dollar deal to buy the webby, low-end open source database house MySQL when Sun turned around and put money high-end open source Postgres company Greenplum, evidently what Sun CEO Jonathan Schwartz meant last week when he said “and we ain’t finished yet.”

The problem with JPA/Hibernate (or the future of ORM)

sdevijver — Thu, 17 Jan 2008 11:00:23 -0500

I know, a lot of people are happy to work with JPA and Hibernate. Consider this a post from somebody who thinks things can be improved. I have a love/hate relationship with Hibernate, for many reasons that I don't want to go into now. Overall I do like Hibernate and think it does a good job but it can be improved in many ways.

Sun Buys MySQL, Gets Oracle for an Enemy

mog — Wed, 16 Jan 2008 21:14:35 -0500

Sun, Oracle’s sometimes best friend, turned into an Oracle competitor this morning when it said it was buying MySQL, the open source database that’s part of the famous LAMP stack. It’s paying a billion dollars. MySQL was supposed to go public but picked the easier monetization route.

Introduction To iBatis

matt — Thu, 10 Jan 2008 22:01:56 -0500

ActiveObjects: An Easier Java ORM

matt — Thu, 10 Jan 2008 21:37:29 -0500

Java is absolutely full of Object Relational Mapping frameworks. Obviously Hibernate is the first which comes to mind, but also high on the list would be the likes of iBatis, Beankeeper, etc. In short, there is no shortage of ORMs. However, they all seem to suffer from one of a number of fundamental flaws: