alibaba82
17 years agoSuper Contributor
Groovy SQL.execute help
Hello,
On your example at
http://www.eviware.com/index.php?option ... view&id=57
you have a groovy statement
sql = Sql.newInstance("jdbc:mysql://localhost:3306/eviware_demo_datainsert", "evidemo", "evipass", "com.mysql.jdbc.Driver")
I tried to do something similar but i get an error when I try to run the groovy script. I use the same parameters in the datasource step without any problem. Can you tell me if my groovy script is wrong.
DataSource parameters
Driver- com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String
jdbc:sqlserver://:1433;databaseName=;user=;password=;
corresponding sql.execute statement:
sql = Sql.newInstance("jdbc:sqlserver://:1433/", "", "","com.microsoft.sqlserver.jdbc.SQLServerDriver")
when I run the above groovy statement, I get the following error.
Thu May 24 18:12:46 PDT 2007:ERROR:com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/is not valid.
Can you tell me what I am doing wrong.
Thanks
Ali
On your example at
http://www.eviware.com/index.php?option ... view&id=57
you have a groovy statement
sql = Sql.newInstance("jdbc:mysql://localhost:3306/eviware_demo_datainsert", "evidemo", "evipass", "com.mysql.jdbc.Driver")
I tried to do something similar but i get an error when I try to run the groovy script. I use the same parameters in the datasource step without any problem. Can you tell me if my groovy script is wrong.
DataSource parameters
Driver- com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String
jdbc:sqlserver://
corresponding sql.execute statement:
sql = Sql.newInstance("jdbc:sqlserver://
when I run the above groovy statement, I get the following error.
Thu May 24 18:12:46 PDT 2007:ERROR:com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/
Can you tell me what I am doing wrong.
Thanks
Ali