voltdb drop procedure，create procedure

最新推荐文章于 2023-05-03 20:28:39 发布

转载最新推荐文章于 2023-05-03 20:28:39 发布 · 109 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2308739/blog/665026

本文介绍了如何使用SQL命令删除已定义的存储过程及其对应的类文件，并详细阐述了通过类文件创建存储过程的过程，包括打包存储过程到Jar文件、加载到数据库及声明存储过程的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

一、删除预先定义的的procedure

The following example removes the definition of the FindCanceledReservations stored procedure, then

1.1 uses remove classes to remove the corresponding class.

$ sqlcmd

1> DROP PROCEDURE FindCanceledReservations;
2> remove classes "*.FindCanceledReservations";

1.2 删除加载的class

3> remove classes com.hpe.procedures.Insertprocedure_service_t;
Command succeeded.

二、利用class 文件创建存储过程

$ jar cvf storedprocs.jar *.class

Once you package the stored procedures into a Jar file, you can then load them into the database using the sqlcmd load classes directive. For example:

$ sqlcmd
1> load classes storedprocs.jar;

Finally, we can declare the stored procedure in our schema, in much the same way simple stored procedures are declared. But this time we use the CREATE PROCEDURE FROM CLASS statement, specifying the class name rather than the SQL query.

We can also partition the procedure on the People table, since all of the queries are constrained to a specific value of State_num, the partitioning column. Here is the statement

we add to the schema.

CREATE PROCEDURE
PARTITION ON TABLE people COLUMN state_num
FROM CLASS UpdatePeople;

Notice that you do not need to specify the name of the procedure after "CREATE PROCEDURE" because, unlike simple stored procedures, the CREATE PROCEDURE FROM CLASS statement takes the procedure name from the name of the class; in this case, UpdatePeople.

Go ahead and enter the CREATE PROCEDURE FROM CLASS statement at the sqlcmd prompt to bring your database up to date:

$ sqlcmd
1> CREATE PROCEDURE
2> PARTITION ON TABLE people COLUMN state_num
3> FROM CLASS UpdatePeople;

转载于:https://my.oschina.net/u/2308739/blog/665026