Hi Ravi. As Gianni wrote, you can't use JDBC directly. Using App Engine's datastore would be ideal, but if you must use an existing RDBMS, you'll have to put a web service in front of it. This can be as simple as a servlet or script (not running on App Engine) which retrieves the data and returns it as plain text, XML, JSON, or another format of your choice. You can call this servlet or script using App Engine's URL Fetch service.
- Jason On Mon, Sep 14, 2009 at 10:11 AM, Ravi Mandliya <funkyr...@gmail.com> wrote: > > Thanks for the reply... > Can u please elaborate How JDBC request can be pushed to another > server > I have an event coming up so I have to upload the site in urgency. > any help would be appreciated. > > On Sep 14, 2:25 am, Gianni Mariani <gian...@google.com> wrote: > > App Engine does not allow access to JDBC. You must either use the App > > Engine Datastore or push you JDBC requests to another server using the > > UrlFetch service (perhaps using SDC). > > > > > > > > > > > > On Sun, Sep 13, 2009 at 2:14 AM, Ravi Mandliya <funkyr...@gmail.com> > wrote: > > > > > Hello everyone I just uploaded my first application, its running, and > > > seems to be working fine, > > > but there is a problem, I get the following error when onblur() on > > > the > > > textbox is activated, I have applied ajax which fetches the data from > > > Database(IBM DB2). It generates the following error: > > > java.security.AccessControlException: access denied > > > (java.lang.RuntimePermission accessClassInPackage.sun.io) > > > Full error code is following: > > > java.security.AccessControlException: access denied > > > (java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc) > > > at java.security.AccessControlContext.checkPermission(Unknown > > > Source) > > > at java.security.AccessController.checkPermission(Unknown > > > Source) > > > at java.lang.SecurityManager.checkPermission(Unknown Source) > > > at com.google.appengine.tools.development.DevAppServerFactory > > > $CustomSecurityManager.checkPermission(DevAppServerFactory.java:139) > > > at java.lang.SecurityManager.checkPackageAccess(Unknown > > > Source) > > > at org.apache.jasper.servlet.JasperLoader.loadClass > > > (JasperLoader.java: > > > 117) > > > at org.apache.jasper.servlet.JasperLoader.loadClass > > > (JasperLoader.java: > > > 69) > > > at java.lang.ClassLoader.loadClassInternal(Unknown Source) > > > at java.lang.Class.forName0(Native Method) > > > at java.lang.Class.forName(Unknown Source) > > > at java.sql.DriverManager.getCallerClass(Unknown Source) > > > at java.sql.DriverManager.getConnection(Unknown Source) > > > at java.sql.DriverManager.getConnection(Unknown Source) > > > at org.apache.jsp.validate_jsp._jspService(validate_jsp.java: > > > 65) > > > at org.apache.jasper.runtime.HttpJspBase.service > > > (HttpJspBase.java:94) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > > > 806) > > > at org.apache.jasper.servlet.JspServletWrapper.service > > > (JspServletWrapper.java:324) > > > at org.apache.jasper.servlet.JspServlet.serviceJspFile > > > (JspServlet.java:292) > > > at org.apache.jasper.servlet.JspServlet.service > > > (JspServlet.java:236) > > > at > > > com.google.appengine.tools.development.PrivilegedJspServlet.access > > > $101(PrivilegedJspServlet.java:23) > > > at com.google.appengine.tools.development.PrivilegedJspServlet > > > $2.run > > > (PrivilegedJspServlet.java:59) > > > at java.security.AccessController.doPrivileged(Native Method) > > > at > > > com.google.appengine.tools.development.PrivilegedJspServlet.service > > > (PrivilegedJspServlet.java:57) > > > 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 > > > com.google.appengine.tools.development.StaticFileFilter.doFilter > > > (StaticFileFilter.java:121) > > > 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:313) > > > 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.headerComplete > > > (HttpConnection.java:830) > > > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java: > > > 514) > > > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java: > > > 211) > > > 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) > > > > > Thanks in advance > > > Regards > > > > -- > > Gianni Mariani > > Google, Sydney > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~----------~----~----~----~------~----~------~--~---
