Search:

Type: Posts; User: bballard

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    2,452

    VoltDB uses the TIMESTAMP datatype, which...

    VoltDB uses the TIMESTAMP datatype, which includes date and time. You can insert a date string in the format 'YYYY-MM-DD' into a timestamp datatype column and it will default the time to 00:00:00. ...
  2. Replies
    2
    Views
    143

    In general, this is not recommended for a few...

    In general, this is not recommended for a few reasons:
    - It could cause issues with determinism
    - i/o will slow the execution of the procedure

    It would be better to use export. You could...
  3. Can you provide the rest of the SQL statement? ...

    Can you provide the rest of the SQL statement? Line number 15 is just the line that begins the statement, but the error could be anywhere in the statement.
  4. Hi Arthur, We'd love to help you with a POC. ...

    Hi Arthur,

    We'd love to help you with a POC. This is a question that might be best handled with a discussion. Could you contact me directly to set up a call to go over this.

    I will try to...
  5. Hi Edson, Thanks, we're interested in your...

    Hi Edson,

    Thanks, we're interested in your results. Please ask us to review your tests further if you get lower than expected performance. We're happy to take the conversation private if you...
  6. Hi Edson, It looks like your Test.java class...

    Hi Edson,

    It looks like your Test.java class creates a new client object, connects to one node of VoltDB, calls a single procedure using a synchronous call, then closes the connection.

    VoltDB...
  7. No, you don't need to call drain() before sending...

    No, you don't need to call drain() before sending more requests. In our example applications, drain() is called at the end of the run to ensure that all the responses are received before the...
  8. Hi Stijn, Stefano will assist you. I was...

    Hi Stijn,

    Stefano will assist you. I was typing this earlier and got interrupted, but it may still be useful.

    There isn't a way to call one stored procedure from another. If the work can be...
  9. Replies
    3
    Views
    654

    HD.Users.Boss.voltdb-4.2.voltdb may be a java...

    HD.Users.Boss.voltdb-4.2.voltdb may be a java package name that is somehow inadvertently generated from your directory structure /HD/Users/Boss/voltdb-4.2/voltdb

    It doesn't make sense that this...
  10. Hi Kadafi, You can follow the instructions...

    Hi Kadafi,

    You can follow the instructions linked above to install the tar.gz distribution of VoltDB Enterprise Edition, which includes a 30-day trial license. You can download the precompiled...
  11. Replies
    13
    Views
    2,369

    Hi Derek, This seems like a lot of boilerplate...

    Hi Derek,

    This seems like a lot of boilerplate java code to queue and execute 2 SQL statements, but I assume you have your reasons for that. I don't see any reason why it wouldn't work correctly...
  12. Hi Sabrina, We recommend setting sitesperhost...

    Hi Sabrina,

    We recommend setting sitesperhost to somewhere between 1/2 to 3/4 of the total number of cores (counting 2x for CPUs with hyperthreading), but it's always good to experiment to see...
  13. Hi Sabrina, There is an explanation of...

    Hi Sabrina,

    There is an explanation of Synchronous vs. Asynchronous procedure calls in the Performance Guide here: https://voltdb.com/docs/PerfGuide/Hello2Async.php

    Take a look especially at...
  14. Replies
    13
    Views
    2,369

    Hi Paul, I tried some variations and found a...

    Hi Paul,

    I tried some variations and found a few things. I'm going to revise what I wrote above on 3/21 about there being two ways to reuse SQLStmt objects, there is really only one way that...
  15. Replies
    13
    Views
    2,369

    I'm able to reproduce this. I'll get back to you...

    I'm able to reproduce this. I'll get back to you later today.
  16. Replies
    13
    Views
    2,369

    Hi Paul, The VoltProcedure.voltQueueSQL()...

    Hi Paul,

    The VoltProcedure.voltQueueSQL() method is an object method, not static, so when it is called within a normal stored procedure, it is equivalent to "this.voltQueueSQL(...);". From the...
  17. Replies
    13
    Views
    2,369

    Hi Paul, Thanks for bringing this to our...

    Hi Paul,

    Thanks for bringing this to our attention. Can you use a broader wildcard as a workaround? I'll have our engineering team review this as a potential bug in the wildcard matcher.
    ...
  18. Replies
    13
    Views
    2,369

    Thanks for sharing that link, Paul. That is from...

    Thanks for sharing that link, Paul. That is from a while ago when we did not have some features such as the IMPORT CLASS statement, and the only way to make java code that was outside of a stored...
  19. Replies
    5
    Views
    1,079

    Hi FloM, Yes, this can also work with the...

    Hi FloM,

    Yes, this can also work with the Python client. If you refer to the Python Client README file, it mentions that parameters can be arrays (or lists). You declare the VoltProcedure...
  20. Replies
    13
    Views
    2,369

    Hi Paul, There are two ways you can re-use...

    Hi Paul,

    There are two ways you can re-use SQLStmt objects.

    One is you can have a "Base" Stored Procedure that extends VoltProcedure and defines a number of reusable SQLStmt objects, and then...
  21. Replies
    5
    Views
    1,079

    There are some notes about using "WHERE column IN...

    There are some notes about using "WHERE column IN ?;" syntax in Using VoltDB, App. B - SELECT (https://voltdb.com/docs/UsingVoltDB/sqlref_select.php) about halfway down the page.

    For example, if...
  22. Replies
    2
    Views
    578

    Hi Martin, The interface between a stored...

    Hi Martin,

    The interface between a stored procedure (running in java) and the SQL Execution Engine (running in C++) is when you call voltExecuteSQL(). At that point, the queued statements and...
  23. Replies
    2
    Views
    1,005

    Thanks for the files. For the benefit of forum...

    Thanks for the files. For the benefit of forum readers, here is a summary of the issue.

    When security is enabled, VEM should automatically choose a user from the xml file that it will use itself...
  24. Replies
    2
    Views
    1,005

    Hi, There is no configuration to indicate to...

    Hi,

    There is no configuration to indicate to VEM which user account to use, but it should choose one of the users in the file that has sufficient privileges. I'd like to try to reproduce the...
  25. VoltDB 4.0 requires Sun or Open JDK version 7. ...

    VoltDB 4.0 requires Sun or Open JDK version 7. You will need to install JDK 7, then recompile stored procedure java classes and the catalog.
Results 1 to 25 of 83
Page 1 of 4 1 2 3 4