SSHUser: Set this to the username that you use to authenticate with the SSH server.įor assistance in constructing the JDBC URL, use the connection string designer built into the SingleStore JDBC Driver.SSHServerFingerPrint: The SSH Server fingerprint used for verification of the host you are connecting to.SSHServer: The SSH authentication server you are trying to authenticate against.SSHPort: The port used for SSH operations.SSHPassword: The password that you use to authenticate with the SSH server.SSHClientCertType: The certificate type of the client store.Used to locate the certificate in the store. SSHClientCertSubject: The subject of the TLS/SSL client certificate.SSHClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.SSHClientCert: Set this to the name of the certificate store for the client certificate.To access SingleStore data via SSH, configure the following connection properties: Using SSH, you can securely login to a remote machine. SSLServerCert: The certificate to be accepted from the server.SSLClientCertType: The certificate type of the client store. SSLClientCertSubject: The subject of the TLS/SSL client certificate.SSLClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.Used in the case of 2-way SSL, where truststore and keystore are kept on both the client and server machines. SSLClientCert: Set this to the name of the certificate store for the client certificate.Configure the following connection properties to connect to data: You can leverage SSL authentication to connect to SingleStore data via a secure session. Password: The password which will be used to authenticate with the SingleStore server.Īs an alternative to providing the standard username and password, you can set IntegratedSecurity to True to authenticate trusted users to the server via Windows Authentication.User: The user which will be used to authenticate with the SingleStore server.To authenticate using standard authentication, set the following: If this is not set, tables from all databases will be returned. Database (Optional): The default database to connect to when connecting to the SingleStore Server.Port: The port of the server hosting the SingleStore database.Server: The host name or IP of the server hosting the SingleStore database.The following connection properties are required in order to connect to data. Driver class: Ĭonnection URL: A JDBC URL, starting with jdbc:singlestore: and followed by a semicolon-separated list of connection properties.Select src as the parent folder and click Next.Right-click on the new project and select New -> Hibernate -> Hibernate Configuration File (cfg.xml).Click Add External JARs to add the library, located in the lib subfolder of the installation directory.įollow the steps below to configure connection properties to SingleStore data.Click Java Build Path and then open the Libraries tab. Right-click the project and click Properties.Select Java Project as your project type and click Next. In Eclipse, navigate to Help -> Install New Software.įollow the steps below to add the driver JARs in a new project.In the Knowledge Base you will find tutorials to connect to SingleStore data from IntelliJ IDEA and NetBeans.įollow the steps below to install the Hibernate plug-in in Eclipse. Product that supports the Java Runtime Environment. Though Eclipse is the IDE of choice for this article, the CData JDBC Driver for SingleStore works in any The tutorial below shows how to use the CData JDBC Driver for SingleStore to generate an ORM of your SingleStore repository with Hibernate. You can use Hibernate to map object-oriented domain models to a traditional relational database.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |