Java tutorial
import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; public class Main { public static void main(String[] argv) throws Exception { String driverName = "com.jnetdirect.jsql.JSQLDriver"; Class.forName(driverName); String serverName = "127.0.0.1"; String portNumber = "1433"; String mydatabase = serverName + ":" + portNumber; String url = "jdbc:JSQLConnect://" + mydatabase; String username = "username"; String password = "password"; Connection connection = DriverManager.getConnection(url, username, password); CallableStatement cs = connection.prepareCall("{? = call myfunc}"); // Register the type of the return value int intValue = 0; cs.registerOutParameter(1, intValue); // Execute and retrieve the returned value cs.execute(); String retValue = cs.getString(1); } }