HTTP Eroor 500- unable to compile jsp class | Java Community | Help. Code. Learn. | Page 1

novel tide Dec 24, 2022, 2:27 PM

#

Hi.... I am getting Http error 500...unable to compile jsp class while trying to connect my project to Mysql db through eclipse....it seems to be an issue with the out.print statement in my index.jsp file coz when I remove that statement...other jsp files are running on localhost as expected....hope someone could help?

P:s - I read somewhere that there shouldn't be any statement with ; in jsp file so how do I correct line 15 in my index.jsp file as in image below:

lime fiberBOT Dec 24, 2022, 2:27 PM

#

⌛ This post has been reserved for your question.

Hey @novel tide! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

novel tide Dec 24, 2022, 2:28 PM

#

How to correct line 15 in my index.jsp file

#

This is my DbCon.java file

outer heath Dec 24, 2022, 2:30 PM

#

What's the compilation error

novel tide Dec 24, 2022, 2:30 PM

#

I am getting Http error 500...unable to compile jsp class while trying to connect my project to Mysql db through eclipse....it seems to be an issue with the out.print statement in my index.jsp file coz when I remove that statement...other jsp files are running on localhost as expected....

P:s - I read somewhere that there shouldn't be any statement with ; in jsp file so how do I correct line 15 in my index.jsp file as in image below:

outer heath Dec 24, 2022, 2:30 PM

#

Share the stack trace here?

novel tide Dec 24, 2022, 2:31 PM

#

Ok

novel tide Dec 24, 2022, 2:34 PM

#

outer heath Share the stack trace here?

outer heath Dec 24, 2022, 2:43 PM

#

Issue is dbcon isn't initialised anywhere

#

Not related to semicolons

#

You just stated using a variable called dbcon without declaring it

novel tide Dec 24, 2022, 2:56 PM

#

Ok

novel tide Dec 24, 2022, 2:58 PM

#

outer heath Issue is dbcon isn't initialised anywhere

Pls lemme know how do I declare it...in index. jsp..... I have just started learning java or coding....appreciate it

outer heath Dec 24, 2022, 3:03 PM

#

https://stackoverflow.com/questions/39122273/how-to-get-mysql-query-result-in-jsp-page

Stack Overflow

how to get mysql query result in jsp page?

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection(url, "root", "");
// assuming your SQL Server's username is "username" // and password is "password"

Statemen...

#

Note this isn't very good design but I assume you don't care about that at the moment

novel tide Dec 24, 2022, 3:04 PM

#

Yes...i just wanna make a connection to my db(rough project

outer heath Dec 24, 2022, 3:04 PM

#

Look at the example in this stackoverflow question and the accepted answer

novel tide Dec 24, 2022, 3:05 PM

#

Ok....checking now

novel tide Dec 24, 2022, 3:20 PM

#

@outer heath Thanks so much.... It's working now, all errors gone 🙂

outer heath Dec 24, 2022, 5:27 PM

#

novel tide <@1027970087656902757> Thanks so much.... It's working now, all errors gone 🙂

No problems, close the post when done

#HTTP Eroor 500- unable to compile jsp class