Forum Stats

  • 3,839,935 Users
  • 2,262,549 Discussions
  • 7,901,101 Comments

Discussions

Categories

connecting to remote database(MSSqlserver) using applet

835813
835813 Member Posts: 7
edited Feb 4, 2011 2:26PM in Java Programming
HI, I am having a problem that I have to insert the data in a table from the applet. since the applet run on the client machine and the database is on the remote machine now when java on client machine looks for the driver "com.microsoft.jdbc.sqlserver.SQLServerDriver" then it give the exception that class com.microsoft.jdbc.sqlserver.SQLServerDriver not found. so how should I set the classpath of the jar file mssqlserver.jar so that applet can connect to remote database

Thnaks and Regards
Dilip Agarwal
Tagged:
· Share on TwitterShare on Facebook

Answers

  • 793415
    793415 Member Posts: 7,279 Bronze Badge
    The matter of the driver being on the run-time class-path of the applet, and its ability to connect to 'home' or remote servers is quite different.

    The driver will need to be on the class-path for either. To achieve that, add the mssqlserver.jar to the archive attribute of the applet element.

    To connect to a DB on a remote server, the applet would also need to be digitally signed (by you) and accepted (by the end user).
    793415
    · Share on TwitterShare on Facebook
  • 835813
    835813 Member Posts: 7
    Thanks for you reply,
    can you please tell me how to digitally sign the applet
    · Share on TwitterShare on Facebook
  • 835174
    835174 Member Posts: 16
    Hope this help:

    <object
    classid = "clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
    width = 1 height = 1
    name = "Application Web Client"
    codebase = "http://java.sun.com/j2se/1.4.1/download.html">

    <param name = CODEBASE VALUE = "." >
    <param name = ARCHIVE VALUE = "myjar1.jar,
    sqljdbc4.jar"
    <param name = CODE VALUE = "applet.myapplet.class" >
    <param name = NAME VALUE = "Application Web Client" >
    <param name = "type" VALUE = "application/x-java-applet;version=1.1" >
    <param name = CLIENT_INI VALUE = "client.ini">
    </object>
    · Share on TwitterShare on Facebook
  • Kayaman
    Kayaman Member Posts: 3,844 Silver Trophy
    832171 wrote:
    Hope this help:
    codebase = "http://java.sun.com/j2se/1.4.1/download.html">
    Nicely done!

    If they gave prizes for worthless advice here, you'd definitely get one.
    · Share on TwitterShare on Facebook
  • 793415
    793415 Member Posts: 7,279 Bronze Badge
    ..can you please tell me how to digitally sign the applet
    See the Generating and Verifying Signatures lesson (http://download.oracle.com/javase/tutorial/security/apisign/index.html) of the Java Tutorial.
    · Share on TwitterShare on Facebook
  • 793415
    793415 Member Posts: 7,279 Bronze Badge
    See also http://stackoverflow.com/questions/4897758/connecting-to-remote-databasemssqlserver-using-applet
    · Share on TwitterShare on Facebook
  • 803795
    803795 Member Posts: 164
    I suggest you have your applet talk to a servlet. The servlet actually talks to the database (and holds the userID/password). This way, you aren't embedding the userID/password to the database in the applet where someone might get it and have direct access ot your database (a security concern).

    I also suggest you review your design to see if separation of concerns might be a better choice (model view controller (MVC) design).
    · Share on TwitterShare on Facebook
This discussion has been closed.