i have done some demo application in GWT but when i m doing database
connection in 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()
do i have to make any changes to my gwt.xml file or any other
configuration change????????
this is my code at server side ...
package com.example.server;
import java.sql.*;
import com.example.server.DB_Conn;
import com.example.client.GreetingService;
import com.example.shared.FieldVerifier;
import com.google.gwt.user.server.rpc.RemoteServiceServlet;
/**
* The server side implementation of the RPC service.
*/
@SuppressWarnings("serial")
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");
displayData+="Driver Information";
System.out.println("\tDriver Name: " + dm.getDriverName());
displayData+="\tDriver Name: " + dm.getDriverName();
System.out.println("\tDriver Version: " + dm.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("\tDatabase Name: "
+ dm.getDatabaseProductName());
System.out.println("\tDatabase Version: "
+ dm.getDatabaseProductVersion());
System.out.println("Avalilable Catalogs ");
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.
