Java Code Examples for java.sql.DriverManager#setLoginTimeout()

private void preferencesHaveChanged(PropertyChangeEvent evt)
{
	final String propName = evt != null ? evt.getPropertyName() : null;

	if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.SHOW_TOOLTIPS))
	{
		ToolTipManager.sharedInstance().setEnabled(_prefs.getShowToolTips());
	}

	if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.JDBC_DEBUG_TYPE))
	{
		setupJDBCLogging();
	}

	if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.LOGIN_TIMEOUT))
	{
		DriverManager.setLoginTimeout(_prefs.getLoginTimeout());
	}

	if (propName == null || propName == SquirrelPreferences.IPropertyNames.PROXY)
	{
		new ProxyHandler().apply(_prefs.getProxySettings());
	}
}
 

/**
 * Test for connect timeout specified through connection property (in the url)
 */
@Test
public void connectTimeoutFromProperty() {
    // Reset DriverManager timeout
    DriverManager.setLoginTimeout(0);
    long startTime = System.currentTimeMillis();
    try {
        DriverManager.getConnection(buildTestURL() + "?connectTimeout=1&encoding=NONE", "sysdba", "masterkey");
        fail("Expected connection to fail");
    } catch (SQLException e) {
        long endTime = System.currentTimeMillis();
        long difference = endTime - startTime;
        assertEquals("Expected error code for \"Unable to complete network request\"", 335544721, e.getErrorCode());
        assertEquals("Unexpected timeout duration (in ms)", 1000, difference, TIMEOUT_DELTA_MS);
    }
}
 

/**
 * Test for connect timeout specified through {@link java.sql.DriverManager#setLoginTimeout(int)}
 */
@Test
public void connectTimeoutFromDriverManager() {
    // Timeout set through DriverManager
    DriverManager.setLoginTimeout(2);
    long startTime = System.currentTimeMillis();
    try {
        DriverManager.getConnection(buildTestURL() + "?encoding=NONE", "sysdba", "masterkey");
        fail("Expected connection to fail");
    } catch (SQLException e) {
        long endTime = System.currentTimeMillis();
        long difference = endTime - startTime;
        assertEquals("Expected error code for \"Unable to complete network request\"", 335544721, e.getErrorCode());
        assertEquals("Unexpected timeout duration (in ms)", 2000, difference, TIMEOUT_DELTA_MS);
    } finally {
        // Reset to default
        DriverManager.setLoginTimeout(0);
    }
}
 

/**
 * DERBY-2026 make sure loginTimeout does not
 * affect queries
 * @throws SQLException
 */
public void clientTestDerby2026LoginTimeout() throws SQLException  {
    String url = "jdbc:splice://" + TestConfiguration.getCurrent().getHostName() +":" +
            TestConfiguration.getCurrent().getPort() + "/" + TestConfiguration.getCurrent().getDefaultDatabaseName();
    try {
        DriverManager.setLoginTimeout(10);
        //System.out.println(url);
        try {
            Class.forName("org.apache.derby.jdbc.ClientDriver");
        } catch (ClassNotFoundException e) {
            fail(e.getMessage());
        }
        Connection conn = DriverManager.getConnection(url);
        TestRoutines.installRoutines(conn);
        CallableStatement cs = conn.prepareCall("CALL TESTROUTINE.SLEEP(20000)");
        cs.execute();
        //rollback to make sure our connection is ok.
        conn.rollback();
    } finally {
        DriverManager.setLoginTimeout(0);
    }
}
 

/**
 * Test if a normal connection will work when the timeout is specified in the connection properties.
 */
@Test
public void normalConnectionWithTimeoutFromProperty() throws Exception {
    // Reset DriverManager timeout
    DriverManager.setLoginTimeout(0);
    FBManager fbManager = createFBManager();
    defaultDatabaseSetUp(fbManager);
    try {
        Properties properties = FBTestProperties.getDefaultPropertiesForConnection();
        properties.setProperty("connectTimeout", "1");
        Connection connection = DriverManager.getConnection(FBTestProperties.getUrl(), properties);
        connection.close();
    } finally {
        defaultDatabaseTearDown(fbManager);
    }
}
 

public DataSourcePoolFactory(){
	registeredDrivers 		= new HashSet<String>();
	longTermPoolFactory		= new LongTermPoolFactory();
	shortTermPoolFactory	= new ShortTermPoolFactory();
	
	DriverManager.setLoginTimeout(30);
}
 

/**
 * Validate that values set using setLoginTimeout will be returned by
 * getLoginTimeout
 */
@Test
public void test() {
    int[] vals = {-1, 0, 5};
    for (int val : vals) {
        DriverManager.setLoginTimeout(val);
        assertEquals(val, DriverManager.getLoginTimeout());
    }
}
 

public static String testConnection(DBInstanceInfo dbinfo, 
			String username, 
			String password)
{
  String url = dbinfo.getConnectionString();
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	try
	{
	  logger.info("Test connection to ("+dbinfo+"): "+url);
	  DriverManager.setLoginTimeout(60);
	  conn = DriverManager.getConnection(url, username, password);
	  if(conn!=null)
	  {
	    dbinfo.setConnectionVerified(true);
		logger.info("Connection test succeeded to ("+dbinfo+")");
	    return null;
    }
	else
    {
		logger.log(Level.SEVERE,"Connection test failed: reason null.");
	    return "Connection test failed: reason null.";    	  
    }
	  
	}catch(Exception ex)
	{
	    logger.log(Level.SEVERE,"Exception", ex);
        return "Connection test to "+ url+" failed: "+ex.getMessage();
	}finally
	{
		DBUtils.close(rs);
		DBUtils.close(stmt);
		DBUtils.close(conn);
	}
  }
 

/**
 * Validate that values set using setLoginTimeout will be returned by
 * getLoginTimeout
 */
@Test
public void test() {
    int[] vals = {-1, 0, 5};
    for (int val : vals) {
        DriverManager.setLoginTimeout(val);
        assertEquals(val, DriverManager.getLoginTimeout());
    }
}
 

/**
 * Validate that values set using setLoginTimeout will be returned by
 * getLoginTimeout
 */
@Test
public void test() {
    int[] vals = {-1, 0, 5};
    for (int val : vals) {
        DriverManager.setLoginTimeout(val);
        assertEquals(val, DriverManager.getLoginTimeout());
    }
}
 

/**
  * All the top level beans, sql manager, connection manage, db manager, etc, will be initialized here.
  */
 public void afterPropertiesSet() throws Exception 
 {
   configureLogging();
Logger logger = Logger.getLogger(this.getClass().getName());		
logger.info("Setup afterPropertiesSet.");

logger.info("Loading JDBC Drivers");
if(this.jdbcDriver!=null)
{
   DriverManager.setLoginTimeout(60);
   logger.info("Set JDBC DriverManager loginTimeout as 60 seconds");
   for(Map.Entry<String, String> e: jdbcDriver.entrySet())
   {
	  logger.info("Loading "+e.getKey()+": "+e.getValue());
	  try
	  {
	    Class.forName(e.getValue());	  
		logger.info("Loaded "+e.getKey()+": "+e.getValue());
	  }catch(Throwable ex)
	  {
	    logger.info("Failed to Load "+e.getKey()+": "+e.getValue());			  
	  }
   }
}

alertRootPath = new File(new File(this.fileReposirtoryPath), "alerts");
alertRootPath.mkdirs();

this.sqlManager.setSqlPath(sqlPath);
this.sqlManager.init();

this.metricsDef.init();
logger.info("Refreshing metrics list ...");
refreshMetricsList();
logger.info("Retrieved metrics list: " + this.metricsList.size());

this.metaDb.setDbkey(this.configRepKey);
this.metaDb.init();

this.dbInfoManager.setMetaDb(metaDb);//since we store db info now in metricsdb, 
        //it can only be initialized after metricsDB initialized 

this.userManager.setMetaDb(metaDb);
this.auth.setContext(this);	
this.queryEngine.setSqlManager(this.sqlManager);
this.queryEngine.setFrameworkContext(this);
   this.statDefManager.init();
   
logger.info("Initialize AutoScanner ...");
this.myperfConfig.init(this);
this.snmpSettings.init(this);
if(this.myperfConfig.isConfigured())
{
  this.initMetricsDB(); //move metrics db creation and initialization away from scanner
     this.alertSettings.setContext(this);
  if(this.metricDb != null)
  {
    this.dbInfoManager.init(this.metricDb);//need metricsDB to update
	this.metricsDef.getUdmManager().loadSubscriptions(this);
   	this.metricDb.loadAlertSetting(this.alertSettings);//load alert setting after DB info is loaded.
  }
}
   this.instanceStatesManager.init(this);
this.hipchat.init(this);

autoScanner = new AutoScanner(this);
autoScanner.init();//it will update metricsDB
if(autoScanner.isInitialized())
{
  logger.info("Starting AutoScanner ...");
  autoScanner.start();
   }

logger.info("Done setup afterPropertiesSet.");
 }
 

@Override
public void setLoginTimeout(int seconds) {
  DriverManager.setLoginTimeout(seconds);
}
 

public Connection createConnection(String user, String password) throws Exception{
  String url = getURL();
  DriverManager.setLoginTimeout(0);
  Connection connection =  DriverManager.getConnection(url, user, password);
  return connection;
}
 

@Override
protected Connection getConnection(String driver, String url, Properties prop) throws ClassNotFoundException, SQLException {
	Class.forName(driver);
	DriverManager.setLoginTimeout(1);
	return DriverManager.getConnection(url, prop);
}
 

@Override
public void setLoginTimeout(int loginTimeout) throws SQLException {
  DriverManager.setLoginTimeout(loginTimeout);
}
 

@Override
public void setLoginTimeout(int loginTimeout) throws SQLException {
  DriverManager.setLoginTimeout(loginTimeout);
}
 

public void setLoginTimeout(int loginTimeout) throws SQLException {
	DriverManager.setLoginTimeout(loginTimeout);
}
 

@Override
public void setLoginTimeout(int seconds) throws SQLException {
    DriverManager.setLoginTimeout(seconds);
}
 

public void setLoginTimeout(int timeout)
{
    DriverManager.setLoginTimeout(timeout);
}
 

@Override
public void setLoginTimeout(int seconds) {
  DriverManager.setLoginTimeout(seconds);
}