• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection to database

 
Pranav Butala
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way to write a bash script that will connect to MySQL database if all the JDBC connection information along with user id and password is provided?
driver=com.mysql.jdbc.Driver
url=jdbc.url
userid=jdbc.userid
password=jdbc.password
 
George Brown
Ranch Hand
Posts: 919
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you're accessing the database from a bash script, why not just use the mysql client program? IMO it's easier to call it directly, and then process the results in the shell program.
 
Pranav Butala
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Cannot do it. Using ant script for deployment precess. Sql task in ant fails to execute the dump file properly. Need to call it through a shell script. Project guide lines.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic