New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Connection pool deadlocks in multithreaded environment [JDBC219] #268
Comments
Modified by: Artem Farafonov (farafonoff)description: package pooltest; import java.sql.Connection; /**
} This code should print success 10 times, but does only three times. 0 [Thread-0] DEBUG org.firebirdsql.pool.AbstractFBConnectionPoolDataSource - Thread Thread-0 wants to take connection. => package pooltest; import java.sql.Connection; /**
} This code should print success 10 times, but does only three times. 0 [Thread-0] DEBUG org.firebirdsql.pool.AbstractFBConnectionPoolDataSource - Thread Thread-0 wants to take connection. |
Modified by: Artem Farafonov (farafonoff)Attachment: log.txt [ 12080 ] description: package pooltest; import java.sql.Connection; /**
} This code should print success 10 times, but does only three times. 0 [Thread-0] DEBUG org.firebirdsql.pool.AbstractFBConnectionPoolDataSource - Thread Thread-0 wants to take connection. => package pooltest; import java.sql.Connection; /**
} This code should print success 10 times, but does only three times. |
Commented by: @mrotteveel This is fixed in Jaybird 2.2 by the changes for JDBC93 (and related tickets). However, if you are using these datasource in an application server, I advise you to switch to the new ConnectionPoolDatasources in org.firebirdsql.ds which are added in Jaybird 2.2. If you use these datasources standalone in a normal Java program, you should be able to continue using them (with the fixes in Jaybird 2.2). However, as I am planning on removing the datasources that provide connection pooling in Jaybird 2.3, I advise you to then switch to a third-party implementation of datasources like C3P0, DBCP or BoneCP. Jaybird 2.2 has not yet been released, but if you are willing to test things, I can create a test build. |
Modified by: @mrotteveelassignee: Roman Rokytskyy [ rrokytskyy ] => Mark Rotteveel [ avalanche1979 ] status: Open [ 1 ] => Resolved [ 5 ] resolution: Duplicate [ 3 ] |
Modified by: @mrotteveel |
Modified by: @mrotteveelstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Artem Farafonov (farafonoff)
Duplicates JDBC93
Attachments:
log.txt
package pooltest;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.apache.log4j.BasicConfigurator;
import org.firebirdsql.jdbc.FBDataSource;
import org.firebirdsql.pool.FBConnectionPoolDataSource;
import org.firebirdsql.pool.FBWrappingDataSource;
/**
*
* @author Артём
*/
public class Main implements Runnable {
}
This code should print success 10 times, but does only three times.
The text was updated successfully, but these errors were encountered: