Posts by cloudcon

cloudcon · mORMot 1

Good evening again,
I am starting my http server but found a following problem.
I created the class, called the method "aServer.CreateMissingTables (0);" the framework created everything perfectly.
But when I try to make the call by the browser "http://localhost:8081/root/WmsEmpresa" it returns me the following error
"OCI-21560: 10 argument is null, invalid, or out of range"

Where my code

Class

unit SQLWMS_EMPRESA;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, SynLog,
  mORMot, mORMotSQLite3, SynSQLite3Static, mORMotHttpServer, SynCommons;

type
  /// WMS_EMPRESA Table
  // - type definition auto-generated by SynDBExplorer 1.18.1094 at 2015-03-21 18:37:45
  // from CLOUDCON.WMS_EMPRESA
  // - note that the ORM will add one missing ID field via:
  // $ ALTER TABLE CLOUDCON.WMS_EMPRESA ADD ID NUMBER(22,0) NOT NULL PRIMARY KEY
  TSQLWmsEmpresa = class(TSQLRecord)
  protected
    fEMP_CODIGO: Int64;
    fEMP_RAZAO: RawUTF8;
    fEMP_FANTASIA: RawUTF8;
    fEMP_CNPJ: RawUTF8;
    fEMP_IESTADUAL: RawUTF8;
    fEMP_IMUNICIPAL: RawUTF8;
    fEMP_ENDERECO: RawUTF8;
    fEMP_BAIRRO: RawUTF8;
    fEMP_CIDADE: RawUTF8;
    fEMP_UF: RawUTF8;
    fEMP_CEP: RawUTF8;
    fEMP_COMPLEMENTO: RawUTF8;
    fEMP_EMAIL: RawUTF8;
    fEMP_FAX: RawUTF8;
    fEMP_TELEFONE: RawUTF8;
    fEMP_OBS: RawUTF8;
  published
    /// match WMS_EMPRESA.EMP_CODIGO [NUMBER 22 0 0] *
    property EMP_CODIGO: Int64 read fEMP_CODIGO write fEMP_CODIGO;
    /// match WMS_EMPRESA.EMP_RAZAO [VARCHAR2 100 0 0] *
    property EMP_RAZAO: RawUTF8 index 100 read fEMP_RAZAO write fEMP_RAZAO;
    /// match WMS_EMPRESA.EMP_FANTASIA [VARCHAR2 120 0 0] *
    property EMP_FANTASIA: RawUTF8 index 120 read fEMP_FANTASIA write fEMP_FANTASIA;
    /// match WMS_EMPRESA.EMP_CNPJ [VARCHAR2 18 0 0] *
    property EMP_CNPJ: RawUTF8 index 18 read fEMP_CNPJ write fEMP_CNPJ;
    /// match WMS_EMPRESA.EMP_IESTADUAL [VARCHAR2 20 0 0] *
    property EMP_IESTADUAL: RawUTF8 index 20 read fEMP_IESTADUAL write fEMP_IESTADUAL;
    /// match WMS_EMPRESA.EMP_IMUNICIPAL [VARCHAR2 20 0 0] *
    property EMP_IMUNICIPAL: RawUTF8 index 20 read fEMP_IMUNICIPAL write fEMP_IMUNICIPAL;
    /// match WMS_EMPRESA.EMP_ENDERECO [VARCHAR2 200 0 0] *
    property EMP_ENDERECO: RawUTF8 index 200 read fEMP_ENDERECO write fEMP_ENDERECO;
    /// match WMS_EMPRESA.EMP_BAIRRO [VARCHAR2 100 0 0] *
    property EMP_BAIRRO: RawUTF8 index 100 read fEMP_BAIRRO write fEMP_BAIRRO;
    /// match WMS_EMPRESA.EMP_CIDADE [VARCHAR2 100 0 0] *
    property EMP_CIDADE: RawUTF8 index 100 read fEMP_CIDADE write fEMP_CIDADE;
    /// match WMS_EMPRESA.EMP_UF [VARCHAR2 2 0 0] *
    property EMP_UF: RawUTF8 index 2 read fEMP_UF write fEMP_UF;
    /// match WMS_EMPRESA.EMP_CEP [VARCHAR2 15 0 0] *
    property EMP_CEP: RawUTF8 index 15 read fEMP_CEP write fEMP_CEP;
    /// match WMS_EMPRESA.EMP_COMPLEMENTO [VARCHAR2 200 0 0] *
    property EMP_COMPLEMENTO: RawUTF8 index 200 read fEMP_COMPLEMENTO write fEMP_COMPLEMENTO;
    /// match WMS_EMPRESA.EMP_EMAIL [VARCHAR2 60 0 0] *
    property EMP_EMAIL: RawUTF8 index 60 read fEMP_EMAIL write fEMP_EMAIL;
    /// match WMS_EMPRESA.EMP_FAX [VARCHAR2 20 0 0] *
    property EMP_FAX: RawUTF8 index 20 read fEMP_FAX write fEMP_FAX;
    /// match WMS_EMPRESA.EMP_TELEFONE [VARCHAR2 20 0 0] *
    property EMP_TELEFONE: RawUTF8 index 20 read fEMP_TELEFONE write fEMP_TELEFONE;
    /// match WMS_EMPRESA.EMP_OBS [VARCHAR2 500 0 0] *
    property EMP_OBS: RawUTF8 index 500 read fEMP_OBS write fEMP_OBS;
  end;


implementation

uses
  SynCrtSock;

end.

unit Unit1;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, SynDBOracle,mORMotDB;

type
  TForm1 = class(TForm)
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses
  mORMot, mORMotSQLite3, mORMotHttpServer, SQLWMS_EMPRESA;

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
var
  aProps: TSQLDBOracleConnectionProperties;
  aModel: TSQLModel;
  aServer: TSQLRestServerDB;
  aHTTPServer: TSQLHttpServer;
begin
  aProps := TSQLDBOracleConnectionProperties.Create('xe', 'cloudcon', 'cloudcon', 'cloud123');
  aModel := TSQLModel.Create([TSQLWmsEmpresa], 'root');
  VirtualTableExternalRegisterAll(aModel, aProps, false);

  aServer := TSQLRestServerDB.Create(aModel, false);
  aServer.CreateMissingTables(0);
  aServer.NoAJAXJSON := False;

  aHTTPServer := TSQLHttpServer.Create('8081', [aServer], '+', useHttpApiRegisteringURI);
  aHTTPServer.OnlyJSONRequests := False;
  aHTTPServer.AccessControlAllowOrigin := '*'; // for AJAX requests to work
end;

end.

I need help

cloudcon · mORMot 1

I Solve the problem, the port 8080 is use by oracle ..

cloudcon · mORMot 1

Good night,
I am trying to compile the example "19 - AJAX ExtJS FishFacts" but I is generating this error 'http.sys URI registration error #32 for http://+:8080/root' when running the line
"Server: = TSQLHttpServer.Create ('8080', [DB], '+', useHttpApiRegisteringURI);"
I'm using Delphi XE7, Windows 7 64-bit

Can you help me?

cloudcon · mORMot 1

Good afternoon,
First I would like to congratulate you all for the excellent work.
I am totally new to the framework, I'm willing to build a WMS system that will work with Java and C # Web clients in Data colector.
What would be the best way to do?
I have read, it would be better to create a Http server using methods.
But I really do not even know where to start ...
Connecting with an Oracle database?
Persistence of classes will be on the server, but if my client C # or Java serialize a class created in the same way that language understand my server?

would be possible to post some samples to help me in this task?

I would love your help in this new work and sorry my English, I am Brazilian and google translator using ...

cloudcon · mORMot 1

I unfortunately did not find this button to close the topic !
Sorry

cloudcon · mORMot 1

now worked perfectly.
Many thanks for the help.
I'll develop a great system and I am very eager to start it using the framework.

How do I mark as answered?

cloudcon · mORMot 1

Yes.
I Follow All steps of
http://synopse.info/fossil/wiki?name=Get+the+source
And steps of ReadMe file inside folder D:\Dev\Synopse
I update de SQLite3-64.dll from your link
http://synopse.info/files/SQLite3-64.7z
and now the error 'no such module: rtree' reappeared
for compilation in 32bit everything is working correctly, but more's 64bit generates the error.
I'll post the error log.

indir=C:\Windows
TSQLLog 1.18 2014-05-12T10:20:50

20140512 10205014 EXC   ESQLite3Exception ("no such module: rtree") at 0000000000612D57 
20140512 10205014 EXC   ESQLite3Exception ("no such module: rtree") at 0000000000612D57

The full log

D:\Dev\Synopse\SQLite3\TestSQL3.exe 0.0.0.0 (2014-05-12 10:18:05)
Host=CLOUDCON2-PC User=Cloudcon2 CPU=4*9-6-14857 OS=13.1=6.1.7601 Wow64=0 Freq=1948730
Environment variables=ALLUSERSPROFILE=C:\ProgramData	AMDAPPSDKROOT=c:\Program Files (x86)\AMD APP\	APPDATA=C:\Users\Cloudcon2\AppData\Roaming	BCB=c:\program files (x86)\embarcadero\rad studio\11.0	BDS=c:\program files (x86)\embarcadero\rad studio\11.0	BDSAppDataBaseDir=BDS	BDSBIN=c:\program files (x86)\embarcadero\rad studio\11.0\bin	BDSCOMMONDIR=C:\Users\Public\Documents\RAD Studio\11.0	BDSINCLUDE=c:\program files (x86)\embarcadero\rad studio\11.0\include	BDSLIB=c:\program files (x86)\embarcadero\rad studio\11.0\lib	BDSPLATFORMSDKSDIR=C:\Users\Cloudcon2\Documents\RAD Studio\SDKs	BDSPROFILESDIR=C:\Users\Cloudcon2\Documents\RAD Studio\Profiles	BDSPROJECTSDIR=C:\Users\Cloudcon2\Documents\RAD Studio\Projects	BDSUSERDIR=C:\Users\Cloudcon2\Documents\RAD Studio\11.0	CATALINA_HOME=C:\apache	CG_64_BOOST_ROOT=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\include\boost_1_50	CG_BOOST_ROOT=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\include\boost_1_39	CLASSPATH=C:\Program Files\Java\jdk1.6.0_25\bin	CommonProgramFiles=C:\Program Files\Common Files	CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files	CommonProgramW6432=C:\Program Files\Common Files	COMPUTERNAME=CLOUDCON2-PC	ComSpec=C:\Windows\system32\cmd.exe	DELPHI=c:\program files (x86)\embarcadero\rad studio\11.0	DEMOSDIR=C:\Users\Public\Documents\RAD Studio\11.0\Samples\	FP_NO_HOST_CHECK=NO	HOMEDRIVE=C:	HOMEPATH=\Users\Cloudcon2	IBREDISTDIR=C:\Users\Public\Documents\InterBase\redist\InterBaseXE3	IB_Protocol=rad_xe4	InterBase=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\InterBaseXE3	JAVA_HOME=C:\Program Files\Java\jdk1.8.0	LOCALAPPDATA=C:\Users\Cloudcon2\AppData\Local	LOGONSERVER=\\CLOUDCON2-PC	NUMBER_OF_PROCESSORS=4	OS=Windows_NT	Path=C:\Users\Public\Documents\InterBase\redist\InterBaseXE3\win32_togo;C:\Users\Public\Documents\InterBase\redist\InterBaseXE3\win64_togo;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\Redist\boost\win64;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\Redist\boost\win32;C:\Program Files\Java\jdk1.8.0\bin;C:\Python27\;D:\app\Cloudcon2\product\11.2.0\client_1\bin;C:\Program Files (x86)\Embarcadero\RAD Studio\10.0\bin;C:\Users\Public\Documents\RAD Studio\10.0\Bpl;C:\Program Files (x86)\Embarcadero\RAD Studio\10.0\bin64;C:\Users\Public\Documents\RAD Studio\10.0\Bpl\Win64;C:\Program Files (x86)\Embarcadero\RAD Studio\7.0\bin;C:\Users\Public\Documents\RAD Studio\7.0\Bpl;C:\Program Files (x86)\CollabNet;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin;C:\Users\Public\Documents\RAD Studio\11.0\Bpl;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin64;C:\Users\Public\Documents\RAD Studio\11.0\Bpl\Win64;c:\Program Files (x86)\AMD APP\bin\x86_64;c:\Program Files (x86)\AMD APP\bin\x86;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Python27	PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.py;.pyw	PROCESSOR_ARCHITECTURE=AMD64	PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 58 Stepping 9, GenuineIntel	PROCESSOR_LEVEL=6	PROCESSOR_REVISION=3a09	ProductVersion=11.0	ProgramData=C:\ProgramData	ProgramFiles=C:\Program Files	ProgramFiles(x86)=C:\Program Files (x86)	ProgramW6432=C:\Program Files	PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\	PUBLIC=C:\Users\Public	pythonpath=C:\Program Files (x86)\Python27	SESSIONNAME=Console	SystemDrive=C:	SystemRoot=C:\Windows	TEMP=C:\Users\CLOUDC~1\AppData\Local\Temp	TMP=C:\Users\CLOUDC~1\AppData\Local\Temp	USERDOMAIN=Cloudcon2-PC	USERNAME=Cloudcon2	USERPROFILE=C:\Users\Cloudcon2	windir=C:\Windows
TSQLLog 1.18 2014-05-12T10:20:50

20140512 10205014 EXC   ESQLite3Exception ("no such module: rtree") at 0000000000612D57 
20140512 10205014 EXC   ESQLite3Exception ("no such module: rtree") at 0000000000612D57

Any Sugestions ?

Thanks again

cloudcon · mORMot 1

I Solved the problem with the error.
Download
http://sourceforge.net/p/zeoslib/code-0 … lite/Win64
But, Now I receive the error.

windir=C:\Windows
TSQLLog 1.18 2014-05-12T01:18:50

20140512 01185047 EXC   ESQLite3Exception ("near \",\": syntax error") at 0000000000612D17 
20140512 01185749 EXC   ESQLDBException ("TSQLDBSQLite3ConnectionProperties.MultipleValuesInsert() Prepare(INSERT INTO PeopleExternal (Key,FirstName,LastName,YearOfBirth,YOD,Value,LastChange,CreatedAt) VALUES (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?))") at 0000000000742F1C 
20140512 01185749 EXC   ESQLDBException ("TSQLDBSQLite3ConnectionProperties.MultipleValuesInsert() Prepare(INSERT INTO PeopleExternal (Key,FirstName,LastName,YearOfBirth,YOD,Value,LastChange,CreatedAt) VALUES (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?))") at 0000000000742F1C 
20140512 01185749 warn  Test failed 
20140512 01185749 fail  TTestExternalDatabase(00000000002FAAF0) External database: External via REST "" stack trace API

The full log

D:\Dev\Synopse\SQLite3\TestSQL3.exe 0.0.0.0 (2014-05-12 01:13:22)
Host=CLOUDCON2-PC User=Cloudcon2 CPU=4*9-6-14857 OS=13.1=6.1.7601 Wow64=0 Freq=1948730
Environment variables=ALLUSERSPROFILE=C:\ProgramData	AMDAPPSDKROOT=c:\Program Files (x86)\AMD APP\	APPDATA=C:\Users\Cloudcon2\AppData\Roaming	BDS=c:\program files (x86)\embarcadero\rad studio\11.0	BDSAppDataBaseDir=BDS	BDSBIN=c:\program files (x86)\embarcadero\rad studio\11.0\bin	BDSCOMMONDIR=C:\Users\Public\Documents\RAD Studio\11.0	BDSINCLUDE=c:\program files (x86)\embarcadero\rad studio\11.0\include	BDSLIB=c:\program files (x86)\embarcadero\rad studio\11.0\lib	BDSPLATFORMSDKSDIR=C:\Users\Cloudcon2\Documents\RAD Studio\SDKs	BDSPROFILESDIR=C:\Users\Cloudcon2\Documents\RAD Studio\Profiles	BDSPROJECTSDIR=C:\Users\Cloudcon2\Documents\RAD Studio\Projects	BDSUSERDIR=C:\Users\Cloudcon2\Documents\RAD Studio\11.0	CATALINA_HOME=C:\apache	CG_64_BOOST_ROOT=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\include\boost_1_50	CG_BOOST_ROOT=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\include\boost_1_39	CLASSPATH=C:\Program Files\Java\jdk1.6.0_25\bin	CommonProgramFiles=C:\Program Files\Common Files	CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files	CommonProgramW6432=C:\Program Files\Common Files	COMPUTERNAME=CLOUDCON2-PC	ComSpec=C:\Windows\system32\cmd.exe	DELPHI=c:\program files (x86)\embarcadero\rad studio\11.0	DEMOSDIR=C:\Users\Public\Documents\RAD Studio\11.0\Samples\	FP_NO_HOST_CHECK=NO	HOMEDRIVE=C:	HOMEPATH=\Users\Cloudcon2	IBREDISTDIR=C:\Users\Public\Documents\InterBase\redist\InterBaseXE3	IB_Protocol=rad_xe4	InterBase=C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\InterBaseXE3	JAVA_HOME=C:\Program Files\Java\jdk1.8.0	LOCALAPPDATA=C:\Users\Cloudcon2\AppData\Local	LOGONSERVER=\\CLOUDCON2-PC	NUMBER_OF_PROCESSORS=4	OS=Windows_NT	Path=C:\Users\Public\Documents\InterBase\redist\InterBaseXE3\win32_togo;C:\Users\Public\Documents\InterBase\redist\InterBaseXE3\win64_togo;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\Redist\boost\win64;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\Redist\boost\win32;C:\Program Files\Java\jdk1.8.0\bin;C:\Python27\;D:\app\Cloudcon2\product\11.2.0\client_1\bin;C:\Program Files (x86)\Embarcadero\RAD Studio\10.0\bin;C:\Users\Public\Documents\RAD Studio\10.0\Bpl;C:\Program Files (x86)\Embarcadero\RAD Studio\10.0\bin64;C:\Users\Public\Documents\RAD Studio\10.0\Bpl\Win64;C:\Program Files (x86)\Embarcadero\RAD Studio\7.0\bin;C:\Users\Public\Documents\RAD Studio\7.0\Bpl;C:\Program Files (x86)\CollabNet;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin;C:\Users\Public\Documents\RAD Studio\11.0\Bpl;C:\Program Files (x86)\Embarcadero\RAD Studio\11.0\bin64;C:\Users\Public\Documents\RAD Studio\11.0\Bpl\Win64;c:\Program Files (x86)\AMD APP\bin\x86_64;c:\Program Files (x86)\AMD APP\bin\x86;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Python27	PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.py;.pyw	PROCESSOR_ARCHITECTURE=AMD64	PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 58 Stepping 9, GenuineIntel	PROCESSOR_LEVEL=6	PROCESSOR_REVISION=3a09	ProductVersion=11.0	ProgramData=C:\ProgramData	ProgramFiles=C:\Program Files	ProgramFiles(x86)=C:\Program Files (x86)	ProgramW6432=C:\Program Files	PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\	PUBLIC=C:\Users\Public	pythonpath=C:\Program Files (x86)\Python27	SESSIONNAME=Console	SystemDrive=C:	SystemRoot=C:\Windows	TEMP=C:\Users\CLOUDC~1\AppData\Local\Temp	TMP=C:\Users\CLOUDC~1\AppData\Local\Temp	USERDOMAIN=Cloudcon2-PC	USERNAME=Cloudcon2	USERPROFILE=C:\Users\Cloudcon2	windir=C:\Windows
TSQLLog 1.18 2014-05-12T01:18:50

20140512 01185047 EXC   ESQLite3Exception ("near \",\": syntax error") at 0000000000612D17 
20140512 01185749 EXC   ESQLDBException ("TSQLDBSQLite3ConnectionProperties.MultipleValuesInsert() Prepare(INSERT INTO PeopleExternal (Key,FirstName,LastName,YearOfBirth,YOD,Value,LastChange,CreatedAt) VALUES (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?))") at 0000000000742F1C 
20140512 01185749 EXC   ESQLDBException ("TSQLDBSQLite3ConnectionProperties.MultipleValuesInsert() Prepare(INSERT INTO PeopleExternal (Key,FirstName,LastName,YearOfBirth,YOD,Value,LastChange,CreatedAt) VALUES (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?), (?,?,?,?,?,?,?,?))") at 0000000000742F1C 
20140512 01185749 warn  Test failed 
20140512 01185749 fail  TTestExternalDatabase(00000000002FAAF0) External database: External via REST "" stack trace API 00000000005CFC82 00000000005D6DDA 00000000005B6FAB 00000000007FA659 00000000007F87F5 00000000005B885B 00000000008225D3 000000000082C37A 00000000773059ED 000000007753C541 
20140512 01185749 warn  Test failed 
20140512 01185750 fail  TTestExternalDatabase(00000000002FAAF0) External database: External via REST "" stack trace API 00000000005CFC82 00000000005D6DDA 00000000005B6FAB 00000000007FA6B1 00000000007F87F5 00000000005B885B 00000000008225D3 000000000082C37A 00000000773059ED 000000007753C541 
20140512 01185750 warn  Test failed 
20140512 01185750 fail  TTestExternalDatabase(00000000002FAAF0) External database: External via REST "" stack trace API 00000000005CFC82 00000000005D6DDA 00000000005B6FAB 00000000007FA76A 00000000007F87F5 00000000005B885B 00000000008225D3 000000000082C37A 00000000773059ED 000000007753C541 
20140512 01185750 warn  Test failed 
20140512 01185750 fail  TTestExternalDatabase(00000000002FAAF0) External database: External via REST "" stack trace API 00000000005CFC82 00000000005D6DDA 00000000005B6FAB 00000000007FA829 00000000007F87F5 00000000005B885B 00000000008225D3 000000000082C37A 00000000773059ED 000000007753C541 
20140512 01185942 EXCOS EAccessViolation (00000000C0000005) at 00000000007FAB36

Any Suggestions ?
Thanks guys

cloudcon · mORMot 1

Good night,
I'm trying to install Framework in Delphi XE4 and am getting the error "ESQLiteException 'no such module: rtree.'"
When trying to compile the module
2.4 after the "Regex-Function"

Windows 7 64bits Ultimate
Synopse framework used: 1:18
SQLite3 engine use: 3.7.16
Delphi's XE4 64bit
The download link was made by
http://synopse.info/files/SQLite3-64.7z

Any idea what could be the error?

mORMot Open Source

#1 mORMot 1 » TSQLDBOracleLib error: OCI-21560: argument 10 is null, invalid, or out » 2015-03-21 23:16:51

#2 Re: mORMot 1 » [FIXED]'http.sys URI registration error #32 for http://+:8080/root' » 2015-03-21 21:43:40

#3 mORMot 1 » [FIXED]'http.sys URI registration error #32 for http://+:8080/root' » 2015-03-21 21:13:31

#4 mORMot 1 » Building WMS » 2015-03-21 15:49:46

#5 Re: mORMot 1 » Exception on Install mORMot ESQLiteException 'no such module: rtree' » 2014-05-12 20:50:14

#6 Re: mORMot 1 » Exception on Install mORMot ESQLiteException 'no such module: rtree' » 2014-05-12 18:09:45

#7 Re: mORMot 1 » Exception on Install mORMot ESQLiteException 'no such module: rtree' » 2014-05-12 13:33:35

#8 Re: mORMot 1 » Exception on Install mORMot ESQLiteException 'no such module: rtree' » 2014-05-12 04:20:43

#9 mORMot 1 » Exception on Install mORMot ESQLiteException 'no such module: rtree' » 2014-05-12 03:34:43

Board footer