Database testing

Archive
1

How to establish connection to the mysql database and fire a query and get the value from a particular column in a table and print it

2
  1. create Connection (java.sql.Connection) by instantiating DB driver (java.sql.DriverManager)
  2. using java.sql.Statement prepare statement (SELECT * FROM TABLE_OF_INTEREST)
  3. create result set (java.sql.ResultSet) by executing statement on connection
  4. cycle thru result set and pick data from response using any of ResultSet.getXXX() functions
  5. print

if you try search this forum, you will find lot of detailed solutions for you. What you need is to get and try what will work for you…

3

@arvindram.1995 There is a free Katalon Plugin available at below link. There is also detailed documentation linked on the plugin page which can help you with your requirements.

https://store.katalon.com/product/24/DBMS-Custom-Keywords

4

Thank you will surely go through the forum

5

Thank you for your kind response

6

Hi i am facing an issue

i gave encoded base 64 password still it is not establishing an connection

Plz help me i am new to this

Test Cases/DBtest FAILED.
Reason:
org.codehaus.groovy.runtime.InvokerInvocationException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ’

ClientConnectionId:43459f45-dc49-4d70-b0a9-90e3242c05b4
at com.katalon.plugin.keyword.connection.DatabaseKeywords.invokeMethod(DatabaseKeywords.groovy)
at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.invokeStaticMethod(CustomKeywordDelegatingMetaClass.java:49)
at DBtest.run(DBtest:32)
at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)
at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)
at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:336)
at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:327)
at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:306)
at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:298)
at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:232)
at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:114)
at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:105)
at com.kms.katalon.core.main.TestCaseMain$runTestCase$0.call(Unknown Source)
at TempTestCase1557834077728.run(TempTestCase1557834077728.groovy:21)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ’ psp '. ClientConnectionId:43459f45-dc49-4d70-b0a9-90e3242c05b4
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:251)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:81)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:3077)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2360)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2346)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1404)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1068)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:904)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:451)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014)
at java_sql_DriverManager$getConnection.call(Unknown Source)
at com.katalon.plugin.keyword.connection.DatabaseKeywords.createConnection(DatabaseKeywords.groovy:44)
at com.katalon.plugin.keyword.connection.DatabaseKeywords.invokeMethod(DatabaseKeywords.groovy)
at com.kms.katalon.core.main.CustomKeywordDelegatingMetaClass.invokeStaticMethod(CustomKeywordDelegatingMetaClass.java:49)
at Script1557830194123.run(Script1557830194123.groovy:32)
… 11 more

dIvQqVjuDH
dIvQqVjuDH1920×1080 211 KB