Package de.chojo.sqlutil.jdbc

Class MariaDbJdbc

java.lang.Object
de.chojo.sqlutil.jdbc.JdbcConfig<T>
de.chojo.sqlutil.jdbc.RemoteJdbcConfig<MariaDbJdbc>
de.chojo.sqlutil.jdbc.MariaDbJdbc
public class MariaDbJdbc extends RemoteJdbcConfig<MariaDbJdbc>

  • Constructor Details

    • MariaDbJdbc

      public MariaDbJdbc()

  • Method Details

    • driver

      public String driver()
      Description copied from class: JdbcConfig
      Returns the driver name of the jdbc url
      Specified by:
      driver in class JdbcConfig<MariaDbJdbc>
      Returns:
      driver

    • connectTimeout

      public MariaDbJdbc connectTimeout(int millis)
      The connect timeout value, in milliseconds, or zero for no timeout. Default: 30 000.
      Parameters:
      millis - milliseconds
      Returns:
      builder instance

    • useServerPrepStmts

      public MariaDbJdbc useServerPrepStmts()
      PrepareStatement are prepared on the server side before executing. The applications that repeatedly use the same queries have value to activate this option, but the general case is to use the direct command (text protocol).
      Returns:
      builder instance

    • allowLocalInfile

      public MariaDbJdbc allowLocalInfile()
      Permit loading data from file

      See LOAD DATA LOCAL INFILE.

      Returns:
      builder instance

    • sslMode

      public MariaDbJdbc sslMode(MariaDbJdbc.SslMode sslMode)
      Enables SSL/TLS in a specific mode.

      This option replaces the deprecated options: disableSslHostnameVerification, trustServerCertificate, useSsl

      Parameters:
      sslMode - ssl mode. Default MariaDbJdbc.SslMode.DISABLE
      Returns:
      builder instance

    • serverSslCert

      public MariaDbJdbc serverSslCert(String path)
      Permits providing server's certificate in DER form, or server's CA certificate. The server will be added to trustStor. This permits a self-signed certificate to be trusted.

      Can be used in one of 2 forms :

      - serverSslCert=/path/to/cert.pem (full path to certificate)

      - serverSslCert=classpath:relative/cert.pem (relative to current classpath

      Parameters:
      path - vert path
      Returns:
      builder instance

    • keyStore

      public MariaDbJdbc keyStore(String path)
      File path of the keyStore file that contain client private key store and associate certificates (similar to java System property "javax.net.ssl.keyStore", but ensure that only the private key's entries are used).
      Parameters:
      path - path
      Returns:
      builder instance

    • keyStorePassword

      public MariaDbJdbc keyStorePassword(String password)
      Password for the client certificate keyStore (similar to java System property "javax.net.ssl.keyStorePassword").
      Parameters:
      password - password
      Returns:
      builder instance

    • enabledSslCipherSuites

      public MariaDbJdbc enabledSslCipherSuites(String ciphers)
      Force TLS/SSL cipher (comma separated list).

      Example : "TLS_DHE_RSA_WITH_AES_256_GCM_SHA384, TLS_DHE_DSS_WITH_AES_256_GCM_SHA384"

      Default: use JRE ciphers.

      Parameters:
      ciphers - ciphers
      Returns:
      builder instance

    • keyStoreType

      public MariaDbJdbc keyStoreType(String type)
      Indicate key store type (JKS/PKCS12). default is null, then using java default type.
      Parameters:
      type - type
      Returns:
      builder instance

    • maxQuerySizeToLog

      public MariaDbJdbc maxQuerySizeToLog(int maxQuerySizeToLog)
      Only the first characters corresponding to this options size will be displayed in logs Default: 1024.
      Parameters:
      maxQuerySizeToLog - size
      Returns:
      builder instance

    • allowMultiQueries

      public MariaDbJdbc allowMultiQueries(boolean state)
      Allow multi-queries like insert into ab (i) values (1); insert into ab (i) values
      Parameters:
      state - state. Default: false
      Returns:
      builder instance

    • allowMultiQueries

      public MariaDbJdbc allowMultiQueries()
      Allow multi-queries like insert into ab (i) values (1); insert into ab (i) values
      Returns:
      builder instance

    • dumpQueriesOnException

      public MariaDbJdbc dumpQueriesOnException(boolean state)
      If set to 'true', an exception is thrown during query execution containing a query string.
      Parameters:
      state - state. Default: false
      Returns:
      builder instance

    • addParameter

      public <V> MariaDbJdbc addParameter(String key, V value)
      Add a new parameter to the url
      Overrides:
      addParameter in class JdbcConfig<MariaDbJdbc>
      Type Parameters:
      V - value type
      Parameters:
      key - key
      value - value
      Returns:
      builder instance
      See Also:

    • defaultDriverClass

      protected String defaultDriverClass()
      Description copied from class: JdbcConfig
      Returns the full path of the driver class
      Specified by:
      defaultDriverClass in class JdbcConfig<MariaDbJdbc>
      Returns:
      driver class