Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-690

DataSourceExtensionPoint : Validation Query

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.4.2, 2.5
    • 2.4
    • None
    • None

      Validation query is limited for Oracle, we have to use the driver oracle.jdbc.driver.OracleDriver but it also exists the driver oracle.jdbc.OracleDriver.

      Is it possible to modify _getValidationQuery(driver) method like this or something else ?

      private String _getValidationQuery(String driver)
{
    if (driver.endsWith("OracleDriver"))
    {
        return "SELECT 1 FROM DUAL";
    }
    else if ("org.apache.derby.jdbc.EmbeddedDriver".equals(driver))
    {
        return "SELECT 1 FROM SYS.SYSTABLES";
    }
    else
    {
        return "SELECT 1";
    }
}

          [RUNTIME-690] DataSourceExtensionPoint : Validation Query

          Laurence Aumeunier made changes -
          Status Original: Resolved [ 5 ] New: Closed [ 6 ]
          Laurence Aumeunier made changes -
          Fix Version/s New: 2.5 [ 11401 ]
          Fix Version/s New: 2.4.2 [ 11689 ]
          Fix Version/s Original: 2.LATER [ 10140 ]
          Nicolas Gavalda (Inactive) made changes -
          Resolution New: Fixed [ 1 ]
          Status Original: Open [ 1 ] New: Resolved [ 5 ]
          Nicolas Gavalda (Inactive) made changes -
          Link New: This issue Duplique RUNTIME-844 [ RUNTIME-844 ]
          Cédric Damioli made changes -
          Fix Version/s New: 2.LATER [ 10140 ]
          Issue Type Original: Bug [ 1 ] New: Improvement [ 4 ]
          Priority Original: Major [ 3 ] New: Minor [ 4 ]
          Laurence Perier made changes -
          Description Original: Validation query is limited for Oracle, we have to use the driver oracle.jdbc.driver.OracleDriver but it also exists the driver oracle.jdbc.OracleDriver.

          Is it possible to modify _getValidationQuery(driver) method like this or something else ?

          [noformat]private String _getValidationQuery(String driver)
          {
              if (driver.endsWith("OracleDriver"))
              {
                  return "SELECT 1 FROM DUAL";
              }
              else if ("org.apache.derby.jdbc.EmbeddedDriver".equals(driver))
              {
                  return "SELECT 1 FROM SYS.SYSTABLES";
              }
              else
              {
                  return "SELECT 1";
              }
          }[/noformat]           		New: Validation query is limited for Oracle, we have to use the driver oracle.jdbc.driver.OracleDriver but it also exists the driver oracle.jdbc.OracleDriver.

          Is it possible to modify _getValidationQuery(driver) method like this or something else ?

          {noformat}
          private String _getValidationQuery(String driver)
          {
              if (driver.endsWith("OracleDriver"))
              {
                  return "SELECT 1 FROM DUAL";
              }
              else if ("org.apache.derby.jdbc.EmbeddedDriver".equals(driver))
              {
                  return "SELECT 1 FROM SYS.SYSTABLES";
              }
              else
              {
                  return "SELECT 1";
              }
          }
          {noformat}
          Bérénice Maurel created issue -

            Unassigned Unassigned
            bmaurel Bérénice Maurel
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: