Hi, I am having one query how to stop transaction i.e insert, update and delete if it's successfully on first database how do I stop it over there and it should not move to second database and following.
It is, though I don't work on it as often as I'd like. On Tue, Oct 8, 2019 at 4:17 AM Rogerio rogerthat@users.sourceforge.net wrote: Hi, is this project still alive? HA-JDBC Releases. https://sourceforge.net/p/ha-jdbc/discussion/383396/thread/2041e133/?limit=25#ad8c Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/ha-jdbc/discussion/383396/ To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Hi, is this project still alive?
Informix JDBC driver support
Hi, I am facing 'insufficient privileges' exception whenever I am accessing the database with the user 'eodb'. The query I am trying to run is given in the below exception message. But when I debugged the execution, while throwing the error it was trying to access the object 'apex_040000.wwv_flow_dual100'. Not sure why it is trying to access this object and how it is relevant for the below query. Otherwise the 'eodb' user has permissions to run the select query. Please explain. 2018-05-14 20:19:52.645...
Hi, I am using the version 3.0.0 of ha-jdbc in a Spring boot project (JDK1.8). And I wanted to configure Database cluster using the application.properties file and using the class 'DriverDatabaseClusterConfiguration'. Do I still need to provide the file ha-jdbc-default.xml? When I boot the application, it throws exception that the xml is not available. Please let me know, if any details is needed.
HA-JDBC invokes the load balancer for any JDBC method it expects to contact the database server in an immutable way. Sometimes this results in 2 calls to the load balancer for a given statement execution, sometimes more, e.g. calls to Connection.getAutoCommit() or prepareStatement(...) or getTransactionIsolation(). Sequential tests like this do nothing to test balancer behavior. Round-robin (or any balanacer logic) is pointless without concurrent activity. Perform the same test with multiple concurrent...
Hello, We would like to use the HA-JDBC software as a replacement for the multi - datasource feature that is available in Weblogic 12.2 (we used the load-balancing algorithm of the multi-datasource). When we tested using the round-robin balancer setting we observered that the HA-JDBC driver did not alternate between the 2 datasouces as we were expecting. It seemed to only send a request to the first datasource and once in awhile send a request to the second datasource. Is this how the round-robin...
Thank you so much for your reponse Paul!, I will give it a try!
This is the equivalent code in HA-JDBC 3.0: Dialect dialect = new OracleDialect(); DatabaseProperties database = new LazyDatabaseProperties(new SimpleDatabaseMetaDataProvider(metaData), dialect); TableProperties table = databaseProperties.findTable(tableName); Collection<UniqueConstraint> constraints = table.getUniqueConstraints(); Paul On Mon, Jul 31, 2017 at 7:14 PM "Héctor Cadavid" hectorcadavid@users.sf.net wrote: Dear friends, I'm trying to upgrande a 8-years legacy application that worked with...
Dear friends, I'm trying to upgrande a 8-years legacy application that worked with some HA-JDBC 2.0.x classes for database meta-data extraction. Unfortunately, such version is no longer available in the official Maven repository, and the new API have changed a lot!... I haven't found any documentation so I don't have any clue how to update the following code, intented to identify if a given column name, in a given table, is a unique key: DatabaseMetaDataSupport metaSup = new DatabaseMetaDataSupport(dbMetaData,new...
Dear friends, I'm trying to upgrande a 8-years legacy application that worked with some HA-JDBC 2.0.x classes for database meta-data extraction. Unfortunately, such version is no longer available in the official Mavenrepositories, and the API have changed considerably!... I haven't found any documentation so I don't have any clue how to update the following code, intented to identify if a given column name, in a given table, is a unique key: DatabaseMetaDataSupport metaSup = new DatabaseMetaDataSupport(dbMetaData,new...
Dear friends, I'm trying to upgrande a 8-years legacy application that worked with some HA-JDBC 2.0.x classes for meta-data extraction. Unfortunately, such version is no longer available in the official Mavenrepositories, and the API have changed considerably!... I haven't found any documentation so I don't have any clue how to update the following code, intented to identify if a given column name, in a given table, is a unique key: DatabaseMetaDataSupport metaSup = new DatabaseMetaDataSupport(dbMetaData,new...
Is there any new release updates for HA-JDBC. The last one was back in 07/2014 and...
Hi. I created cluster over 3 same hsqldb databases. <ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">...
I'm not sure how I got this error, but here it is: java.util.ConcurrentModificationException...
Am trying to synchronize my data base. Using the FullSynchronizationStrategy, (I've...
Is it possible to configure HA-JDBC in this way?: 1. route all SELECT (read-only)...
Hi, I'm using HA-JDBC with JPA EclipseLink and I've got this exception: java.sql.SQLException:...
Hi! I'm trying to deploy hajdbc on JBossAS EAP 6.3 with two PostgreSQL 9.3 DB, but...
Hi! I'm trying to deploy hajdbc on JBossAS EAP 6.3 with two PostgreSQL 9.3 DB, but...
Hi! I'm trying to deploy hajdbc on JBossAS EAP 6.3 with two PostgreSQL 9.3 DB, but...
In our project we are using the H2 database (http://www.h2database.com) and our goal...
Using 3.0.x, you can create a DataSourceDatabase that references your DataSource...
Hi, We are using ha-jdbc 2.0.16 rc, with jdk 6, and postgres. Following is our use...
Hi, in my application, I have connection pools created for my databases and want...
Hi Paul, Ignore the previous attachments. I re-ran with FINER logging for net.sf.hajdbc...
Hi Paul, Ignore the previous attachments. I re-ran with FINER logging for net.sf.hajdbc...
I noticed the writeLock() messages are not balanced if initiating from Tomcat 1 (coordinator)...
I noticed the writeLock() messages are not balanced if initiating from Tomcat 1 (coordinator)...
I ran into this problem on HA-JDBC 3.0.4-SNAPSHOT. It is running on Tomcat 7u62,...
I ran into this problem on HA-JDBC 3.0.4-SNAPSHOT. It is running on Tomcat 7u62,...
I ran into this problem on HA-JDBC 3.0.4-SNAPSHOT. It is running on Tomcat 7u62,...
Sorry for the slow response. Have you figured this out yet? I don't see HA-JDBC anywhere...
We are using ha-jdbc 2.0.16, and we are seeing following statements in the log files...
If I could ask a related question, is it possible to include the stack trace with...
Thank you for the clarification. I used these settings in Tomcat's logging.properties...
The reason for this is that in HA-JDBC we send fine/coarse durability commands per...
HA-JDBC offers serial or parallel transaction mode. From what I can tell from source,...
This is an old thread, but I wanted to caution against using "SELECT 1 FOR UPDATE"...
Thanks you. Paul You were all successful in all conditions, thanks. JBoss AS 7 &...
HA-JDBC 2.0 used to log remote commands as INFO. In 3.0, source address was added...
To use the JDBC url style of access, you must use HA-JDBC's jdbc driver as your entry...
Can I reactivate a member without synchronization? Can I call DatabaseClusterImpl.activate()...
env: tomcat7, hajdbc3.0.3, cento 6.5 64bit, mysql mysql jdbc driver in $TOMCAT_HOME/lib...
env: tomcat7, hajdbc3.0.3, cento 6.5 64bit, mysql mysql jdbc driver in $TOMCAT_HOME/lib...
Thank you. Paul Ferraro All Works fine! I'm sorry to my rudimentary mistakes.
Hi. Sorry for the delay in responding. For which JDBC url was no suitable driver...
Question... Why don't you use the ResultSet returned by PreparedStatement.executeQuery(...)...
Hello ferraro. environment : Centos 6.5 tomcat 7.0 postgresql 9.4 ( it has test/test2...
Hello ferraro. environment : Centos 6.5 tomcat 7.0 postgresql 9.4 ( it has test/test2...
Hello ferraro. My problem is as follows: environment : Centos 6.5 tomcat 7.0 postgresql...
I was able to get ColdFusion to find the file by moving it into the web-inf folder,...
I have recently been given the task of setting up an HA-JDBC test environment and...
I am wondering how to deal with two specific split-brain edge cases. The setup is...
I am wondering how to deal with two specific split-brain edge cases. The setup is...
how to find active database while execution
Thanks! This helped, I was having issue with database activation from Tomcat as well....
It seems like the error is when we try to activate a DB from a non coordinator. After...
Just an update, the error that I was facing with jgroups 3.4, its because I use System.setProperty(java.net.preferIPv4Stack),...
I have two nodes/applications that is connected via jgroups, pointing to two database....
I have two nodes/applications that is connected via jgroups, pointing to two database....
I have two nodes/applications that is connected via jgroups, pointing to two database....
Hi, I did a pull request and noticed you changed pom.xml and license. It changed...
The reason why I tried jgroups 3.6 is because I couldn't get the jgroups 3.4 to work...
I am new to jgroups, managed to create a cluster, but I am finding it difficult to...
Thanks all, switched to jgroups 3.4 and the unpatched code worked without issue....
I am using ha-jdbc-3.0.4-snapshot, latest from github. With JGroups 3.6.3. Both the...
HA-JDBC 3.0 and JGroups 3.6 are not compatible. You can either recompile with the...
Is the problem related to using JGroups 3.6? The dependencies page says to use JGroups...
After some digging, seems to be a bug, should be using the getBuffer() from Message...
After some digging, seems to be a bug, should be using the getBuffer() from Message...
I am using ha-jdbc-3.0.4-snapshot, latest from github. With JGroups 3.6.3. Both the...
Provider net.sf.hajdbc.logging.jboss.JBossLoggingProvider not a subtype
Fixed. https://github.com/ha-jdbc/ha-jdbc/commit/1f42722247e80611739a18f447c92d3...
Hi, I am trying to setup HA-JDBC 3.0.3 with JBoss-6.1. I am receiving below exception,...
A couple of issues: Your module files should only include the module.xml, ha-jdbc...
I try to add ha-jdbc as a module to WildFly 8.1, and I've got error 15:02:26,468...
When I receive a DatabaseEvent I push it to logs, reports, and user notifications....
I am using activated() and deactivated() listeners with HA-JDBC 3.0.3-SNAPSHOT. When...
So if there is a database server outage, the database nodes are marked as inactive....
can you post details on what changes to be made to disable write replication? I made...
HA-JDBC quiesces all connections during activate/synchronize? I think you mentioned...
Great! This unblocks the last two issues I had with 3.0.4-SNAPSHOT. So, are you planning...
If you remove UNICAST3 from your stack, messages can be sent concurrently - whereas...
I just tested database activation from a restarted Tomcat node. The indefinitely...
I just tested database activation from a restarted Tomcat node. The indefinitely...
I was comparing tcp.xml for JGroups 2.6 and 3.4 to see if there was anything I could...
I was comparing tcp.xml for JGroups 2.6 and 3.4 to see if there was anything I could...
You'd like to use JNDI from your application, correct? Just bind a DataSource to...
... and attached to this post, the source. Jean-Philippe MINETTI
Hi Paul, Attached to this post, the binary. To run: you need to create empty PostgreSQL...
Hi Paul, Help me on this.If i want to use JNDI name instead of JDBC Url what should...
Hi Paul, I would like to submit this patch to 3.0.4-SNAPSHOT. This is required for...
ok.If i want to use JNDI name instead of JDBC Url what should i have to do??
Good news. I wrote a unit test for HA-JDBC to reproduce and demonstrate this indefinite...
Hi Paul, This is regarding HA-JDBC lock timeout after Tomcat member restarts. I retested...
Hi Paul, This is regarding HA-JDBC lock timeout after Tomcat member restarts. I retested...
Hi Paul, This is regarding HA-JDBC lock timeout after Tomcat member restarts. I retested...
Hi Paul, This is regarding HA-JDBC lock timeout after Tomcat member restarts. I retested...