connection « JSTL « JSP-Servlet Q&A

1. JSTL doctype without internet connection

I was using a properties.xml file which i stored with storeToXML. but storeToXML always set a doctype like:

<!DOCTYPE properties SYSTEM "">
now i use JSTL XML to check for the properties:
<c:import url="${settingsPath}" ...

2. JSTL persistent database connections

Are the database connections used by JSTL <sql:query> tag persistent?

  1. I mean if I use a lot of <sql:query> tags on a page then will they share the same database connection?
  2. What ...

3. Connection Pooling and JSTL

Hi Guys, I am in the process of re-structuring most of my webapp and in particular will be using JSTL to get rid of all the scriptlets from JSPs and writing a new controller servlet as previously the app was using a Model 1 MVC. I am currently using a Connection Pool that came with Marty Hall's core Servlets book, which ...

4. database connection with jstl

6. Database Connection Error with JSTL

It's in my common\lib but it won't work so I also supplied a mysql.jar in my \jre\lib\ext still won't work so again I put one in my \WEB-INF\lib (very clever indeed) but it still won't work! Uhmmm... I won't be using the sql tags anymore but I'd still like to know the answer... If you don't mind... Thanks!

7. problem in JSTL connection

hi ranchers, i am trying to pick up some values from database using JSTL. Earlier i was picking up the connection variable dynamically. <% pReq.setAttribute("csm",dataSource); %> Later i have hardcoded my database schema 'jdbc/CSG_DS' but everytime i try to run the application i got the following error--- javax.servlet.jsp.JspTagException: Error ...

8. db connection with jstl

Hi all, anyone now how to search data in mysql using jstl tag. I've tried few but it seemms didn;t work at error but not working. My scenerio is, one textfield for user to enter bookid and one submit button to display selected id they search in the database. For your information i'm using netbeans 5.0 and not any jsp ...

9. database connection using jstl

10. How to use an existing Connection with jstl.sql?

Hello, I inherited an old JSP application (very low traffic) that already has a sql Connection object held at the session level. For quick & dirty extension I was thinking of using the JST SQL tags, but has someone built a wrapper that would allow me to use the connection as dataSource? I think one needs to implement the javax.servlet.jsp.jstl.sql.dataSource interface, ...

11. Unable to get connection

I have a jsp page that allow user to upload excel file and at the same page retrieve the data from the uploaded excel file. the problem is when i click the upload button, i got this error: org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is ...

13. passing a db connection across jsps throughout a session

hi all, please,i need urgent help with this: i have this database connection bean package common; import*; import java.sql.*; import java.util.*; public class DBConnectionBean { private String url = ("jdbc:oracle:thin:@localhost:1521:ASEB"); private String user = "cmc"; private String pass = "orapower2223"; Connection conn = null; public DBConnectionBean(){ try{ Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(url,user,pass); } catch(Exception e){e.printStackTrace();} }// End Constructor public Connection ...

14. sql server connection problem

15. Problems about connection to a database

16. connection pooling problem

17. Connection problem

Connection.jsp <%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> <% try { String ConnectionURL = "jdbc:oracle:thin:@localhost:1521:mydata"; //String DBName = "mydata"; String Driver_Package = "oracle.jdbc.driver.OracleDriver"; String UserName = "system"; String Password = "dharmit"; //Load the Oracle Driver Class.forName(Driver_Package); Connection conn = DriverManager.getConnection(ConnectionURL,UserName ,Password); } catch(Exception error) { out.println("Connection Problem"); } %> Process.jsp // Process.jsp file is in other folder.. <%@ page language="java" ...

18. DB2 Database Connection using JavaScript