Connection URL Used with JDBC Driver Manager Example

Here's an example of how to connect using a connection URL with JDBC Driver Manager. Replace sample values with the values available under Your Configuration on the SuiteAnalytics Connect Driver Download page. For more information, see Connect Driver Download Page section.

          import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionTest
{
   public static void main(String[] args) throws Exception
   {
      Connection connection = null;
      try
      {
         Class.forName("com.netsuite.jdbc.openaccess.OpenAccessDriver");
         String connectionURL =
                  "jdbc:ns://<ServiceHost>:1708;" +
                  "ServerDataSource=NetSuite.com;" +
                  "Encrypted=1;" +
                  "NegotiateSSLClose=false;" +
                  "CustomProperties=(AccountID=<accountID>;RoleID=<roleID>)";
         connection = DriverManager.getConnection(connectionURL, "User", "Password");
         System.out.println("Connection success");
      }
      finally
      {
         if (connection != null)
               connection.close();
      }
   }
} 

        

General Notices