Announcement

Collapse
No announcement yet.

Is it possible to create tables on the fly using java client and connecting to DB instead of using sqlcmd

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is it possible to create tables on the fly using java client and connecting to DB instead of using sqlcmd

    I was looking at https://docs.voltdb.com/UsingVoltDB/SchemaTables.php for creation of table in VoltDB.

    But my use case is where I do not know the table schema before hand. A user might want to create new table and put some data into it.
    So I wanted to create the schema using the Client like it is used for stored procedures. Please let me know if that is possible? if yes, any documentation would be great.

    Thanks in advance,
    Nitiraj.

  • #2
    You can send DDL using JDBC, or other clients using our @AdHoc system procedure.
    https://docs.voltdb.com/v4docs/Using...sprocadhoc.php

    Just note that DDL and other SQL can't be mixed in a single transaction at this time.

    Comment

    Working...
    X