File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes CloudScape Stored Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CloudScape Stored Procedures" Watch "CloudScape Stored Procedures" New topic
Author

CloudScape Stored Procedures

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I'm am searching for a few examples of stored procedures.
#1 a stored procedure that return's a simple result set
(or)
#2 a stored procedure that performs and update
(or)
#3 any other examples would be appreaciated
TIA, Monty6
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi,
Try out the Java Tutorial: http://web2.java.sun.com/docs/books/tutorial/jdbc/index.html
or more specifically: http://web2.java.sun.com/docs/books/tutorial/jdbc/basics/sql.html
You can also download the SQLServer Documentation file from Microsoft at: http://www.microsoft.com/sql/downloads/P51745.htm
Hope this helps.
cheers,
Yoo-Jin.
[This message has been edited by Yoo-Jin, Lee (edited September 18, 2000).]
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Thank-you.
I'm looking for vendor specific code....
Do you know where I can find any vendor specific code examples.
TIA, Monty6
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944

I'm not too sure what vendor server you're interested in, but you could start with SQLServer: http://www.microsoft.com/sql/downloads/P51745.htm
The online help documentation is free for downloading. The online help includes examples for all the sql commands too. I don't know if oracle or db2 doc's are free since I've never used them.
cheers,
Yoo-Jin.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Thanks for the info...
I'm interested in Informix's CloudScape or Oracle 8i
stored procedures code examples.

------------------
We learn more from our mistake than from our successes.
Monty6
Ames Carlson
Greenhorn

Joined: Apr 23, 2001
Posts: 9
There are some pointers available now in the Cloudscape
FAQ at http://www.cloudscape.com/support/faq.jsp.
Look under the SQL topic.
Cloudscape uses Java as its stored procedure language,
and provides Class and Method aliases as a way to
make invoking them in SQL use the same SQL as other
vendors. You simply define a static public method
in a class, and then you can use it in SQL statements;
void methods would use the CALL statements, non-void
methods can also be used as expressions within
statements.
To call back to the database, you connect using the
standard jdbc:default:connection JDBC URL, and
then use JDBC to access the database, on the same
connection as the caller. You can also open new
connections (the Cloudscape tutorial shows examples
of doing this).
Hope this helps, and apologies for not finding
this forum until now...
Ames Carlson
ames.carlson-at-informix.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CloudScape Stored Procedures
 
Similar Threads
How resultset is returned by stored procedure?
Calling stored procedures from hibernate
stored procedure inside another stored procedure
Create stored procedure in hssql
Retrieve Stored Procedure Code