Groovy SQL.execute help

No,

It looks perfectly fine.

Hmm, what happens if you Telnet to the database?

If you choose start/run... and write cmd
and then write "telnet computer port" (for example "telnet srv-myServer 1433" or "telnet localhost 1433") does it connect?

/niclas

Ole,
I tried 'telnet and it seemed like it connected.

Have I specified the password correctly. I think '$' is escape character in groovy but it is also part of my password. my password (which is changed a little is 'passdev1$'. The actual statement which gives the error is below. I have changed some sensitive information.

--------------------------------------------------
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:sqlserver://exampledb1:1433/intwebp2", "username", "passdev1\$","com.microsoft.sqlserver.jdbc.SQLServerDriver")

Tue May 29 16:37:41 PDT 2007:ERROR:com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/intwebp2 is not valid.

----------------------------------------------------------------


Ali

I digged into it, and it's really weird. It seems there is a conflict between Groovy SQL and MS SQL. I am not sure yet, but it seems that Groovy passes connection info wrong to SQl Server. Specifically, it sends the database name into the port number.

Here is my workaround.

sql = Sql.newInstance("jdbc:sqlserver://localhost:1898", "eviware", "eviware",
"com.microsoft.sqlserver.jdbc.SQLServerDriver")


sql.execute("insert into eviware_demo_datainsert.dbo.eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})")

That is; I removed the database name from the connection string (jdbc:sqlserver://localhost:1898" insted of jdbc:sqlserver://localhost:1898/eviware_demo_datainsert" )

and moved it to the query itself

(eviware_demo_datainsert.dbo.eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})") instead of eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})"))

Here is the full Groovy code to replace the code in the example:

--------------------------------------------------------------------------------

import groovy.sql.Sql

def authorStep = testRunner.testCase.getTestStepByName( "GetData" )
def resultStep = testRunner.testCase.getTestStepByName( "ResultProperties" )
    AuthorName = authorStep.getPropertyValue( "Author" )
ResultCount = resultStep.getPropertyValue( "TotalResults" )


sql = Sql.newInstance("jdbc:sqlserver://localhost:1898", "eviware", "eviware",
"com.microsoft.sqlserver.jdbc.SQLServerDriver")


sql.execute("insert into eviware_demo_datainsert.dbo.eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})")

DOH!

I thought this was the first i tried. Try the following:

import groovy.sql.Sql

def authorStep = testRunner.testCase.getTestStepByName( "GetData" )
def resultStep = testRunner.testCase.getTestStepByName( "ResultProperties" )
    AuthorName = authorStep.getPropertyValue( "Author" )
ResultCount = resultStep.getPropertyValue( "TotalResults" )

sql = Sql.newInstance("jdbc:sqlserver://localhost:1898;
databaseName=eviware_demo_datainsert;user=eviware;password=eviware;")

sql.execute("insert into dbo.eviware_tb_datainsert (Author, NumberOfBooks) values (${AuthorName}, ${ResultCount})")

What I've corrected is the connection string to be exactly like the one in the datasource tutorial.

/niclas