A newbie question... What's do you means with JDBC (type I, II, IV, etc..)? I think that must to exist some difference between it. regards, > ----- Mensagem original ----- > De: Haseltine, Celeste [SMTP:[EMAIL PROTECTED]] > Enviada em: ter�a-feira, 21 de agosto de 2001 13:04 > Para: [EMAIL PROTECTED] > Assunto: Re: sql server insert (ADO... or equiv) > > Nasser, > > At one time, there was some talk of a JDO library on the Sun site, but I'm > not sure where that discussion has lead to. I too am currently developing > a JSP application using SQLServer 7.0 (and boy do I wish I could use > Oracle!!!). I purchased a third party JDBC driver (Type IV), but I too > have had problems with SQLServer, particularly updating or inserting large > amounts of data. To my knowledge there is no ADO equivalent in Java/JSP, > although back in March of this year when I was doing research for this > project, I did find some third party tools that gave similar functionality > to ADO. But these were Type II JDBC drivers, and I needed at least a Type > III or a Type IV, so I never investigated those tools further. If you do > a search on google.com for JDBC drivers for SQL Server, you should hit on > the Type II drivers that emulate ADO that I found back in March. > > Do consider using some of the tag libraries out on the net to help you > with your database functionality. I am using both JRUN's tag library (for > version 3.01), and the Jakarta DBTags. If you are using a server other > than JRUN, take a serious look at the Jarkarta project, and the list of > tag libraries they have. They can be a big help. > > Hope this helps!!! > > Celeste > > > > -----Original Message----- > From: Nasser Dassi [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 21, 2001 10:23 AM > To: [EMAIL PROTECTED] > Subject: Re: sql server insert (ADO... or equiv) > > > Hi Greg, > > As Ashish brought up, used PreparedStatement. The overall idea is > to use SQL Server's stored procedures, which accept values from the > calling tier (front-end, or middle-tier). In ASP it's quite simple, using > ADO's capabilities. Is there a JSP or Servlet equivalent, is the question > to ask. Answering this would solve any and ALL data transfer issues > between jsp/servlets and any Microsoft Servers (either SQL Svr, Access > 2000/XP, or .NET's data handling... in general). > > Sorry to not be much more of help, as I am learning JSP and Servlets > myself. There's GOT to be an ADO equiv, though. > > Nasser > "Unemployed by trade" > > ----- Original Message ----- > From: Gregory Price <mailto:[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > Sent: Monday, August 20, 2001 11:35 AM > Subject: sql server insert > > Hello, I am running Jrun and have run into a problem > submitting a long string. > The long string a user submits will likely be in French, > which means a lot of single and double quotes. I am > now able to submit this field under normal circumstance, but > my code is > choking on these characters... I bet you guys can nail this > one pretty > quick... I must need a function when I set that large > string as a > variable... Your help is very much appreciated. code is > below: > > <%@ taglib uri="jruntags" prefix="jrun" %> > > <% String news_ID= request.getParameter("news_ID"); %> > <% String newsletter_ID= > request.getParameter("newsletter_ID"); %> > <% String heading= request.getParameter("heading"); %> > <% String entry= request.getParameter("entry"); %> > <% String enteredby=request.getParameter("enteredby"); %> > <% String newslettermonth= > request.getParameter("newslettermonth"); %> > <% String newsletteryear= > request.getParameter("newsletteryear"); > String sqlQuery = "INSERT INTO news (newsletter_ID, > heading, entry, > enteredby) VALUES (" > +newsletter_ID + ", '" > +heading+ "', '" > +entry+"', '" > +enteredby+"')"; %> > > > > <%--INSERT NEWSITEM--%> > <jrun:sql datasrc="afdallas" id="allnews"> > <%=sqlQuery%> > </jrun:sql> > > > > Thanks > Greg Price > ==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
