TheServerSide

Java, JDBC and the HSQLDB database tutorial

Community driven content discussing all aspects of software development from DevOps to design patterns. The easiest way for a Java developer to learn Java Database Connectivity (JDBC) is to experiment ...
GitHub

When using java.sql.Timestamp for update, an exception thrown

When I use java.sql.Timestamp value with PreparedStatement#setObject, PreparedStatement#executeUpdate throws an exception. It probably happens due to the conversion: driver converts the value to the ...
Law

Stare Decisis: Its Definition, Role and Exceptions

The operation of stare decisis in our judicial system has received some attention lately given the recent major decisions from the U.S. Supreme Court in which the court overturned long-standing ...
GitHub

Could not commit JDBC transaction; nested exception is java.sql.SQLException "Caused by: java.sql.SQLException: null"

sql:update sku set version = version + 1, lock_stock = lock_stock - 1, sales_num = sales_num + 1, update_time = 1634890932671 where id = '6172713fca31ea641a495081 ...
TheServerSide

JDBC tutorial: Easy installation and setup with Apache Derby

Prior to the release of Java 9, Apache Derby was distributed along with the JDK and named JavaDB. As a result, it was common for developers interested in Java database connectivity (JDBC) to learn on ...
ZDNet

Embedded SQL in Java

One dilemma of deployment is what to do about a SQL database. For easy deployment of a Java application, you've probably used tools like Web Start to let the application download and run in almost a ...