Servlets :: Database Connection And Tomcat

Mar 15, 2015

I am trying to make a simple login using netbeans, derby database included in netbeans and tomcat server. I made everything nice and separated: I have a model package with a class called DbConnector that has the following method:

public Connection connect() {
try {
return DriverManager.getConnection(url, user, pass);
} catch (SQLException ex) {
return null;
}
}

Then i have another class, an userDAODB that has a password check method:

public boolean checkPassword(String user, String password) {
try (Connection con = new DbConnector().connect(); Statement stmt = con.createStatement()) {
//checks the password in the database

In the main method of this class i tested everything, it works very nice, logs me in, other methods work too, no problem what so ever.But then i go to my servlet:

public class LoginTest extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
String username = request.getParameter("username");
String pass = request.getParameter("pass");
UserDAODB userDAO = new UserDAODB();
boolean authe = userDAO.checkPassword(username, pass);

[code]....

So when i start the webpage and i try to click on the login button I get a NullPointerException com.model. UserDAODB. check Password (User DAODB. java:14) - so line 2 here

I have been googling a bit, i placed the derby.jar and the derbyclient.jar in the lib directory of tomcat, i tried to modify the context.xml of my application, but then it wouldn't even start anymore.

View Replies


ADVERTISEMENT

Servlets :: Closing DB Connection Retrieved From Connection Pool

Jan 11, 2015

I configured a connection pool in tomcat 7. For every database activity I get a connection from the pool. Do I have to close the connection like other regular connection after the database operation is done? If I close the connection will it have any effect on the connection pool?

View Replies View Related

Servlets :: Tomcat Basic Authentication

Mar 30, 2015

I moved some static html pages I was hosting from apache into tomcat. (no point in running two servers) This works as expected, but I'm having trouble with the authentication part. In apache the authentication was handled by htaccess. I tried various tutorials on the web about configuring basic authentication in tomcat using WEB-INF/web.xml in tomcat, but I'm not sure this approach applies to static html pages. Using basic authentication for static html in tomcat?

View Replies View Related

Servlets :: Request Resource Is Not Available In Tomcat

Jul 13, 2014

i was i a program for Execute JSP Page.Inside Tomcat Conf Server File i add following path:

<Context path = "JSPTEST"
docBase="D:Tomcat 8.0webappsJSPTEST">
</Context>
</Host>
</Engine>
</Service>
</Server>

and this is my Jsp page program:

<html>
<head>
<title>Hello World Example in Jsp</title>
</head>
<body>
<h1>

[code]....

but same error is repeting:The request resourse is not available.

View Replies View Related

Servlets :: Download Large Files Using Tomcat

Oct 8, 2014

We have a website used for downloading large files as large as 6gb and sometimes larger. We have all files in FTP server. The websit is JSP/Servlet /Tomcat combination. Below is code sample. I need a solution to increase the download speed. I understand it is bound to network bandwidth but are the steps that we need to take while we have such large files.I read about multipart downloads,gunzip streaming.

//first connect to FTP server and login and keep connection
Calendar cal=Calendar.getInstance();
startTime=cal.getTime();
fis=ftp.downloadFile(ftpclient,separator+resourceID);
response.setContentType("application/*");
response.setHeader("Content-Disposition", "attachment; filename="" + downloadFileName + "";");
byte[] bytes = new byte[1024];

[code]....

View Replies View Related

Servlets :: IE And Firefox Use GET After HTTPS Redirect With TOMCAT 7

Jun 3, 2014

I have a simple application ( only 2 JSPs files and one servlet the main components the whole webapp directory is attached ), I am using security constraint to redirect the user to HTTPS instead of HTTP when he submit from first page to the second page.

The problem is when the user submit the first page I get the error HTTP Status 405 - HTTP method GET is not supported by this URL although I m using only POST.

I have traced the firefox browser using httpfox and the result was the first HTTP request was done using POST correctly but after redirect the browser send GET.

This problem appears with FireFOx and IE but doesnot appear with google chrome.

index.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="myTags" tagdir="/WEB-INF/tags" %>
<html>
<head>
<title>Welcome Page</title>
<link href="css/style.css" type = "text/css" rel="stylesheet" />

[Code] ......

View Replies View Related

Servlets :: Getting HTTP Status 404 Error In Tomcat

Feb 26, 2014

Below is my Servletclass code

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class MyFirstServlet extends HttpServlet {

[Code] .....

I have configured tomcat7 in my ecclipse ide...

View Replies View Related

Connection To A Database In Its Own Class

Jan 15, 2015

I was wondering if I could take the following code and somehow put the connection to database in it's own class without the "public static void main(String[] args)" method. That way I could call it anytime i want to open a connection to the database.

Java Code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Sample {
public static void main(String[] args) throws ClassNotFoundException

[Code] ....

View Replies View Related

Database Connection In Java

Oct 27, 2014

I'm using oracle 10g Database and Java 'jdk1.7.0_45' version.I have to a create program to insert data into a table.

View Replies View Related

JSF :: Which Way Is Better For Holding Database Connection Parameters

Sep 16, 2014

I'm using JSF framework. I can let Netbeans to create the persistence unit and hardcodes connection parameters into the persistence.xml file or i can use resource tag in context.xml file or using another file like property file or class for holding connection parameters like username and password; what is the most secure way or expert way to use connection properties in my app or there is no difference?

View Replies View Related

How To Create A New Java Class For Database Connection

Jan 15, 2015

I have a shop and I use visual studio.net to create an Inventory application to manage my shop. So I am familiar with vb.net codes.

Now, I'm trying to built another Inventory application for my shop using java, 'coz now I'm using Linux Ubuntu for my OS desktop and there's no visual studio.net in linux.

So in vb.net, there's a module that I use for database connection that I can call from any form that I needed.

I searched google for the equivalent module for java and there is none. But, there's an example that use a new java class.

Here's the code in MySQLConnect.java :

Java Code:

public class MySQLConnect {
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/dbInventory";
static final String USER = "root";
static final String PASS = "root";
public static Connection ConnectDb() {

[Code] ....

View Replies View Related

Unable To Create A Connection In JSP Program To MSSQL Database

Oct 7, 2014

i have a problem in connecting my jsp program in MSsql 2005 i want to create a connection in my jsp program to MSsql database but theres an error of my work here is my code

Code:

PHP Code:

<%@ page import="java.util.*" %>
<%@ page import="javax.sql.*;" %>
<%@ page import="java.sql.*;" %>
<%@ page import="java.util.Enumeration;" %>
<html>
<head><title>Sample MS connection</title></head>

[Code]...

View Replies View Related

Error While Making Connection With Remote Oracle Database

May 21, 2014

I am trying to make connection with oracle database but when i run java file it's raise an error

"classnotfoundexception oracle.jdbc.driver.oracledriver"
 
DriverManager.getConnection(
  "jdbc:oracle:thin:@erp:1521:ORCL", "apps",
  "apps");

View Replies View Related

JDBC :: No Suitable Driver Found For Oracle Database Connection

Jul 10, 2015

I have small Java code, which execute every day and checks for data in database using Cronj Schedular and everything works fine, but recently I have observed that, it is failing due to
  
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.110.xx.xxx:1521/test
 
At the same time, when I run my test code to check Database connectivity that works fine without above exception. I'm unable to figure it out. Although, there was just slight code change, but that was nowhere related to Database or Database connection.  
 
dbconf.java
    public class dbconf {
    private Connection connect;
    private String connstr;
    public Connection getConnection() throws SQLException {
    connstr = "jdbc:oracle:thin:@160.110.xx.xxx:1521/test";

[Code] .... 
 
Application Log file
 
    Wed Jul 01 09:25:17 IST 2015:------- Initializing -------------------
    Wed Jul 01 09:25:17 IST 2015:------- Scheduling Jobs ----------------
    Wed Jul 01 09:25:17 IST 2015:------- Job Started Running ----------------
    Thu Jul 02 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.xxx.67.xxx:1521/test
    Sat Jul 04 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    Sun Jul 05 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.xxx.67.xxx:1521/test
 
So, you can see, It failed on 3rd of July and 5th July as well. But, in between it ran fine.

View Replies View Related

Java Servlet :: Using Custom Listener To Initialize Database Connection

May 25, 2012

I am trying to use a custom listener to initialize database connection pool (C3P0) on start up and then destroy on context shut down. The reason for that is that I whenever context is shutdown I have a memory leak because initialized connection pool is not being destroyed.

I have a static class called C3P0Utils that deals with connection pool. In my listener in contextInitialized method I have tried at first to init the pool like this :

+public void contextInitialized(ServletContextEvent sce) {+
+try {+        
C3P0Utils.newInstance().init();
+} catch (PropertyVetoException ex) {+
Logger.getLogger(DatabaseInit.class.getName()).log(Level.SEVERE, null, ex);
+}+
+}+

I know that object is created. I checked it using jconsole. However it is not accessible with in the application. My second attempt was to regester the pool and then add it to the context and then when I need it read from there.

+public void contextInitialized(ServletContextEvent sce) {+
+try {+
ServletContext ctx=sce.getServletContext();
C3P0Utils.newInstance().init();
ctx.setAttribute("myDataSource", C3P0Utils.newInstance().getDataSource());
+} catch (PropertyVetoException ex) {+
Logger.getLogger(DatabaseInit.class.getName()).log(Level.SEVERE, null, ex);
+}+
+}+

However when I try to red from the context I get nothing. I try to read like this.

+(ComboPooledDataSource)ctx.getAttribute("myDataSource")+

When I print names of all of the attributes in the context I get these attributes.

Context Name

org.apache.tomcat.InstanceManager
org.apache.catalina.jsp_classpath
javax.servlet.context.tempdir
org.apache.catalina.resources
+org.apache.tomcat.JarScanner
+org.apache.jasper.compiler.TldLocationsCache
+org.springframework.web.context.WebApplicationContext.ROOT

Why I can not use anything initialized in the listener.

View Replies View Related

Enterprise JavaBeans :: No Connection Left In WebLogic Database Pool

Jun 19, 2014

We have a J2EE business web application that runs in WebLogic. We noticed in application log files errors messages that seems like  "No resource available in db pool", it means all the connection objects (to Oracle database) are used. Then the application is unstable and unseable.

I think the maximum number of  connections configured in Weblogic pool has been reached due to an increase of users and activity. But when the workload decreases the application is still out of service. It seems connections objects are not relased to the pool. What can be the explanation for this issue ? Normally it is managed by the container (EJB3 for the business tier).

Once the limit of the pool is reached it is necessary to restart the server to solve this kind of error ?

View Replies View Related

Web Services :: Share JDBC Datasource Connection Among All Servlets

Apr 20, 2015

I am new to java. I have recently learned JDBC connection pool in tomcat. To make code reuse I want to share the connection among all servlets without any conflict.

Here My code snippet:

public class GetConnection{
private DataSource ds;
public Connection getConnection(){
try {
InitialContext initialContext = new InitialContext();
Context context = (Context) initialContext.lookup("java:comp/env");
ds = (DataSource) context.lookup("connpool");

[Code] .....

Is this right way to do. Or I will get any problem due to concurrent threads.

View Replies View Related

Establish Connection Using Connection Pool And Retrieve Username

Sep 1, 2014

I have created a JSP page, on click of a particular button, the control moves to the servlet "TestServlet".

This is the code under TestServlet:

import java.io.IOException;
import java.io.PrintWriter;
import java.security.Principal;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

[Code]...

Now, I have got a comment saying I should get the database connection from connection pool. And one more issue is that I have used the function System.getProperty("user.name") to get the username which i have logged in. But this code will be run on Unix which will not support this function. Any function where I can get the windows username. There is a function getUserPrincipal(), but this function returns a NULL. How to resolve this.

View Replies View Related

Servlets :: How To Set Values Into JSP Page From Database

May 30, 2014

I want to set the values coming from database with multiple field's Through AJAX and Custom XML. How to do ???

View Replies View Related

Servlets :: Insert Data To The Database?

Apr 4, 2014

i am stucked with a little error in servlets

this is my jsp page
form.jsp
<form action="InsertData" method="post" >
username:<input type="text" name="username">
Password :<input type="password" name="password">

[Code]....

i am getting wroor page not foung 404

View Replies View Related

Servlets :: Errors Referring To Old Database

Apr 21, 2014

I implemented the new DB, I have changed all the variables accordingly. When I execute the website, I get errors and it keeps referring to the old db.

Using sql langauge, the website has been implemented in Java.

View Replies View Related

Servlets :: File Not Getting Retrieved From Database

May 12, 2014

I want to retrieve file from database which is stored with blob datatype and i am passing manually id associated with in code. Its not retrieving the file.

public class retrieve_image extends HttpServlet
{
/**
*
*/
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ResultSet rs = null;

[Code] .....

View Replies View Related

Servlets :: Data Is Not Getting Inserted Into Database

Mar 26, 2015

I am trying to insert data using servlet but it is not getting into database.

I have a two JSP's form from which i enter the data and using servelt trying to insert the data into database.

JSP page code:

1.add_question_list.jsp
<script language="JavaScript">
function validate(form) {
if (form.question.value == "") {

[code]...

View Replies View Related

Servlets :: Insert Data To Database?

Aug 2, 2014

How can we insert data through java servlet?

I can insert data to table by using JSP Scriptlet easily but I have a hard time with servlet.

public class UsertToDatabase() {
public boolean inserUser(String name, String email, String pwd) throws SQLException {
PreparedStatement pstmt = null;
boolean flag = false;
System.out.println("start");
openConn();
System.out.println("start_1");
if(conn == null) {

[code]....

I am positive that the above code function fine. The problem is whenever I call UserToDB() class inside the servlet, and I got this error: java.lang.ClassNotFoundException: org.postgresql.

Driver which mean that my conn (connection) is not connected to the database but I have ensure to do so by calling openConn() before start the transaction.

This is my servlet code:

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
String email = request.getParameter("email");
String password = request.getParameter("password");
List<String> errList = new ArrayList<String>();

[code]....

View Replies View Related

Servlets :: Print The Result From The Database

Jul 7, 2014

here is the code,

ResultSet rs = result.executeQuery(selectsql);
int columns = rs.getRow();
while(rs.next()){

[Code].....

I can print out the result correctly, there are three rows of result from the database, but they are shown in one row on the browser, how could i show the result one row after another to let it looks pretty?

View Replies View Related

Servlets :: Access List Of Database Records Using JSP?

Apr 3, 2014

How we can get the list of records from database my sql using jsp pages and servlets so that it show results on webpage.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved