must run on database with support for transactions

Classic Servoy
1

I moved the repository from the FireBird database to PostgreSQL to MySQL 3.23.54-blueworld.com. All went fine until I moved from my iBook to my new PowerBook.
I use the same versions but now Servoy tells me “The repository server must run on a SQL database with support for transactions!”.

Any idea’s ? Why did it work before?

2

Are you using another diriver now? which correctly tells mysql is not usable as repository server becouse it does not have guaranteed consistency in transactions (which might currupt the repository if db crashes)

BTW there is an engine for mysql which supports transactions.

3

I don’t use another driver unless you bundled a new driver with Servoy.

But what you are saying is that you can’t use Servoy with Lasso Proffesional 6. :?
LP6 comes with a commercial license of MySQL 3.23.54.
Ofcourse you can hook LP6 up to a MySQL 4.x but then you need to pay for another commercial license when used in a production setting.

So I guess I need to wait for LP 7 that comes with MySQL 4.x. (or use PostgreSQL). :(

4

I don’t know exactly but is that the MAX version?
You can use 3.23.xx if i am not mistaken but you need another engine like InnoDB (which is included in some versions of mysql by default)

5

ROCLASI:
I don’t use another driver unless you bundled a new driver with Servoy.

But what you are saying is that you can’t use Servoy with Lasso Proffesional 6. :?
LP6 comes with a commercial license of MySQL 3.23.54.
Ofcourse you can hook LP6 up to a MySQL 4.x but then you need to pay for another commercial license when used in a production setting.

So I guess I need to wait for LP 7 that comes with MySQL 4.x. (or use PostgreSQL). :(

I’ve hooked into Lasso6 MySQL to build a solution but not to run the repository. Not sure if there is a difference between the two.

Lasso 7 is using an “embedded” version of MySQL 4.x. Which means that you will not be able to access the database with external tools like Servoy.

http://www.listsearch.com/lassotalk.lasso?id=123687

  • david
6

Just to be sure, you can use mysql (what ever version you want) for youre solution data but not as the repository server.

7

david:
Lasso 7 is using an “embedded” version of MySQL 4.x. Which means that you will not be able to access the database with external tools like Servoy.

http://www.listsearch.com/lassotalk.lasso?id=123687

  • david

ACK!
I wonder if there will be a jdbc2Lasso API. Certainly would make LP7 more attractive.

8

I can’t think of any advantage to using LassoSQL over a separate installation of MySQL except for saving a little extra set-up time. Lasso and Servoy hook into MySQL as a data source equally well so it makes sense to use a separate MySQL install if you are using both.

The only issue outstanding with this setup is pk management:

http://forum.servoy.com/viewtopic.php?t=781

For this reason I’ll be checking out Postgres since there is a way to have Lasso and Servoy both recognize and increment the pk field. Bob has posted detailed instructions:

http://forum.servoy.com/viewtopic.php?t=874

  • david