Creating a Connection

To connect to a Vertica database:

1. In your Java code, import the SQL package:

   import java.sql.*;

2. Load the Vertica driver:

   Class.forName("com.vertica.Driver")

3. Make the connection:

   Connection db = DriverManager.getConnection
("jdbc:vertica://<server>:5433/<instance>",<user>, "");

   Parameter	Description
   <server>	A Vertica node (default localhost)
   5433	5433
   <instance>	database instance name
   <user>	user (default is user who started Vertica)
   ""	empty password

Notes

• When you disconnect a user session, any transactions in progress are automatically rolled back.