Hi Matt Thanks for your help! I had been doing several nights of research to prepare for this, and although I have simple examples running on both Tomcat and JRun, more complex functionality seems to always fail on NT systems. It seems to run fine on Win2K, and I have not had problems implementing it on a Mandrake Linux box with Apache that I am using at home for development. -----Original Message----- From: Matthew L. Wright [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 16, 2001 2:08 PM To: JRun-Talk <[EMAIL PROTECTED]> Subject: Re: allaire JDBC driver vs. Tomcat (re - Java Server Pages from Scratch). Hi Ed - In my experience (as others would probably attest in the group) JRun has specific considerations to implement JDBC and Sendmail that are unique to that JSP server. As the book you are using (and from your mail I see you have talked to the author about the code) is specific to Tomcat, it probably would not be wise to do a conversion, as that would take longer than the timeframe that you probably have. The steps required would be code specific, evaluated on a case by case basis. By that point, it is better to start from scratch (even though elements of different code may share the same functionality, the approach may be different). If you have to, I'd suggest showing a very simple example, preferably from the JRun Guide from Allaire. However, I think that too would be a little on the complex end for students, plus it requires administrative privileges to the Jrun Admin area (as you probably know). Considering the restrictions enforced by your school, it may be best simply to run Tomcat and work from there (besides, its free and easy to implement). Hope that helps. cheers Matt Matthew L. Wright Java Internet Programmer Jupiter One Web World Studios West Coast www.jupiterone.com (818) 763-2927 ----- Original Message ----- From: "Edward Apostol" <[EMAIL PROTECTED]> To: "JRun-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13th, 2001 7:16 AM Subject: Re: allaire JDBC driver. > Hello - I am preparing to do a series of demonstrations involving JSP, JDBC and the Javamail protocol. Currently I have it running fine on a Win2K machine running Tomcat, but would like to know the implications of converting the code to make it work for JRun. > The examples employed are based on the Java Server Pages from scratch Book published by Que: Anyone use that book before? I was wondering if anyone has had problems running that code. > The reason is I cannot seem to get the demonstrations working on Jrun, after working through > the instructions supplied by the book. I had to of course research potential conversion processes, but they seem to fail. > > > > I also have administrative considerations to think about. > '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
