Comments (5)
can anyone write plain old JDBC code to show how it works?
from sql2o.
Example stolen from here
public static void executeStoredProcedure(Connection con) {
try {
CallableStatement cstmt = con.prepareCall("{call dbo.GetImmediateManager(?, ?)}");
cstmt.setInt(1, 5);
cstmt.registerOutParameter(2, java.sql.Types.INTEGER);
cstmt.execute();
System.out.println("MANAGER ID: " + cstmt.getInt(2));
}
catch (Exception e) {
e.printStackTrace();
}
}
@dimzon I have been working on a solution for this issue, and is almost done. I create a ProcedureCall class that represents a CallableStatement. This will have some of the same methods as the Query class (addParameter, executeAndFetch etc) and some new methods (addOutParameter, execute, getOutParameter etc)
from sql2o.
can you reproduce this on H2 as test-case ?
2014-04-10 1:48 GMT+04:00 Lars Aaberg [email protected]:
Example stolen from herehttp://technet.microsoft.com/en-us/library/ms378108.aspx
public static void executeStoredProcedure(Connection con) {
try {
CallableStatement cstmt = con.prepareCall("{call dbo.GetImmediateManager(?, ?)}");
cstmt.setInt(1, 5);
cstmt.registerOutParameter(2, java.sql.Types.INTEGER);
cstmt.execute();
System.out.println("MANAGER ID: " + cstmt.getInt(2));
}
catch (Exception e) {
e.printStackTrace();
}
}Reply to this email directly or view it on GitHubhttps://github.com//issues/31#issuecomment-40020787
.
from sql2o.
DECLARE @returnedStatus INT
DECLARE @returnedMessage VARCHAR(2000)
exec [dbo].[play_GetData] @returnedStatus, @returnedMessage
SELECT @returnedStatus, @returnedMessage
this way all you need is just nextResultSet()
support
from sql2o.
After some evaluation of the possible code-fix, I have decided to label this issue with "wontfix" label. The added complexity in the Sql2o core is not worth the slightly improved api.
When Sql2o version 2 is released, underlaying JDBC objects will be easily available from Sql2o objects, and therefor it will be easier to mix sql2o and plain JDBC.
from sql2o.
Related Issues (20)
- Warnings with Java 11, possible future denied operation HOT 2
- ORDER BY does not work with addParameter HOT 2
- Remove case sensitive converter
- Column mappings failed HOT 1
- Issue with ArrayParameters.updateQueryWithArrayParameters when query contains '?' character
- When in jar file I receive No suitable driver for error HOT 1
- Publish version 1.6.0 of oracle extensions
- sql2o can't rolback ? HOT 3
- can i change the Type of return value of executeAndFetch()
- State of the Project
- NPE when return query object is of type Map HOT 1
- How to correctly insert with array type (ex bigint[]) columns?
- Library uses now-private reflection mechanism HOT 2
- Can't add ON DELETE CASCADE to forein key when creating table, using PostgreSQL. HOT 1
- Updated MySQL 8.0.26 connector breaks historically working code HOT 2
- Next release HOT 2
- MethodSetter setProperty failing with generic IllegalArgumentException
- Failed test testAllTypes(org.sql2o.reflect.ReflectionFieldSetterFactoryTest) only in Maven HOT 2
- Collection of enums is not properly mapped to query params HOT 1
- SQL2o 1.6.0 Compatabile with JDK 17/ OpenJDK 17 ? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql2o.