You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 mORMot 1 » TestSQL3 - Failed to execute some tests » 2018-01-23 11:59:39
- tdanop
- Replies: 1
Hi,
I have run TestSQL3 with almost all tests been successfully passed, except the below 4:
My Configuration is Win7, DelphiXE5 behind proxy and firewalls.
1.1 Low Level common - UTF8: Which I resolved by myself by updating Check(StringCodePage(W)=1252) to 1253;
LOG: SynSelfTests.TTestLowLevelCommon(00A60180) Low level common: UTF8 "" stack trace API 005BBE0E 005D2576 005D04AD 00866F54 00869E5D 005D15E9 00940987 0094A74D 769B336A 771A98F2 771A98C5
1.2 Low Level Types - Encode decode JSON :
LOG:11395813 fail SynSelfTests.TTestLowLevelTypes(00A76830) Low level types: Encode decode JSON "" stack trace API ....
EXC EWinHTTP ("winhttp.dll error 12019 (The handle is in the wrong state for the requested operation)") at 005A3A21 stack trace API ....
1.2 Low Level Types - Mustache rendered: 5/52 FAILED
LOG:SynSelfTests.TTestLowLevelTypes(00A76830) Low level types: Mustache renderer "" stack trace API ....
1.4 Synopse PDF: -TpdfDocument 1 / 2 FAILED
LOG: SynSelfTests.TTestSynopsePDF(00A768B8) Synopse PDF: TPdfDocument "" stack trace API ....
how can I resolve these errors, can you help?
Thank you,
#2 Re: mORMot 1 » Client-Server Callbacks » 2017-12-15 11:53:02
By stateless behavior I mean you can not broadcast messages from server to all connected clients through a predefined channel.
#3 mORMot 1 » Client-Server Callbacks » 2017-12-15 10:21:29
- tdanop
- Replies: 6
Hi,
I would like to ask if client/server callbacks are possible to implement with mOrmort framework which rather support stateless behavior.
#4 Re: mORMot 1 » MVC Server sample with MSSQL db » 2017-09-12 14:23:33
I can't find parameter with name [EA] which is specified in log file. There is no such a parameter name.
#5 Re: mORMot 1 » MVC Server sample with MSSQL db » 2017-09-11 15:24:11
Yes it is a MSSQL limitation .
In the first case I would like to know how can I define the type of parameter according to field types of insert statement?
#6 Re: mORMot 1 » MVC Server sample with MSSQL db » 2017-09-11 08:47:23
On the first exception the error is coming from the fact that the parameter in a insert query when you execute prepare is of unknown type :
SQL SynDBFireDAC.TSQLDBFireDACStatement(0244AD10) insert into dbo.Author (ID,CreatedAt,ModifiedAt,LogonName,FirstName,FamilyName,BirthDate,Email,HashedPassword,Verified,Rights) values (1,135393478062,135393478062,'synopse',NULL,'Synopse','',NULL,'aa4aecd02efeaab94433ff1eae7479a43bcfa5e685e8c97f7c321ffe57d23daf',1,15)
20170911 08224822 EXC EFDException ("[FireDAC][Phys][MSSQL]-335. Parameter [EA] data type is unknown. Hint: specify TFDParam.DataType or assign TFDParam value before Prepare/Execute call") at 007E1D22 stack trace API 00592973 0059299C The second one is coming from the SQL statement in GetViewInfo:
"if not fDefaultData.AddExistingProp('archives',result) then
fDefaultData.AddNewProp('archives',RestModel.RetrieveDocVariantArray(
TSQLArticle,'','group by PublishedMonth order by PublishedMonth desc limit 100',[],
'distinct(PublishedMonth),max(RowID)+1 as FirstID'),result)"I think the limit 100 (TOP in MSSQL) is invalid if you combine it with distinct, may work with Postgress but not in MSSQL.
I remove the "limit 100" from the query and was execute fine in MSSQL.
#7 mORMot 1 » MVC Server sample with MSSQL db » 2017-09-08 10:22:12
- tdanop
- Replies: 12
Hi,
I am testing the MVCServer with Delphi XE5 Update 2, MSSQL 2014 as back-end Server and FireDAC 19.0.14356 as a connection driver.
When I start the project (in debug mode) I am getting the following error:
First chance exception at $75F0C42D. Exception class EFDException with message '[FireDAC][Phys][MSSQL]-335. Parameter [EA] data type is unknown. Hint: specify TFDParam.DataType or assign TFDParam value before Prepare/Execute call'. Process MVCServerMSQL.exe (2884)
When I skip this error the server starts "normally" but when I try to connect with http://localhost:8092 I am getting the JSON output
{
"errorCode":500,
"error":
{"EMSSQLNativeException":{"EMSSQLNativeException":"[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'distinct'."}}
}
Can you help?
#8 mORMot 1 » Migration of an old fat client/server application to mormot framework » 2017-03-22 11:28:48
- tdanop
- Replies: 3
Hi forum,
I have an old C/S CRM application (delphi7 90's) with one data module, SQL server as a DB Server, ADO as provider, ClientDatasets, about 30 forms and grids, a lot of RAD data aware components and a Report Builder (Digital Metaphor) engine as a reporting system.
My goal for start is just to replace the old fashion C/S with mormot keeping all these components and the rich Delphi client as possible as it is now.
After the migration I wish to start develop an extra web interface keeping the rich Delphi client to work as usually works.
I have read the documentation, excellent document by the way, but I cannot find an easy path through the chapters and samples to do it.
If someone has a success case story in similar migration it could be very helpful to give me at least a starting point.
Thank you,
#9 Re: mORMot 1 » Debug MVC sample » 2017-03-22 10:17:50
How can I enable the log? I was tried to enable through SynLog unit but if this the right way I need a little help.
#10 mORMot 1 » Debug MVC sample » 2017-03-21 15:31:56
- tdanop
- Replies: 2
Hi,
How can I debug the MVC Sample in order to view how requests are processed?
Thank you,
#11 Re: mORMot 1 » MVCServerPostgreSQL sample » 2017-02-23 08:19:46
Its ok the issue is coming from the fact that there were missing the postgress dlls.
The project running fine as standalone exe.
#12 mORMot 1 » MVCServerPostgreSQL sample » 2017-02-22 11:41:45
- tdanop
- Replies: 1
Hi,
With delphiXE5 under Windows7-64bit I was trying to run MVCServerPostgreSQL sample as a standalone (outside the IDE) but when the application starts hung immediately with the know widows message for "searching a solution". In the windows event viewer I notice in the details of the message the "Faulting module path: C:\Windows\syswow64\KERNELBASE.dll".
The same app when I "run without debugging" or "with debugging" for IDE it works ok.
Any idea for help?
#13 Re: mORMot 1 » SQLite3 sample projects - Procedure entry point isdebuggerpresent » 2017-01-05 09:29:52
First thank you for the assist. The issue was resolved after totally remove the dev\lib and replaced by the last night build. Really I don't know what was the root of this issue I just suspect the debug information parameter bu I have no time for more R&D.
But I have to point this, for those who has several installations of Delphi in the same machine like me (Delphi7, XE3, XE5, Berlin starter edition) they should avoid reuse the same .proj file across all releases as there is a conflict in the debug information parameter across all those releases.
Thank you again.
#14 Re: mORMot 1 » SQLite3 sample projects - Procedure entry point isdebuggerpresent » 2017-01-04 13:45:22
Windows 7 (64)
#15 mORMot 1 » SQLite3 sample projects - Procedure entry point isdebuggerpresent » 2017-01-04 13:03:06
- tdanop
- Replies: 4
Hi,
There is an error "The procedure entry point isdebuggerpresent could not be located in the dynamic link library kernel32.dll" when I try to run either in debug or release the sample programs or SQLTest.
I am not quite sure that this error comming from framework but when I open a new project without use of framework with just a single form is running fine.
I use Delphi Berlin starter edition 10.1 and the framework was downloaded 14 Dec 2016.
Anybody has an idea what is this error coming from?
Thanks,
Theodor
#16 Re: mORMot 1 » TestSQL3 project failed some tests, why? » 2016-12-15 10:09:38
I think this is not the reason it fails, when I debugged seems actually it hangs on HttpGet('https://api.github.com/users/zendframework/repos'); with class EwinHTTP error 12002 Operation Timed Out then coms the access violation and the whole test fails.
#17 Re: mORMot 1 » TestSQL3 project failed some tests, why? » 2016-12-15 08:53:20
Well I think this could be the reason it fails, my DOS command prompt (cmd) gives active code page 737 which is not UTF-8.
I was try with chcp command in the registry to change cmd command to 65001 and 1253 active page, but when I run the tests using these settings I get the exactly the same fail result.
I also try with XE5 and XE10.1 Berlin starter edition with the same fail reason. The rest of tests was successful.
May I had to switch my active page somehow to 65001 or 1253 inside to TestSQL3.pas, but I don't know how.
#18 Re: mORMot 1 » TestSQL3 project failed some tests, why? » 2016-12-14 13:47:20
TestSQL3 Failed to test LowLevel Types - Encode decode JSON with Access Violation. I am using DelphiXE3 - Update2. Mormot Framework NightlyBuild on 14/12/2016 14:00.
Any idea?
#19 Re: mORMot 1 » Newbie question for MSSQL connection » 2015-06-25 11:02:44
Hi, sorry I posted here but I can't create a new post, I don't know why. My question is about sample 30 MVC. I was convert db connection in order my connect will be on my local 2008 R2 server. My sample was compile successfully but in runtime
an error raise on method aServer.CreateMissingTables on MVCFirebird.exe and the message is
'[FireDAC][Phys][IB]Unable to complete network request to host "tdserver:3050".
Failed to establish a connection.
No connection could be made because the target machine actively refused it.'. where tdserver is my instance of SQL server.
I was try to find where is defined that port but I can't. It seems trying creating the tables on SQLlite3 instead of MSSQL, can you help?
#20 Re: mORMot 1 » Demo application + some question / remarks. » 2015-06-12 11:57:28
Tnx ab it is working now.
#21 Re: mORMot 1 » Demo application + some question / remarks. » 2015-06-12 09:34:17
I am trying to run on XE5 but it comes with error on ACustomer.Tasks.DestGet(globalClient, ACustomer.ID, fIds)
[dcc32 Error] Unit1.pas(184): E2250 There is no overloaded version of 'DestGet' that can be called with these arguments
I am trying to fix but as I can see DestGet method does not use anymore TSQLRecord as a param type but TSQLRest, I am lost because when the demo was construct propably was with a different framework.
#22 Re: mORMot 1 » MVCServer : /blog path » 2015-06-08 10:15:45
Thank you, I follow the MVCPostgress sample technique modifying for MSSQL and project run with success.
Is this the proper technique to follow in order to be indepented of all DB vendors by including all vendors in complie and choose one each time project runs in runtime?.
#23 Re: mORMot 1 » MVCServer : /blog path » 2015-06-08 08:07:52
Hi, I am newbie to framework and i run the sample MVCServer. Just wondering how can i change the line of code where a TSQLRestServerDB is created
"aServer := TSQLRestServerDB.Create(aModel,ChangeFileExt(ExeVersion.ProgramFileName,'.db'));" instead of pointing to a SQL3 db to point to an MSSQL db.
#24 Re: mORMot 1 » Newbie question for MSSQL connection » 2015-03-26 10:42:37
I have 2 views with identical number and column names. Can I create one object (TSQLRecord) for the 2 views and each time I want data from the views I have to give the name of the view in a variable?
#25 Re: mORMot 1 » Newbie question for MSSQL connection » 2015-03-17 16:25:49
Based on what the article describe I am trying to modify the sample "16. Execute SQL via services" to connect to an SQL Server using instead of SQL authentication the windows one. Just adding a new property in class TProjectSettings isn't enough (boolean winauth). Where it is supposed to be my next implementation?
#26 Re: mORMot 1 » Newbie question for MSSQL connection » 2015-03-17 08:01:44
Thank you very much, I am in the stage where I am trying to unterstand the mormot framework way of think. Well, now I am on the db connection and my main difficulty, except my "transfer" from thinking in relational model to object model, is to understand db connections. In old-fashion way we have a datamodule a connection object (ADO,DBEXpress or FireDAC) and dozens of datasets, which are all connected toogether. Now they all gone and their place took some methods and objects which I must understand their use and how these will replace the old "dataset-thinking".
#27 Re: mORMot 1 » Newbie question for MSSQL connection » 2015-03-15 11:45:03
Which part of sample "13 - StandAlone JSON SQL server" msut I modify in order the same application work for my local MS-SQL server? I just cant understand how this can happen from Documentation.
Pages: 1