Subject | Help in setLoginTimeout |
---|---|
Author | Francisco Antonio Vieira Souza |
Post date | 2004-10-05T12:16:33Z |
I am having problems with setLoginTimeout in my connection pool,
sundelly the system starts giving me the exception:
Could not obtain connection during blocking timeout (20000 ms)
What should I do??
public static void setConnectionPool() ///throws Exception
{
try
{
String maquina = getCaminhoServidor();
String user = TG.usuario;
String pwd = TG.senha;
String dir_db = "C:\\Kooky\\SiGet\\dados\\SIGET.FDB";
String url =
"jdbc:firebirdsql:"+maquina+"/3050:"+dir_db+"?lc_ctype=ISO8859_1";
System.setProperty("FBLog4j", "true");
ds = new org.firebirdsql.pool.FBWrappingDataSource();
ds.setDescription("Conexao SiGet");
ds.setType("type4");
ds.setSqlRole("USER");
ds.setEncoding("ISO8859_1");
ds.setUserName(user);
ds.setPassword(pwd);
ds.setLoginTimeout(20);
ds.setMaxConnections(150);
ds.setMinConnections(5);
ds.setNonStandardProperty("isc_dpb_sql_dialect","3");
ds.setDatabase(maquina+"/3050:"+dir_db);
/* para gravar em arquivo tudo que ocorrer de erros no JDBC */
FileOutputStream fos = new
FileOutputStream("dados\\jdbclog.txt",true);
PrintWriter ps = new PrintWriter(fos);
DriverManager.setLogWriter(ps);
}
catch(java.io.IOException jio)
{}
catch(java.lang.NoClassDefFoundError nc)
{
TG.Mess("Criando o Pool de Conexão",nc.getMessage());
}
catch(java.sql.SQLException se)
{
TG.Mess("Criando o Pool de Conexão",se.getMessage());
}
}
sundelly the system starts giving me the exception:
Could not obtain connection during blocking timeout (20000 ms)
What should I do??
public static void setConnectionPool() ///throws Exception
{
try
{
String maquina = getCaminhoServidor();
String user = TG.usuario;
String pwd = TG.senha;
String dir_db = "C:\\Kooky\\SiGet\\dados\\SIGET.FDB";
String url =
"jdbc:firebirdsql:"+maquina+"/3050:"+dir_db+"?lc_ctype=ISO8859_1";
System.setProperty("FBLog4j", "true");
ds = new org.firebirdsql.pool.FBWrappingDataSource();
ds.setDescription("Conexao SiGet");
ds.setType("type4");
ds.setSqlRole("USER");
ds.setEncoding("ISO8859_1");
ds.setUserName(user);
ds.setPassword(pwd);
ds.setLoginTimeout(20);
ds.setMaxConnections(150);
ds.setMinConnections(5);
ds.setNonStandardProperty("isc_dpb_sql_dialect","3");
ds.setDatabase(maquina+"/3050:"+dir_db);
/* para gravar em arquivo tudo que ocorrer de erros no JDBC */
FileOutputStream fos = new
FileOutputStream("dados\\jdbclog.txt",true);
PrintWriter ps = new PrintWriter(fos);
DriverManager.setLogWriter(ps);
}
catch(java.io.IOException jio)
{}
catch(java.lang.NoClassDefFoundError nc)
{
TG.Mess("Criando o Pool de Conexão",nc.getMessage());
}
catch(java.sql.SQLException se)
{
TG.Mess("Criando o Pool de Conexão",se.getMessage());
}
}