This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem while executing Procedures Using Callable Statement

 
vasu devan
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,

Having probelom in executing Procedures in Database.
I am Using MS-SQL Server ,and connecting the Database through JDBC-ODBC Coonection.Following are the short Description of the Probelom that is Encountering.

1.Created Procedure in MS-SQL Server, which intern have 28 Tables Interaction,ie..,Creating Temprory Tables,Selecting Values from Source Table,Pushing the Selected values into Temprory Tables.
2.Execute Above Procedure through Callable Statement.
working fine,but it is Working only for Selected tables,ie..,only for first few tables not for 28 tables.
3.While executing the same Procedure in MS-Query Analyser,its working Perfect.

My Suggestions or Questions....

Is there any way to improve the execution of Procedures using Callable Statement?if yes, how can achieve that?

Solutions is needed urgently

Thanks in advance

cheers
vasu
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vasu,
Are all the tables being used in the same stored proc? If so, it might be timing out. Or are these similar stored procs? If so, check the permissions.

Tuning a stored proc is just like tuning a SQL statement: check execution plan, add indexes, make sure not returning unnecessary data, ...
 
vasu devan
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

the single procedure has all the tables interaction.if i splitted the same procedures into multiple procedures,then working fine.

i found that some probelom in executing the procedure through Callable statement(While executing same procedure in sql-query analyser its working fine).connected the MS-SQL Server through JDBC-ODBC connection using DSN.whats my question is....

How can i achieve the Execution of multiple trasactions in single procedure using Callable statement?if anyone have idea to improve the above probelom,please provide asap.

Thanks in advance

cheers
vasu
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic