Schema Name Sql server from java jdbc connection

Question

i am trying to call stored procedures from java using jdbc conenction to connect sql server

String storedProcd = "{call TEST_PROC(?,?)}";
callableStatement = dbConnection.prepareCall(storedProcd);
callableStatement.setInt(1, id);
callableStatement.setString(2, Entityname);
callableStatement.execute();
callableStatement.close();

problem is that i cant set schema name in JDBC url,it works fine if my Stored procuders are in default schema that is dbo but what if my stored procedures are in other schema ?

hi thanks Leos ,working fine .Please post it as answer

rish1690
– rish1690

2014-04-22 04:46:35 +00:00
Commented Apr 22, 2014 at 4:46 — rish1690
– rish1690, Commented Apr 22, 2014 at 4:46

Leos Literak · Accepted Answer · 2014-04-22 05:10:01Z

2

As any SQL resource you can prefix procedure name with schema name:

"{call schema.TEST_PROC(?,?)}"

answered Apr 22, 2014 at 5:10

Leos Literak

9,46022 gold badges97 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Schema Name Sql server from java jdbc connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related