spwrap
spwrap copied to clipboard
Simple Stored Procedure call wrapper with no framework dependencies.
Each time the stored procedure is being called, there's a compilation step happening: https://github.com/mhewedy/spwrap/blob/7384f0c8651302533c695fdd411dc8f1f82edc36/src/main/java/spwrap/Caller.java#L211-L223 So instead of doing such activity eachtime, spwrap can cache such calculations. (spring stored procedure do)
In parameters: https://github.com/mhewedy/spwrap/blob/7384f0c8651302533c695fdd411dc8f1f82edc36/src/main/java/spwrap/Caller.java#L230 Output parameters: https://github.com/mhewedy/spwrap/blob/7384f0c8651302533c695fdd411dc8f1f82edc36/src/main/java/spwrap/Caller.java#L239 The following snippet is from `spring-jdbc` ``` if (declaredParam.getScale() != null) { cs.registerOutParameter(sqlColIndx, declaredParam.getSqlType(), declaredParam.getScale()); } else { cs.registerOutParameter(sqlColIndx, declaredParam.getSqlType()); } ```
Unit test Props classes found at https://codecov.io/gh/mhewedy/spwrap/tree/master/src/main/java/spwrap/props
http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-developing-auto-configuration.html
Support of executing the stored procedure asynchronously and get the result back on the caller thread. The support should be available in the new interface as well as the old...