Re: problem regarding dBa
To: comp.lang.java.gui
On 19 Sep, 12:36, HESH <maheshpanch...@gmail.com> wrote:
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?
Yes, applet can be based on swing too.
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.
Before you look at your own code again you should ask yourself - what
is the main difference between application and applet?
(one runs locally, the other runs on remote client)
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");
You are trying to load applet local (i.e. remote client)
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...
Your code is working in application, it does not mean that it will
work in remote applet - different security settings.
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
I suggest you read
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/samples/jdbc/s-Applt-java.htm
and change the code to suit your needs.
---
* Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24