473,324 Members | 2,257 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,324 software developers and data experts.

cannot fetch data from mysql database

8
i have written a jsp code which fetches data from mysql database. it performs insertion operation correctly but it fails while fetching the data.
i am getting error on line which contains getString() function.

please help.
Jun 19 '07 #1
4 2756
r035198x
13,262 8TB
i have written a jsp code which fetches data from mysql database. it performs insertion operation correctly but it fails while fetching the data.
i am getting error on line which contains getString() function.

please help.
And what is the error that you get?
Jun 19 '07 #2
sssk28
8
And what is the error that you get?
the eroor is:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /test/index2.jsp:111

108: <%
109: while(rs1.next())
110: {
111: family=rs1.getString("family");
112: {
113: %>
114: <option value="<%=family%>"><%=family%></option>


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServletWrapper.servic e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.service(jaspe r5-compiler-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)

root cause

java.io.CharConversionException
gnu.gcj.convert.Input_iconv.read(libgcj.so.7rh)
java.lang.String.init(libgcj.so.7rh)
java.lang.String.<init>(libgcj.so.7rh)
com.mysql.jdbc.SingleByteCharsetConverter.<init>(S ingleByteCharsetConverter.java:153)
com.mysql.jdbc.SingleByteCharsetConverter.initChar set(SingleByteCharsetConverter.java:108)
com.mysql.jdbc.SingleByteCharsetConverter.getInsta nce(SingleByteCharsetConverter.java:86)
com.mysql.jdbc.Connection.getCharsetConverter(Conn ection.java:3471)
com.mysql.jdbc.Field.getStringFromBytes(Field.java :598)
com.mysql.jdbc.Field.getName(Field.java:502)
com.mysql.jdbc.ResultSet.buildIndexMapping(ResultS et.java:615)
com.mysql.jdbc.ResultSet.findColumn(ResultSet.java :946)
com.mysql.jdbc.ResultSet.getString(ResultSet.java: 5613)
org.apache.jsp.test.index2_jsp._jspService(index2_ jsp.java:161)
org.apache.jasper.runtime.HttpJspBase.service(jasp er5-runtime-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)
org.apache.jasper.servlet.JspServletWrapper.servic e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.service(jaspe r5-compiler-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
Jun 19 '07 #3
r035198x
13,262 8TB
the eroor is:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /test/index2.jsp:111

108: <%
109: while(rs1.next())
110: {
111: family=rs1.getString("family");
112: {
113: %>
114: <option value="<%=family%>"><%=family%></option>


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServletWrapper.servic e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.service(jaspe r5-compiler-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)

root cause

java.io.CharConversionException
gnu.gcj.convert.Input_iconv.read(libgcj.so.7rh)
java.lang.String.init(libgcj.so.7rh)
java.lang.String.<init>(libgcj.so.7rh)
com.mysql.jdbc.SingleByteCharsetConverter.<init>(S ingleByteCharsetConverter.java:153)
com.mysql.jdbc.SingleByteCharsetConverter.initChar set(SingleByteCharsetConverter.java:108)
com.mysql.jdbc.SingleByteCharsetConverter.getInsta nce(SingleByteCharsetConverter.java:86)
com.mysql.jdbc.Connection.getCharsetConverter(Conn ection.java:3471)
com.mysql.jdbc.Field.getStringFromBytes(Field.java :598)
com.mysql.jdbc.Field.getName(Field.java:502)
com.mysql.jdbc.ResultSet.buildIndexMapping(ResultS et.java:615)
com.mysql.jdbc.ResultSet.findColumn(ResultSet.java :946)
com.mysql.jdbc.ResultSet.getString(ResultSet.java: 5613)
org.apache.jsp.test.index2_jsp._jspService(index2_ jsp.java:161)
org.apache.jasper.runtime.HttpJspBase.service(jasp er5-runtime-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)
org.apache.jasper.servlet.JspServletWrapper.servic e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(jasper5-compiler-5.5.17.jar.so)
org.apache.jasper.servlet.JspServlet.service(jaspe r5-compiler-5.5.17.jar.so)
javax.servlet.http.HttpServlet.service(tomcat5-servlet-2.4-api-5.5.17.jar.so)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
Ah well some character conversion is failing there. Is your server version a stable one?
Jun 19 '07 #4
sssk28
8
i have installed Fedora Core 6 with MySQL 5.0.22.
Jun 20 '07 #5

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

Similar topics

1
by: Krista | last post by:
Hi guys, i have a problem about inserting data into the table. I dont know why the output always said cannot be added to the database! Anyone has idea for me? i check the connect is ok, but dont...
0
by: AJ Shankar | last post by:
Hi, In the C API, is there any way to execute a query, store all the results, and somehow find the maximum realized width for each of the fields before fetching each row? Otherwise there is no...
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
5
by: gooderthanyou | last post by:
Alright i've looked a ton of topics and most of them are unresolved... configure: error: Cannot find MySQL header files under usr/local/mysql. Note that the MySQL client library is not bundled...
7
by: Bernard Lebel | last post by:
Hello, I'm stumbled at a serious problem, and quite frankly getting desparate. This is a rather long-winded one so I'll try to get straight to the point. I have this Python program, that...
11
by: saurabhbpl | last post by:
hi, i have a html drop down menus and i want to conver it into dynamically means that menu show data from database.how can i fetch data from database for using menus and sub menus using php and...
7
by: asenthil | last post by:
Hai to all, this is senthil... i'm now working in the field of VC++... i want to connect a mysql database... just now tried to retrieve rows from a simple mysql database by using VC++ My...
3
by: Hazza | last post by:
Hi, I am using PHP and mysql to create a website. I am fairly new to PHP, and thus am grateful to anyone who helps! Firstly I am running a homepage, that displays additional content if a user...
1
by: robin1983 | last post by:
Dear All, How are you everyone! I need a help from you all. Firstly, I want to know is it possible to fetch the email details from the Outlook to Excel or Database by using PHP. MS outlook has...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.