Blog

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows to the client. When I try to run one of the long running queries with default jdbc parameters, I inevitablyRead more

I use PostgreSQL 9.6.6 on CentOS Linux 7.4 and after upgrading the postgresql-jdbc package – # sudo yum update Failed to set locale, defaulting to C Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.fra10.de.leaseweb.net * epel: mirror.wiuwiu.de * extras: centosmirror.netcup.net * updates: mirror.wiuwiu.de Resolving Dependencies –> Running transaction check —> PackageRead more

Construi uma aplicação com Java Swing e sqlite, o projeto roda perfeitamente na IDE Netbeans, porém, quando vou limpar e construir, o JAR que não encontra o driver sqltie. Já fiz várias aplicações utilizando o MySql, e o mesmo não me trouxe nenhum problema. Já procurei em fóruns, mas sem resposta encontrada.Read more

We have a JDBC connection to some external DB, which can not be easily dumped and deployed somewhere on our side, since it is a secret; we just know that several our SQL requests sent via jdbc connection are working for it; now we need an integration test emulating the real connection to the externalRead more

Como posso fazer um metodo de reconexão com o MySQL? Pois a hospedagem que eu uso ele fecha a conexão depois de 10 segundos aberta. public void mysqlSetup() { host = configmmysql.getConfig().getString(“host”); port = configmmysql.getConfig().getInt(“port”); database = configmmysql.getConfig().getString(“database”); username = configmmysql.getConfig().getString(“username”); password = configmmysql.getConfig().getString(“password”); table = configmmysql.getConfig().getString(“table”); try { synchronized (this) { if (getConnection() !=Read more

Hy, i am using a MSSQL Server 2016 from my java application via JDBC with transaction isolation level READ_COMMITED and with AUTOCOMMIT = false. I need to lock some rows of a table from differnet threads/connections and get different results when using a PreparedStatemtn vs. using a Statement. With the Statement everything is shiny, butRead more

So i’ve been working with postgre databases and I noticed that it throws an error sometimes when I try to read a csv file and copy to a table remotely. It works perfectly when I use a buffered reader but i’m trying to see if there’s a way i can get i to work usingRead more