wood burning stoves 2.0*
The moose likes JDBC and the fly likes Stored Procedure in Hypersonic Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored Procedure in Hypersonic " Watch "Stored Procedure in Hypersonic " New topic
Author

Stored Procedure in Hypersonic

Nitin Agarwal
Greenhorn

Joined: Dec 15, 2005
Posts: 9
Hi derby,

I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.

Also please help me with this problem too - I am passing a string value to a query. If I pass the string value "Teamwork" i get the desired result. But when i pass "teamwork" i get no value in return.
Is there any way to make the query run ignoring the case of the string value i pass?


Thanks
Nitin
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41096
    
  44
Hello-

(Not sure whom you are addressing as "derby" - many people read this forum.)

HSQLDB does not have stored procs in the common sense, but you can call methods written in Java. The user guide has an example that demonstrates how to do that. It's also possible to define triggers written in Java (see the TriggerSample class).


Ping & DNS - my free Android networking tools app
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by Nitin Agarwal:
Hi derby,

I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.

Also please help me with this problem too - I am passing a string value to a query. If I pass the string value "Teamwork" i get the desired result. But when i pass "teamwork" i get no value in return.
Is there any way to make the query run ignoring the case of the string value i pass?


Thanks
Nitin


Nitin,

stored procedures and everything else are covered in the hypersonic documentation, which is onlne, here:
http://hsqldb.org/web/hsqlDocsFrame.html

Yes, hsqldb supports stored procedures, but not in the usual way. Instead you create an alias to a java function; it's in the documentation.

Yes, by default string matching is case-sensitive, if you want case-insensitive matching, you have to use a function such as upper() or lower() to force your data to match. These functions are in the documentation as well.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored Procedure in Hypersonic
 
Similar Threads
Derby and HSQLDB
Problem with IN clause
Problem with stored procedure in Hibernate
Create stored procedure in hssql
CLOBS