Get Started doesn't write

[grep_fruit]

Hello,
I changed the connection string to be able to connect to locally running Mysql in the HelloWorld tutorial. I am able to read (/hello works fine), but when I attempt to write new objects (using /create), the application claims to succeed("Created a new star.."), but the objects aren't in the database. No error shown, there is even no attempt to connect to the server. There is probably some fundamental fault on my side, but I am not able to find where could have I done it.

This is how I changed the values in the configuration:
<add key="DataProviderFactory" value="DomainObjects.DbAccess.DataProvider.MySql.MySqlDataProvider, DomainObjects.Extensions" />

...

<add key="ConnectionString" value="server=localhost;uid=DomainObjects;pwd=DomainObjects123;database=DomainObjects; pooling=true" />

  Thank you.
                  Libor

[Dario]

Hi Libor. I don´t know if MySqlDataProvider is fuly implemented.

Regards
Dario K.

[Jan Sandquist]

Hi Libor,

I'm glad to hear that you are trying the MySql support.

Do you use the InnoDB setup for MySql?

I've implemented parts of the MySql support and
I'm currently testing this with MySql 5.0.11 with InnoDB set as Default storage (in MySql Administrator, StartUp Variables, General Parameters).

I just retrieved revision 208 of the source code from the SVN repository.  My ConnectionString looks the same as yours and the tutorial works just fine here. :-)

Can you run the unit tests? In my case I currently get:
  161 passed, 8 failed, 1 skipped, took 23.11 seconds.

The failing ones are all specific to either SQL Server or Oracle except one -

TestCase 'DomainObjects.Test.TestFixture.QueryTests.LongStringsAreAllowedInWhereClauses'
failed: There is a book with the ISBN like %1234567890%

which works if either of the '%' is removed from the search criteria. This seems to be a problem with the parameter length matching the column definition of char(10).

-- Jan

PS. As you have noticed building the tutorial does some xml poking with the ConnectionString making it specific to SQL Server. Apparently though, you have updated it after that as you've managed to connect. :-)