In my developement environment i have Jrun 3.0 development edtion & BEA jdbc
driver trial.Now i am shifting to pre production server(JRun 3.0 Enterprise
with jdbc type 4 driver which comes with that),there only
i am getting this problem
allaire driver try to popuplate the table
'Datetime' column with Date &time, even though i am passing only sqlDate
object using insert stt.It was not happening with bea driver.
For select stt also,i am passing sqlDate object in the where clause,it
searches for date&time in the table returns null resultset.
Is this the way it suppose to work? or it is a bug?
sahaya.
>From: "sahaya ranialex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: JRun-Talk <[EMAIL PROTECTED]>
>Subject: Re: allaire JDBC driver.
>Date: Tue, 27 Mar 2001 15:34:05 -0000
>
>String query1="SELECT stoplight,prod_element_id "+
> "FROM prod_list "+
> "WHERE bemsid=? AND submitted_date=? "+
> "ORDER BY prod_element_id ";
>i inserted space after question mark
>it does not throw any any excepion but no resultset
>
>i thiink expects date with time as it populates.
>
>Still i need some suggestion for this problem
>
>sahaya.
>
> >From: "sahaya ranialex" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: JRun-Talk <[EMAIL PROTECTED]>
> >Subject: allaire JDBC driver.
> >Date: Tue, 27 Mar 2001 15:05:30 -0000
> >
> >Hi there,
> >
> >I am using JRUN enterprise in solaris,database as sqlserver 7.o runs on
> >win-NT 4.0.
> >Here is my snippet
> >bemsid=rs1.getInt(1);
> >.....
> >String query1="SELECT stoplight,prod_element_id "+
> > "FROM prod_list "+
> > "WHERE bemsid=? AND submitted_date=?"+
> > "ORDER BY prod_element_id";
> >java.sql.Date sqldate0 =new java.sql.Date(date.getDate0().getTime());
> >pst=con.prepareStatement(query1);
> >
> >try{
> >
> > pst.setInt(1,bemsid);
> > pst.setDate(2,sqldate0);
> > rs=pst.executeQuery();
> > for(int j=0 ;j<13&&rs.next();j++){
> > date0[j]=rs.getString(1);
> > }
> > rs.close();
> >}catch(SQLException e){out.println("0"+e);}
> >
> >i am getting the below error.
> >0java.sql.SQLException: [Allaire JRun][SQLServer JDBC
> >Driver][SQLServer]Must
> >declare the variable '@P2ORDER'.
> >
> >The same query runs fine in SQL query analyser.& also using BEA type 4
>jdbc
> >driver.
> >In my developement environment i have Jrun development edtion & BEA jdbc
> >driver trial.Now iam shifting to pre production server,there only i am
> >getting this problem
> >
> >Does any one have any clue to this?
> >
> >one more pbm i across is, allaire driver try to popuplate the table
> >'Datetime' column with Date &time,It was not happening with bea driver
> >it just populate with date only.
> >
> >
> >sahaya
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
