InfoQ Homepage Data Access Content on InfoQ
-
Upgrading SQL Server - xp_execresultset
SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. Unfortunately for those currently using it, SQL Server 2005 has dropped this feature.
-
Hibernate 3.2 Released with Java Persistence Provider Support
The Hibernate team has released Hibernate 3.2 GA. This release is ready for production use and includes final releases of the Java Persistence provider, Hibernate Annotations and Hibernate EntityManager. The Hibernate Java Persistence provider has been certified with the Sun TCK.
-
Ruby Driver for HSQLDB Released
A Ruby driver for HSQLDB has been released on RubyForge by Jared Richardson. The driver relies on Java Bridge technology (quite different than JRuby) to interop with the Java-based HSQLDB (formerly HypersonicSQL) open-source database.
-
English Query Discontinued in VS 2005
English Query, a tool that translated queries written in English into SQL queries, has been discontinued.
-
Study Shows That 11% of Sites Are Vulnerable to SQL Injection Attacks
In an informal study, Michael Sutton of SPI Dynamics was able to demonstrate that 80 out of 708 tested web sites were susceptible to SQL injection attacks.
-
C24 Creates Process for XQuery over non-XML without intermediary XML
Financial integration tool vendor C24 has added a unique XQuery optimization to their Integration Objects product that allows full XML XQuery and XSLT capabilities on non-XML documents without the overhead of first converting those non-xml documents into instances of XML.
-
System.Data.SQLite to Support ADO.NET vNext
SQLite is a lightweight database engine written in C. Designed to be cross-platform, it doesn't have any external dependencies and only takes about 250 KB of disk space. Though it doesn't support all of SQL92, it is suitable for smaller projects, especially ones that need cross-platform support. And to top it all off, the source code is in the public domain.
-
SQL Server Everywhere: the Future of Lightweight Databases
What is a developer who wants a light-weight, file-sharing based database to do? The answer is SQL Server Everywhere (SSEv). Like Jet, it is an in-process, file-sharing based engine. Though it lacks the functionality of SQL Server, it is suitable for small end-user applications that run on the desktop.
-
H2 1.0 Database by Hypersonic Creator is Out
HSQLDB creator Thomas Mueller has released 1.0 final of H2, his pure Java database successor to HSQLDB. H2's focus is to be best database for the lower end (low number of concurrent connections, embedded usage). InfoQ spoke to H2 creator Thomas Mueller to find out more.
-
Spring and EJB 3 Compared
devx is hosting an article comparing Spring 2 and EJB 3 focusing on support for persistence, transaction management, and statefulness, concluding that support is mostly the same with but with EJB being slightly better at handling state.
-
LINQ Examples Posted
Scott Guthrie has posted the materials from his recent Language INtegrated Query (LINQ) talk at Tech Ed Australia. For those looking for detailed code samples to understand LINQ further, download these materials. LINQ is a set of extensions for .NET to provide a native query syntax for C# and VB, allowing developers to perform SQL-like queries against any .NET collection or drop down to raw SQL.
-
Ruport: A Ruby Report Builder and Reporting Library
Gregory Brown releases a free library and toolset for Ruby that makes building reporting applications easy.
-
Debates flare on the right level of abstraction over ORM and JDBC
A heated debate started a few weeks ago initiated by members of the Hibernate team, arguing that using an abstraction framework on top of an ORM is a bad idea, citing Spring's HibernateTemplate as a specific example. Along the theme of levels of abstraction, Brian McCalister also surveyed various convenience frameworks over JDBC.
-
Easier Database Development with JDBC 4.0
Java 6.0 will include a number of Java Database Connectivity enhancements collectively known as JDBC 4.0. One of the main goals of JDBC 4.0 was to try and reduce the amount of boilerplate JDBC code a developer had to write.
-
BEA Finishes Moving OpenJPA Code to the Apache Incubator
BEA has finished the last set of OpenJPA code drops to the Apache Incubator. OpenJPA will be an enterprise grade JPA implementation suitable for production use. It will also form the basis for BEA's commercial Kodo 4.1 and WebLogic's JPA support.