ansaurus

Question

Answer 1

A:

It seems that you try to serialize a Connection to XML which leads to

java.sql.Connection is an interface, and JAXB can't handle interfaces.

Check your annotations, if you don't find the problem, you should append the code to your question.

stacker 2010-07-20 05:36:07

problem solved!!!! i just declared all public functions as private and in @webmethod removed 'throws exception'...rest works just fine....

awaiskhan200 2010-07-21 10:20:34

Answer 2

A:

thanks stacker....please elaborate it more..here is my code.....::

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package vas.gift;

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintStream;
import java.net.URL;
import java.net.URLConnection;
import java.net.URLEncoder;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.StringTokenizer;
import javax.jws.*;
import oracle.jdbc.pool.OracleDataSource;

/**
 *
 * @author muhammad.awais
 */
@WebService()
public class giftingService2 {

    /**
     * Web service operation
     */
      private String parameterFile;


    //return codes

    private String VMSUserName;
    private String VMSPassword;
    private String VMSjdbcUrl;
    private String sendSMSUrl;
    private String xmsFrom;
    private int sessionLA;
    private String partyAmessage;
    private String partyBmessage;
    private String MTLA;
    private String tID;
    private String mode;

    /**
     *
     */
   /* public giftingService(){
         parameterFile=giftingService.class.getClassLoader()
         .getResource("parameters.conf").getPath()
        .replaceAll("%20", " ");

         LoadParameters();
    }
*/
    /**
     *
     * @param username
     * @param password
     * @param partyA
     * @param partyB
     * @param serviceID
     * @param serviceName
     * @param channel
     * @return
     * @throws SQLException
     */
    @WebMethod(operationName = "giftRequest")
    public String giftRequest(@WebParam(name = "username")
    String username, @WebParam(name = "password")
    String password, @WebParam(name = "partyA")
    String partyA, @WebParam(name = "partyB")
    String partyB, @WebParam(name = "serviceID")
    String serviceID, @WebParam(name = "serviceName")
    String serviceName, @WebParam(name = "channel")
    String channel) throws SQLException {
        //TODO write your implementation code here:

        String UserAuthResp ="";
        String response="0";
        String lookupResp="";
        String createSessResp="";
        //String lookupArr[];
        int correlationid=0;
        String sendSMSResp = "";


        int LA=0;
        Connection vmsConn = createVMSConnection(VMSUserName, VMSPassword, VMSjdbcUrl);

        UserAuthResp = verifyCredentials (vmsConn,username,password,channel);
        if(UserAuthResp.equals("1"))
        {
            lookupResp=lookUpSession (vmsConn, partyB, serviceID);
            if(!lookupResp.equals("-8"))
            {
                LA=getNewSessionLA(LA, sessionLA);
                correlationid = getCorrelationID (vmsConn);
                createSessResp=createSession(vmsConn, partyA, partyB, correlationid, serviceID,String.valueOf(LA));
                if(createSessResp.equals("1"))
                {
                    sendSMSResp=sendSMS(partyB, partyBmessage, correlationid, serviceID, MTLA, createSessResp);
                    if(sendSMSResp.equals("1"))
                        response="1";
                }
            }
        }
        logHistory (vmsConn, partyA, partyB, partyBmessage, correlationid, serviceID, LA, UserAuthResp, lookupResp, createSessResp, sendSMSResp,response);
        vmsConn.close();
        return response;
    }


    /**
     *
     * @param VMSUsername
     * @param VMSPassword
     * @param VMSUrl
     * @return
     * @throws SQLException
     */
    public Connection createVMSConnection(String VMSUsername, String VMSPassword, String VMSUrl) throws SQLException
    {
        Connection vmsConn = null;
        OracleDataSource vmsDS = new OracleDataSource();
        //vmsConn=null;
        try
        {
            vmsDS.setURL(VMSUrl);
            vmsConn = vmsDS.getConnection(VMSUsername, VMSPassword);
        }
        catch (SQLException ex)
        {

        }
        return vmsConn;
    }

    /**
     *
     * @param vmsConn
     * @param username
     * @param password
     * @param channel
     * @return
     * @throws SQLException
     */
    public String verifyCredentials(Connection vmsConn, String username, String password, String channel) throws SQLException
    {
        ResultSet rs = null;
        Statement stmt=null;
        String sql="";
        String response = "";
        try
        {
            stmt = vmsConn.createStatement();
            sql = "select * from lu_vms_wap_users where WAP_Uname = '"+username+"' and WAP_Pwd='"+password+"'and Channel ='"+channel+"' and status = '1'";
            rs = stmt.executeQuery(sql);
            if(rs.next())
            {
                response = "1";
            }
        }
        catch (SQLException ex)
        {
            response="-4";
        }

        return response;
    }

    /**
     *
     * @param vmsConn
     * @param partyB
     * @param serviceid
     * @return
     * @throws SQLException
     */
    public String lookUpSession(Connection vmsConn, String partyB, String serviceid) throws SQLException
    {
        ResultSet rs=null;
        Statement stmt=null;
        String sql="";
        String response="";
        try
        {
            stmt = vmsConn.createStatement();
            sql = "select LA from tbl_vms_wap_sessions where partyB='"+partyB+"' /*and serviceid='"+serviceid+"'*/ and status = '0' order by LA desc";
            rs = stmt.executeQuery(sql);
            if(rs.next())
            {
                response = rs.getString("LA");
            }
            else
                response = "0";
        }
        catch (SQLException ex)
        {
            response = "-8";
        }
        return response;
    }

    /**
     *
     * @param LA
     * @param sessionLA
     * @return
     */
    public int getNewSessionLA(int LA, int sessionLA)
    {
        if(LA == 0)
        {
            LA=sessionLA;
        }
        return LA + 1;
    }

    /**
     *
     * @param vmsConn
     * @return
     * @throws SQLException
     */
    public int getCorrelationID(Connection  vmsConn) throws SQLException
    {
        ResultSet rs=null;
        Statement stmt=null;
        String sql="";
        int ret=0;
        try
        {
            stmt = vmsConn.createStatement();
            sql = "select SEQ_TBLCPAMSGS_ID.nextval from dual";
            rs = stmt.executeQuery(sql);
            if(rs.next())
            {
                ret=Integer.parseInt(rs.getString(1));
                return ret;
            }
            else
                return 0;
        }
        catch (SQLException ex)
        {
            return -5;
        }
    }

    /**
     *
     * @param vmsConn
     * @param partyA
     * @param partyB
     * @param correlationid
     * @param serviceid
     * @param LA
     * @return
     * @throws SQLException
     */
    public String createSession(Connection vmsConn, String partyA, String partyB, int correlationid, String serviceid, String LA) throws SQLException
    {
        Statement stmt=null;
        String sql="";
        String response="1";
        try
        {
            stmt = vmsConn.createStatement();
            sql = "insert into tbl_vms_wap_sessions (id, partyA, partyB, correlationid, serviceid, LA, status) values (seq_vms_wap_session.nextval, '"+partyA+"','"+partyB+"','"+correlationid+"','"+ serviceid+"','"+ LA+"','0')";
            stmt.executeQuery(sql);
        }
        catch (SQLException ex)
        {
            response="-5";
        }

        return response;
    }

    /**
     *
     * @param vmsConn
     * @param partyA
     * @param partyB
     * @param partyBmessage
     * @param correlationid
     * @param serviceid
     * @param LA
     * @param UserAuthResp
     * @param lookupResp
     * @param createSessResp
     * @param sendSMSResp
     * @param ReturnCode
     * @return
     * @throws SQLException
     */
    public String logHistory(Connection vmsConn, String partyA, String partyB, String partyBmessage, int correlationid, String serviceid, int LA, String UserAuthResp, String lookupResp, String createSessResp, String sendSMSResp, String ReturnCode)  throws SQLException
    {
        Statement stmt=null;
        String sql="";
        String response="1";
        try
        {
            stmt = vmsConn.createStatement();
            sql = "insert into tbl_vms_wap_hist (id, partyA, partyB, partyBmessage, correlationid, serviceid, LA, UserAuthResp, lookupResp, createSessResp, sendSMSResp, ReturnCode) values (seq_vms_wap_history.nextval, '"+partyA+"','"+partyB+"','"+partyBmessage+"','"+correlationid+"','"+ serviceid+"','"+ LA+"','"+UserAuthResp+"','"+lookupResp+"','"+createSessResp+"','"+sendSMSResp+"','"+ReturnCode+"')";
            stmt.executeQuery(sql);
        }
        catch (SQLException ex)
        {
            response="-5";
        }

        return response;
    }

    /**
     *
     * @param partyB
     * @param partyBmessage
     * @param correlationid
     * @param serviceid
     * @param MTLA
     * @param ErrorCode
     * @return
     */
    public String sendSMS(String partyB, String partyBmessage, int correlationid, String serviceid, String MTLA, String ErrorCode)
    {
       URL url=null;
       URLConnection connection=null;
       PrintStream outStream=null;
       InputStreamReader isr=null;
       BufferedReader inStream=null;
       String cgi_Response="";
       String inputLine="";

           try{
                url = new URL(sendSMSUrl);
                connection = url.openConnection();
                connection.setDoOutput(true);
                connection.setUseCaches(false);
                outStream = new PrintStream(connection.getOutputStream());
                outStream.println((new StringBuilder()).append("to=").append(URLEncoder.encode(partyB, "UTF-8")).append("&from=").append(URLEncoder.encode(xmsFrom, "UTF-8")).append("&service=").append(URLEncoder.encode(String.valueOf(serviceid), "UTF-8")).append("&LA=").append(URLEncoder.encode(MTLA, "UTF-8")).append("&message=").append(URLEncoder.encode(partyBmessage, "UTF-8")).append("&correlationID=").append(URLEncoder.encode(String.valueOf(correlationid), "UTF-8")).append("&serviceID=").append(URLEncoder.encode(String.valueOf(serviceid), "UTF-8")).append("&mode=").append(URLEncoder.encode(String.valueOf(mode), "UTF-8")).append("&tid=").append(URLEncoder.encode(String.valueOf(tID), "UTF-8")).toString());
                outStream.flush();
                outStream.close();
                isr = new InputStreamReader(connection.getInputStream());
                inStream = new BufferedReader(isr);

                cgi_Response = "";
                while ((inputLine = inStream.readLine())!=null){
                    cgi_Response = cgi_Response+inputLine;
                }
            }
            catch (Exception ex)
            {

            }
            return cgi_Response;
    }

    private void LoadParameters(){
        String Token=null;
        String fileLine=null;

        try{
            FileReader fr= new FileReader(parameterFile);
            BufferedReader br= new BufferedReader(fr);
            //open file
            do{//while not end of file
            //read from file
                fileLine=br.readLine();
                if (fileLine!=null){
                    //tokenize the line read
                    StringTokenizer st= new StringTokenizer(fileLine);
                    //get first token
                    Token=st.nextToken("=");
                    if (Token.equals("VMSUserName")){
                        VMSUserName =st.nextToken();
                    }else if (Token.equals("VMSPassword")){
                        VMSPassword =st.nextToken();
                    }else if (Token.equals("VMSjdbcUrl")){
                        VMSjdbcUrl =st.nextToken();
                    }else if (Token.equals("sendSMSUrl")){
                    sendSMSUrl =st.nextToken();
                    }else if (Token.equals("xmsFrom")){
                        xmsFrom =st.nextToken();
                    }else if (Token.equals("MTLA")){
                        MTLA =st.nextToken();
                    }else if (Token.equals("TID")){
                        tID =st.nextToken();
                    }else if (Token.equals("MODE")){
                        mode =st.nextToken();
                    }else if (Token.equals("sessionLA")){
                        sessionLA =Integer.parseInt(st.nextToken());
                    }else if (Token.equals("partyBmessage")){
                        partyBmessage = st.nextToken();
                    }
                }
            }
            while(fileLine!=null);
            br.close();
        }catch(FileNotFoundException e){

        }catch(IOException e){

        }
    }

}

looking forward to your comments

awaiskhan200 2010-07-20 05:51:11

@awaiskhan200 please check Andreas hint, I didn't find anything unusual. You should append the code to your question instead of posting it as an answer.

stacker 2010-07-20 07:10:39

please check now....

awaiskhan200 2010-07-20 09:33:01

Answer 3

A:

In createVMSConnection, if you get a SQLException on the lines:

vmsDS.setURL(VMSUrl);
vmsConn = vmsDS.getConnection(VMSUsername, VMSPassword);

then the exception is not shown and the method returns null instead of a connection. This could cause trouble.

You should log exceptions or leave a short comment, if there's no need to implement the catch clause.

Andreas_D 2010-07-20 06:31:50

ansaurus

tags:

views:

answers:

how to endorse tomcat, jdk, jre?????

related questions