Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

I want to develop a simple application which is not complex

 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to develop an application using JSP, AJAX, Database and servelets. The application needs a fex details shown on the web page which will be filled by the user and will want it to be simple not fuzzy logic.

I have no idea about database and JDBC kindly help me in choosing a database and develop this simple application.

Thank you for the forth coming response.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Pretty much any relational database will do. What are your requirements?
 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it is very simple on a form i want one field to be filled by user then rest of them must be availabe in the form of drop down list from the database and when the form is complete and submitted DB must be updaed accordingly.
 
Mohamed Sanaulla
Saloon Keeper
Posts: 3159
33
Google App Engine Java Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Neeraj, Welcome to JavaRanch
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, any old DB will do for his. You probably want to avoid MS Access (you can only access this via ODBC or a commercial driver) but there are any number of databases out there you might like to try. MySQL is free and popular, Postgres similarly so, as is Hypersonic SQL or Derby, SQL Server Express is also free and comes with quite a good toolset if you like working in a Windows environment.
 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Okay, I agree I downloaded SQL Server but have no idea how to use it and how to connect it with java programs.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The documentation explains this. You should also probably look at our JDBC FAQs and Oracle's JDBC tutorial.
 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the application do not need database to be created by the java program it will be created using the dbms itself. It only needs db retrieval and updation. Well I am still not sure which db to use.
 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to use Java DB is it esy to use. Since the application is small I do not want to download a big DB
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

the application do not need database to be created by the java program it will be created using the dbms itself. It only needs db retrieval and updation. Well I am still not sure which db to use.

OK - what is your confusion? All the databases I listed above behave like this.


how to use Java DB is it esy to use. Since the application is small I do not want to download a big DB

Not sure I follow what you mean by "big DB". I wouldn't consider any of the database I listed above to be that big. What part are you struggling with?
 
neeraj kaushik
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have never worked on any database though I have seen many like oracle, sql server. I fear about the typical interface they have, I have installed sql server 2005 and I do not know how to create tables in it, is there any way to learn it.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. It comes with documentation that covers this. And MSDN is a good resource. SQL Server management studio is fairly intuitive as well.
 
Ashutosh M Kulkarni
Ranch Hand
Posts: 41
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you should opt for MySQL for many reasons.
1. The most important was already told by Paul - it is popular.
2. Since it is popular, its issues and How To's are discussed over a wide range of forums. In case you have any trouble, finding a solution would not be a problem.
3. Also, it is FREE. Which saves you from the troubles such as license et al.
4. It is not a very big download/installation which also qualifies another one of your criteria.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64985
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashutosh M Kulkarni wrote:I think you should opt for MySQL for many reasons.
1. The most important was already told by Paul - it is popular.
2. Since it is popular, its issues and How To's are discussed over a wide range of forums. In case you have any trouble, finding a solution would not be a problem.
3. Also, it is FREE. Which saves you from the troubles such as license et al.
4. It is not a very big download/installation which also qualifies another one of your criteria.


...though I would warn that the default MyISAM (if it is still the default?) database engine does not implement an RDBMS, which can be confusing if you are a beginner on this topic. Fine if all you want is a fairly basic persistent store for simple unrelated data, assuming you can tolerate some data loss. But something to be aware of if you choose to use it.

(NB: all the databases I listed above are free to use, the only caveat being that SQL Server express needs a Windows OS license)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic