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


ADVERTISEMENT

Java Servlet :: Connection Pool And Context

Jan 23, 2013

I am working on netbeans IDE , but I understand how the application know the parametres for the connections. I understand what is a Context , specifically i understand this code about the init method

Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
servicioConexiones = (DataSource) envCtx.lookup("jdbc/bd_tutorias");

I want to know how the application knows to use these connection parameters, on the Context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/tutorias_pag480">
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
maxActive="8" maxIdle="4" name="jdbc/bd_tutorias" password="mysqladmin"
type="javax.sql.DataSource" removeAbandoned="true"
url="jdbc:mysql://localhost:3306/bd_tutorias" username="root"/>
</Context>

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

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

Custom Listener - How To Separate Interactors

Jan 12, 2014

my application shows a profile. The profile has various interactors. I'm trying to follow the MVC model, so I neeed to tell my controller that something was selected. But the profile has many elements that can be selected(mostly labels, so not setActionCommand), how do I tell it WHICH one was it?

how do I separate those interactors? I created a HashMap that maps from JLabels to Strings. When a mouse event occurs I loop trough it to search for the event source. If I find it I fire my custom event.

View Replies View Related

Java Servlet :: Unable To Send Data From JSP To Oracle Database

Jan 31, 2013

I'm creating a web applicaion. for that i want to create a registration page. and this registration details have to be stored in the database.

I'm getting the below error while trying to send the data ...

The requested resource (/cmd/InsertRegtodb) is not available.

Here cmd is project name and InsertRegtodb is servlet name.

Actually the servlet is present is the mentioned address. but it is not connecting to it

There is one more servlet in the same folder and which is accessible from another jsp. But this servlet is not accessible even though i have used same code as it is used for the servlet which worked for me previously...

View Replies View Related

Java Servlet :: Storing Images In Folder And Their Relative Paths In MySQL Database

Nov 16, 2012

I am developing an web application with servlets and jsp. I have an issue to store images. I am storing images in folder and their relative path's in mysql database.

When I retrieve path from database then using <IMG> tag i have displayed image like:

     out.println("<td><img src="+user.getPlaceImage()+" width='70' height='50' /></td>");

It is working fine with internet explorer but not working (that is Not displaying image) in chrome/mozilla.

How to display that image in all browsers....

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

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

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 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

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

Java Servlet :: Showing Error While Compiling Servlet

Jan 23, 2013

I am a beginner want to compile servlet with following path

javac -classpath Program FilesApache Software FoundationTomcat 5.5commonlibservlet-api.jar;classes:.-d classes srccomexamplewebBeerSelect.java

Problem arises as follows:

javac: invalid flag: FilesApache
Usage: javac <options> <source files>
use -help for a list of possible options

View Replies View Related

JSP :: Display Record From Database And Servlet

Feb 9, 2015

<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import = "java.util.Iterator" %>
<%@page import ="java.util.List" %>
<%@ page import="com.asal.training.rasha.servlet.*" %>

[Code] ....

it displays table every time i will run the server ? gives the data twice and so on

View Replies View Related

Unable To Insert Date Into Database Using JSP Servlet

May 13, 2014

date.jsp

<form action="insertDateServlet" method="post">
Name: <input type="text" name="name">
<label for="from">Available Date</label>
<input type="text" id="from" name="from">
<label for="to">Final date</label>
<input type="text" id="to" name="upto"><br>
<input type="submit" name="submit">
</form>

blank values are going to database

insertDateServlet.java
String name= request.getParameter("name");
String Available_from = request.getParameter("from");
String Available_Upto = request.getParameter("upto");
Sql query="insert into db values(?,?,?)";

[Code]...

View Replies View Related

Insert Multiple Values Of Checkbox Into Database Using JSP Servlet

May 12, 2014

As I am new in java, JSP and DATABASE...

<form action="Insert_Values_Servlet" method="post">
<label><strong>Title</strong></label>
<input type="text" name="Title" placeholder="max 50 characters"/><br>
<label><strong>Profession</strong></label>
<input type="text" name="Profession" placeholder="Ex.Manager"/> <br>
<input type="checkbox" value="LifeStyle" id="slideOne" name="check" />
<label for="slideOne">LifeStyle</label><br />

[Code]...

This is my insert.jsp page I want to insert multiple values into database Including multiple values of checkbox, other values are getting inserted but only problem at selecting multiple checkbox values in same column and radio button value in same column.

---------------------look for servlet page below----------------

Connection con = null;
ResultSet rs = null;
PreparedStatement pst = null;
int user = 0;
String User_Id1 = null;
String Other_Services = "";
String Title = request.getParameter("Title");

[Code]...

Is there any solution to insert this...By mistake in query I have followed with extra questionmark in following line This is correctline for inserting 5 values in database

String insertinfo = "INSERT into offer_data (Title,Profession, Other_Services ,Area, City) values(?,?,?,?,?)";

View Replies View Related

JSP :: Saving User Information In Database Via Saveuser Servlet

May 3, 2014

I am making my minor project on a money management website. One problem is occurring:

As we are registering via register.jsp page, the form in that jsp page calls the "saveuser" servlet which saves the user data in the database.

But the data is not getting saved. Following is the code of register.jsp page:

<!DOCTYPE HTML>
<html>
<head>
<title>Virtual Wallet</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

[Code] .....

View Replies View Related

Insert ImagePath Into Database And Using AJAX / JQUERY In JSP Servlet

May 21, 2014

If user register himself and will go to his own profile then he will be asked upload profile photo at that time when he uploads his photo dynamically... for this I have to insert imageurl/imagepath into table (mysql) using jquery/ajax and image to respective folder depends on userID?

View Replies View Related

GWT 2.4 - File Upload Servlet To Accept CSV And Parse For Insert Into Database

Oct 22, 2014

Creating a file upload servlet to accept a CSV and parse for insert into a database, however, whenever I click submit, it always seems to open a new tab/window. Below is the method I have that builds the upload form: (Using GWT 2.4)

private void buildUpload(){
LayoutContainer headerContainer = new LayoutContainer(new ColumnLayout());
headerContainer.setStyleAttribute("padding", "5px");
add(headerContainer);
NamedFrame hiddenFrame = new NamedFrame("uploadFrame");
final FormPanel form = new FormPanel(hiddenFrame);

[Code] .....

Is there something I'm missing? or something I've added that makes it open a new tab/window?

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 :: 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

Java Client To WCF Service - Secured Connection

Oct 14, 2014

I have created a sample java web service client using Apache Axis. It works well with basicHTTPbinding (without security and Basic authentication).I am not able to make a secured communication. How to make it work in a secured way using NTLM or any other security.

View Replies View Related

JDBC :: Java Oracle Rac Connection URL Using Scan

Dec 30, 2014

I am trying to connect to an oracle rac using jdbc thin . when i use the scan as the host, like this

String url = "jdbc:oracle:thin:@//<scan>:port/servicename;

I get error 1153, connection refused

but when i use the ip of the rac instead of the scan

String url = "jdbc:oracle:thin:@//<ip>:port/servicename;

The connection is successful
 
Is the issue at the application level? or is the problem with the server ....

View Replies View Related

Swing/AWT/SWT :: Possible To Stop And Start A Listener Alternatively In Java Frames?

Dec 3, 2014

I was developed a simple GUI, in that it requires modification of jtextfield content while JComboBox item selected and vice-versa. I was used itemListener on JComboBox and Document Listener on JTextField. It was gives exception while running the code. Because one listener source effected by another one..

Exceptions are like this:

Exception in thread "AWT-EventQueue-0" java.lang.IllegalStateException: Attempt to mutate in notification
at javax.swing.text.AbstractDocument.writeLock(Unknown Source)
at javax.swing.text.AbstractDocument.replace(Unknown Source)
at javax.swing.text.JTextComponent.setText(Unknown Source)
at ronanki.swing.pcahostsimUI$5.itemStateChanged(pcahostsimUI.java:368)
at javax.swing.JComboBox.fireItemStateChanged(Unknown Source)

[Code] ......

View Replies View Related







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