JDBC form for setting the connection URL

The Connection URL is important information for generating persistable code and setting file to interactive with database in DB Visual Architect (DB-VA). The Connection URL contains many different kind of information for connect with database such as hostname, port number, database name, service name etc…. On the other hand, different database may have different Connection URL format then user will type wrong format easily. The DB-VA provide the Connection URL Form for each database, user can follow the field to type in information therefore it can reduce the format and typo error.

The following is an example to show you that how to use the Connection URL form and Single Connection URL field to configure the MySQL database in DB-VA.

1. Create a new project call ConfigConnectionURL.
   
   
   
2. Select Tools → Object-Relational Mapping(ORM) → Database Configuration… on menu bar.
   
   
   
3. Select Java Language and MySQL database as default.
   
   
   The Driver file maybe empty when you select MySQL database. You can click the … button to select the JDBC driver or click to download the MySQL driver by DB-VA.
   For more detail : Configuring Database
   
   
4. Enter the Connection URL information.
   
   1. Select the Connection URL Form. Enter the hostname, port number and database name. When you type information in the form, the single Connection URL field will update by Connection URL information at the same time.
      
      
      
   2. Select the single Connection URL field. You can enter the Connection URL information according to the Connection URL format String (jdbc:mysql://<host_name>:<port_number>/<database_name>). It also will synchronize the information in the Connection URL form immediately.
      
      
      
      • Different database may have different format Connection URL. For example HSQL(In-process) driver only require the database file name. When you select HSQL (In-process) driver, the DB-VA update the Connection URL form, and then you can enter the request information for the database.
        
        
        
5. Finish to type in the Connection URL information, you can press the Test Connection button. It will report your information success or not to connect your selected database but you must notify you have been selected the driver file and enter the correct information for database.
   
   
   
6. You also can select the other language (.NET and PHP); they also provide the form to enter the connection database information.
   
   • For .NET(Connection string):
     
     
     
   • For PHP(DNS):
     
     
     
7. After you configure the database, you can export the schema or generate the persistable code and setting for your selected default database.