{"repo":"zalando-stups/java-sproc-wrapper","free":true,"listed":false,"github":"https://github.com/zalando-stups/java-sproc-wrapper","clone":"git clone https://github.com/zalando-stups/java-sproc-wrapper.git","description":"Java Stored Procedure Wrapper: Calling PostgreSQL stored procedures from Java","language":"Java","stars":65,"topics":["postgresql","java","stored-procedures","proxy","rpc","hacktoberfest"],"license":"MIT","category":"databases-storage","readme_excerpt":"SProcWrapper ============ Library to make PostgreSQL stored procedures(SProcs) available through simple Java \"SProcService\" interfaces including automatic object serialization and deserialization (using typemapper and convention-over-configuration). Supports horizontal database sharding (partition/access logic lies within application), easy use of pg advisory lock through annotations to ensure single Java node execution, configurable statement timeouts per stored procedure, and PostgreSQL types including enums and hstore. Usage ------------ To use SProcWrapper, add the following lines to your pom.xml: Type Mapping ------------ SProcWrapper provides an efficient and easy-to-use mechanism for translating values from database to Java objects and vice-versa. It allows us to map not only primitive types, but also complex types (Java domain objects). Here are some examples! Using basic types: And a complex type: Please check unit/integration tests for more examples. The following table shows the mapping between a database type and a Java type: Database Java Type ---------------- ------------------------------------------------- smallint int integer int bigint long decimal java.math.BigDecimal numeric java.math.BigDecimal real float double precision double serial int bigserial long varchar java.lang.String char char text java.lang.String timestamp java.sql.Timestamp timestamptz java.sql.Timestamp date java.sql.Timestamp time java.sql.Timestamp timetz java.sql.Timestamp boolean boole","default_branch":null,"files":null,"tree":[],"storefront":"/r/zalando-stups","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/zalando-stups/java-sproc-wrapper/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}