InfoQ Homepage Data Access Content on InfoQ
-
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.
-
Red Hat Sued Over Hibernate 3 ORM Patent Infringement Claim
Firestar Software has filed a patent claim against Red Hat for Hibernate 3 allegedly infringing on a patent covering O/R mapping. Firestar, who has not released it's ObjectSpark O/R product since 2003 claims that it "has suffered and will continue to suffer substantial damages."
-
WinFS Officially Dropped
On the WinFS team blog on Friday, Quentin Clark blogged that WinFS, the new relational filestore would no longer be shipped as a separate product, instead, parts of it will make it into ADO.NET (entities) and SQL Server. The community is calling thea nnouncement spin and proclaiming that WinFS is dead.
-
DataDirect XQuery 2.0 Released; W3C XQuery Specs Updated
DataDirect has released XQuery 2.0, a Java implementation of the XML query and transformation language (XQuery) API for Java (XQJ) that allows the querying of combinations of RDBMS, XML, EDI, CSV, and other sources and returns the results as XML. On June 8th, new versions of the XQuery and related W3C specs were submitted, currently in Candidate Recommendation stage.