How to call a stored procedure from Java and JPA

JPA 2.1 now support Stored Procedure, read the Java doc here. Example: StoredProcedureQuery storedProcedure = em.createStoredProcedureQuery(“sales_tax”); // set parameters storedProcedure.registerStoredProcedureParameter(“subtotal”, Double.class, ParameterMode.IN); storedProcedure.registerStoredProcedureParameter(“tax”, Double.class, ParameterMode.OUT); storedProcedure.setParameter(“subtotal”, 1f); // execute SP storedProcedure.execute(); // get result Double tax = (Double)storedProcedure.getOutputParameterValue(“tax”); See detailed example here.

Would you, at present date, use JBoss or Glassfish (or another) as Java EE server for a new project? [closed]

I have used WebLogic, WebSphere, JBoss, GlassFish, Resin, Jetty, Tomcat, and a few others over the last 10+ years. So, if I were considering a new project, I would ask myself a few questions first. One thing that I would not question anymore is that I would flat refuse to use JSPs unless I was … Read more

JBoss vs Tomcat again [closed]

First the facts, neither is better. As you already mentioned, Tomcat provides a servlet container that supports the Servlet specification (Tomcat 7 supports Servlet 3.0). JBoss AS, a ‘complete’ application server supports Java EE 6 (including Servlet 3.0) in its current version. Tomcat is fairly lightweight and in case you need certain Java EE features … Read more

Using HeapDumpOnOutOfMemoryError parameter for heap dump for JBoss

Here’s what Oracle’s documentation has to say: By default the heap dump is created in a file called java_pid.hprof in the working directory of the VM, as in the example above. You can specify an alternative file name or directory with the -XX:HeapDumpPath= option. For example -XX:HeapDumpPath=/disk2/dumps will cause the heap dump to be generated … Read more

PSQLException: current transaction is aborted, commands ignored until end of transaction block

I got this error using Java and PostgreSQL doing an insert on a table. I will illustrate how you can reproduce this error: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block Summary: The reason you get this error is because you have entered a transaction and one of your SQL … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)