Search:

Type: Posts; User: pzhao

Search: Search took 0.00 seconds.

  1. Duydx, When you develop stored procedures, you...

    Duydx,

    When you develop stored procedures, you must decide if they are to be partitioned or not, in which case it will run as a multi-partition transaction. If the procedure needs to access data...
  2. Replies
    1
    Views
    233

    Duydx, Doumentation (http://docs.voltdb.com/)...

    Duydx,

    Doumentation for VoltDB contains alot of the information you are looking for. There is also a search if you need to find something specific. If you find something you need further help on,...
  3. Replies
    2
    Views
    87

    duydx, Did you do jar the class files after...

    duydx,

    Did you do jar the class files after javac? It appears you were able to compile properly using javac. I was able to compile your code properly as well.
    Here is a guide on...
  4. Gopals, I suspect there is more to the crash...

    Gopals,

    I suspect there is more to the crash then just this warning message. Within your working directory, there should be a log/volt.log file present you can check.
    Alternatively, you can run...
  5. Gopals, Added, you could define row limits on...

    Gopals,

    Added, you could define row limits on tables to prevent over utilizing heap size.

    Peter
  6. GopalS, Ultimately, an undersized Java heap...

    GopalS,

    Ultimately, an undersized Java heap memory (VOLTDB_HEAPMAX) leads to VoltDB crashing due to not enough heap memory or VoltDB performance will suffer due to java garbage collection being...
  7. Replies
    8
    Views
    1,472

    Challagal, My name is Peter from VoltDB. I'd...

    Challagal,

    My name is Peter from VoltDB. I'd love to help you out with your setup.

    Suggestions/questions:
    What version of voltdb is being run?
    Try simpler setup to just prove that,voltdb is...
  8. Replies
    5
    Views
    321

    Sirin, One suggestion is to check if swapping...

    Sirin,

    One suggestion is to check if swapping is enabled using the command 'swapon -s'. Memory swapping is enabled by default for most linux distributions and hinder VoltDB performance.

    Here...
  9. Replies
    5
    Views
    321

    Sirin, Thanks for your response. Could you do...

    Sirin,

    Thanks for your response. Could you do a simple count(*) on your 'store' table just to verify the row count?
    Added, would it be possible to send us all the necessary files via zip so that...
  10. Replies
    5
    Views
    321

    Sirin, I think our best approach here is to...

    Sirin,

    I think our best approach here is to reproduce this problem. Just a few questions/information I'd like to gather:

    After 1.6billion rows, can you validate that there are indeed values...
  11. Replies
    1
    Views
    152

    Duydx, Can you send show me your deployment...

    Duydx,

    Can you send show me your deployment file? It appears the userid is not present in your deployment.xml file.
  12. Replies
    2
    Views
    415

    Racerx, There are 2 things you could do. One...

    Racerx,

    There are 2 things you could do. One option is to put callprocedure1/callprocedure2/dootherimportantthings in one stored procedure. This will either all succeed or all fail. The other...
  13. Replies
    2
    Views
    459

    Ghalia, It seems like the port being used is...

    Ghalia,

    It seems like the port being used is either not listening or being used for something else, ie another application.
    Please verify that voltdb is running, ie 'ps aux | grep voltdb' or...
  14. Replies
    3
    Views
    559

    Thiago, Sorry for the late reply to your...

    Thiago,

    Sorry for the late reply to your question.

    Here is a quick example of assumeunique index:
    CREATE TABLE T38
    (
    C INTEGER
    C6 DECIMAL ASSUMEUNIQUE NOT NULL
    , CONSTRAINT...
  15. Replies
    3
    Views
    376

    Alessandro, In order for you to use the...

    Alessandro,

    In order for you to use the updateApplicationCatalog method in java, you'd need to modify your deployment. Sorry but not being clear about how to modify it.

    In the deployment file,...
  16. Replies
    3
    Views
    376

    Alessandro, Thanks for your question. It seems...

    Alessandro,

    Thanks for your question. It seems that you have our release of community voltdb from github. You are correct, Voltdb will 'on the fly' update the catalog with the...
  17. Replies
    2
    Views
    2,080

    Munkhdalai, For development, you are free to...

    Munkhdalai,

    For development, you are free to use your favorite ide/editor like eclipse, emacs, etc.

    For management, Voltdb has VEM, voltdb enterprise management, only available in the...
  18. Replies
    4
    Views
    3,294

    Munkhdalai, Jdbc driver is now included in our...

    Munkhdalai,

    Jdbc driver is now included in our server/client kit, specifically voltdb/voltdbclient-n.n.jar for the client. An example of its use can be found in examples/voter.
    Here is...
  19. Replies
    4
    Views
    552

    Victor, If its possible, can you send us your...

    Victor,

    If its possible, can you send us your catalog.jar file, we could take a closer look.
    Please send to support@voltdb.com
    Thanks.

    -Peter
  20. Replies
    4
    Views
    552

    Victor, I was able to replicate a similar...

    Victor,

    I was able to replicate a similar error using our voter example application:
    ../../bin/sqlcmd --query="select top ? * from votes"
    VOLTDB ERROR: HSQL-BACKEND ERROR
    Number of...
  21. Replies
    4
    Views
    552

    Victor, Thanks for your question. I'm taking a...

    Victor,

    Thanks for your question. I'm taking a look at it and let you know shortly.

    -Peter
  22. Replies
    5
    Views
    1,006

    Paul, Thats great! Just to clarify, the...

    Paul,

    Thats great! Just to clarify, the default partitioning column value is the first parameter. However, it does not need to be the first parameter.

    So in your original code,

    the...
  23. Replies
    5
    Views
    1,006

    Paul, Thanks for your question. I've engaged...

    Paul,

    Thanks for your question. I've engaged an engineer for some help on this issue. We are investigating and will get back to you shortly.
    As for 'are you missing anything?', you are definitely...
  24. Thread: Stored procedure

    by pzhao
    Replies
    1
    Views
    575

    Antociam, You most definitely can. You'll...

    Antociam,

    You most definitely can.
    You'll need to add 'import class <external class>' to your ddl.sql or database schema file. Please refer to example voltcache in voltdb folder which imports an...
  25. + Thanks for your question. One option is to...

    +

    Thanks for your question. One option is to create a user which has in its' Path variable the JAVA_HOME pointed to right version of java\bin.
Results 1 to 25 of 25