We are planning to do a CD which contains educational software. It will have Quizzes for each grade of school. And the client wants it to be done in Java. It should have a database which contains questions and answers for each quiz of each grade. But I have a doubt regarding the making of CD version because as far as I know in order to run a servlet or JSP u need a server like Tomcat. How will u run it from a CD and make ur JSP or servlet interact with the database? Or should we make some applets or jar files and put them in the CDs? Please guide..
If they are thinking of a CD, then I would guess that they are thinking about having a client piece on the CD, and using RMI to get at the remote server stuff. Or perhaps having the whole application on the CD, and just using JDBC to get at the data on a remote server. In this case you just would not have a servlet or JSP component at all. What makes you think that there should be JSP/Servlets? Or are you just asking what is the best solution?
"JavaRanch, where the deer and the Certified play" - David O'Meara
Joined: Feb 18, 2003
I was just asking for te best solution. I understand now that we cannot use JSP/Servlets here. So we have to go for creating a Java application (in the CD)which interacts with the access database inside the CD and runs the quiz. We want something which executes immmediately once the CD is run (for this I understand that we need autorun.inf). What I am wondering is how do we go about doing it? Create a java applicaation using Swing, JDBC and accesss database? Have heard that we cannot make the application into a jar because the ODBC driver will not get to it in the CD. Then how will the class files run automatically. Please guide...
Joined: Sep 29, 2000
The business about not using a Jar because of the ODBC driver - never heard of it. Perhaps you should ask that question in the JDBC forum. As for getting that application to run automatically if it is not in a jar, I would guess that you would have your autorun invoke either a .bat file or a .sh file that would invoke the application with the correct classpath and property files etc.
Are you looking for a Stand alone Swing applicatin with a stand alone database. You could probably use Hypersonic as your stand alone database HSQL(It is a 100% java db and does not occupy too much space) and write your client in Swing.