It's a little hard to explain. The different type classifications for JDBC
drivers basically tells you how the driver handles the mapping of the Java
method calls in the JDBC classes to the database's native API. A more
detailed explanation of the different types of drivers can be found on Sun's
web site at http://java.sun.com/products/jdbc/driverdesc.html.
Celeste
-----Original Message-----
From: Gilson Nascimento D Elrei [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 10:00 AM
To: [EMAIL PROTECTED]
Subject: RES: sql server insert (ADO... or equiv)
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
==========================================================================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
