Can I still use stored procedures (Sybase) ?

hi, links, examples, etc welcome, fairly new to JSC...

I have retrieved data from table via query/rowset and have used setText calls to populate my fields... not sure if this is the best way... not sure how to 'bind' my fields to the rowset so I did it that way..

can I now use existing stored procedure in the db to save from my form, and if so, how do I associate my form/fields to my stored proc? how do define my proc on my page? anyone have an example?

or is it easier to bind data to my db table w/o using sp?

thanks in advance -

[571 byte] By [yukhntr] at [2007-11-26 9:33:34]

«« Error in SWUP/Cacao Register system
»» Use Ajax to call method in session bean?

# 1

Yep..You can use it by creating a dataprovider. Pass the values as a List from the Stored Proc to the Dataprovider and set the list.Lots of example code in the forum. Search for it.DK

Deepakarun at 2007-7-7 0:21:30 >

top of Java-index,Development Tools,Java Tools...

# 2

Creator doesn't support stored procedures call, you can use CachedRowset to propagate your data then call acceptChanges()

lucylucy at 2007-7-7 0:21:30 >

# 3

can I use the same cachedrowset I used to save it and I did to retrieve it or do I need to create a new one? can you outline? thanks

yukhntr at 2007-7-7 0:21:30 >

# 4

this will help. http://developers.sun.com/prodtech/javatools/jscreator/reference/techart/2/inse rt_row_in_table.html

lucylucy at 2007-7-7 0:21:30 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Can I still use stored procedures (Sybase) ?

Development Tools New Topic

Development Tools Hot Topic

Development Tools

All Classified