[HA-JDBC] Some comments on my 1-day expierence with ha-jdbc 1.0-rc5

[Roman K. <rom...@br...>]

hi,

just a few words about my expierences with ha-jdbc after a short time
playing around with it (no, it's not complaining ;):



i had some problems compiling the source code with jdk 1.4.2 because
there are two lines in the sourcecode that seems to be working with java
1.5 only. BalancerEnum (line 65): the constructor of
IllegalArgumentException takes only a String object, not an Exception,
as parameter. The other problem is in LocalDatabaseCluster (line 56):
the quote method of Pattern was also introduced in Java 1.5, i think.
however, it is not necessary in this particular line of code because

DELIMITER = ","

would be equivalent.

if i were supposed to make these changes myself in the sourcecode.... i
would love to, but i thought it might be easier for you to first check
whether my assumptions are correct. ;)




i also had an error that let me assume that the xml file is wrong:

net.sf.hajdbc.SQLException: Failed to configure HA-JDBC using
configuration file: file:/tmp/ha-jdbc/ha-jdbc.xml
....
Caused by: org.jibx.runtime.JiBXException: Error while unmarshalling
(line 24, col 13)
at
net.sf.hajdbc.local.LocalDatabaseCluster.JiBX_binding_unmarshal_2_0(LocalDatabaseCluster.java)
at net.sf.hajdbc.local.JiBX_bindingLocalDatabaseCluster_access.unmarshal()
at
net.sf.hajdbc.DatabaseClusterFactory.JiBX_binding_unmarshal_1_0(DatabaseClusterFactory.java)
...

as i finally found out, this just meant that the mysql driver (i've
configured two mysql databases as backend) were missing in the
classpath. i justed wanted to point this out in case somebody else got
this problem.





finally, i had to add username and password to the mysql-urls because
the <user>/<password> elements were not used.
the exception was:

java.sql.SQLException: Access denied for user: '@<hostname>' (Using
password: YES)

when i added username and password to the urls, everything worked just
fine. (but that is probably the fault of the mysql database driver
because the properties object is filled correctly)




well, that's it. i'm definitely going to evaluate ha-jdbc more deeply
because (i like it and) it fits our needs better that c-jdbc.

roman


-- 
Dr. Roman Kurmanowytsch          rom...@br...
Braintribe IT Technologies GmbH  Tel: +43 (1) 596 70 60 ext. 130
Hoher Markt 5/Dachgeschoss       Fax: +43 (1) 596 70 60 ext. 120
1010 Vienna, Austria             http://www.braintribe.com/