Are you using the wrong type of quotes around NewProposal.
Example you may be using = "NewProposal" when it really wants =
'NewProposal'
just a guess.
On Thu, 25 Jan 2001, Ritesh wrote:
> Hi
>
> I am Running EJbserver on two machines .
> Each is having same configuration .
>
> In both machine i am hving jConnect_5_2 as jdbc driver for sybase
>
> I am passing a string (query ) to my seesion bean
> and the steps i am doing in session bean are....
>
> public Object getQueryResult(String sqlQ)
> throws RemoteException{
>
> java.util.Vector retVect = new java.util.Vector();
> System.out.println("Hello In side getqueryResult Session Beans");
> try{
> Context sessionContext = new InitialContext();
> DataSource ds = (DataSource) sessionContext.lookup("jdbc_1");
> String retStr= "";
>
> Connection con = ds.getConnection();
> Statement stmt = con.createStatement();
> ResultSet rS = null;
> rS = stmt.executeQuery(sqlQ);
> while(rS.next()){
> retStr="";
> for(int cntr=1;cntr<=(rS.getMetaData()).getColumnCount();cntr++){
> if(cntr==1){
> retStr=rS.getString(cntr);
> continue;
> }
> retStr +="|"+rS.getString(cntr);
> }
> retVect.add(retStr);
> }
> rS.close();
> stmt.close();
> con.close(); catch(Exception E){
> //If we are in problem then send back the exception.
> return "Got Exception in Sssion Bean calling result set"+E;
> }
> System.out.println("Hello In side the Befor Return of Session Beans");
> return retVect;
> }
>
>
> The above code perfectly gives me the result as desired on my one machine
> But the same code when i am running on other machine i am geeeting error
>
>
> Hello is Got Exception In Create of Proposal Master>>java.rmi.ServerException:
> RemoteException occurred in server
> thread; nested exception is: java.rmi.RemoteException: RuntimeException thrown
>by an
> enterprise Bean; nested
> exception is: javax.ejb.EJBException>>0>>New Company>>null>>>
> QUERY>>>>> select Status_Code, Status_Type from Status_Master where Status_Name
>=" New
> Proposal"
>
> RET OBJ IS Got Exception in Sssion Bean calling resultset
> com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ' New Proposal'.
>
> As from the query it is clear that "" NewProposal "" of which status code and
>status
> type shud be displayed.
>
>
> The same code is working fine one machine .
>
> Is any one have any clue what exactly the error is ......
>
>
> Thanks in advance
> Ritesh
>
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
>
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
