This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am running a jsp page on this URL: http://www.xyz.com/register.jsp There is no database support available in www.xyz.com website. I want my form data to be posted on another site: http://www.abc.com/thankyou.jsp In the www.abc.com site I have support for both JSP and mySQL. If this scenario is possieble then what will be the jsp connectivity script for the following: String username = "abc_mysql_database_username"; String password = "abc_mysql_database_password"; String url= "jdbc:mysql://localhost:3356/events"; In place of localhost what to give. "events" is the name of the database.
That would be "jdbc:mysql://www.abc.com:3356/events". But no responsible hosting provider would let their firewall expose the database to the outside world like that. Try, but don't be surprised if you cannot get a connection. What you can do is, on www.abc.com, expose your database functionality as some sort of service accessible over HTTP. This can be RMI tunneled over HTTP, an XML-RPC service, a Web service, or some other HTTP-based service of your own design. You will have to think through the security implications of this, though, especially if you don't have SSL/TLS (HTTPS) support. - Peter [ April 09, 2003: Message edited by: Peter den Haan ]