how to let java applet using mysql database work in zope?
Hello! Currently, I am trying to integrate one java applet to zope/plone. my java applet use mySQL database and is working outside zope, however, when I integrate my applet into zope, it can not take mySQL data anymore. Please give me suggestions how to overcome this problem. (I have tried to connect mySQL database to zope as external, it works with DTML and ZPT but I do not know how to do with my java applet ) Best regards, Lon Lon --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze.
+-------[ LonLon ]---------------------- | Hello! | | Currently, I am trying to integrate one java applet to zope/plone. my java | applet use mySQL database and is working outside zope, however, when | I integrate my applet into zope, it can not take mySQL data anymore. Please | give me suggestions how to overcome this problem. | (I have tried to connect mySQL database to zope as external, it works with DTML | and ZPT but I do not know how to do with my java applet ) You're letting a java applet connect to a MySQL database located on one of your servers from ANYWHERE on the internet? Are you sure this is really what you're really trying to do? [WebServer] ---[Internet]--- [Client Machine] [MySQL DB] [Java Applet] As you can see the Java Applet runs on the Client Machine and would have to connect to your MySQL DB across the internet... You will probably have to modify your Java Applet to use some other way to get the data (XMLRPC would probably be your best bet, but, there are other ways) -- Andrew Milton akm@theinternet.com.au
On 26.02.06 03:36:59, LonLon wrote:
Currently, I am trying to integrate one java applet to zope/plone. my java applet use mySQL database and is working outside zope, however, when I integrate my applet into zope, it can not take mySQL data anymore. Please give me suggestions how to overcome this problem. (I have tried to connect mySQL database to zope as external, it works with DTML and ZPT but I do not know how to do with my java applet )
This is totally unrelated to Zope, because your applet runs on the client side in the browser. Now my guess is, that it is not allowed to access the database, either due to restrictions that apply to java applets or by MySQL not listening on external interfaces or not allowing logins from anywhere else than localhost. You should go either to a Java or MySQL Mailinglist/Forum to discuss this. Andreas -- You will contract a rare disease.
Dear Andrew and Andreas, Thanks a lot for your comments and suggestions! I will try my best. Best regards, lon Andreas Pakulat <apaku@gmx.de> wrote: On 26.02.06 03:36:59, LonLon wrote:
Currently, I am trying to integrate one java applet to zope/plone. my java applet use mySQL database and is working outside zope, however, when I integrate my applet into zope, it can not take mySQL data anymore. Please give me suggestions how to overcome this problem. (I have tried to connect mySQL database to zope as external, it works with DTML and ZPT but I do not know how to do with my java applet )
This is totally unrelated to Zope, because your applet runs on the client side in the browser. Now my guess is, that it is not allowed to access the database, either due to restrictions that apply to java applets or by MySQL not listening on external interfaces or not allowing logins from anywhere else than localhost. You should go either to a Java or MySQL Mailinglist/Forum to discuss this. Andreas -- You will contract a rare disease. _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze.
participants (3)
-
Andreas Pakulat -
Andrew Milton -
LonLon