Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc value retrieval from a bean and then from a jsp  RSS feed

 
Shehzad Khan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello everyone
i am trying to call database values from a bean and then ultimately want to display them from a jsp but the error "java.sql.SQLException: no data found" arising everytime.
what to do? please help. my database name is ppp.mdb and it is placed in d:\jakarta-tomcat-4.0-b5\examples\jsp\ppp.mdb
in here, i have two tables with the name a)conference and b)shuttles
in the conference table, i have four field which i am writing in the following order: field_name:field_type
1)ID:integer
2)city:String
3)airport:String
4)seats:integer
the ConnectionBean class code is the same that i have posted previously
however i have changed conference1.jsp a bit.
so the code of conference1.jsp is pasted here.
i want to tell that i have tomcat server and the path for both .java and .jsp is as follows:
d:\jakarta-tomcat-4.0-b5\webapps\examples\web-inf\classes\babaji\ch_7\ConnectionBean.java
d:\jakarta-tomcat-4.0-b5\webapps\examples\jsp\conference1.jsp


please help and let me know the solution for this error
thanks, wating anxiously for the reply
bye
take care
from Shehzad Khan
[ Edited by Dave to format code and fix UBB smilies ]
[ January 31, 2002: Message edited by: David O'Meara ]
 
Napa Sreedhar
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Everrthing seems to be fine...
But a look up.. Chek the dbURL in your connection bean class... Is it OK ?
Napa
 
Napa Sreedhar
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And one more suggestion use PreparedStatement in your bean class.
I heard some where that Statement doesn't work out for regular expressions.
Napa
 
Shehzad Khan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello everybody
thanks a lot mr.napa sreedher, for your kind suggestion. but still no use.
i kindly request you mr. napa and also request to anyone that you run this code which i have given here on your pc if you have some time and let me know whether it is running alright or not.
ok take care
bye
from shehzad khan
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!