Class MariaDbPoolDataSource

  • All Implemented Interfaces:
    java.io.Closeable, java.lang.AutoCloseable, java.sql.Wrapper, javax.sql.CommonDataSource, javax.sql.ConnectionPoolDataSource, javax.sql.DataSource, javax.sql.XADataSource

    public class MariaDbPoolDataSource
    extends java.lang.Object
    implements javax.sql.DataSource, javax.sql.ConnectionPoolDataSource, javax.sql.XADataSource, java.io.Closeable, java.lang.AutoCloseable
    MariaDB pool datasource. This use mariadb internal pool.
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void close()
      Close datasource.
      private void config()  
      java.sql.Connection getConnection()
      Attempts to establish a connection with the data source that this DataSource object represents.
      java.sql.Connection getConnection​(java.lang.String username, java.lang.String password)
      Attempts to establish a connection with the data source that this DataSource object represents.
      int getLoginTimeout()
      Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
      java.io.PrintWriter getLogWriter()
      Implementation doesn't use logwriter
      java.util.logging.Logger getParentLogger()
      Not implemented
      javax.sql.PooledConnection getPooledConnection()  
      javax.sql.PooledConnection getPooledConnection​(java.lang.String username, java.lang.String password)  
      java.lang.String getPoolName()
      get pool name
      java.lang.String getUrl()
      Returns the URL for this datasource
      java.lang.String getUser()
      return user
      javax.sql.XAConnection getXAConnection()  
      javax.sql.XAConnection getXAConnection​(java.lang.String username, java.lang.String password)  
      boolean isWrapperFor​(java.lang.Class<?> iface)
      Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
      void setLoginTimeout​(int seconds)
      Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
      void setLogWriter​(java.io.PrintWriter out)
      Implementation doesn't use logwriter
      void setPassword​(java.lang.String password)
      set password
      void setUrl​(java.lang.String url)
      Sets the URL for this datasource
      void setUser​(java.lang.String user)
      Set user
      java.util.List<java.lang.Long> testGetConnectionIdleThreadIds()
      Get current idle threads.
      <T> T unwrap​(java.lang.Class<T> iface)
      Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Field Detail

      • pool

        private Pool pool
      • url

        private java.lang.String url
      • user

        private java.lang.String user
      • password

        private java.lang.String password
      • loginTimeout

        private java.lang.Integer loginTimeout
    • Constructor Detail

      • MariaDbPoolDataSource

        public MariaDbPoolDataSource()
        Constructor
      • MariaDbPoolDataSource

        public MariaDbPoolDataSource​(java.lang.String url)
                              throws java.sql.SQLException
        Constructor with url
        Parameters:
        url - connection string
        Throws:
        java.sql.SQLException - if configuration fails
    • Method Detail

      • config

        private void config()
                     throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • getConnection

        public java.sql.Connection getConnection()
                                          throws java.sql.SQLException
        Attempts to establish a connection with the data source that this DataSource object represents.
        Specified by:
        getConnection in interface javax.sql.DataSource
        Returns:
        a connection to the data source
        Throws:
        java.sql.SQLException - if a database access error occurs
        java.sql.SQLTimeoutException - when the driver has determined that the timeout value specified by the setLoginTimeout method has been exceeded and has at least tried to cancel the current database connection attempt
      • getConnection

        public java.sql.Connection getConnection​(java.lang.String username,
                                                 java.lang.String password)
                                          throws java.sql.SQLException
        Attempts to establish a connection with the data source that this DataSource object represents.
        Specified by:
        getConnection in interface javax.sql.DataSource
        Parameters:
        username - the database user on whose behalf the connection is being made
        password - the user's password
        Returns:
        a connection to the data source
        Throws:
        java.sql.SQLException - if a database access error occurs
        java.sql.SQLTimeoutException - when the driver has determined that the timeout value specified by the setLoginTimeout method has been exceeded and has at least tried to cancel the current database connection attempt
      • unwrap

        public <T> T unwrap​(java.lang.Class<T> iface)
                     throws java.sql.SQLException
        Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

        If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise, return the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.

        Specified by:
        unwrap in interface java.sql.Wrapper
        Parameters:
        iface - A Class defining an interface that the result must implement.
        Returns:
        an object that implements the interface. Maybe a proxy for the actual implementing object.
        Throws:
        java.sql.SQLException - If no object found that implements the interface
      • isWrapperFor

        public boolean isWrapperFor​(java.lang.Class<?> iface)
        Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.
        Specified by:
        isWrapperFor in interface java.sql.Wrapper
        Parameters:
        iface - a Class defining an interface.
        Returns:
        true if this implements the interface or directly or indirectly wraps an object that does.
      • getLogWriter

        public java.io.PrintWriter getLogWriter()
        Implementation doesn't use logwriter
        Specified by:
        getLogWriter in interface javax.sql.CommonDataSource
        Returns:
        the log writer for this data source or null if logging is disabled
        See Also:
        setLogWriter(java.io.PrintWriter)
      • setLogWriter

        public void setLogWriter​(java.io.PrintWriter out)
        Implementation doesn't use logwriter
        Specified by:
        setLogWriter in interface javax.sql.CommonDataSource
        Parameters:
        out - the new log writer; to disable logging, set to null
        See Also:
        getLogWriter()
      • getLoginTimeout

        public int getLoginTimeout()
        Gets the maximum time in seconds that this data source can wait while attempting to connect to a database. A value of zero means that the timeout is the default system timeout if there is one; otherwise, it means that there is no timeout. When a DataSource object is created, the login timeout is initially to 30s.
        Specified by:
        getLoginTimeout in interface javax.sql.CommonDataSource
        Returns:
        the data source login time limit
        See Also:
        setLoginTimeout(int)
      • setLoginTimeout

        public void setLoginTimeout​(int seconds)
                             throws java.sql.SQLException
        Sets the maximum time in seconds that this data source will wait while attempting to connect to a database. A value of zero specifies that the timeout is the default system timeout if there is one; otherwise, it specifies that there is no timeout. When a DataSource object is created, the login timeout is initially 30s.
        Specified by:
        setLoginTimeout in interface javax.sql.CommonDataSource
        Parameters:
        seconds - the data source login time limit
        Throws:
        java.sql.SQLException - if wrong configuration set
        See Also:
        getLoginTimeout()
      • getParentLogger

        public java.util.logging.Logger getParentLogger()
        Not implemented
        Specified by:
        getParentLogger in interface javax.sql.CommonDataSource
        Returns:
        the parent Logger for this data source
      • getPooledConnection

        public javax.sql.PooledConnection getPooledConnection()
                                                       throws java.sql.SQLException
        Specified by:
        getPooledConnection in interface javax.sql.ConnectionPoolDataSource
        Throws:
        java.sql.SQLException
      • getPooledConnection

        public javax.sql.PooledConnection getPooledConnection​(java.lang.String username,
                                                              java.lang.String password)
                                                       throws java.sql.SQLException
        Specified by:
        getPooledConnection in interface javax.sql.ConnectionPoolDataSource
        Throws:
        java.sql.SQLException
      • getXAConnection

        public javax.sql.XAConnection getXAConnection()
                                               throws java.sql.SQLException
        Specified by:
        getXAConnection in interface javax.sql.XADataSource
        Throws:
        java.sql.SQLException
      • getXAConnection

        public javax.sql.XAConnection getXAConnection​(java.lang.String username,
                                                      java.lang.String password)
                                               throws java.sql.SQLException
        Specified by:
        getXAConnection in interface javax.sql.XADataSource
        Throws:
        java.sql.SQLException
      • getUrl

        public java.lang.String getUrl()
        Returns the URL for this datasource
        Returns:
        the URL for this datasource
      • setUrl

        public void setUrl​(java.lang.String url)
                    throws java.sql.SQLException
        Sets the URL for this datasource
        Parameters:
        url - connection string
        Throws:
        java.sql.SQLException - if url is not accepted
      • getUser

        public java.lang.String getUser()
        return user
        Returns:
        user
      • setUser

        public void setUser​(java.lang.String user)
                     throws java.sql.SQLException
        Set user
        Parameters:
        user - user
        Throws:
        java.sql.SQLException - if configuration fails
      • setPassword

        public void setPassword​(java.lang.String password)
                         throws java.sql.SQLException
        set password
        Parameters:
        password - password
        Throws:
        java.sql.SQLException - if configuration fails
      • close

        public void close()
        Close datasource.
        Specified by:
        close in interface java.lang.AutoCloseable
        Specified by:
        close in interface java.io.Closeable
      • getPoolName

        public java.lang.String getPoolName()
        get pool name
        Returns:
        pool name
      • testGetConnectionIdleThreadIds

        public java.util.List<java.lang.Long> testGetConnectionIdleThreadIds()
        Get current idle threads. !! For testing purpose only !!
        Returns:
        current thread id's