Hello here,
I tryed to compile a new sequoia-driver.jar package with your suggested
modifications but when I launch myosotis :
Starting Myosotis MySQL/jdbc proxy: myosotis
8013
[09:08:55] INFO [org.continuent.myosotis.App] - Starting Myosotis
Exception in thread "main" java.lang.ExceptionInInitializerError
at org.continuent.sequoia.driver.Driver.<clinit>(Driver.java:223)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at
org.continuent.myosotis.configuration.Configuration.<init>(Configuration.java:172)
at org.continuent.myosotis.App.<init>(App.java:62)
at org.continuent.myosotis.App.main(App.java:120)
Caused by: java.lang.NullPointerException
at java.util.Properties$LineReader.readLine(Properties.java:365)
at java.util.Properties.load(Properties.java:293)
at
org.continuent.sequoia.common.util.Constants.getVersionProperties(Constants.java:42)
at
org.continuent.sequoia.common.util.Constants.<clinit>(Constants.java:55)
... 6 more
[09:08:55] INFO [org.continuent.myosotis.App] - Exiting Myosotis
I got the sources from :
cvs -z3
-d:pserver:[email protected]:/cvsroot/sequoiadb co
-r sequoia-2_10_10 -P sequoia
modified the specified file as you said, ran ant (with sun-java5-jdk from
ubuntu 8.10) and zip the build/classes/org directory into a
sequoia-driver.jar file ...
Am I wrong ?
I'm not a java Dev (more sysadm :) ?
Cheers,
--
Damien Hardy
>
> Hi Damien,
>
> You have to update the regular expression for BEGIN in the
> org.continuent.sequoia.driver.SequoiaJDBCRegExp class.
> Replace:
> private static final String BEGIN_PATTERN_STRING
> = "^begin.*";
> with
> private static final String BEGIN_PATTERN_STRING
> = "^(begin|start\\s+transaction).*";
>
> That should properly convert 'start transaction' to a
> setAutoCommit(false) in the driver. Note that if you are using Myosotis,
> this should be done by Myosotis. If it does not work, please post a
> message on the Myosotis mailing list.
>
> Hope this helps,
> Emmanuel
>
>> To be more precise here is the error I obtain with the sql client within
>> the sequoia console :
>>
>> jdbc:sequoia://.../magento?alwaysGetGeneratedKeys=true&preferredController=roundRobin
>> (magento) > START TRANSACTION;
>> An error occured while executing SQL query
>> (org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
>> Message of cause: Request START TRANSACTION;/ failed on backend db1
>> (Error
>> while building Sequoia ResultSet (ResultSet is from UPDATE. No Data.)))
>>
>> Whereas It work as expected with "BEGIN" :
>>
>> jdbc:sequoia://.../magento?alwaysGetGeneratedKeys=true&preferredController=roundRobin
>> (magento) > begin
>> Transaction started
>>
>> No idea about this problem ?
>>
>> Is it reasonable to aim to make magento working over sequoia with a
>> mysql
>> cluster ?
>>
>> Thanks.
>>
>> Best regards
>>
>>
>
>
> --
> Emmanuel Cecchet
> FTO @ Frog Thinker
> Open Source Development & Consulting
> --
> Web: http://www.frogthinker.org
> email: [email protected]
> Skype: emmanuel_cecchet
>
> _______________________________________________
> Sequoia mailing list
> [email protected]
> http://forge.continuent.org/mailman/listinfo/sequoia
>
>
_______________________________________________
Sequoia mailing list
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
