Difference between revisions of "Documentation/DevGuide/Database/Connecting Using the DriverManager and a Database URL"

  Connection xConnection = DriverManager.getConnection(url);

  // create the DriverManager
  Object driverManager = xMultiServiceFactory.createInstance("com.sun.star.sdbc.DriverManager");
 
  // query for the interface XDriverManager
  com.sun.star.sdbc.XDriverManager xDriverManager;
 
  xDriverManager = (XDriverManager)UnoRuntime.queryInterface(
      XDriverManager.class, driverManager);
 
  if (xDriverManager != null) {
      // first create the database URL
      String adabasURL = "sdbc:adabas::MYDB0";
 
      // create the necessary sequence of PropertyValue structs for user and password
      com.sun.star.beans.PropertyValue [] adabasProps = new com.sun.star.beans.PropertyValue[] { 
          new com.sun.star.beans.PropertyValue("user", 0, "Scott",
              com.sun.star.beans.PropertyState.DIRECT_VALUE),
          new com.sun.star.beans.PropertyValue("password", 0, "huutsch",
              com.sun.star.beans.PropertyState.DIRECT_VALUE)
          };
 
      // now create a connection to Adabas
      XConnection xConnection = xDriverManager.getConnectionWithInfo(adabasURL, adabasProps);
 
      if (adabasConnection != null) {
          System.out.println("Connection was created!");
 
          // now we dispose the connection to close it
          XComponent xComponent = (XComponent)UnoRuntime.queryInterface(
              XComponent.class, xConnection );
 
          if (xComponent != null) {
              // connection must be disposed to avoid memory leaks
              xComponent.dispose();
              System.out.println("Connection disposed!");
          }
      } else {
          System.out.println("Connection could not be created!");
      }
  }