hello friend
i m doing database connection on server in service implementation file
it gives error as
java.security.AccessControlException: access denied
(java.io.FilePermission C:\DOCUME~1\....\LOCALS~1\Temp read)
at DirverManager.getConnection()
this is my source code
public class GreetingServiceImpl extends RemoteServiceServlet
implements
GreetingService {
private java.sql.Connection con = null;
public String greetServer(String input) throws
IllegalArgumentException {
try {
displayData +="Before Class Load! <br> ";
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
displayData +="Before Connection! <br> ";
con = DriverManager.getConnection("jdbc:jtds:sqlserver://
ServerName /databaseName","username","password");
displayData +="After Connection! <br> ";
if (con != null)
System.out.println("Connection Successful!");
displayData +="Connection Successful!";
} catch (Exception e) {
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " +
e.getMessage());
displayData +="Error Trace in getConnection() : " +
e.getMessage();
}
java.sql.DatabaseMetaData dm = null;
java.sql.ResultSet rs = null;
try {
if (con != null) {
dm = con.getMetaData();
System.out.println("Driver Information");
rs = dm.getCatalogs();
while (rs.next()) {
System.out.println("\tcatalog: " +
rs.getString(1));
displayData+="\tcatalog: " + rs.getString(1);
}
rs.close();
rs = null;
//closeConnection();
} else
System.out.println("Error: No active
Connection");
} catch (Exception e) {
e.printStackTrace();
}
dm = null;
String serverInfo = getServletContext().getServerInfo();
String userAgent = getThreadLocalRequest().getHeader("User-
Agent");
return " Display " + displayData
}
}
--
You received this message because you are subscribed to the Google Groups
"Google Web Toolkit" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-web-toolkit?hl=en.
