nevermind, i've figured it out on my own...
On Sunday, January 20, 2002, at 03:15 AM, olizedobar wrote:
> hello, i'm getting the following (very annoying) error when trying to do
> a simple mysql connection from a jsp on tomcat 4:
>
> java.lang.NumberFormatException: mysql
> at java.lang.Integer.parseInt(Integer.java:414)
> at java.lang.Integer.parseInt(Integer.java:463)
> at
> org.apache.jasper.compiler.Compiler.getJspLineErrors(Compiler.java:321)
>
> why on earth is the compiler trying to convert the 'mysql' string in my
> database url?!
> i'm using the following code, which works perfectly from a servlet:
>
> try {
>
> Class.forName("org.gjt.mm.mysql.Driver");
>
> connection =
> DriverManager.getConnection("jdbc:mysql://mymachine/somedb",
> "mysql","password");
>
> String sql = "select * from table;";
>
> PreparedStatement ps = connection.prepareStatement(sql);
>
> ResultSet result = ps.executeQuery();
>
> ResultSetMetaData rsmd = result.getMetaData();
>
> while (result.next()) {
>
> int i=0;
>
> Object obj = result.getObject(i);
>
> if (obj != null) {
> fields[i] = obj.toString();
> } else {
> fields[i] = "no entry";
> }
> }
>
> ps.close();
> connection.close();
>
> } catch (SQLException e) {
>
> out.println("sql error: " + e.getMessage() + "\n");
>
> }
>
> any help would be greatly appreciated... man, how I hate debugging
> jsp... what a waste of time.
>
> -oliver
>
> =========================================================================
> ==
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
