Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

java database applet connectivity

Posted on 2002-05-02
8
225 Views
Last Modified: 2010-03-31
i want to use a java applet/servlet for user aunthentication for an online application that i'm developing.the applet connects to an MS Access database So i want the applet to verify the details entered by the user ny comparing with some values st
0
Comment
Question by:thembie
8 Comments
 
LVL 16

Expert Comment

by:heyhey_
ID: 6985870
what's the problem ?
0
 

Author Comment

by:thembie
ID: 6986190
no the problem is i'm failing to connect the applet to the database and i'm getiing datasource not found error.i've set up the drivers correctly but still getting the same error
0
 
LVL 16

Expert Comment

by:heyhey_
ID: 6986225
post the full exception stacktrace.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 9

Expert Comment

by:Ovi
ID: 6987902
"the problem is i'm failing to connect the applet to the database and i'm getiing datasource not found
error.i've set up the drivers correctly but still getting the same error" - to what datasource are you connecting? Is local datasource accesed with odbc or remote server? Do you have raised sequrity exception or db connect exception?
0
 
LVL 3

Expert Comment

by:shyamkumarreddy
ID: 6987988
Thembie.
If you are trying to connect to database from applet. Then you need to been signed applet or the database and web server should be in the same database.
Datasource is the Client dependent stuff. I don't think it is possible to connect applet using DSN. DSN is client side piece of information. So u need to use to use Type3 or Type 4 drivers.
Type 1 and Type 2 are client dependent.

Shyam
0
 
LVL 4

Expert Comment

by:pellep
ID: 6989177
Access database is a 'desktop' database, ie not distributed. accessing an access db over a network is done thru the windows file-sharing system. an applet trying to use an access db is thus subject to two levels of security checks.
1) Applet security (has to be signed to access filesystem)
2) Windows security (machine running applet has to have access to machine hosting access db thru windows filesharing)

I'd suggest that if you intend your applet to acces your db you choose a true RDBMS (where the client can connect to the db thru TCP/IP directly via an appropriate JDBC driver), like Oracle or SQL-server. If you are not keen on paying there are free alternatives like MySQL or Postgress.

If you are forced to use an Access db, i'd try and use servlets for all your db-dependant logic, since you can host both the db and the servlet engine on the same machine, thereby removing the depenancy on remote connectability.

PAP
0
 
LVL 9

Expert Comment

by:Venci75
ID: 7992933
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
PAQ'd and pts removed
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Venci75
EE Cleanup Volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8048437
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HTTPSessionBindingListernter not configured in deployment descriptor 2 65
difference of if loops 23 62
jsp login check 12 42
Selenium docs api java index 3 48
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question