Jdbc Connection and stored value

luckyvasul · November 2, 2023, 1:32pm

Hi gatling team,
Use: Gatling java

  1. How do I execute a SQL SELECT and save the result ?
  2. How can use the saved result into another sql UPDATE ?

Thanks
lucky

sbrevet · November 2, 2023, 5:28pm

There is a third party plugin (not supported here): Gatling - Third Party Plugins

luckyvasul · November 3, 2023, 2:50pm

github.com

Tinkoff/gatling-jdbc-plugin/blob/master/src/test/java/ru/tinkoff/load/jdbc/test/cases/JdbcActions.java

package ru.tinkoff.load.jdbc.test.cases;

import ru.tinkoff.load.javaapi.actions.*;
import ru.tinkoff.load.javaapi.check.simpleCheckType;

import java.util.Map;
import java.util.UUID;

import static ru.tinkoff.load.javaapi.JdbcDsl.*;

public class JdbcActions {

    public static RawSqlActionBuilder createTable(){
        return jdbc("Create table")
                .rawSql("CREATE TABLE TEST_TABLE (ID INT PRIMARY KEY, NAME VARCHAR(64), CREATED_AT DATE DEFAULT now(), flag BOOLEAN DEFAULT false);" +
                                        "CREATE TABLE TT (ID UUID, NAME VARCHAR(64));");
    }

    public static RawSqlActionBuilder createprocedure(){
        return jdbc("Procedure create")

This file has been truncated. show original

I see, it do not have UPDATE function support

GatlingPete · November 3, 2023, 3:48pm

Hello there,

What Sebastien meant is the Jbdc plugin that you’re using is a third party plugin not managed by Gatling. This community is not meant for support of 3rd party applications.

However, if you look here you can find the plugin code: Jdbc Connection and stored value - #3 by luckyvasul

Reading the code you can see using either query or rawSql or batchUpdate will work for your use case.

I would kindly ask that you read the code and try their for 3rd party plugins in the future.

All the best,
Pete

system · December 3, 2023, 3:48pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.