Hi Sowjanya, 2009/6/29 Sowjanya Yerramneni <y.sowja...@gmail.com>
> Hi, > > I am using spring and hibernate in my gwt application. > I configured my datasource in the application-context.xml. > > < > bean id=*"dataSource"* > > class=*"org.springframework.jdbc.datasource.DriverManagerDataSource"*> > > <property name=*"driverClassName"*> > > <value>jdbc.odbc.driver.OracleDriver</value> > > </property> > > <property name=*"url"*> > > <value>jdbc:oracle:thin:@10.10.10.21:1521:*wpstdev*</value> > > </property> > > <property name=*"username"*> > > <value>*dohsy*</value> > > </property> > > <property name=*"password"*> > > <value>password</value> > > </property> > > </bean> > When I run the application (in hosted mode ) I get the 'couldnot connect > jdbc connection error' though I had classes12.jar in my classpath. > Please help. > Do you also have your jar in your application server classpath as well (WEB-INF/lib) ? > > > > On Sat, Jun 27, 2009 at 8:17 PM, @vi <aviral.ban...@gmail.com> wrote: > >> >> Why is this restriction there? >> >> Is there some kind of custom Security implemented for Google Apps? >> >> On Jun 21, 2:40 am, Petein <majestyel...@gmail.com> wrote: >> > problem solved! Thanks! >> > >> > On Jun 20, 1:00 pm, Enea <eneager...@gmail.com> wrote: >> > >> > >> > >> > > hm... I had similar problem with jdbc... >> > >> > > if you are using eclipse, >> > > try to go under Project->properties->google->App Engine >> > > and disable "Use Google App Engine" checkbox . >> > >> > > regards :) >> > >> > > On 20 Giu, 02:00, Petein <majestyel...@gmail.com> wrote: >> > >> > > > package faceRecognition.server; >> > >> > > > import faceRecognition.client.AuthService; >> > > > import com.google.gwt.user.server.rpc.RemoteServiceServlet; >> > >> > > > import java.sql.*; >> > > > import java.util.*; >> > > > import java.text.SimpleDateFormat; >> > >> > > > /** >> > > > * The server side implementation of the RPC service. >> > > > */ >> > > > @SuppressWarnings("serial") >> > > > public class AuthServiceImpl extends RemoteServiceServlet implements >> > > > AuthService { >> > >> > > > public String doAuthenticate(String name, String surname, >> > > > String username, String password, >> > > > String email, String info){ >> > >> > > > String serverInfo = >> getServletContext().getServerInfo(); >> > > > String userAgent = >> getThreadLocalRequest().getHeader("User-Agent"); >> > >> > > > //jdbc part >> > >> > > > /* >> > > > Connection con = null; >> > > > try { >> > >> > > > Class.forName("com.mysql.jdbc.Driver").newInstance(); >> > >> > > > //out.println("<br>driver is ok"); >> > >> > > > String url = "jdbc:mysql://" + "localhost" + "/" + >> > > > "USERSDB" + "?"; >> > > > String usernamedb = "root"; >> > > > String passworddb = ""; >> > > > con = (Connection) DriverManager.getConnection(url, >> > > > usernamedb, passworddb); >> > >> > > > Statement st = con.createStatement(); >> > > > ResultSet rs; >> > >> > > > rs = st.executeQuery("SELECT username, password FROM >> > > > users"); >> > >> > > > boolean found = false; >> > >> > > > while (rs.next()) { >> > > > usernamedb = rs.getString(1); >> > > > passworddb = rs.getString(2); >> > >> > > > if (usernamedb.equals(username)) { >> > > > found = true; >> > > > break; >> > > > } >> > > > } >> > >> > > > if (!found){ >> > >> > > > password = " a"; >> > > > //create user >> > >> > > > String sql = "INSERT INTO testusers(name, username, >> > > > password, info) VALUES(?, ?, ?, ?)"; >> > >> > > > PreparedStatement pstmt = con.prepareStatement(sql); >> > >> > > > // Set the values >> > > > pstmt.setString(1, name); >> > > > pstmt.setString(2, username); >> > > > pstmt.setString(3, password); >> > > > pstmt.setString(4, info); >> > >> > > > //Calendar calendar = new GregorianCalendar(); >> String >> > > > time = calendar.getTime().toString(); //Thu Jun 11 02:30:10 EEST >> 2009 >> > >> > > > //String time = new GregorianCalendar().getTime >> > > > ().toString(); >> > >> > > > //pstmt.setString(5, time); >> > >> > > > pstmt.execute(); >> > >> > > > } >> > >> > > > }catch(ClassNotFoundException cnfe){ >> > > > return(cnfe.toString()); >> > > > } catch(SQLException sqle){ >> > > > return(sqle.toString()); >> > > > } catch(InstantiationException ie){ >> > > > return(ie.toString()); >> > > > }catch (IllegalAccessException iae) { >> > > > return(iae.toString()); >> > > > } >> > >> > > > */ >> > >> > > > return "Hello, " + name + " " + surname + >> "!<br><br>Server info: " >> > > > + serverInfo >> > > > + ".<br><br>Using:<br>" + userAgent >> + " Your request was sent!"; >> > > > } >> > >> > > > } >> > >> > > > when this part of code is executed without the jdbc part it executes >> > > > fine and the RPC method works ok. >> > > > When i execute the code as it is above i get these errors: >> > > > The server is running athttp://localhost:1598/ >> > > > 19 Ιουν 2009 11:33:32 μμ >> > > > com.google.appengine.tools.development.ApiProxyLocalImpl log >> > > > SEVERE: [1245454412421000] javax.servlet.ServletContext log: >> Exception >> > > > while dispatching incoming RPC call >> > > > com.google.gwt.user.server.rpc.UnexpectedException: Service method >> > > > 'public abstract java.lang.String >> > > > faceRecognition.client.AuthService.doAuthenticate >> > > > >> (java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.l >> ang.String,java.lang.String)' >> > > > threw an unexpected exception: java.lang.ExceptionInInitializerError >> > > > at >> com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure >> > > > (RPC.java:360) >> > > > at >> com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse >> > > > (RPC.java:546) >> > > > at >> com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall >> > > > (RemoteServiceServlet.java:166) >> > > > at >> com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost >> > > > (RemoteServiceServlet.java:86) >> > > > at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:713) >> > > > at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:806) >> > > > at >> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: >> > > > 487) >> > > > at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter >> > > > (ServletHandler.java:1093) >> > > > at >> > > > >> com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter >> > > > (TransactionCleanupFilter.java:43) >> > > > at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter >> > > > (ServletHandler.java:1084) >> > > > at org.mortbay.jetty.servlet.ServletHandler.handle >> > > > (ServletHandler.java:360) >> > > > at org.mortbay.jetty.security.SecurityHandler.handle >> > > > (SecurityHandler.java:216) >> > > > at org.mortbay.jetty.servlet.SessionHandler.handle >> > > > (SessionHandler.java:181) >> > > > at org.mortbay.jetty.handler.ContextHandler.handle >> > > > (ContextHandler.java:712) >> > > > at >> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: >> > > > 405) >> > > > at >> com.google.apphosting.utils.jetty.DevAppEngineWebAppContext.handle >> > > > (DevAppEngineWebAppContext.java:54) >> > > > at org.mortbay.jetty.handler.HandlerWrapper.handle >> > > > (HandlerWrapper.java:139) >> > > > at >> com.google.appengine.tools.development.JettyContainerService >> > > > $ApiProxyHandler.handle(JettyContainerService.java:306) >> > > > at org.mortbay.jetty.handler.HandlerWrapper.handle >> > > > (HandlerWrapper.java:139) >> > > > at org.mortbay.jetty.Server.handle(Server.java:313) >> > > > at >> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: >> > > > 506) >> > > > at org.mortbay.jetty.HttpConnection$RequestHandler.content >> > > > (HttpConnection.java:844) >> > > > at >> org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644) >> > > > at >> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205) >> > > > at >> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381) >> > > > at org.mortbay.io.nio.SelectChannelEndPoint.run >> > > > (SelectChannelEndPoint.java:396) >> > > > at org.mortbay.thread.BoundedThreadPool$PoolThread.run >> > > > (BoundedThreadPool.java:442) >> > > > Caused by: java.lang.ExceptionInInitializerError >> > > > at com.mysql.jdbc.NonRegisteringDriver.connect >> > > > (NonRegisteringDriver.java:282) >> > > > at >> java.sql.DriverManager.getConnection(DriverManager.java:582) >> > > > at >> java.sql.DriverManager.getConnection(DriverManager.java:185) >> > > > at faceRecognition.server.AuthServiceImpl.doAuthenticate >> > > > (AuthServiceImpl.java:37) >> > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> > > > at sun.reflect.NativeMethodAccessorImpl.invoke >> > > > (NativeMethodAccessorImpl.java:39) >> > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke >> > > > (DelegatingMethodAccessorImpl.java:25) >> > > > at java.lang.reflect.Method.invoke(Method.java:597) >> > > > at >> com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse >> > > > (RPC.java:527) >> > > > ... 25 more >> > > > Caused by: java.security.AccessControlException: access denied >> > > > (java.lang.RuntimePermission modifyThreadGroup) >> > > > at java.security.AccessControlContext.checkPermission >> > > > (AccessControlContext.java:323) >> > > > at java.security.AccessController.checkPermission >> > > > (AccessController.java:546) >> > > > at >> java.lang.SecurityManager.checkPermission(SecurityManager.java: >> > > > 532) >> > > > at >> com.google.appengine.tools.development.DevAppServerFactory >> > > > $CustomSecurityManager.checkPermission(DevAppServerFactory.java:122) >> > > > at >> com.google.appengine.tools.development.DevAppServerFactory >> > > > $CustomSecurityManager.checkAccess(DevAppServerFactory.java:149) >> > > > at java.lang.ThreadGroup.checkAccess(ThreadGroup.java:288) >> > > > at java.lang.Thread.init(Thread.java:332) >> > > > at java.lang.Thread.<init>(Thread.java:377) >> > > > at java.util.TimerThread.<init>(Timer.java:456) >> > > > at java.util.Timer.<init>(Timer.java:71) >> > > > at java.util.Timer.<init>(Timer.java:122) >> > > > at >> com.mysql.jdbc.ConnectionImpl.<clinit>(ConnectionImpl.java:208) >> > > > ... 34 more >> > >> > > > What's going on? I tried the same >> > >> > ... >> > >> > read more ยป >> >> -- >> -Regards, >> Sowjanya. >> >> >> >> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To post to this group, send email to Google-Web-Toolkit@googlegroups.com To unsubscribe from this group, send email to google-web-toolkit+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Web-Toolkit?hl=en -~----------~----~----~----~------~----~------~--~---