How to connect to a Database (via Scripting)

[VParamasivam]

I am trying to customise the Auto Generated Groovy script for connecting in to a DataBase ,
Can you please let me know the procedures involved to customise and run the
Auto Generated (Recorded) Groovy script for DB connection , Result validation etc.

[Frank_Fang1]

Please check the related code in Groovy.

[azinchuk]

@VParamasivam - please see these topics:

Connecting Sql Server from Machine Task

All, Is there is a way we can connect Sql Server from Machine task. We are getting an error. <?xml version="1.0" encoding="UTF-8"?> <config charset="UTF-8"> <datastore-connection url="jdbc:sqlserver://xyz.server.net;databaseName=RPAMIS;" username="username" password="password" > <var-def name="result"> <datastore name="TBL_PROCESS"> select * from TBL_PROCESS; …

Connecting to MS SQL server

We have a problem connecting to Microsoft SQL Server. Right now we try to write working code in WF Eclipse. Tried two different approaches: 1. Using WebHarvest tag <var-def name="result"> <datastore name="GlobalStaffHistoryAll"> select * from @this; </datastore> </var-def> Such usage generates error: Table "ds_GlobalStaffHistoryAll" not found; SQL statement in our case GlobalStaffHistoryAll is a name of view. But even using wrong credentials error still th…

Issue with Connecting My SQL

Hi Guys, I need to connect My SQL server with WF, am using the below code in my web harvest XML but no luck, facing below issue. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Will my WF allows download from Maven? import groovy.sql.Sql this.class.classLoader.addURL(new URL("http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar")) def url = 'jdbc:mysql://localhost:3306/sakila' def user = 'root' def password = 'admin' def dr…