can i call the procedure in the hsql ?just like the jdbc.
example: connection.prepareCall("{call sp_zyjs_match()}");
thanks!

No. You can however get the underlying JDBC connection from Hibernate using session.connection() and execute your prepared statement using plain JDBC.

thanks for your reply! i think that you means:
i can use the hibernate to get the db connection.then use the plsql
to call the procedure,do you think i uncerstand what you mean?

another question,as what you said.that means i can mix the hsql and
plsql in my application.do you think it 's performance is well. do you think
the hibernate is better than jdbc?

Hibernate can be better than straight JDBC on two fronts:
1) Productivity of producing a persistance layer for an application. Its excellent when you also consider the level of db vendor indepenence you get.
2) With effective caching, hibernate can execute faster. [This is subjective and depends on the application at hand].