Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
v4.0
Search
    中文EN
    v4.0

      Server Connection (Old Version)

      1. Ultipa Database Address

      Multiple addresses of the servers of a cluster should be separated with comma ',' before being configured as the Ultipa Database Address.

      2. Account and Password

      Default account and password of the Ultipa Database are both 'root'

      3. Configuration

      Configuration class UltipaConfiguration suports settings such as connetion timeout, consistency level, etc. In the case of ssl connetection type, crtFile and overrideAuthority should be set.

      Item Range Description
      username \ The account username
      password \ The account password
      url \ The server address, either the address of a stand-alone server, or multiple addresses of all servers of a cluster separated with comma ','
      timeout >0 The connection timeout
      consistency true, false The consistency level
      type ssl, insecure The connection type
      crtFile \ File path of CA certificate, required when connType is 'ssl'
      overrideAuthority ultipa Over-ride the 'hostname' to match the cert the server uses

      4. Instantiation of UltipaClientDriver

        UltipaConfiguration configuration = UltipaConfiguration.config()
                      .username("root")
                      .password("root")
                      .url("192.168.1.1:60061");
      
        UltipaClientDriver driver = new UltipaClientDriver(configuration);
        Connection client = new DefaultConnection(driver, "default");
        String reply = client.sayHello("Ultipa");
        System.out.println(reply);
      

      5. Configuration File

      The Ultipa Server can also be connected via a configuration file named 'ultipa.properties', which will be read automatically when creating UltipaClientDriver and thus no need for UltipaConfiguration.

      Create file 'ultipa.properties' under classpath of the database project, and fill below configurations:

      ultipa.grpc.pool.conn.username=root
      ultipa.grpc.pool.conn.password=root
      ultipa.grpc.pool.conn.url=192.168.1.1:60061,192.168.1.2:60061,192.168.1.3:60061
      ultipa.grpc.pool.conn.query.timeout=15
      ultipa.grpc.pool.conn.consistency=false
      ultipa.grpc.pool.conn.type=insecure
      ultipa.grpc.pool.conn.crtFile=F:\\ultipa.crt
      ultipa.grpc.pool.conn.overrideAuthority=ultipa
      

      Instantiate the UltipaClientDriver with configuration file:

      UltipaClientDriver driver = new UltipaClientDriver();
      Connection client = new DefaultConnection(driver);
      String reply = client.sayHello("Ultipa");
      System.out.println(reply);
      

      6. Connection Pool

      UltipaClientDriver uses Apache Common-Pool, and below connection pool information need to be configured when creating UltipaClientDriver:

      UltipaConfiguration configuration = UltipaConfiguration.config()
              .username("root")
              .password("root")
              .hosts("192.168.1.1:60061");
      GenericObjectPoolConfig<ManagedChannel> poolConfig
              = new GenericObjectPoolConfig<ManagedChannel>();
      poolConfig.setMaxIdle(50);
      poolConfig.setMinIdle(2);
      poolConfig.setMaxTotal(200);
      poolConfig.setMaxWaitMillis(-1);
      UltipaClientDriver driver = new UltipaClientDriver(configuration, poolConfig);
      Connection client = new DefaultConnection(driver, "default");
      String reply = client.sayHello("Ultipa");
      System.out.println(reply);
      

      The above configuration can also be included in the configuration file 'ultipa.properties' alternatively:

      # Maximum number of idle connections
      ultipa.grpc.pool.conn.maxIdle=50
      # Minimum number of idle connections
      ultipa.grpc.pool.conn.minIdle=20
      # Maximum number of total connections
      ultipa.grpc.pool.conn.maxTotal=2000
      # Minimum idle time of an evictable connection, defalut is 1800000 ms (30 min)
      ultipa.grpc.pool.conn.minEvictableIdleTimeMillis=1800000
      # Test interval for evictable connections (ms), default is -1 (do not scan)
      ultipa.grpc.pool.conn.timeBetweenEvictionRunsMillis=3600000
      # Test connections when borrow, default is fasle
      ultipa.grpc.pool.conn.testOnBorrow=true
      # Test connections when return, default is fasle
      ultipa.grpc.pool.conn.testOnReturn=false
      # Test connections when idle, default is fasle
      ultipa.grpc.pool.conn.testWhileIdle=false
      # Maximum wait time, default is -1 (infinite wait)
      ultipa.grpc.pool.conn.maxWaitMillis=-1
      # Last in first out, default is true
      ultipa.grpc.pool.conn.lifo=true
      # Block new request when connections are exhausted, default is true (block until timeout), false will popup error
      ultipa.grpc.pool.conn.blockWhenExhausted=true
      # Number of connections to test each time, default is 3
      ultipa.grpc.pool.conn.numTestsPerEvictionRun=3
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写