Home Tutorialhelp Comment Hi, I am investigating the configuration for the

 
 

Comment

Abey
Hi, I am investigating the configuration for the,
January 17, 2007 at 11:28 AM

Hi,
I am investigating the configuration for the DB Connection Pooling described in
http://tomcat.apache.org/tomcat-4.1-doc/printer/jndi-datasource-examples-howto.html for MySQL database.

But I am not sure some parameters:

1. server.xml configuration
Configure the JNDI DataSource in Tomcat by adding a declaration for your resource to $CATALINA_HOME/conf/server.xml.

Add this in between the </Context> tag of the examples context and the </Host> tag closing the localhost definition.

<Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true"
crossContext="true"><!-- Here, I don't know the exact path for me and don't
understand the other parameters -->

<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/><!-- This is probably not that important -->

<Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource"/><!-- So it means that for every database I am using, I need to config it here. Is that right? -->

<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourc#*$!</value>
</parameter>

<!-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. -->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>

<!-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. -->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<!-- MySQL dB username and password for dB connections --> <!-- This part, I can replace them with real username and password of MySQL -->
<parameter>
<name>username</name>
<value>javauser</value>
</parameter>
<parameter>
<name>password</name>
<value>javadude</value>
</parameter>

<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>

<!-- The JDBC connection url for connecting to your MySQL dB. The
autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. -->
<!-- For this, I don't know what is the value for my purpose? -->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>

web.xml configuration
Now create a WEB-INF/web.xml for this test application.

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<description>MySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>I don't understand this. I have some many application programs.
How should I deal with this web.xml configuration?
To configure a DBCP DataSource so that abandoned dB connections are removed and recycled add the following paramater to the ResourceParams configuration for your DBCP DataSource Resource:
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
When available db connections run low DBCP will recover and recyle any
abandoned dB connections it finds. The default is false. Use the
removeAbandonedTimeout parameter to set the number of seconds a dB
connection has been idle before it is considered abandoned.
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
The default timeout for removing abandoned connections is 300 seconds.
The logAbandoned parameter can be set to true if you want DBCP to log a stack trace of the code which abandoned the dB connection resources.
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
The default is false. I probably need to configure this abandoned DB connection recycling mechanism as well.Finally, in order to use the following code:

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.InitialContext;
import javax.sql.DataSource;

public class MyServletJspOrEjb {

public void doSomething() throws Exception {
/*
* Create a JNDI Initial context to be able to
* lookup the DataSource
*
* In production-level code, this should be cached as
* an instance or static variable, as it can
* be quite expensive to create a JNDI context.
*
* Note: This code only works when you are using servlets
* or EJBs in a J2EE application server. If you are
* using connection pooling in standalone Java code, you
* will have to create/configure datasources using whatever
* mechanisms your particular connection pooling library
* provides.
*/

InitialContext ctx = new InitialContext();

/*
* Lookup the DataSource, which will be backed by a pool
* that the application server provides. DataSource instances
* are also a good candidate for caching as an instance
* variable, as JNDI lookups can be expensive as well.
*/

DataSource ds =
(DataSource)ctx.lookup("java:comp/env/jdbc/MySQLDB");

/*
* The following code is what would actually be in your
* Servlet, JSP or EJB 'service' method...where you need
* to work with a JDBC connection.
*/

Connection conn = null;
Statement stmt = null;

try {
conn = ds.getConnection();

/*
* Now, use normal JDBC programming to work with
* MySQL, making sure to close each resource when you're
* finished with it, which allows the connection pool
* resources to be recovered as quickly as possible
*/

stmt = conn.createStatement();
stmt.execute("SOME SQL QUERY");

stmt.close();
stmt = null;

conn.close();
conn = null;
} finally {
/*
* close any jdbc instances here that weren't
* explicitly closed during normal code path, so
* that we don't 'leak' resources...
*/

if (stmt!= null) {
try {
stmt.close();
} catch (sqlexception sqlex) {
// ignore -- as we can't do anything about it here
}

stmt = null;
}

if (conn!= null) {
try {
conn.close();
} catch (sqlexception sqlex) {
// ignore -- as we can't do anything about it here
}

conn = null;
}
}
}
}

Also, I notice that I need to download some jar files for this? what are them exactly?

I am using several databases for my website, do I need to configuration each database for this? like specify the max connection for each database?

Can anybody give me some ideas on this? Is ther any other method for connection pooling?can we edit server.xml stored in a remote server? Thanks very very much!

Regards
Abey
View All Comments | View Tutorial
Advertisement
Related Tutorial and Articles
Development process Questions

hi
hi   i want to develop a online bit by bit examination process as part of my project in this i am stuck at how to store multiple choice questions options and correct option for the question.this is the first project i am doing 

SQL Question

MySql
MySql  what is default password of mySql, and how i configure mySql.   Hi, If you are installing MySQL on windows then you will have to provide the Password for the user root at the installation time. You may try 

Java Beginners

JDBC Configuration in Ubuntu 10.04
JDBC Configuration in Ubuntu 10.04  Hi everybody, Am using Linux Ubuntu 10.04, java jdk 1.6 and mysql 5.1 and I have trouble to load mysql connector and i have no such driver found for dbtest.java. pleas guide me to solve 

Programming Tutorials

MySQL Configuration
MySQL Configuration      ... . The mysql configuration is included with The mysql 5.0 server and mysql also available for only window users. Introduction of configuration wizard The MySQL 

JDBC Questions

how to connect mySql drivers into eclipse(configuration)?
how to connect mySql drivers into eclipse(configuration)?  how to connect mySql drivers into eclipse(configuration)? I need the configuration in eclipse. what do i have to download from mySql and just downloading is enough or do 

JDBC Questions

hi
hi   I have connected mysql with jsp in linux and i have used JDBC connectivity but when i run the program, its not working the program is displaying 

Java Server Faces Questions

hi
hi  sir i've a project on railway reservation... i need to connect netbeans and mysql with the help of jdbc driver... then i need to design the frame... created in mysql at the beggining itself.... i wanted the coding 

Java Beginners

hi
hi  sir i've a project on railway reservation... i need to connect netbeans and mysql with the help of jdbc driver... then i need to design the frame... created in mysql at the beggining itself.... i wanted the coding 

Spring Framework Questions

spring mvc configuration with mysql using jdbc
spring mvc configuration with mysql using jdbc  hai I want to configure web mvc with mysql using jdbc template. when I submit values using registration form it will reflect on database which i was created earlier. send me code 

JDBC Questions

mysql installation problem - JDBC
mysql installation problem  Hi, when i installing mysql server on my pc in MySQL Server Instance Configuration Wizard,I enter the root pw... solution. Thanks in advance   Hi Srikala, I am sending you 

MySQL

MySQL Configuration
MySQL Configuration      ... . The MySQL server configuration normally started during  installation process .  MySQL server configuration wizard window  The MySQL configuration wizard 

Java Beginners

hi.......
hi.......  i've a project on railway reservation... i need to connect netbeans and mysql with the help of jdbc driver... then i need to design... created in mysql at the beggining itself.... i wanted the coding 

SQL Question

mysql - SQL
mysql  hi i am using mysql. i want to create simple table... the the table with foreign key  Hi friend, Code to solve Solve...=INNODB; For more information MySql visit to : http://www.roseindia.net 

JDBC Questions

HI!!!!!!!!!!!!!!!!!!!!!
HI!!!!!!!!!!!!!!!!!!!!!  import java.awt.*; import java.sql....("com.mysql.jdbc.Driver"); Connection con =DriverManager.getConnection("jdbc:mysql://localhost...=con.createStatement(); int i=st.executeUpdate("insert into bankdata(name,pass 

Java Beginners

hi.......
hi.......  import java.awt.; import java.sql.*; import javax.swing.... =DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","admin... from bank where branch='kannur'"); Statement st=con.createStatement(); int i 

Development process Questions

JSP with Mysql
JSP with Mysql  Hi sir, I trying to several time but i am not get an answer. My questions are 1. How to inserting same field data to different mysql table using jsp. That is creating a form with 5 fields,data's are same 

JDBC Questions

xml configuration file - JDBC
xml configuration file  Hi, Could you please tell me how to write a xml configuration file . We have mysql database in some other system. I have... to create a xml file. Please help me out. Thank you  Hi Friend, Try 

JSP Servlet Questions

jsp_mysql
temp=null; try{ String url="jdbc:mysql://localhost:3306/test"; int i=1...jsp_mysql  hi,, plz help me by providing the code for displaying SELECTED columns from mysql table which are given dynamically through checkboxes 

SQL Question

mysql - SQL
mysql  hi sir i want to display first two person highest salary in mysql  Hi I am sending a link where u can find max function to find the maximum marks of student. http://www.roseindia.net/sql/sql-aggregate 

SQL Question

mysql
mysql  How can install My sql drivers using a jar File   Hi you need to download the mysql-connector jar file for connecting java program from mysql database.......   Hi friend, MySQL is open source database 

JDBC Questions

mysql datasource - JDBC
mysql datasource  hello there......... i'm a real beginner for mySql can any one tell me how i do configurations in my windows machine after...,configuration and important mysql executable files etc.This link also contains some mysql 

JDBC Questions

MySql ClassNotFoundException - JDBC
MySql ClassNotFoundException  Dear sir, i am working in Linux platform with MySQL database , actually i finished all installation in MySQL but while i am executing java program i am getting ClassNotFoundException. Can i 

Java Beginners

Hi ..I am Sakthi.. - Java Beginners
Hi ..I am Sakthi..  can u tell me Some of the packages n Sub Directories starts with... import javax.swing.*; import javax._________;  ...;Hi friend, package javacode; import javax.swing.*; import 

SQL Question

schema extraction from mysql
schema extraction from mysql  hi i am completely new to MySql. i need export the data base schema to a text file so that i can use it further. i want... is not working. there is no username. 1)how do i findout username(its not assigned 

JSP Servlet Questions

MySql - JSP-Servlet
MySql  Hello friends, I am developing a JSP project with back end MYSQL and i am using SQLYOG editor enterprise 7.11. I got the serial number also for this version. But, i am not able to found where is the option to register 

JDBC Questions

MySQL connectivity - JDBC
MySQL connectivity  hi all, i am not able to connect Mysql to java ..as i connect it ..i am getting the error ..saying classNotFoundException....... thank u..  Hi friend, This error occur due 

Hibernate-Tutorials

Hibernate Configuration File
to map the persistent class(POJO) file to the configuration. Example : Here I am...Hibernate Configuration File In this tutorial you will learn about the hibernate configuration file. To define a Hibernate Configuration info a resource file 

Java-Tutorials

MySQL NOT IN
using an example. Example Here I am giving a simple example which...MySQL NOT IN In this section we will read about how to use the NOT IN function in MySQL with a simple example. MySQL NOT IN() function specifies 

JDBC Questions

Mysql connector
Mysql connector  Wer can i get mysql-connector? Is it jar or exe file?   Hi Friend, Visit the following link: http://mirrors.ibiblio.org/pub/mirrors/maven/mysql/jars/mysql-connector-java-5.0.5.jar It will provide you 

Struts Questions

Hi - Struts
very urgent....   Hi friend, I am sending you a link...Hi  Hi friends, must for struts in mysql or not necessary please tell me its very urgent....I have a only oracle10g database please let me 

SQL Question

mysql - SQL
mysql  hi i want to export my data from mysql to excel using php script. pls help me  Hi Friend, Please visit the following link: http://www.roseindia.net/sql/mysql-table/mysql-php-select.shtml Thanks 

Java Beginners

Java and MySQL
Java and MySQL   I am doing a project on an accounting system. I need to know to things: How do I write reports using information in an MySQL database . How get multiple MySQL database rows and assign them to variables r 

SQL Question

Foreign key in mysql
Foreign key in mysql  Hi I am creating a website and linking it to a database using php and mysql. I need to create the databases in phpmyadmin... works properly and can be queried using sql? I would really appreciate help 

SQL Question

How to get factorial in mysql
How to get factorial in mysql  Hi, In order to improve the speed of my queries, one in particular tries to find matches between multiple tables, I am trying to use prime numbers to speed the process, but I have been googling 

SQL Question

MySql function - SQL
MySql function  Hi sir/madam, I am creating a function in mysql5.0... correspinding to your MySQL version for right systax' I am using MySQL5.0 version. Please check my code and let me inform what mistake i did. Your help 

WebSevices Questions

MySQL &PHP - WebSevices
MySQL &PHP  Hello, I have write a script to read from a file and than store the values to a mysql. My problem is when I am storing this values in mysql the 1st column is taking 0 value and after this it is storing 

JDBC Questions

mysql problem - JDBC
mysql problem   hai friends i have some problem with image storing in mysql. i.e while i am using image(blob) for insert the image it says... photos. i have use below code for that. try{ Class.forName(driverName 

JDBC Questions

mysql tables - JDBC
mysql tables  hi, I have a table in MySql, having fields, emp_id,emp_name,emp_vertical,emp_supervisor. i need a JDBC program with driver...().myStuff(); } } Rajanikant  Hi, I am sending a link 

SQL Question

MySql,java
MySql,java  In MySQL table i am adding the fields of name,photo,video... maths) but here i am not creating the separate table for each table. tell me... then it automatically save into MySQL.but i am not create the table for that subject 

SQL Question

mysql select statement - SQL
patientdetails1 where id=?   Hi chitra, I am sending select...mysql select statement  i want to select id,name,age values from... a[]) { Connection con = null; String url = "jdbc:mysql 

JDBC Questions

jdbc mysql - JDBC
be problem in your mySql, the above code is working fine. first you check for connection u geeting or not. thanks rajanikant  Hi, I am sending...=DriverManager.getConnection("jdbc:mysql://localhost:3306/ram","root","root 

Struts Questions

Hi
Hi  Hi All, I am new to roseindia. I want to learn struts. I do not know anything in struts. What exactly is struts and where do we use it. Please help me. Thanks in advance. Regards, Deepak 

JSP Servlet Questions

java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql 

JSP Servlet Questions

java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql 

JSP Servlet Questions

java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql 

JSP Servlet Questions

java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql 

JSP Servlet Questions

java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql 

WebSevices Questions

mysql - WebSevices
am getting the same problem!!!!! mysql storing values in column with zero... when I want to store this value in mysql it store 0 first and than 60. My php... tell me again what should I do with this coding and also in mysql Thanks 

SQL Question

Migrating from mysql to MS Access
Migrating from mysql to MS Access  Hi I am hoping for some help I need to write a conversion program (SQL statements) to import existing data in a MYSQL database to a MS Access database. any suggestions would be appreciated 

WebSevices Questions

mysql - WebSevices
when I want to store this value in mysql it store 0 first and than 60...mysql  Hello, mysql storing values in column with zero,but there is no 0.after 0 it is storing my values which i have extract from the file 

XML Questions

hi
online multiple choice examination  hi i am developing online multiple choice examination for that i want to store questions,four options,correct answer in a xml file using jsp or java?can any one help me?   Please 

Java Beginners

mysql-java
mysql-java   i try to execute this code stmt1.executeUpdate("insert... the manual that corresponds to your MySQL server version for the right syntax to use...; hi friend, You are missing the single quote in your sql statement before 

JDBC Questions

hi!
hi!  public NewJFrame() { initComponents(); try { Class.forName("java.sql.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","admin"); } catch(Exception e 

Hibernate Questions

Hibernate giving exception - struts - MySQL - Hibernate
is Asif. I am trying to Run one simple application using NetBeans IDE, and using Struts frame work with hibernate and MySQL database. I am getting exection... Please can anyone help on this. i am working on this from past 3 days 

Java Beginners

Hi
Hi   I need some help I've got my java code and am having difficulty to spot what errors there are is someone able to help import java.util.Scanner; public class Post { public static void main(String[] args) { Scanner sc 

JSP Servlet Questions

connecting jsp to mysql - JSP-Servlet
connecting jsp to mysql  Hi, i am working on 'Web application development' project that uses JSP, MySQL and tomcat.i am not able to connect to the mysql database through jsp. After downloading the mysql-connector-java-5.0   

Development process Questions

hi
storing data in xml file using jsp  hi i am storing data in xml file using jsp.in this when i enter data into xml file i am getting xml declaration for each specified data?can any one help me to prevent this?   < 

Java Beginners

Hi
Hi   I have got this code but am not totally understanding what the errors. Could someone Please help. Thanks in advance! import java.util.Random; import java.util.Scanner; private static int nextInt() { public class 

WebSevices Questions

mysql - WebSevices
mysql  hello all, How can I select one row at a time from 1st table and also from 2nd table and write it to a file line by line. If I use... to a file than its write all rows of second table. I just want to wite a 1st row 

JDBC Questions

java with mysql
java with mysql  Hi, Here is my code: import java.awt.*; import...=DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root...]; // initialize col heads for (int i = 0; i < cols; i 

Struts Questions

Hi i am new to J2ee Technology and struts - Struts
Hi i am new to J2ee Technology and struts  what exatly will happen when we hit the Login button? Once we enter in to the application, what will happen. How the UserID and Password validations will done. Can any one help 

MySQL

Setting up MySQL Database and Tables
Setting up MySQL Database and Tables       I am assuming that you have running instance of MySQL Database and you know how to work with the MySQL database. To access the database 

Hibernate Questions

Could not parse configuration: hibernate.cfg.xml
Could not parse configuration: hibernate.cfg.xml  Hi, I am getting... configuration: hibernate.cfg.xml at org.hibernate.cfg.Configuration.doConfigure... version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration 

JSP Servlet Questions

jsp/mysql connection
jsp/mysql connection  I am puttng the following files in the lib... and in the lib folder of project of netbeans but I am unable to to connect jsp and mysql on wamp server.I am using jdk1.5. mysql-connector-java-5.1.15-bin.jar, mysql 

JSP Servlet Questions

jsp/mysql connection
jsp/mysql connection  I am puttng the following files in the lib... and in the lib folder of project of netbeans but I am unable to to connect jsp and mysql on wamp server.I am using jdk1.5. mysql-connector-java-5.1.15-bin.jar mysql 

JDBC Questions

how to connect mysql from gui?
how to connect mysql from gui?  i am unable to connet to mysql server from my projet that is gui for mysql...can anyone help me in this...its urgent? i have to connet to mysql from gui..   Hi Friend, Try the following 

JSP Servlet Questions

connection with mysql with jstl - JSP-Servlet
connection with mysql with jstl  hi, i m working on jstl . i hv done connection in MS -Access with JSTL . The code is working well. but when i am trying to connect database with mysql 5.0 it is creating problem. Plz tell me 

SQL Question

hi - SQL
hi  hi sir,i want to copy the mysql prompt queries to one text file,how to achieve this ,plz tell me Thanq 

PHP Questions

I am not able to display the selected value of my combobox
I am not able to display the selected value of my combobox   <... units order by unitcode"; $rsrcResult = mysql_query($strQuery); $i=1; $select='<select size=1 name="unitcode">'; while($arrayRow = mysql_fetch 

PHP Questions

retrieve data from mysql database
retrieve data from mysql database  hi am not familiar in php.....even though i want to create combobox effectively.... my query is that when i have selected value on combobox which is to be retrieve the relevant data from mysql 

SQL Question

Processing stored procedure in MySQL - SQL
Processing stored procedure in MySQL  Dear All java with mysql developer..... i need to convert my SQL procedure to MySQL database... here is my...); inv_name10:=var_rec.inv_code(10); end loop; end; in this SP.. i am 

SQL Question

update statement in mysql
update statement in mysql  i am looking for mysql update statement example. Thanks 

Java Beginners

computer configuration - Java Beginners
and i am totaly new to java and i hae to submit my project kindly help and send... of Computers : 150,0000/- */  Hi Friend, Try the following code...); for(int i=0;i<2;i++){ System.out.print("Computer Name: "); name=input.next 

SQL Question

How do I upgrade mysql?
How do I upgrade mysql?  How do I upgrade mysql 

SQL Question

Start MySQL on Linux
Start MySQL on Linux  hii, How can i start MySQL on Linux? is there any cmd for starting MySQL on linux?   hi, yeah , By typing this cmd you can start MySQL service mysqld start 

JDBC Questions

install mysql - JDBC
install mysql  i want to connect with mysql database.can i install mysql on local system please send me link how download mysql   Hi...://www.roseindia.net/mysql/mysql5/Installing-MySQL-on-Windows.shtml I hope 

Java Beginners

mysql table extract
mysql table extract  Hello friends!! I am a trainee. I am learning connectivity of java with MYSQL. I want to extract table from mysql so that I can access it on another computer. I want to attach mysql table to my java NETBEANS 

Java Beginners

downloading a file directly from mysql using java
downloading a file directly from mysql using java  Hi, I am trying to come up with a code to download a file that is on a mysql database (in form of a blob) without using url. Can anyone tell me how it can be done because I am 

JDBC Questions

MySQL Driver for JDBC - JDBC
MySQL Driver for JDBC  Sir, I have started reading your JDBC tutorial for MySQL. I have installed MySQL successfully. But I do not have MySQL... Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306   

PHP Questions

Mysql-Php code
Mysql-Php code  I want to mysql script for query data from two tables in the mysql database trough php code. Can you help me   Hi Friend, Please visit the following link: Php Mysql Thanks   Hi Friend 

Java Beginners

mysql jsp - Java Beginners
mysql jsp  how to insert values to mysql? i want to insert values from a combo box to mysql... how to perform that. pls help me in urgent.  Hi friend, Plz give full source code where you having the problem 

Java Beginners

Login authentication & mysql - Java Beginners
with the data in database. I am newbies to java & learning java by myself but I...Login authentication & mysql  Hi , Could you guide or provide sample coding for the following scenerio. I need to code authentication for user 

SQL Question

Calculate Month Difference in mysql - SQL
Calculate Month Difference in mysql  hi , i am rahul.Can anybody plz help me.i am calculating month difference in mysql5.0 procedure . i have done coding for it. it's counting difference between months. but what i want 

JDBC Questions

can't connect to MySQL Server(10060) - JDBC
can't connect to MySQL Server(10060)  Hii Sir, I am working with a jsp project with MySQL as server. Now i want to host my application. I am created a DB in the Hosting MySQL server and now i want to create a table By using 

SQL Question

How alter table in MySQL?
How alter table in MySQL?  Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks   Hi, You can use the following query: alter table employees change empid empid 

Java Beginners

hi - Java Beginners
hi  hi sir,Thanks for ur coporation, i am save the 1 image with customer data,when i am search that customer data,i want to see that image (already...,plzzzzzzzzzz i have a panel that allows user to enter new customer,i am save 

Framework Questions

Spring MVC and Hibernate with DWR 3 -- Configuration Using MySQL Database
Spring MVC and Hibernate with DWR 3 -- Configuration Using MySQL Database  How to configure Spring MVC and Hibernate with DWR 3, Simple example -- reading a table, editing-deleting and adding new rows 

MySQL

cPanel upgrade MySQL 5.1 to 5.5
my.cnf file from any of the above file. In my case I am using my-small.cnf...cPanel upgrade MySQL 5.1 to 5.5 - Upgrade MySQL 5.1 to MySQL 5.5 through cPanel wizard and configure the server after update Learn how to update MySQL 5.1 

JDBC Questions

Prepared statement JDBC MYSQL
Prepared statement JDBC MYSQL  How to create a prepared statement in JDBC using MYSQL? Actually, I am looking for an example of prepared statement.   Selecting records using prepared statement in JDBC 

Hibernate Questions

hibernate Configuration with eclpse 3.1 - Hibernate
/index.shtml Thanks  Hi friend, I am sending you a link. This link...hibernate Configuration with eclpse 3.1  Dear Sir, i m developing a program using hibernate with struts. but i am not able to configure 

Java Beginners

netbeans with mysql and tomcat
netbeans with mysql and tomcat  Hi. I have to run a JSP or JAVA file in netbeans with mysql database and tomcat server 7.0. But while the page loading itself it say error. ClassNotFoundException: com.mysql.jdbc.Driver. How 

JDBC Questions

mysql andservlets - JDBC
mysql andservlets  I have two tables with primarykey fields.I need to retrive records from two tables using their primary key.What is the query in mysql?and what is the code in servlets?  Hi friend, For solving 

JDBC Questions

Mysql & java - JDBC
Mysql & java  Hi guys, please help! I'm new to mysql, I want to connect to mysql 5.1 using java. But it shows error about: Class.forName.... Thanks....   Hi friend, Code to solve the problem : import 

Java Beginners

Hi... - Java Beginners
Hi...  Hi friends I want to make upload file module please help...please write the using mvc1 rule I have three field emp_id,name,file if i am click the browse button then open one dialog box and select any(.doc 

Java Beginners

hi - Java Beginners
hi  hi sir,when i am enter a one value in jtextfield the related... phone no sir  Hi Friend, Try the following code: import... = true; }else if(code==KeyEvent.VK_RIGHT) { for(int i=0 

SQL Question

Derby vs MySQL - SQL
Derby vs MySQL  Hi, I want to know what are the advantages using Derby Database over MySQL.  http://www.roseindia.net/eclipse/plugins/database/index.shtml 

Hibernate Questions

Access data from mysql through struts-hibernate integration
Access data from mysql through struts-hibernate integration  Hi friends, I am making a program in which I want to access data from mysql... delete and insert command gives output correctly but they don't update mysql 

JDBC Questions

using pb datawindow activex with jdbc for mysql - JDBC
using pb datawindow activex with jdbc for mysql  Hi, I am trying to use datawindow activex in a web page. I need to connect to mysql database located on the server. I have downloaded the connectj for mysql. What should 

JSP Servlet Questions

interface to mysql - JSP-Servlet
interface to mysql  i am creating an easy accces to mysql through jsp-sevlets,when ever user enters the query through the interface how to retrieve the result from the database where the developer has to generally develope 

WebSevices Questions

mysql query - WebSevices
mysql query  I have a field in database as DOB. But I want to search recrods as per "fromage" to "toage". I dont know how to compare the ages with DOB field and retrieve records. plese help me. in mysql with PHP  Hi 

Advertisements Advertisements
 

 

 

DMCA.com