Here are the steps: 1. Use JDBC driver for Oracle database. A JDBC driver for Oracle must be present in your project’s classpath. Click here to download Oracle Database JDBC driver. Choose the version according to your Oracle database installation (you must have an account in Oracle website to download. Sign up is free). Ilanchezhian opened SPR-2617 and commented During update by using JdbcTemplate.update(String sql, Object[] args), I encounter exception due to deadlock. This is thrown as an SQLException. Exception occurs during processing SQL query of JAVA application: "[EXCEPTION] javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: com.want/stand~util~ear) Exception raised from invocation of public java.util.List com.want.data.ejb.UtilSessionBean.getLev Open the connection. Specify the SQL statement. Prepare and run the statement. Set up the loop to iterate through the results (if any). Do the work for each iteration. Process any exception. Handle transactions. Close the connection, the statement, and the resultset. The Spring Framework takes care of all the low-level details that can make Data Access Objects (or DAOs for short) are used as a direct line of connection and communication with our database. DAOs are used when the actual CRUD (CRUD = Create, Read, Update, Delete) operations are needed and invoked in our Java code. These data access objects also represent the “data layer” of our application. Hibernate takes care of mapping Java classes to database tables using XML files and without writing any line of code. Provides simple APIs for storing and retrieving Java objects directly to and from the database. If there is change in the database or in any table, then you need to change the XML file properties only. 2qjxQxK.

jdbc exception on hibernate data access