aspose file tools*
The moose likes JSP and the fly likes Unable to get connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Unable to get connection" Watch "Unable to get connection" New topic
Author

Unable to get connection

CN
Greenhorn

Joined: Jul 25, 2008
Posts: 6
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 already opened exclusively by another user, or you need permission to view its data."


but after i refresh the page, it display the page that is expected (which display the data retrieve from uploaded excel file)

I'm sure that I didn't open the file via some other application such as Microsoft Excel when I run the code.

Form.jsp
<!-- Connect to ms excel -->
<sql:setDataSource var="mp"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbcdbc:mp-list" />

<sql:query var="rs" dataSource="${mp}">
SELECT * FROM [MP$]
</sql:query>
<html>
<body>

<form action="upload.jsp" enctype="multipart/form-data" method="post">
<b>File : </b><input type=file size=20 name="fname"/>
<INPUT TYPE="Submit" NAME="Submit" VALUE="Upload">
</form>

<form name="planForm" action="updateDeviceInfo.jsp" method="post" onsubmit="return validate_form(this)">
<b><font color="#0000CC">Plan ID: </font></b>
<input name="planId" type="text" size="8" value="${param.planId}" /></p>

<table>
<tr>
<td><b>Device <b></td>
<td><b>Qty</b></td>
</tr>

<c:forEach var="Row" items="${rs.rows}">
<tr>
<td><input name="partId" type="text" size="25" value="${Row.PartId}" /></td>
<td><input name="qty" type="text" size="12" value="${Row.Qty}" /></td>
</tr>
</c:forEach>
</table>

<input type="reset" name="reset" value="Clear">
<input type="submit" name="submit" value=" Submit "/>
</form>

</body>
</html>

upload.jsp
<%@ page import="java.util.*,
java.io.*,
java.sql.*,
org.apache.commons.fileupload.*,
org.apache.commons.fileupload.servlet.*,
org.apache.commons.fileupload.disk.*,
org.apache.commons.fileupload.util.*"
%>
<html>

<body>

<%
boolean isMultipart = ServletFileUpload.isMultipartContent(request);

if(isMultipart)
{
String fileName = "";

DiskFileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);
List items = upload.parseRequest(request);
Iterator iter = items.iterator();

String name = "";
String value = "";
InputStream stream = null;

//check any field to pass in

while (iter.hasNext())
{
FileItem item = (FileItem) iter.next();
name = item.getFieldName();//field name
value = item.getString();//field value

if (!item.isFormField()) {

name = item.getName();

if(name != null ){

//Upload file --start
fileName = new File(item.getName()).getName();
//Get upload diectory from xml
String uploadDirectoty="C://Program Files//Apache Software Foundation//Tomcat 5.5//webapps//QFN_Planning//uploadFiles//";

File file = new File(uploadDirectoty + fileName);

File dir = new File(uploadDirectoty);
if (!dir.exists())
{
new File(uploadDirectoty).mkdirs();
}

FileOutputStream fos = new FileOutputStream(file);
stream = item.getInputStream();

int c;
while(( c = stream.read()) != -1 )
{
fos.write( c );
}
stream.close();
}

}

}

}
%>

<c:redirect url="Form.jsp"/>

Above is my coding..

Please point out the problem and suggest solution..
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60045
    
  65

Originally posted by Chen Nee Lim:
Please point out the problem and suggest solution..

There should be no such connection code in a JSP. Factor the code out to a Java class that is more easily debugged. Your JSP should have no Java code in it, especially as you are already using the JSTL.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to get connection
 
Similar Threads
upload file question
FileUpload - Form Fields shows Null value
how to upload using html or javascript?
Getting 404 when i forward request using request dispetcher
problem in uploading the file in springframework