Mailing-List: contact axis-user-help@ws.apache.org; run by ezmlm
Precedence: bulk
Reply-To: axis-user@ws.apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <22345253.post@talk.nabble.com>
Date: Wed, 4 Mar 2009 20:53:29 -0800 (PST)
From: riveraej <riveraej@gmail.com>
To: axis-user@ws.apache.org
Subject: Question about exposing a database as a web service...
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi everyone!

I come to you asking for help. I'm trying to mount a web service which
consults a MySQL Database. I have already done the consult, but I can show
all data contained in the database, or I can show data according to
conditions setting these conditions manually in the code of the Java Class.
Nevertheless I need to pass in some way to my class a value in order to make
the SQL consult according to this.

Talking in code terms... I have the next code:

public class poDBService{

	public OrderData orderDetails(){
		Connection conn = (Connection)
MessageContext.getCurrentMessageContext().getProperty(
			poDataServiceLifeCycle.DB_CONNECTION);
		if (conn!=null){
			try{
				String SQL = "SELECT * FROM `porder` WHERE order_id=1";
				PreparedStatement statement = conn.prepareStatement(SQL);
				ResultSet result = statement.executeQuery();
				if (result.next()){
					OrderData orderData = new OrderData();
					orderData.setOrderId(result.getInt("order_id"));
					orderData.setSoldTo(result.getInt("soldTo"));
					orderData.setShipTo(result.getInt("shipTo"));


I can access to my service through my browser in the address:

http://localhost:8080/axis2/services/poDataService/orderDetails

It correctly displays the corresponding data contained in the table porder

But I need to define my SQL sentence allowing to pass it the needed
parameter for the WHERE clause.
I already found that some people makes it with code like the next:

public class poDBService{

	public OrderData orderDetails(int id){
		Connection conn = (Connection)
MessageContext.getCurrentMessageContext().getProperty(
			poDataServiceLifeCycle.DB_CONNECTION);
		if (conn!=null){
			try{
				String SQL = "SELECT * FROM `porder` WHERE order_id = "  + id ;
				PreparedStatement statement = conn.prepareStatement(SQL);
				ResultSet result = statement.executeQuery();
				if (result.next()){
					OrderData orderData = new OrderData();
					orderData.setOrderId(result.getInt("order_id"));
					orderData.setSoldTo(result.getInt("soldTo"));
					orderData.setShipTo(result.getInt("shipTo"));


With this code theoretically it would be possible to pass paramete id to the
service in the URL address:

http://localhost:8080/axis2/services/poDataService/orderDetails?id=1

But when I try to do it in this way Axis returns in my web browser a Soap
message like this:

<soapenv:Reason>
<soapenv:Text xml:lang="en-US">unknown</soapenv:Text>
</soapenv:Reason>

No error is thorwn in JBoss console window.

I'm using:
- JBoss-4.2.2.G.A.
- Axis2-1.3
- jdk1.5.0_17
- mysql-connector-java-5.1.7
- MySQL Server 5.1

Any ideas what is happening? or is there another way to do this?

Thanks in advance!

Ernesto J. Rivera
-- 
View this message in context: http://www.nabble.com/Question-about-exposing-a-database-as-a-web-service...-tp22345253p22345253.html
Sent from the Axis - User mailing list archive at Nabble.com.