Forum: Building VoltDB Applications

Post: Update Cataloge without delete previous data

Update Cataloge without delete previous data
M_A_K687
Sep 5, 2013
Hello everyone,
i want to know that how can i update my catalogue jar file, because in sql statement i create new procedure now i want to update this catalogue file without deleting my current data please help.

currently i am using community addition & testing it on ubuntu64
jpiekos
Sep 5, 2013
See the documentation for the @UpdateApplicationCatalog system procedure. It updates the schema and stored procedures on a running database.
http://voltdb.com/docs/UsingVoltDB/sysprocupdateappcatalog.php

Note that this capability is available in the Enterprise kit only. For the open source version, you must first take a snapshot (to save your data), shutdown the database, and restart with the new catalog.

John