Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 10 months ago. Active 4 years, 10 months ago. Viewed 30k times. Now, in my IntelliJ project I followed this tutorial to add database connection, and my properties look like this: My mysql driver version is 5. Even when I add Class. It only works when I add manually jar to this driver in my libraries and artifacts: Is it really the only way?
Improve this question. Community Bot 1 1 1 silver badge. Mohru Mohru 1 1 gold badge 5 5 silver badges 15 15 bronze badges. I don't think this is a duplicate.
Firstly, I use different environment where configuration is slightly different. Secondly, I knew the solution proposed in that question, and asked if there was any other way to accomplish that. Optionally, Database can be set to connect to a specific database. If not set, tables from all databases will be returned. Either double-click the JAR file or execute the jar file from the command-line.
To discover schema information, right-click the data source you just created and click Refresh Tables. To query a table, right-click it and then click Open Tables Editor.
You can also modify records in the Table Editor. CData Software is a leading provider of data access and connectivity solutions. Load Sources Load source code of database objects for the selected category of schemas. Switch between recently-used items. Item Description Name Use this field to edit the name of the data source. Device Specify where the target database is located. Package name Specify the name of the application package the target database is associated with. Storage Select: Internal if the database is stored in the internal memory of the device or the emulator.
Database If the database is stored in the internal memory, specify the database name. Download If the necessary SQLite driver files are missing, you can download them by clicking the Download link in the lower part of the dialog.
Item Description Connection type A connection type that you want to use for the database connection. Driver The driver from the Drivers list that you want to use for the connection. File The path to the database file.
Path The path to the database file or folder. Host The hostname domain name or the IP address of the computer where the database is located. Port The database port number. Database The name of the target database or schema. User The name of your database user account. Password The password for the database user. Save Save settings for the password field.
You can select the following options for storing your password: Never : password is prompted each time you establish a connection with a database. Create database Adds an argument to the URL to create a database.
Item Description Read-only Set the read-only status. Transaction control Set the isolation level for database transactions and the mode of how the transactions are committed. Manual : switch schemas manually only. Disable : do not switch schemas. Single session mode Enable the single session mode. Run keep-alive query each N seconds Run a keep-alive query to keep the connection alive.
Auto-disconnect after N seconds Disconnect from the database after the specified number of seconds. Single database mode In the database tree view, show and enable only the database that you specified in the connection settings. Startup script Run an SQL query each time you establish a connection. Auto sync Synchronize the actual state of the database automatically.
If the Auto sync checkbox is selected, the view of the data source is automatically updated: When you click OK in the Data Sources and Drivers dialog. Load sources for Load source code of views, procedures, packages and other database objects for the selected category of schemas: all schemas All schemas , all schemas excluding system schemas All excl.
Use pre-introspected objects for system catalogs that are not introspected Toggles the usage of pre-introspected objects for system catalogs. External model data Defines a path to external-data. Code style Select a code style that you want to use for schemas.
Copy from Copy SSH settings from the existing data source. Click the link and select the corresponding data source. Client certificate file Specify the path to your client public key certificate file.
Client key file Specify the path to your client private key file. Item Description Refresh the list of the databases and schemas.
Expand all nodes in all trees. Collapse all nodes in all trees. Schema pattern Define a pattern to select the necessary databases and schemas. Object filter Limit the set of tables and other database objects that are shown in the Database tool window for each data source. Working directory The working directory for the process that handles working with data sources.
Item Description Name The data source name. Extend Optionally, you can select another data source as a parent in the Extend list. Item Description Class The fully qualified name of the driver class to be used. Item Description Transaction control Set the isolation level for database transactions and the mode of how the transactions are committed.
Startup script An SQL query that will run each time you establish a connection. Keep-alive query A keep-alive query that will run to keep the connection alive.
Auto sync The default setting for the auto sync option. Load sources for Load source code of database objects for the selected category of schemas. Dialect The SQL dialect associated with the corresponding data sources. This may require configuration changes.
Windows Firewall may block the communication. You may need to reconfigure or disable it. Check the driver version is compatible with the database software. Please inform us in this case. Further connectivity tips can be found on the MySql Connectivity Tips page.
0コメント