Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

classe server per un web service

0 views

Skip to first unread message

rizzi_al...@libero.it

unread,

Mar 29, 2005, 1:12:11 PM3/29/05

Devo realizzare un web service a partire da questa classe ottengo una
serie di errori una volta realizzato il client utilizzando AXIS APACHE
e addirittura chiude il server web Tomcat. Forse c'è qualcosa di
sbagliato nella classe che esegue il servizio. Chi può aiutarmi a
risolvere il problema?

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.Iterator;

public class PersoneArray {
static Connection conn = null;

public PersoneArray() throws Exception {

DriverManager.registerDriver (new
sun.jdbc.odbc.JdbcOdbcDriver());
if (conn == null) {
conn = DriverManager.getConnection
("jdbc:odbc:Persone", "", "");
}
}

public ArrayList getrecordsArrayList(String args[]) throws Exception
{
PersoneArray personeArray = new PersoneArray();

ArrayList recordsArray = new ArrayList();
recordsArray = recordsArrayList(100);

int j=0;

Iterator iter = recordsArray.iterator();
while (iter.hasNext()) {
iter.next();
}
return recordsArray;
}

public ArrayList recordsArrayList(int rowlimit) throws SQLException
{
Statement stmt = null;
ResultSet rs = null;

ArrayList rowArray = new ArrayList();
ArrayList rowsetArray = new ArrayList();
int sal = 0;

try {

String sqlString = "select ID, Cognome, Nome, Tel , Email,
Homepage from Persone2";

stmt = conn.createStatement();
rs = stmt.executeQuery(sqlString);

stmt.setMaxRows(rowlimit);

while (rs.next()) {
rowArray.clear();
rowArray.add(String.valueOf(rs.getInt(1)));
rowArray.add(rs.getString(2)); rowArray.add(rs.getString(3));
rowArray.add(String.valueOf(rs.getString(4)));
rowArray.add(rs.getString(5));
rowArray.add(rs.getString(6));
rowsetArray.add(rowArray.clone());
}

}finally {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn!=null)
conn.close();
}

return rowsetArray;
}
}

Questi gli errori:

- Mapping Exception to AxisFault
AxisFault
faultCode: {http://xml.apache.org/axis/}Server.userException
faultString: java.net.ConnectException: Connection refused: connect
faultActor: null
faultDetail:
stackTrace: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:427)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:146)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:183)
at org.apache.axis.client.Call.invokeEngine(Call.java:2027)
at org.apache.axis.client.Call.invoke(Call.java:2016)
at org.apache.axis.client.Call.invoke(Call.java:1786)
at org.apache.axis.client.Call.invoke(Call.java:1711)
at org.apache.axis.client.Call.invoke(Call.java:1251)
at localhost.PersoneArraySoapBindingStub.getrecordsArrayList(PersoneArraySoapBindingStub.java:123)
at PersoneArrayClient.main(PersoneArrayClient.java:35)

java.net.ConnectException: Connection refused: connect
at org.apache.axis.AxisFault.makeFault(AxisFault.java:117)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:167)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:183)
at org.apache.axis.client.Call.invokeEngine(Call.java:2027)
at org.apache.axis.client.Call.invoke(Call.java:2016)
at org.apache.axis.client.Call.invoke(Call.java:1786)
at org.apache.axis.client.Call.invoke(Call.java:1711)
at org.apache.axis.client.Call.invoke(Call.java:1251)
at localhost.PersoneArraySoapBindingStub.getrecordsArrayList(PersoneArraySoapBindingStub.java:123)
at PersoneArrayClient.main(PersoneArrayClient.java:35)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:427)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:146)
... 11 more
AxisFault
faultCode: {http://xml.apache.org/axis/}Server.userException
faultString: java.net.ConnectException: Connection refused: connect
faultActor: null
faultDetail:
stackTrace: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:427)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:146)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:183)
at org.apache.axis.client.Call.invokeEngine(Call.java:2027)
at org.apache.axis.client.Call.invoke(Call.java:2016)
at org.apache.axis.client.Call.invoke(Call.java:1786)
at org.apache.axis.client.Call.invoke(Call.java:1711)
at org.apache.axis.client.Call.invoke(Call.java:1251)
at localhost.PersoneArraySoapBindingStub.getrecordsArrayList(PersoneArraySoapBindingStub.java:123)
at PersoneArrayClient.main(PersoneArrayClient.java:35)

0 new messages