<div>
Hi <br />
What I wanted was to get a Connection from the pool maintained by Hibernate, for my jasperreporats and some key Stored procedures I &nbsp;was running with createSQLQuery. With this, I had the impression I was loosing some performance yield by prepared callable statement.<br />
Then, I found this<br />
HibernateUtil.getSessionFa<wbr />ctory().ge<wbr />tCurrentSe<wbr />ssion().do<wbr />Work(new Work() {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @Override<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public void execute(Connection connection) throws SQLException {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if (call == null) {<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;String sql = &quot;&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;call = connection.prepareCall(sql<wbr />);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });
</div>


Hi
What I wanted was to get a Connection from the pool maintained by Hibernate, for my jasperreporats and some key Stored procedures I  was running with createSQLQuery. With this, I had the impression I was loosing some performance yield by prepared callable statement.
Then, I found this
HibernateUtil.getSessionFactory().getCurrentSession().doWork(new Work() {
              @Override
              public void execute(Connection connection) throws SQLException {
                   if (call == null) {
                       String sql = "";
                       call = connection.prepareCall(sql);
                   }
                   
                }
            });

<div>
<div class="content wysiwyg-content">
Hi,<br />
Is there a way to get a connection from Hibernate 5.1 session object?<br />
I am looking forward to hearing from you.
</div>
</div>


Hi,
Is there a way to get a connection from Hibernate 5.1 session object?
I am looking forward to hearing from you.

Hibernate 5.1: Is a way to get a connection

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.