mrluigi2017

  • mrluigi2017 started the topic Service priority in the forum kbmMW 6 years, 6 months ago

    Hi,

    I have recently added a kbmmw fileservice to my existing server application which contains mainly query services and smart services. I noticed that when I am uploading a large file to the server that the response for a query service is much slower in this case.

    My questions:

    1) Is there any mechanism build in to give priorities to…[Read more]

  • mrluigi2017 replied to the topic File Service in the forum kbmMW 6 years, 7 months ago

    Hi Kim,

    It works 🙂 Just tested it with a 64GB file up and down.

    It is true that I did not anticipate sending huge files (>2GB) back in the days.

    I don’t blame you.

    <table>
    <thead>
    <tr>
    <th>connection type</th>
    <th>Download speed</th>
    <th>Download time h:m:s</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td>Modem</td>
    <td>28,8 kbit/s</td>
    <td><label…[Read more]

  • mrluigi2017 replied to the topic File Service in the forum kbmMW 6 years, 7 months ago

    What exactly do you mean? You can set the blocksize in the kbmMWFileClient. I haven’t figured out yet howto deal with the filesize issue.

  • mrluigi2017 replied to the topic Briefcase example in the forum kbmMW 6 years, 7 months ago

    Hi Job,

    There is a demo that contains brief cases. Not sure if it works or not. It can be found in the demo folder:

    kbmmwDemoBasicClient

     

    Kind regards,

    Luigi

  • mrluigi2017 replied to the topic File Service in the forum kbmMW 6 years, 7 months ago

    The slow transfer issue is solved. I have changed the chunksize to 1048576 and the speed is good now. There is however still an issue with downloading a large file. See the code in the second post. Uploading large files (larger than max int) doesn’t seem to be a problem.

  • mrluigi2017 replied to the topic File Service in the forum kbmMW 6 years, 7 months ago

    I also have an issue that the transfer is very, very slow. I think I am doing something wrong, but I have no clue what it is.

  • mrluigi2017 replied to the topic File Service in the forum kbmMW 6 years, 7 months ago

    I figured out that downloading a large file doesn’t work either. I think the cause is that an int 64 is assigned to an VarArray with varIntegers.

    function TkbmMWFileService.PerformGET

    Result:=VarArrayCreate([0,2],varInteger);

    // Prepare result.
    Result[0]:=FFileToken;
    Result[1]:=ofs; //is an int64
    Result[2]:=sz; // is an int64

    Although I didn’t…[Read more]

  • mrluigi2017 replied to the topic Rewriter questions in the forum kbmMW 6 years, 7 months ago

    I had some issues with the ImportDBSchema as well so I wrote my own tool for Postgres databases. I am not sure if the import tool is fixed by now.

    I have used the kbmMWInterbaseSQLRewriter and it worked for me. It’s also important to connect a kbmMWInterbaseMetaData component to the Rewriter component. The metadata component takes care about…[Read more]

  • mrluigi2017 replied to the topic Rewriter questions in the forum kbmMW 6 years, 7 months ago

    Hi Alexander,

    As far as I know there is no specific documentation on the rewriter. The rewriter is needed when you use the ORM. It rewrites the SQL to match your target database requirements. It compiles on Win64 here without a problem (I am using enterprise) What version do you use? And what error do you get?

  • mrluigi2017 started the topic File Service in the forum kbmMW 6 years, 7 months ago

    Hi Kim,

    I’ve created a fileserver+client with kbmmw and uploading works fine except with large files (the file I tried was  a +5GB zip ). I don’t get any exception it’s just that the file transfer seems to stop after 1.009.617 kb this number is the same every time.

    I have set the MaxFileSize property to zero. Any suggestions what might be the…[Read more]

  • Hi,

    I would like to return a different http statuscode when a wrong parameter is passed to a REST method. If I am not mistaken an internal server error occurs by default. I know I can use:

    kbmMWRaiseHTTPError(407,’….’) or

    raise EkbmMWHTTPException.Create(407,’…’);

    But how do I know that the (rest body) parameter is wrong?

    Thank in advance

    Luigi

  • Hi,

    How do you exclude certain fields from updating when using the ORM? Will setting the modified flag to false will do the trick?

    p.s. All my objects are defined as kbmmwNullable.

     

    Thanks in advance!

     

    Luigi

  • Hi,

    How can I use the same transaction for multiple orm methods? I saw that I can pass a transaction, but I don’t know how to obtain it.

    Thanks in advance.

    Kind regards,

    Luigi

  • If/when will this be available on youtube?

  • Hi Kim,

    After a long search today I found out that I accidentally removed the rewriter from my connectionpool. The exception I got was just an Access Violation, but I think it would be much better if it was more specific.

    Kind regards,

    Luigi

  • Hi,

    In my application I make use of composite objects in combination with the ORM for instance a TPerson having a TAddress property. Which I will use like this:

    Person := ORM.Query<TPerson>([1]);

    Person.Address := ORM.Query<TAddress>([1]);

     

    • Is it correct that I should not create the TAddress in the Create constructor because it will give a…

    [Read more]

  • Hi,

    Is it possible to use kbmMWConfiguration to read and write TObjectlist properties?

    Thanks in advance!

  • mrluigi2017 replied to the topic ORM.QueryList in the forum kbmMW 7 years, 2 months ago

    Never mind. I am just a moron 🙁 The dataset was empty

  • mrluigi2017 replied to the topic ORM.QueryList in the forum kbmMW 7 years, 2 months ago

    I think it’s not a bug. I will open a new topic.

  • mrluigi2017 replied to the topic ORM.QueryList in the forum kbmMW 7 years, 2 months ago

    Any change that there is a bug in the ListFromDataset method as well?

  • Load More