i am trying to test a query on jenkins. the database is on another server and i

Question

i am trying to test a query on jenkins. the database is on another server and i am running jenkins on another server. i used execute windows batch command build. I am trying to connect to mysql. this is my query

SQLCMD -S <The server where the database is> -P <my computer password> -U <my computer username> -d <mysql database i am running the query from> -W -Q "SELECT * FROM <column name>"

The statement builds, but I get an error saying "The system cannot find the file specified". i cant figure out the issue.

Explanation / Answer

As per the syntax it is correct.The problem can be in the exact file name or the location is not correctly put up.Also putting the copy te file to project folder will also help.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.