[Hsqldb-user] stored procedure

[Weiquan Y. <wei...@gm...>]

hi, guy:
  I started hsqldb in client server mode, I wrote my customized pubic
static method and put into /org/hsqldb/Benefit.class, so I can
successfully run this stored procedured
========
CALL
"org.hsqldb.Benefit.RT_BL_EMPLOYEE_LIFERATE"('M','25')
======================================

and then I tried to use alias for this stored procedure

=======
CREATE ALIAS RT_BL_EMPLOYEE_LIFERATE FOR
"org.hsqldb.Benefit.RT_BL_EMPLOYEE_LIFERATE"
===========

so I can run without problem
===========

CALL
 RT_BL_EMPLOYEE_LIFERATE('M','25')
=================

but after I shut down the server, and then reconnect it , I can't run
============
CALL
 RT_BL_EMPLOYEE_LIFERATE('M','25')

=================

1. how can I keep my alias for stored procedure even after restarting server?
2. Can I run my stored procedure in in process mode? such as file:hsql

-- 
Weiquan Yuan
Phone: (613) 552-6665
Email: wei...@gm...