DOES HSQLDB supports storedprocedure?

2010-07-29
2014-01-19
  • Raghu Veesam
    Raghu Veesam
    2010-07-29

    Hi,
    I am Raghu. We are using hsqldb 1.8.0.7.We have stored procedure in oracle and able to test that using oracle database connections successfully.I want to test the same stored procedure using static/In memory database.
    Is it possible to test stored procedure using in memory database?
    Please let me know if any one has any thoughts.

    Thanks,
    Raghu

     
  • Fred Toussi
    Fred Toussi
    2010-07-29

    If you read the Guide on the web site, you will see there is extensive support for stored procedures written in SQL or Java. The SQL/PSM Standard syntax is somewhat different from PL/SQL.

     
  • Fred Toussi
    Fred Toussi
    2010-07-29

    You need to use HSQLDB  version 2.0.

     
  • Raghu Veesam
    Raghu Veesam
    2010-07-29

    Can you please give me sample example how u used stored prosedure  through temp/static/inmemory data base.
    Generally in in memory data database we are having inserts..when we are running Junits..temp table will be created with the data.we wont give any syntax related to  create table to use.

    Ex:
    INSERT INTO TestTable (Column1,column2)  VALUES (1, 'importedData');

    COMMIT;

    When we interact TestTable through Junit TestTableWill be created.
    Any thoughts how we need to give the syntax for stored procedure?

    Thanks,
    Raghu

     
  • Fred Toussi
    Fred Toussi
    2010-07-29

    You can use stored procedures in all types of databases. See the Guide.

     
  • Raghu Veesam
    Raghu Veesam
    2010-07-29

    Which guide?i could not find any thing the syntax to use stored procedure.can u provide me the link?
    In the above example i mentioned inserts to create table in inmemory database not create syntax.
    Thanks,
    Raghu

     
  • Fred Toussi
    Fred Toussi
    2010-07-29

    Go to our web site and click on documentation

     
  • Raghu Veesam
    Raghu Veesam
    2010-07-29

    How can i check my objects(Tables and procedures) when i am using inmemory database?

     
  • Fred Toussi
    Fred Toussi
    2010-07-29

    Use the "script" command or check the information_schema tables.

    Please note that this is the wrong place to ask questions. Also, you need to read the Guide and try out the commands before asking questions.