• Post Reply Bookmark Topic Watch Topic
  • New Topic

Executing mssql procedure in java  RSS feed

 
Ranch Hand
Posts: 68
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.
 
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.
 
Marshal
Posts: 58449
178
  • 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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!