Here the steps I followed to solve the previous mysql connection related
error:
1- Add MySQL Connector to Eclipse and Tomcat Classpath
2- Created the class that connect to mysql (AuthServiceImpl in the previous
case)
3- Configure Interfaces on the client side (AuthService and
AuthServiceAsync)
4- Configure the gwt.xml file by adding the following
<servlet class="com.myproject.server.AuthServiceImpl "
path="/AuthServiceI" />
Could you print your error stack, that could help people to understand your
problem.
2009/6/29 Sowjanya Yerramneni <[email protected]>
> I tried to run the same on tomcat. I have it on the tomcat's common/lib
> folder... Still it did not work on tomcat too.
>
>
> On Mon, Jun 29, 2009 at 2:53 PM, Sowjanya Yerramneni <[email protected]
> > wrote:
>
>> i have it in my web-inf/lib.
>>
>> Where else should i place it? please be lil clear.
>>
>>
>> Thanks for your quick response.
>>
>> On Mon, Jun 29, 2009 at 2:24 PM, Keerthan MUTHURASA <
>> [email protected]> wrote:
>>
>>> Hi Sowjanya,
>>>
>>> 2009/6/29 Sowjanya Yerramneni <[email protected]>
>>>
>>>> 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 <[email protected]> wrote:
>>>>
>>>>>
>>>>> Why is this restriction there?
>>>>>
>>>>> Is there some kind of custom Security implemented for Google Apps?
>>>>>
>>>>> On Jun 21, 2:40 am, Petein <[email protected]> wrote:
>>>>> > problem solved! Thanks!
>>>>> >
>>>>> > On Jun 20, 1:00 pm, Enea <[email protected]> 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 <[email protected]> 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.
>>>>>
>>>>>
>>>>>
>>>
>>>
>>> --
>>> -Regards,
>>> Sowjanya.
>>>
>>
>>
>>
>> --
>> -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 [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
-~----------~----~----~----~------~----~------~--~---
