Re: problem regarding dBa

Hello,

Regarding: Airline Information system project dBase connectivity.
Initially we made GUIs using swing in 1st Iteration.
we tried different layout, & we are ok with that.

But as project demand is to make Airline System online.
We were left only with two options to make project either in Applet
or
JSP.
Because by using swings we can make only applications (standalone-
not
web based)

Sir, will it be possible to make online application using swing?

Secondly we don't have that much time to make AIS in JSP as members
require from learning -to-implement.
So finally we decided to make it in Applet, & for back end we are
using MS-Access or SQL, please suggest us which one will be better to
use.

Now we have all the GUIs in applet, but problem arise at the time of
data base connectivity in applet.

I tried by using following code:

Following code I just made for Demo purpose as application
System DSN is: AIS
Table Name is: Name

import java.sql.*;

public class JDBCDemo
{
                public static void main(String args[])

                { try
                                {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                                    Connection c =
DriverManager.getConnection("jdbc:odbc:AIS");
        // connecting with AIS.mdb
                                    Statement st =
c.createStatement();

                                    ResultSet rs =
st.executeQuery("select fName,lName FROM
Name"); // shoot query

                                    while(rs.next())
                                    System.out.println(" name :"
+rs.getString("fName")+"
"+rs.getString("lName"));

                        c.close();
                        st.close();
                         }
                        catch(ClassNotFoundException cnf)
                        {

                                System.out.println("..Cnf
Exception");
                        }
                        catch(SQLException sql)
                        {
                                System.out.println("..SQL
Error"+sql);
                        }

                }
        }

And this code is absolutely working...

It means there is no problem in connectivity
I have already worked with JDBC by using Swing & SQL, but not by
using
applet.

Now when I use above code after Submit Button performed action.... In
applet
I also tried connection code in different methods in init(), run(),
paint() & still
I got same error as:

Exception in thread "AWT-EventQueue-1"
java.security.AccessControlException: acc
ess denied (java.lang.RuntimePermission
accessClassInPackage.sun.jdbc.odbc)

        at
java.security.AccessController.checkPermission(AccessController.java:
427)
        at
java.lang.SecurityManager.checkPermission(SecurityManager.java:532)

        at
sun.applet.AppletSecurity.checkPackageAccess(AppletSecurity.java:190)

        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:
110)

Is there any security issues regarding applet connectivity with
dBase?

Please Help & give guide regarding this

Thank You,

HESH