Databases

Hibernate, C3P0 and robust database connection handling

Quoting from the official Hibernate docs: "Hibernate's own connection pooling algorithm is, however, quite rudimentary. It is intended to help you get started and is not intended for use in a production system, or even for performance testing. You should use a third party pool for best performance and stability."
And it's all true: you should never (imho not even for development) use the default connection provider.

Scripting data in MSSQL

It's a fairly basic requirement to export data from a database table in the form of SQL "INSERT" instructions. However in case of Microsoft SQL Server it's not that simple. There's a utility called "Microsoft SQL Server Database Publishing Wizard", which comes packaged with SQL Server 2008, but has to be downloaded (and installed) separately for SQL Server 2005. Unfortunately it's not very sophisticated and here come the various 3rd party developers into the picture.

Syndicate content