There a number of pure Java SQL database systems develolpers can embed into applications. In this tip we introduce two open source projects, HSQLDB and Apache Derby.

The Java platform includes a variety of language features and library types for dealing with exceptions, which are divergences from expected program behavior.In my previous article, you learned ...

Null pointer exception is an “exception” (error) that is particularly common when programming in Java. For a beginner, this is a confusing and daunting message to receive, but it can be just ...

In this blog post, I demonstrate an advantage of being more explicit in typing when using Groovy SQL with an Oracle database to avoid a potential “Invalid column index” SQLException because I ...

The solution to SQL injection attacks in Java is simple enough: Make sure your app properly validates input and prevents malicious code from being appended to data already accepted into a form. As a ...

In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...

Now that SQL Server also has Java within its SQL code, you have a new path to migrate Java applications to SQL Server. Pushing business logic into the database: Teams that are accustomed to developing ...

She listed a number of use cases for Java inside SQL Server: This extends the T-SQL (Transact-SQL) surface area to better handle use cases involving regular expressions, string handling, and Natural ...