SeleniumHQ
diff --git a/‎java/server/src/org/openqa/selenium/grid/commands/sessionmaps.txt‎
Lines changed: 39 additions & 0 deletions b/‎java/server/src/org/openqa/selenium/grid/commands/sessionmaps.txt‎
Lines changed: 39 additions & 0 deletions
diff --git a/‎java/server/src/org/openqa/selenium/grid/sessionmap/jdbc/JdbcSessionMapOptions.java‎
Lines changed: 15 additions & 5 deletions b/‎java/server/src/org/openqa/selenium/grid/sessionmap/jdbc/JdbcSessionMapOptions.java‎
Lines changed: 15 additions & 5 deletions
@@ -25,3 +25,42 @@ After the sessionmap server successfully starts, you should see some log lines a
 15:22:55.136 INFO [KqueueProvider.<clinit>] - Starting with kqueue library
 15:22:55.328 INFO [SessionMapServer.execute] - Started Selenium session map 4.0.0-alpha-7 (revision a5536dfb7b*): http://192.168.0.5:5556
 ```
+2. JdbcBackedSessionMap
+========================
+
+`JdbcBackedSessionMap` uses the JDBC API to talk to the JDBC driver and use related database for sessions map store.
+
+The table name used to store sessions is : sessions_map
+It consists of three columns of string datatype : session_ids, session_caps, session_uri
+
+Prerequisites
+1. Ensure the appropriate JDBC driver jar is downloaded on the host machine.
+2. Ensure the "sessions_map" table with varchar "session_ids", "session_caps" and "session_uri" columns is created in the database.
+
+Example of creating the table:
+   `CREATE TABLE sessions_map
+         (
+           session_ids varchar(1000),
+           session_caps varchar(1000),
+           session_uri varchar(1000)
+         );`
+ Here the limit for varchar type is given 1000 as an arbitrary number in the example. Ensure the datatype and limit matches the selected database.
+ Also, the limit for varchar type should be able to accommodate the capabilities json stored in "sessions_caps".
+
+Below are the steps to start a `JdbcBackedSessionMap`.
+
+1. Set an environment variable using `export SESSIONS_IMPLEMENTATION='org.openqa.selenium.grid.sessionmap.jdbc.JdbcBackedSessionMap'`
+3. Build the grid deployment jar by running the command
+`bazel build grid`
+2. Start the JdbcBackedSessionMap using the command
+`java -jar <path/to/grid/jar> --ext path/to/selenium/bazel-bin/java/server/src/org/openqa/selenium/grid/sessionmap/jdbc/libjdbc.jar:path/to/jdbc-driver.jar sessions --jdbc-user "<jdbc_user>" --jdbc-password "<jdbc_password>" --jdbc-url "<jdbc_url>"`
+
+After the sessionmap server successfully starts, you should see some log lines as below:
+```
+15:05:20.345 INFO [LoggingOptions.getTracer] - Using OpenTelemetry for tracing
+15:05:20.348 INFO [LoggingOptions.createTracer] - Using OpenTelemetry for tracing
+15:05:20.439 INFO [UnboundZmqEventBus.<init>] - Connecting to tcp://*:4442 and tcp://*:4443
+15:05:20.489 INFO [UnboundZmqEventBus.<init>] - Sockets created
+15:05:20.492 INFO [UnboundZmqEventBus.lambda$new$2] - Bus started
+15:05:21.483 INFO [SessionMapServer.execute] - Started Selenium session map 4.0.0-alpha-7 (revision 857fe401ae): http://192.168.29.132:5556
+```
@@ -23,6 +23,7 @@
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.SQLException;
+import java.util.NoSuchElementException;
 import java.util.logging.Logger;
 
 public class JdbcSessionMapOptions {
@@ -39,10 +40,19 @@ public JdbcSessionMapOptions(Config config) {
   }
 
   public Connection getJdbcConnection() throws SQLException {
-    String jdbcUrl = String.valueOf(config.get(SESSIONS_SECTION, "jdbc-url"));
-    String jdbcUser = String.valueOf(config.get(SESSIONS_SECTION, "jdbc-user"));
-    String jdbcPassword = String.valueOf(config.get(SESSIONS_SECTION, "jdbc-password"));
-
-    return DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword);
+    try {
+      String jdbcUrl = config.get(SESSIONS_SECTION, "jdbc-url").get();
+      String jdbcUser = config.get(SESSIONS_SECTION, "jdbc-user").get();
+      String jdbcPassword = config.get(SESSIONS_SECTION, "jdbc-password").get();
+
+      if (jdbcUrl.isEmpty()) {
+        throw new JdbcException(
+            "Missing JDBC Url value. Add sessions option value --jdbc-url <url-value>");
+      }
+      return DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword);
+    } catch (NoSuchElementException e) {
+      throw new JdbcException(
+          "Missing session options. Check and add all the following options \n --jdbc-url <url> \n --jdbc-user <user> \n --jdbc-password <password>");
+    }
   }
 }