Re: Need Help for gwt-rpc mysql database connectivity

[Khanh Dao Minh]

It sound you need a SocketPermission. Try this: 
http://java.sun.com/developer/onlineTraining/Programming/JDCBook/appA.html#SocketPermission

Regards,
KhanhDM.

-- 
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.

Re: Need Help for gwt-rpc mysql database connectivity

[Dilip Rathod]

Tanks Ben, Jaun for taking interest in my difficulties.

I finnaly got stack trace. In fact I am new to gwt & eclipse, good knowledge
of java.
But things are not turning as i expect. So can any body give me some
detailed steps to connect to mysql in development mode.

Connection conn = null;
String url  =
"jdbc:mysql://localhost:3306/SeekwadiDataBank";
String driver   = "com.mysql.jdbc.Driver";
String user = "user";  String pass = "user";

Class.forName(driver).newInstance();   ==> works fine

conn = DriverManager.getConnection(url, user, pass);
=>problamatic whose stacktrace is given below

I thank in advance

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could
not create connection to database server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at
com.google.appengine.tools.development.agent.runtime.Runtime.newInstance_(Runtime.java:112)
at
com.google.appengine.tools.development.agent.runtime.Runtime.newInstance(Runtime.java:120)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2355)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at
com.google.appengine.tools.development.agent.runtime.Runtime.newInstance_(Runtime.java:112)
at
com.google.appengine.tools.development.agent.runtime.Runtime.newInstance(Runtime.java:120)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at com.demo.server.GeneralServiceImpl.login(GeneralServiceImpl.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
com.google.appengine.tools.development.agent.runtime.Runtime.invoke(Runtime.java:100)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
at
com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:58)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:122)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at
org.mortbay.je

Re: Need Help for gwt-rpc mysql database connectivity

[Ben Imp]

Yeah, I've been meaning to do something like that in my application.
The current lack of details on the client isn't very pleasant for
users or developers.  SSH-ing into the prod server is annoying as
well.  I'm always worried about breaking something with a twitchy rm -
rf finger.

I'm still curious as to why OP can't see the logs in his server,
though.  If it happens in development mode, odds are the server
console is right there in eclipse, full stack trace and all.

-Ben

On Mar 15, 7:20 am, Sean  wrote:
> This is more for Ben then the original poster, but you can make your own
> serializble exception, catch the exception on the server side and then throw
> your Serializable Exception with the original message in it. It makes RCP so
> much easier to debug.

-- 
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.

Re: Need Help for gwt-rpc mysql database connectivity

[Sean]

This is more for Ben then the original poster, but you can make your own 
serializble exception, catch the exception on the server side and then throw 
your Serializable Exception with the original message in it. It makes RCP so 
much easier to debug. 


-- 
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.

Re: Need Help for gwt-rpc mysql database connectivity

[Dilip Rathod]

I cannot connect to database in development mode/hosted mode.
my environment: eclipse hellio 3.6, fedora 12, mysql, gwt2.2.

I could successfully connect to mysql using JSP using same environment.

On Tue, Mar 15, 2011 at 1:33 AM, Juan Pablo Gardella <
gardellajuanpa...@gmail.com> wrote:

> This help?
> http://stackoverflow.com/questions/2297356/mysqlnontransientconnectionexception-in-jdbc-program-at-run-time
>
>
> 
> Juan
>
>
> 2011/3/14 Dilip Rathod 
>
>> I can gwt-rpc communication with server sucessfully.
>> but when i want to interact with mysql I get following error
>>
>> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
>> Could not create connection to database server.
>>
>> I added mysql connector to WEB-Inf/lib dierctory
>>
>> following is my code that tries to connect to data base
>>
>> public String login(String usr,String pwd)
>>{
>>Connection conn = null;
>>String url  = "jdbc:mysql://localhost:3306/
>> SeekwadiDataBank";
>>String db   = "SeekwadiDataBank";
>>String driver   = "com.mysql.jdbc.Driver";
>>String user = "user";
>>String pass = "user";
>>String connerr=null;
>>try
>>  {
>>connerr="Connecting ";
>>Class.forName(driver).newInstance();
>>connerr+="Still Working";
>>//Class.forName("com.mysql.jdbc.Driver");
>>conn = DriverManager.getConnection(url, user, pass);
>>connerr="Conncted";
>>  } catch (Exception e) {
>>// TODO: handle exception
>>  connerr+=e.toString();
>>
>>}
>> return connerr;
>>}
>>
>>
>> i cannot give full stack trace becuse it is not available at client
>> side
>>
>> client side code taht communicate asynchronoulsy to server is
>>
>> Hyperlink login = new Hyperlink("Login", "Login");
>>login.addClickListener(new ClickListener() {
>>public void onClick(Widget widget)
>>{
>>hp.clear();
>>final TextBox usr=new TextBox();
>>final PasswordTextBox pwd=new PasswordTextBox();
>>
>>Button loginb=new Button("Login");
>>loginb.addClickHandler(new ClickHandler()
>>{
>> public void onClick(ClickEvent event)
>>  { //Window.alert("Starts");
>>  AsyncCallback callback = new AsyncCallback()
>>   {
>>
>>   public void onSuccess(Object result)
>> {
>>if(((String) result).equals("Ok"))
>>{ Window.alert("Login
>> Status:"+result.toString());
>> usr.setText(""); pwd.setText(""); }
>>   else { Window.alert("Login
>> Status:"+result.toString()); usr.setText(""); pwd.setText(""); }
>> }
>> public void onFailure(Throwable caught)
>>   { Window.alert(caught.getMessage()); }
>>   };
>>  no.login(usr.getText(),pwd.getText(), callback);
>>   //Window.alert("Ends");
>>  }
>>
>>});
>>
>> --
>> 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.
>>
>>
>  --
> 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.
>

-- 
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.

Re: Need Help for gwt-rpc mysql database connectivity

[Ben Imp]

I am quite curious how it is that you can not have access to the
server side stack trace.  I suspect the answer to your question lies
there.

-Ben

On Mar 14, 7:04 am, Dilip Rathod  wrote:
> I can gwt-rpc communication with server sucessfully.
> but when i want to interact with mysql I get following error
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> Could not create connection to database server.
>
> I added mysql connector to WEB-Inf/lib dierctory
>
> following is my code that tries to connect to data base
>
> public String login(String usr,String pwd)
>         {
>                 Connection conn     = null;
>         String url          = "jdbc:mysql://localhost:3306/
> SeekwadiDataBank";
>         String db           = "SeekwadiDataBank";
>         String driver       = "com.mysql.jdbc.Driver";
>         String user         = "user";
>         String pass         = "user";
>         String connerr=null;
>         try
>           {
>                 connerr="Connecting ";
>                 Class.forName(driver).newInstance();
>                 connerr+="Still Working";
>                 //Class.forName("com.mysql.jdbc.Driver");
>                 conn = DriverManager.getConnection(url, user, pass);
>                 connerr="Conncted";
>           } catch (Exception e) {
>                         // TODO: handle exception
>                   connerr+=e.toString();
>
>                 }
>                  return connerr;
>         }
>
> i cannot give full stack trace becuse it is not available at client
> side
>
> client side code taht communicate asynchronoulsy to server is
>
> Hyperlink login = new Hyperlink("Login", "Login");
>                 login.addClickListener(new ClickListener() {
>                     public void onClick(Widget widget)
>                     {
>                         hp.clear();
>                         final TextBox usr=new TextBox();
>                         final PasswordTextBox pwd=new PasswordTextBox();
>
>                         Button loginb=new Button("Login");
>                         loginb.addClickHandler(new ClickHandler()
>                         {
>                          public void onClick(ClickEvent event)
>                           { //Window.alert("Starts");
>                           AsyncCallback callback = new AsyncCallback()
>                            {
>
>                            public void onSuccess(Object result)
>                          {
>                                 if(((String) result).equals("Ok"))
>                                 { Window.alert("Login 
> Status:"+result.toString());
> usr.setText(""); pwd.setText(""); }
>                                else { Window.alert("Login
> Status:"+result.toString()); usr.setText(""); pwd.setText(""); }
>                          }
>                              public void onFailure(Throwable caught)
>                                { Window.alert(caught.getMessage()); }
>                            };
>                           no.login(usr.getText(),pwd.getText(), callback);
>                            //Window.alert("Ends");
>                           }
>
>                         });

-- 
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.

Re: Need Help for gwt-rpc mysql database connectivity

[Juan Pablo Gardella]

This help?
http://stackoverflow.com/questions/2297356/mysqlnontransientconnectionexception-in-jdbc-program-at-run-time


Juan

2011/3/14 Dilip Rathod 

> I can gwt-rpc communication with server sucessfully.
> but when i want to interact with mysql I get following error
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> Could not create connection to database server.
>
> I added mysql connector to WEB-Inf/lib dierctory
>
> following is my code that tries to connect to data base
>
> public String login(String usr,String pwd)
>{
>Connection conn = null;
>String url  = "jdbc:mysql://localhost:3306/
> SeekwadiDataBank";
>String db   = "SeekwadiDataBank";
>String driver   = "com.mysql.jdbc.Driver";
>String user = "user";
>String pass = "user";
>String connerr=null;
>try
>  {
>connerr="Connecting ";
>Class.forName(driver).newInstance();
>connerr+="Still Working";
>//Class.forName("com.mysql.jdbc.Driver");
>conn = DriverManager.getConnection(url, user, pass);
>connerr="Conncted";
>  } catch (Exception e) {
>// TODO: handle exception
>  connerr+=e.toString();
>
>}
> return connerr;
>}
>
>
> i cannot give full stack trace becuse it is not available at client
> side
>
> client side code taht communicate asynchronoulsy to server is
>
> Hyperlink login = new Hyperlink("Login", "Login");
>login.addClickListener(new ClickListener() {
>public void onClick(Widget widget)
>{
>hp.clear();
>final TextBox usr=new TextBox();
>final PasswordTextBox pwd=new PasswordTextBox();
>
>Button loginb=new Button("Login");
>loginb.addClickHandler(new ClickHandler()
>{
> public void onClick(ClickEvent event)
>  { //Window.alert("Starts");
>  AsyncCallback callback = new AsyncCallback()
>   {
>
>   public void onSuccess(Object result)
> {
>if(((String) result).equals("Ok"))
>{ Window.alert("Login
> Status:"+result.toString());
> usr.setText(""); pwd.setText(""); }
>   else { Window.alert("Login
> Status:"+result.toString()); usr.setText(""); pwd.setText(""); }
> }
> public void onFailure(Throwable caught)
>   { Window.alert(caught.getMessage()); }
>   };
>  no.login(usr.getText(),pwd.getText(), callback);
>   //Window.alert("Ends");
>  }
>
>});
>
> --
> 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.
>
>

-- 
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.

Need Help for gwt-rpc mysql database connectivity

[Dilip Rathod]

I can gwt-rpc communication with server sucessfully.
but when i want to interact with mysql I get following error

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server.

I added mysql connector to WEB-Inf/lib dierctory

following is my code that tries to connect to data base

public String login(String usr,String pwd)
{
Connection conn = null;
String url  = "jdbc:mysql://localhost:3306/
SeekwadiDataBank";
String db   = "SeekwadiDataBank";
String driver   = "com.mysql.jdbc.Driver";
String user = "user";
String pass = "user";
String connerr=null;
try
  {
connerr="Connecting ";
Class.forName(driver).newInstance();
connerr+="Still Working";
//Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, pass);
connerr="Conncted";
  } catch (Exception e) {
// TODO: handle exception
  connerr+=e.toString();

}
 return connerr;
}


i cannot give full stack trace becuse it is not available at client
side

client side code taht communicate asynchronoulsy to server is

Hyperlink login = new Hyperlink("Login", "Login");
login.addClickListener(new ClickListener() {
public void onClick(Widget widget)
{
hp.clear();
final TextBox usr=new TextBox();
final PasswordTextBox pwd=new PasswordTextBox();

Button loginb=new Button("Login");
loginb.addClickHandler(new ClickHandler()
{
 public void onClick(ClickEvent event)
  { //Window.alert("Starts");
  AsyncCallback callback = new AsyncCallback()
   {

   public void onSuccess(Object result)
 {
if(((String) result).equals("Ok"))
{ Window.alert("Login 
Status:"+result.toString());
usr.setText(""); pwd.setText(""); }
   else { Window.alert("Login
Status:"+result.toString()); usr.setText(""); pwd.setText(""); }
 }
 public void onFailure(Throwable caught)
   { Window.alert(caught.getMessage()); }
   };
  no.login(usr.getText(),pwd.getText(), callback);
   //Window.alert("Ends");
  }

});

-- 
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.