• Post Reply Bookmark Topic Watch Topic
  • New Topic

Executing mssql procedure in java  RSS feed

 
Nidheesh Krishna
Ranch Hand
Posts: 60
Java MySQL Database Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
How can i execute MSSQL procedure codes through java?

This procedure codes are available in a file. I want to read the file and execute this procedure codes.
 
Tapas Chand
Ranch Hand
Posts: 614
9
BSD Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe you have to create a stored procedure in MSSQL and call that using JDBC.
I am not sure of any way to read a file and execute the PLSQL block.
 
Campbell Ritchie
Sheriff
Posts: 53779
128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tapas Chand wrote:I believe you have to create a stored procedure . . .
More likely a prepared statement, I think. I suggest you read the Java™ Tutorials about JDBC. I shall take the liberty of duplicating this discussion in our databases forum.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!