Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 7 of 7

Thread: Just started messing with databases

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Just started messing with databases

    o


  2. #2
    Super Moderator jps's Avatar
    Join Date
    Jul 2012
    Posts
    2,642
    My Mood
    Daring
    Thanks
    90
    Thanked 263 Times in 232 Posts

    Default Re: Just started messing with databases

    Quote Originally Posted by pbj View Post
    I'm sort of confused about the best way to go about learning how to use databases with Java.
    Play with an implementation of a word game. Use different designs to store/sort/however-manipulate a large lexicon. Scramble a word and see how many words in the lexicon can be made from the letters. (I made one, it is fun to play even today)

    Quote Originally Posted by pbj View Post
    First off, does the DBMS software that you use matter? Does it really matter in a learning environment what one I use?
    Yes, use as many different ones as possible. You never know what you will run into and you should be familiar with the database patterns rather than the specific syntax.

    Quote Originally Posted by pbj View Post
    Could someone hook me up with a sample skeleton code, on how I would go about starting a Java Derby based application?
    Search engine friend. There are plenty of code samples if you spend some effort searching.

  3. #3
    Junior Member
    Join Date
    Jul 2013
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Just started messing with databases

    o

  4. #4
    Senior Member PhHein's Avatar
    Join Date
    Mar 2013
    Location
    Germany
    Posts
    609
    My Mood
    Sleepy
    Thanks
    10
    Thanked 93 Times in 86 Posts

    Default Re: Just started messing with databases

    Quote Originally Posted by pbj View Post
    I'll be leaving. Please delete my account, I'm going to a friendlier community that doesn't trip over their own ego. Thanks
    LOL, bye!

  5. #5
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,320
    Thanks
    181
    Thanked 833 Times in 772 Posts
    Blog Entries
    5

    Default Re: Just started messing with databases

    @pbj, you are free to never visit this site again. Given you've suggested as much, and seem to not respect advice given (in fact take it as an attack), it doesn't give much incentive to answer.

    Be that as it may, and at the risk of this never being read or sounding 'elitist': my advice would be to skip JDBC for the moment. Become very familiar with SQL first. Learn about database normalization, how to manage a database (database files, schemas/databases, users, security, etc...), how to construct queries, joins, unions, indexing, primary keys, foreign keys and referential integrity, etc...any database will suffice (Oracle, MySQL, PostgreSQL, etc...) - while each has its intricacies the basics are fairly constant from one to the next (yes, which one you choose matters - some hosts only support certain systems, some are not amenable to embedding into an application, some have larger memory footprints, some have better procedural support, and some provide commercial support). I would not advise choosing your database because it is 'easiest' - you may end up being limited in other ways which force you to use the 'harder' one. PostgreSQL and MySQL are popular, free, and IMO good intro systems to learn the necessary subjects. Once familiar with SQL and database administration then move into JDBC, the transition should be much more smooth.

  6. #6
    Member Cronus's Avatar
    Join Date
    Feb 2013
    Location
    Gothenburg, Sweden
    Posts
    41
    My Mood
    Inspired
    Thanks
    6
    Thanked 7 Times in 6 Posts

    Default Re: Just started messing with databases

    I'm afraid you won't find a friendlier place. I was suspended from Stack Overflow for asking questions people found annoying. I asked the same here, and was greeted with friendly faces. And with that attitude you won't go anywhere.

  7. #7
    Junior Member datathinker's Avatar
    Join Date
    Jul 2013
    Location
    Beijing, China
    Posts
    7
    My Mood
    Daring
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Just started messing with databases

    Database is always a headache for me and I am not into it since the beginning because the complicated logic and so much data for computing. Then I started seeking a easy way to do the complex data computing, a very small tool named esProc can easily work out a difficult database computing issue. Database is really important for us, but sometimes we really feel frustrated!

    --- Update ---

    I assume that this advice would be very helpful for pbj because I read and think very word of it. Learning the basics about database administratin and SQL before moving into JDBC would be a very good idea, but it may take some time to learn every aspect very well. Here may I ask how to compute the data which are from different datasources(example: one data source is Oracle, the other is from SQL Server or Excel sheet, how to combine both and do some computation? Thanks!)

Similar Threads

  1. export databases
    By faisalanugrah in forum JDBC & Databases
    Replies: 4
    Last Post: July 17th, 2012, 09:24 AM
  2. Samples to Connect Different Databases
    By dblog616 in forum JDBC & Databases
    Replies: 0
    Last Post: July 13th, 2012, 03:22 PM
  3. Replies: 0
    Last Post: May 11th, 2012, 10:01 PM
  4. Please help! Databases and GUI
    By beebee007 in forum AWT / Java Swing
    Replies: 2
    Last Post: April 14th, 2012, 04:19 PM
  5. String to Int messing up
    By The_Mexican in forum What's Wrong With My Code?
    Replies: 5
    Last Post: November 28th, 2010, 02:54 PM