Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Java Essentials >> Java Programming

problem in running a program in java mysql

i have a lot of nested java programs, individual testting results are ok, how ever, the following results occur when i combine those codes, do you have any idea about this? sorry about this but i hope you can help me.... thanks in advance....

false

true

java.sql.SQLException: Illegal operation on empty result set.

at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)

at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)

at checkvalidity.tesdiscode(checkvalidity.java:44)

at forplay.play(forplay.java:7)

at test1.main(test1.java:27)

false

java.sql.SQLException: Illegal operation on empty result set.

at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)

at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)

at checkvalidity.tesdiscode(checkvalidity.java:44)

at forplay.play(forplay.java:19)

at test1.main(test1.java:27)

java.sql.SQLException: Illegal operation on empty result set.

at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)

at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)

at checkvalidity.tesdiscode(checkvalidity.java:44)

at forplay.play(forplay.java:31)

at test1.main(test1.java:27)

java.sql.SQLException: Illegal operation on empty result set.

at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)

at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)

at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)

at checkvalidity.tesdiscode(checkvalidity.java:44)

at forplay.play(forplay.java:34)

at test1.main(test1.java:27)

Sorry, you have submitted an invalid promo code. Please try again. To send more

entries text SMB PLAY <Promocode> to 2622. Ex. SMB Play abcd123. To start playin

g games log-on to www.smbplay.com/activ8 Create ur group, play & win as a team,

text SMB GROUP to 2622. To learn mre abt this promo text SMB HELP. Mre points, m

re games, mre chances of winning! Promo pd is fr Jul 1?6 ?Jul 1 ?7. BFAD#dean

silver. P2.50/txt

C:\jwork\smbcode>javac test1.java

test1.java:24: ')' expected

System.out.println(checkvalidity.tesdiscel("639155510003");

^

1 error

[2527 byte] By [memnoch_iia] at [2007-10-2 22:06:31]
«« Generating an IOException When Closing a Socket/ServerSocket
»» hashcode()
# 1
without seeing the code, my guess is that you are iterating through the result set in one section of code then other code you combined with it is trying to iterate through it as well. if i'm not mistaken, i THINK once you iterate through a result set, you cannot re-iterate though...
muzica at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 2
your missing a ')' somewhere in your test1.java file. Just like the compiler says.JJBTW, you should follow the Java [url= http://java.sun.com/docs/codeconv/html/CodeConvTOC.doc.html]Code Conventions[/url]. Your class name is not complient.
Java_Jaya at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 3
i thought about that as well Java_Jay. but there's a stack trace like something had execute.Memnoch_ii: did you combine two outputs?
muzica at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 4

about this code:

C:\jwork\smbcode>javac test1.java

test1.java:24: ')' expected

System.out.println(checkvalidity.tesdiscel("639155510003");

^

1 error

i solved this one, the upper is the problem, i made a class for handling mysql - inputting and retrieving datas, the other classes are handling conditional outputs and the actual outputs. the later part of the output is, however, correct, the text that i prepared for the condition class... but still, the problem is that there are a lot of sql exceptions that i don't understand, i do appreciate if you help me more, thank you, by the way, how can i give out duke dollars for the guys who helped me?

memnoch_iia at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 5
how to set session in servlet & jsp with example .how to mentain session in jsp & servlet.thanks in advance.pl'z replay fast.
nimishaa at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 6
> how to set session in servlet & jsp with example .> how to mentain session in jsp & servlet.> thanks in advance.> pl'z replay fast.Why did you post this in a year old unrelated thread?
macrules2a at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 7
how to create sesion in jsp & servlet pl'z give me replay with example.hoe to manage session.thanks in advanse.
nimishaa at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
# 8

> how to create sesion in jsp & servlet pl'z give me

> replay with example.

> hoe to manage session.

> thanks in advanse.

Well, you're quite the stupid little fuckwit aren't you?

Cross-post hijacking

http://forum.java.sun.com/thread.jspa?threadID=495547

cotton.ma at 2007-7-14 1:23:12 > top of Java-index,Java Essentials,Java Programming...
Java Essentials
Java Programming

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified