473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

how to get the cursor values in java

kaleeswaran
132 100+
hi!
how to get a cursor values inside the java.i written procedure for getting 3 columns values like menuName,menuId,targetUrl it depends upon menuId so i am getting bulk values so i am using cursor for that.now how to fetch these values inside the java...
thank you,
klaeeswaran
Dec 3 '07 #1
5 2184
heat84
118 100+
hi!
how to get a cursor values inside the java.i written procedure for getting 3 columns values like menuName,menuId,targetUrl it depends upon menuId so i am getting bulk values so i am using cursor for that.now how to fetch these values inside the java...
thank you,
klaeeswaran

Do you mean the cursor of a ResultSet or some other cursor?
Dec 3 '07 #2
kaleeswaran
132 100+
thank you for your reply,
but i don't have knowledge in mysql in ref cursor...
i need to get the cursor values inside the procedure into java...
ill follow if you giving any instruction
thank you,
kaleeswaran
Dec 4 '07 #3
thank you for your reply,
but i don't have knowledge in mysql in ref cursor...
i need to get the cursor values inside the procedure into java...
ill follow if you giving any instruction
thank you,
kaleeswaran
refer the applet coding to get the position of cursor
Dec 4 '07 #4
kaleeswaran
132 100+
hi!
i am not able to understand about the applet coding...
can u give me a brief thing....
thank you,
kaleeswaran
Dec 6 '07 #5
heat84
118 100+
I think a jdbc tutorial can be helpful. Are you getting the values from a ResultSet/ Select query or not?
Dec 6 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Jim Garrison | last post by:
Oracle has a tech article describing how a Java stored procedure can return a REF CURSOR: http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/refcur/index.html Here's the...
0
by: Prashanth | last post by:
I am getting this error from BEA DB2 Driver in weblogic console. java.sql.SQLException: CURSOR C02 NOT IN A PREPARED STATE java.sql.SQLException: CURSOR C02 NOT IN A PREPARED STATE We keep...
10
by: technocrat | last post by:
Hi, I am trying to declare and cursor and thn load from that cursor into another table. Since I have almost 4 million records, I cant do it without the cursor which reduces the time by almost...
1
by: Jim Garrison | last post by:
Oracle has a tech article describing how a Java stored procedure can return a REF CURSOR: http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/refcur/index.html Here's the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.