• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

A real life project ? ideas needed from u

 
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello folks,
I have started a project for developing a customized stand-alone s/w using Java and SQL Server 7.0 . I m giving a brief description of my project and my plan. I need all ur advices, corrections urgently. Hope u guys will help me....

The Jobs to Do :
==================
(1) Swing components in the main swithchboard for GUI. AWT may be used if necessary but better not to use.
(2) An SQL Server Database. I have chosen SQL 7.0 instead of 2000 due to his low powerful PC.
(3) Creating one databse containing approximately 8/9 tables and a few Views and Reports.
(4) Connecting to the database using JDBC-ODBC. (Or should i use anything else here instead? ).
(5) To give in the main switchboard buttons to click and get Forms for giving new entry and saving them.
(6) To give in the main switchboard buttons to click and open Forms for viewing already created tables.
(7) To generate reports on a specific searches depending on a particular field (say by date or by cutomer_id).
(8) To give an authentication (username/password) window to go to the main switchboard or to connect to the database.

To Remember
===========
(1) He is running a PC of Intel Pentuim 233 MMX with Windows 98 and 64 MB RAM. He'll upgrade RAM from 64 to 128.
(2) The whole thing may be done only by using SQL Server 7.0 but use of Java GUI is a must here
(3) It has to be delivered within approximately one month.

So now suggest me whether i m missing something. I have taken this project to learn the tools needed in a real-life project, with courage....as i m not n expert here. But i think JavaRanch is a gr8 resouorce to get helps from....
Any comment, participation, criticism, suggestion or idea is warmly welcome.

------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!

[This message has been edited by Ashik uzzaman (edited October 28, 2001).]
 
Ranch Hand
Posts: 898
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have u lookd already in www.BruceEckel.com?
It is better to upgrade to 256 MB RAM, really. It is, now, not much more expensive
[This message has been edited by G Vanin (edited October 29, 2001).]
 
Ranch Hand
Posts: 346
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashik
I guess u are well-set , have done ur home-work well.
Just one thing , is it gonna be Single server , mutiple clients ? ( tho seems obvious ). then how ll clients communicate wid server . using sockets i guess Or u gonna use RMI ?

------------------
Gagan (/^_^\) SCJP2
Die-hard JavaMonk -- little Java a day , keeps u going .
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thnx Gagan for ur interest! It's a stand-alone solution, a stand-alone PC not connected to the network will be used. I asked for more money to make it work under network with multiple clients(when i would have used sockets)....but they don't need that much. They'll only keep an operator who 'll maintain the s/w, give entries and generate reports to print them. He may need maximum 20,000 entries per months...
I m thinking whether report generating without third-party s/w (they are as expensiveas $300) will be tough for me. In that case may be i'll use SQL Server's report generating facilities. It's a small project where they previously used Foxpro and that worked properly only a few months and did not work more due tio heavy entries....
Only creating it with SQL Server would be a better solution with possibly Visual Basic. But i m doing it in Java to have some exercise/practice.
------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Gagan Indus
Ranch Hand
Posts: 346
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

nice idea Ashik
go ahead , just bit of same thing as G Vanin sed
u wanna run SQL server and then front-end on same PC , so make it lill powerfull
Yes i am sure u ll conquer it wid in one month
Anytime u nee my help , i ll be more than happy to come forward
Good luck
------------------
Gagan (/^_^\) SCJP2
Die-hard JavaMonk -- little Java a day , keeps u going .
 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ashik,
here some hints and questions:
(1)
Do some UML modeling, starting with Usecases.
(2)
To have more flexibility use RMI or even better realize a Web browser based solution using Servlets and JSP pages.
(3)
What does mean it has to be delivered in one month? Does it mean that you will work fulltime on the job for one month?
(4)
What should be the quality of the result? Should it be just a quick and dirty solution for training purposes or will someone regularly work with the software?
(5)
Should the creation of the database and of database elements also be possible through the software to be developed?
CU
R�diger
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thnx Gagan and Waurig for ur interests.
This is actually a small project (but with varieties of options, tables and relationships to be offered) and not to work in a network. The idea of UML i have thaught also but not yet decided. Developing it thru Servlets would rather be easier but not applicable here. My customer needs a stand-alone solution rather than each time open a browser....
The quality of the result should be at least medium-professional level and so i have got my one friend WAHID SADIK with me who has already worked in some projects. We are thinking to make a generalize s/w so that we can sell it to other firms with slight modifications, if possible. For our own sake, we decided to implement some security mechanism also so that no other one can use that s/w as far as we do not install them or decompiling the bytecodes may not result in full/understandable source code.
And yah, the money we are getting is not so much still not small also and we have taken it as a practice of our knowledge, facing standard problems in customer services as we may to work in a bigger project within a few months....its a rehersal you can say.
The time frame ONE MONTH is an estimated time and may varry a little. We two will work at night only (in our houses) as in day we have to go to offfice....
Thanks again and waiting for some additional tips and comments...

------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a reason you are using JAVA and starting from scratch? Doesn't sound like there is much to the database, why not just use Access or something like that.
Might save you a lot of time.

------------------
Happy Coding,
Gregg Bolinger
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My customer does not rely on the power of ACCESS, so wants SQL SERVER or ORACLE and he LIKES JAVA! Not providing the solution only is the matter here, but providing it with the Java is something special to me....i m having a little bit real-life experience by doing so.
But it's true that developing it with Visual Basic and ACCESS would save me a lot time. But in my country a lot work is going on VB, and we some people (lover of Java) want to work with Java whenver possible....
Thanks Gregg for your suggetion anyway.
------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashik,
Hey, I'm with you. I am in a similar situation. I had made a database for a friend in Access, and he needed some tables and fields added to it, so I scapped Access and am working on a JAVA one for him using MySQL.
The hard part it importing all his data from Access into the new Database, but it is a learning experience and it is fun for me.
Good luck with your project.

------------------
Happy Coding,
Gregg Bolinger
 
Guennadiy VANIN
Ranch Hand
Posts: 898
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashik,
I like everything said by Greg. Love to something is not a reason why you should worsen quality, spoil/endanger success of projects.
If you need to do a lot of work, you may consider VB/Access attitude as the starting point/prototyping. You first make all in VB/Access and then, when it works, you pass to Java and whatever you want. Here are many points: 80% of project just never comes to end. I have seen a lot of clients and your characterization of your client just do resemble me a lot the client that would tell you in the middle of the project that he never really needed it to be done...
Then I would like to recommend to find the codes of a similar projects because what you are doing is just have been already done million times!
Bruce Eckel's book that I advised contain almost 150 pages of advises (in the start and end part of book). Have you looked it already? Though of course there are dozens of books on organization, initiation of projects.
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thnx Vanin for your reference to Bruce Eckel's book! I have it and will go thru the appropriate chapters....
As pointed earlier, i am doing this project with a friend and we have decided to make a generic solution that may be implemented with few modifications for other future customers and so we are dividing it to modules. Each and every module should be indepenedent of each other and may be reused in our future projects as well. We are also taking it as an exercise of algorithm and trying to give so many features that our client might not have thaught of....due to our own sake of experience!
I have already tested the JDBC-ODBC bridge that's working fine in my Win2k Server. We already have started with Access and after some prelemanry testing we will shift to SQL Server 7.0 as in both case we are using JDBC-ODBC bridge. But there is also a chance that we'll use type 4 JDBC if the driver is avlbl.
I have worked in projects with VB-Access and VC++ - Access, but here i want to work with Java. Besides my client is aware of whether i am using Java or not....

------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Ranch Hand
Posts: 1246
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
just wondering..
Generic solution!? i think your project cries out for the
use of Patterns. I am in a process of leaning Patterns OOD.
If you are using patterns let us know how patterns have
helped you so far??
Have fun on your project.


 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Generic Solution in the sense that we have to modify our codes in some particular areas instead of starting anew for a new client. The areas to rebiult or modified would be minimal thaugh we are not going thru any design patterns and using papers and pencils to draw/visualize our plans....
Think abt developing an inventory Control System. There are so many in the world developed so far. If some of them can be taken as a model then i would say that it was a generic solution thaugh may have been implemented in a particular project....
Thnx for ur interest FEI!
------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Guennadiy VANIN
Ranch Hand
Posts: 898
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashik,
IMHO, I would rely on drivers 1 or 2 only, because they are the most developed, debuged and "generic" (adapted for many SW, DBMS, OSes, formats). Tell me if you find driver 4 (I would be surprised) and how much it is helpful (my beleive it will be pain in the ass!!!
I told to use VB/Access for protyping (a "Lego" experiment). Above prototyping, there are some graphical/wizard/diagram/translating tools (you just can see the codes of macros in VB, of relational diagrams in SQL). I doubt that you have it in/for Java, at least it is not that cheap, well done?
So, shall you use EJBs?
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Vanin! We have already prepared the preliminary stages and decided finally to use Type 1 driver (JDBC-ODBC) with SQL Server 7.0 and Windows NT Server/2000 Server. Thanks for ur suggsion at it matches our decision accordingly. We are giving the operator no chance to make a mistake after he opens the s/w and till he closes the s/w. Each and every event we have analyzed and capturing them according with swings and event listeners. We are using JBuilder 5.0 in development phase....
If we are able to deliver it successfully we have to resell it to other clients at double price...if we get any....

------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
Guennadiy VANIN
Ranch Hand
Posts: 898
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ashik,
1)Nice to have opportunity to develop because I mainly patch bugs or small additions.
2)I just should warn that JBuilder maintains its project references but what may need to be adjusted for independent or in other PC/OS launching. Just you should test separately before delivering to client.
Vanin
Send me Email notification (to gvanin@iapmei.pt) in case of reply you decide replying
[This message has been edited by G Vanin (edited November 13, 2001).]
 
Ashik Uzzaman
Ranch Hand
Posts: 2376
MySQL Database Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thnx Vanin for the timely warning. I already noticed the JBuilder fact, but was not sure... ...
------------------
Muhammad Ashikuzzaman (Fahim)
Sun Certified Programmer for the Java� 2 Platform
--When you learn something, learn it by heart!
 
I guess I've been abducted by space aliens. So unprofessional. They tried to probe me with this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic