asked on

connection to DB from an applet

hi.
IM building a chat on the web and i wanted to keep info in some tables and then loop around them to take the data.

my Q is, can i connect to DB by an applet and if so, how?
i connect threw applications with the JDBC driver but it doesent seem to work from an applet.
thanks

Mick Barry

You can certainly connect to a database from an applet in exactly the same way you do from an application.
If you're applet is not signed then you must use either a type 3 or 4 JDBC driver.

gilboker

ASKER

well im using JdbcOdbcDriver and i dont know why it doesent connect from the applet after loading to web page.

i have the same example in an application and there it work perfectly

Mick Barry

Because it's not a type 3 or 4 driver.
Get yourself a type 3/4 driver and it will work.

heyhey_

> Get yourself a type 3/4 driver and it will work.

you probably won't find such driver for Access :)

try MySQL + mmsql jdbc driver

P.S. IMHO using datatbase from applet to implement chat is TERRIBLE design

kelfink

Type 4 jdbc can connect from an applet, but ONLY by connecting to a database on the machine which served the applet.
It would be a browser security violation, if an applet
was allowed to open network connections anywhere but back to the server it was launched from.

Mick Barry

Type 3/4 drivers for Access exist, they just cost money :)
Have a look at JDataConnect at http://www.j-netdirect.com/ I think they have a single connection license for free.

I agree regards the design decision.

gilboker

ASKER

kelfink
Where can i find this type of JDBC bridge(type 4)?

Mick Barry

Depends on you DB.

gilboker

ASKER

im using MSSql7

ASKER CERTIFIED SOLUTION

Mick Barry

membership

This solution is only available to members.