Pages: 1

#1 Re: mORMot 1 » Problem with timeout MySQL + ZEOS » 2015-08-06 13:57:34

sergioschel

Hi ab,

Thanks for return,

how can i do it  in reconnecting?

#2 mORMot 1 » Problem with timeout MySQL + ZEOS » 2015-08-06 12:08:28

sergioschel
Replies: 4

Hello,
I am using the example 13 - StandAlone JSON SQL server, I changed the connection to use MySQL with ZEOS:

Props := TSQLDBZEOSConnectionProperties.Create('zdbc:mysql://localhost:3306/teste?username=root;password=root;MYSQL_OPT_RECONNECT=TRUE','teste', '', '');

The Process function of the standard return is UTF8 but after connection timeout of MySQL the process function returns AnsiString.

To test I put the MySQL server timeout 10 seconds.

Run SQL command that return with special character as select campo from teste

Return before timeout: [{"campo":"Está correto"}]

Return after timeout: [{"campo":"Está correto"}]

Please help smile

#3 mORMot 1 » Syntax Error MySQL for INSERT command with special characters » 2015-07-09 10:35:08

sergioschel
Replies: 1

Hi,

What should I set to work the INSERT command with special character? Ex.: ç, é, á, à, ã...

**** server***
ModeloDados := TSQLModel.Create([], ROOT_NAME);
ModeloServicos := TSQLModel.Create([],'rap_services');
ServidorServicos := TSQLRestServerFullMemory.Create(ModeloServicos);
ServidorServicos.ServiceRegister(TServiceRemoteSQL,[TypeInfo(IRemoteSQL)], sicShared);
BaseDados := TSQLDBZEOSConnectionProperties.Create('zdbc:mysql://localhost:3306/rap?username=root;'+
                                                      'password=root;characterSetResults=utf8;'+
                                                      'MYSQL_OPT_RECONNECT=TRUE',
                                                      'teste', '', '');
BaseDados.ThreadingMode := tmMainConnection;
ConexaoBD := BaseDados.ThreadSafeConnection;
ServidorDados := TSQLRestServerFullMemory.Create(ModeloDados);
ServidorHTTP := TSQLHttpServer.Create('8080', [ServidorServicos]);

****client****
POST command INSERT: insert into testes (coluna) values ('Análise')
SQL Error: Incorrect string value: '\\xE1lise:...' for column 'coluna' at row 1

#4 Re: mORMot 1 » Regional Settings Windows » 2015-02-21 15:46:03

sergioschel

Great ab
Thanks for the help, is now working. big_smile

#5 Re: mORMot 1 » Regional Settings Windows » 2015-02-21 12:31:15

sergioschel

In mORMoti18n (line 1247) always puts as lngEnglish, even if I set i18nLanguageToRegistry(lngPortuguese).
I'm using the mORMot_and_Open_Source_friends_2015-02-16_211520_112f15efcb sources

#6 mORMot 1 » Regional Settings Windows » 2015-02-21 11:27:06

sergioschel
Replies: 5

Hi ab

I'm using mormot on an existing project but to call TimeToStr (Now) is returning with AM / PM (ex. "9:02:45 AM"). If I remove mormot project files the same function returns the time correctly (ex. "09:02:45").
In my Windows the default time format is HH: mm: ss (Portuguese Brazil).
I need the mormot work with the same format of my language in Windows.

#7 Re: mORMot 1 » Failover » 2014-12-18 13:05:06

sergioschel

On the server side.
Is ORM.
Yes, I hope that a second server mORMot to take care of the process if the first server is down.
The Oracle database server is on another host and already has failover.
Thanks for the quick return!

#8 mORMot 1 » Failover » 2014-12-18 12:16:39

sergioschel
Replies: 5

How can I implement failover with mormot?

#9 mORMot 1 » CRUD Desktop Delphi » 2014-11-06 00:36:33

sergioschel
Replies: 1

Hi ab!

This is my first post on the forum and the first doubt. smile

I'm creating a MVC project with mORMot ...

On the client side i have multiple screens of the type CRUD:

1- Create TSQLHttpClientWinHTTP for each CRUD only with TSQLModel table used?

2 - Create TSQLHttpClientWinHTTP only once for all the project with TSQLModel creating all tables?

What is better?

Thanks,
Sergio Schelbauer

Pages: 1

Board footer

Powered by FluxBB