Hmm.. ok, maybe its a clash of placeholder syntax, what if we try an java style way of adding the schema string e.g.
"DELETE FROM ["+dbschema1+"].[dbo].[JOB] WHERE EMPNAME = 'NAME1'"
?
Hi,
OK, thats strange, the syntax looks OK, for example this works fine for me:
def invoice = db.firstRow("select * from invoices where id =
$requestInvoiceNo")
I don't have your setup / db etc, I just tested to see if I could get the same string that you said works:
def dbschema1 = 'EMP_SCHEMA' log.info "DELETE FROM [$dbschema1].[dbo].[JOB] WHERE EMPNAME = 'NAME1'" //doesnt work, com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ''EMP_SCHEMA'.dbo.JOB'. error at line: 14
Gives:
Wed Jun 29 14:06:15 BST 2016:INFO:DELETE FROM [EMP_SCHEMA].[dbo].[JOB] WHERE EMPNAME = 'NAME1'
And you say that
context.expand('${#Project#Schema1}')
is definitely returning EMP_SCHEMA? Can you print out the query string after the substitution of dbschema1 has taken place?
Regards,
Rupert
You are absolutely right. It does displays the correct value
INFO:DELETE FROM [EMP_SCHEMA].[dbo].[JOB] WHERE EMPNAME = 'NAME1'
But while substituting with
[$dbschema1]
it gives the error . I don't know if its database mssql 2012 specific..i hope not
Hmm.. ok, maybe its a clash of placeholder syntax, what if we try an java style way of adding the schema string e.g.
"DELETE FROM ["+dbschema1+"].[dbo].[JOB] WHERE EMPNAME = 'NAME1'"
?
:smileyhappy:
Thank you, the java syntax worked.
Ok - no problem, must be a quirk of the DB driver, as your first syntax seemed fine for other DBs :-)
