Ifyou are using Maven as your build tool, then add this below dependency. Make sure you have the correct version of corresponding to the database version. For me, I have an Oracle 11g database, hence I am using ojdbc6.jar. Step 1) Add dependency KnowledgeBase java.sql.SQLException: Query or procedure does not return a result set Itallows us to set propagation, isolation, timeout, read-only, and rollback conditions for our transaction. We can also specify the transaction manager. 2.1. @Transactional Implementation Details. Spring creates a proxy, or manipulates the class byte-code, to manage the creation, commit, and rollback of the transaction. javasql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor When I run the application and call the request to the Dao class through UI I am getiing below exception message. Whena query selects one or more LONG or LONG RAW columns, the JDBC driver transfers these columns to the client in streaming mode. After a call to executeQuery or next, the data of the LONG column is waiting to be read. Do not create tables with LONG columns. Use large object (LOB) columns, CLOB, NCLOB, and BLOB, instead. vAXF.

jdbc exception on hibernate data access sqlexception for sql