Error when creating store procedure
Feb 14, 2015
Hi everyone,
I want to create a store procedure but I met a problem when trying compile it.
I looking forward to hearing from you.
Sincerely,
I want to create a store procedure but I met a problem when trying compile it.
package voltdb;
import org.voltdb.*;
public class insert_cust extends VoltProcedure {
// TODO Auto-generated method stub
public final SQLStmt sqlAdd = new SQLStmt(
"insert into customer values (?, ?, ?);");
public VoltTable[] run(int id, int number, String text)
throws VoltAbortException {
voltQueueSQL(sqlAdd, id, number, text);
voltExecuteSQL();
return null;
}
}
javac -classpath "./:/opt/voltdb-ent-5.0/voltdb/*" insert_cust.java
[voltdb@voltdb1 voltdb]$ sqlcmd
SQL Command :: localhost:21212
1> load classes insert_cust.jar
2> ;
VOLTDB ERROR: UNEXPECTED FAILURE:
org.voltdb.VoltProcedure$VoltAbortException: insert_cust (wrong name: voltdb/insert_cust)
at org.voltdb.sysprocs.UpdateApplicationCatalog.executePlanFragment(UpdateApplicationCatalog.java:195)
at org.voltdb.ProcedureRunner.executeSysProcPlanFragment(ProcedureRunner.java:812)
at org.voltdb.iv2.Site.executeSysProcPlanFragment(Site.java:885)
at org.voltdb.iv2.SysprocFragmentTask.processFragmentTask(SysprocFragmentTask.java:188)
at org.voltdb.iv2.SysprocFragmentTask.run(SysprocFragmentTask.java:126)
at org.voltdb.iv2.Site.run(Site.java:537)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NoClassDefFoundError: insert_cust (wrong name: voltdb/insert_cust)
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
at java.lang.ClassLoader.defineClass(ClassLoader.java:643)
at org.voltdb.utils.InMemoryJarfile$JarLoader.loadClass(InMemoryJarfile.java:300)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:270)
at org.voltdb.sysprocs.UpdateApplicationCatalog.executePlanFragment(UpdateApplicationCatalog.java:183)
... 6 more
3>
I looking forward to hearing from you.
Sincerely,