Getting the Return Value from JDBC MSSQL

by

Bozho’s 2nd revised answer was close but not quite there. It did lead me to the answer though.

Taking the code example I started with we end up with:

CallableStatement proc = connection.prepareCall("{ ? = call dbo.mySproc() }");
proc.registerOutParameter(1, Types.INTEGER);
proc.execute();
int returnValue = proc.getInt(1);

The key pieces here are the “? =” in front of the “call” in the prepareCall function which sets up a place for the return value and the registerOutputParameter. It has to be registered as an Integer, as the return value is always an int (at least in SQL Server, maybe it’s different in other DBs). You therefore have to get it using getInt. I tested this method and it does work.

More Related Contents:

  1. How to get *everything* back from a stored procedure using JDBC
  2. JDBC connection failed, error: TCP/IP connection to host failed
  3. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  4. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  5. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  6. How to call oracle stored procedure which include user-defined type in java?
  7. How do I connect to a SQL Server 2008 database using JDBC?
  8. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  9. JPA SQL Server No Dialect mapping for JDBC type: -9
  10. Native Library sqljdbc_auth.dll already loaded in another classloader
  11. Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
  12. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  13. How to pass Table-Valued parameters from java to sql server stored procedure?
  14. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  15. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  16. The TCP/IP connection to the host localhost, port 1433 has failed
  17. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  18. How to map an entity field whose name is a reserved word in JPA
  19. Cannot issue data manipulation statements with executeQuery()
  20. JDBC Class.forName vs DriverManager.registerDriver
  21. IO Error: The Network Adapter could not establish the connection
  22. SQL prepared statement how to select via multiple possible menu selections?
  23. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  24. JDBC- Implementation of interfaces
  25. PreparedStatement setNull(..)
  26. ojdbc14.jar vs. ojdbc6.jar
  27. Java JDBC ignores setFetchSize?
  28. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  29. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  30. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

Leave a Comment