?
Solved

extract to xml + Connection pooling

Posted on 2009-04-21
4
Medium Priority
?
224 Views
Last Modified: 2013-12-18
Hi

i want to design a utility where two parameters could be passed at start i.e 1 load  2: extract

in case of load i need to connect to db by reading name mentioned in the config file and list of table also in config file. i want to query these tables from the above db and store the data and metadata in form of xml and write to disk.
please provide me with some sample code if u have any and also a sample code for connection pool singleton sample code is really required.
please guide and give some sample or working code files to help me get started

0
Comment
Question by:manojvashisht
3 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 24192245
0
 

Author Comment

by:manojvashisht
ID: 24193522
i cant use dbunit.........i have to code all in java ...please suggest how connection pooling can be done and i dont have a app server to handle this,i will be a simple java program calling the util.

please give your expert advice how the same could be done
0
 
LVL 92

Accepted Solution

by:
objects earned 2000 total points
ID: 24193541
you can use dbcp for your connmection pool
following shows how to set it up

http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/BasicDataSourceExample.java?view=markup

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses
Course of the Month14 days, 15 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question