Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Server-side JavaScript doubt - database connectivity  RSS feed

 
kiran bayyana
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am developing a website on Yahoo!Geocities. Now I want to have some kind of database connection to store my data. Only Access files r listed in geocities supported files. I know that I should use Server-side javascript to get database connection. But can anybody tell me how to get connected to Access database thru server-side JS. Or r they any other ways to do this? Anybody who developed websites with geocities etc. please help me. Waiting for the response. Thank you.
- Kiran
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The java way to do it would be with JSP, JDBC, and Sun's JDBC-ODBC bridge driver ( since there is no pure java JDBC driver for Access ). The way you are talking about doing it is called ASP (Active Server Pages), a Microsoft technology which is more likely to be supported by your particurlar host than JSP. It isn't too hard, but this isn't really the place to discuss it. Check out asp101.com and 4guysFromRolla.com to learn the basics of connecting to Access using server-side Javascript.
 
manav k
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think what kiran is talking abt is Server Side JavaScript. Yep it is possible to access databases using JavaScript, but you will need your own webserver for that becaus as far as I could remember Geocities does not support Server Side JavaScripts. But you could use java and a thin client (inside an applet and read/write to an access db)
-manav
 
kiran bayyana
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank u both for ur replies. Manav, can u please explain me in detail about accessing the Access database with Java applet(in view of Geocities webpage)? Do u want me to use LiveConnect or simply calling an applet from HTML and accessing the database with JDBC? Do u think Geocities support JDBC driver?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"manav k",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks
 
manav kher
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kiran there are a couple of ways to appraoch your problem
1) Move to a different provider, geocities is not a place where you can do what you are trying to do it is more for basic web pages. go to this link, it lists out providers that support technologies like JSP, CGI and ASP which will make your life so much more simpler
2) Write out flat files using java applets, if your database is going to be simpler then you can simply use flat files (the recommended way of doing non complex database read/write).
But if I were you I would leave geocities (which i did actually, i used to have a homepage there but due to these very limitations i moved out), because by going to a place like MyCGIserver.com etc not only will you get what you want, you will also learn a lot more.
-manav
 
manav kher
Ranch Hand
Posts: 98
 
kiran bayyana
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

thank u very much manav. Ur reply helped a lot.
 
kiran bayyana
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I searched a lot to change my web host geocities before. But I couldn't find this type of free web hosting supporting Servlets, JSP. Now I decided to change my host to one of them. Manav, can u please tell me which one is the best among those three. Which one r u using? Can u tell me any other good sites like this? Two of the three sites r supporting mySQL database. I don't know mySQL but I can learn for the purpose. So, I should select from the two. I would like to have ur advice. Thank you.
 
manav kher
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
check this post out http://www.javaranch.com/ubb/Forum7/HTML/002841.html
the type of data base shouldn't matter unless you have some data to migrate, if you are starting from scratch then as long as the DB supports SQL (mySQL has SQL which is slightly diff from SQL-92..the std most RDBMS's know) but most likely you will not have any problems
didn't myCGIserver.com work?...i thought it supported Servlets and JDBC?
-manav
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!