Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

JDBC help, need DB

  • 14-01-2008 11:12PM
    #1
    spectre
    Registered Users, Registered Users 2 Posts: 729 ✭✭✭


    I'm trying to do a JDBC tutorial. Basically trying to write a JAVA program which will login to a db and execute some basic SQL. Problem is I've no db to login to. I want to find out if there's some free db I can download to my local machine and use this to test my program?

    The tutorial I'm doing asks me to connect to this db using an ODBC-JDBC bridge if that makes any sense.

    I know this is probably fairly basic stuff but it's been ages since I looked at databases.

    Much obliged.


Comments

  • #2
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    Download MySQL. That will do the job.


  • #3
    information
    Closed Accounts Posts: 362 ✭✭information


    if you are using the odbc-jdbc bridge you don't need any database.

    just create an access file(even a text file can be used), set it up in the odbc connections and thats it.


  • #4
    fasty
    Registered Users, Registered Users 2 Posts: 981 ✭✭✭fasty


    Make one in Access.


  • #5
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,202 ✭✭✭✭Tom Dunne


    spectre wrote: »
    I've no db to login to. I want to find out if there's some free db I can download to my local machine and use this to test my program?
    fasty wrote: »
    Make one in Access.

    Last time I checked, Access wasn't free.

    Spectre - there are loads of free databases you can download - MySql, Postgres (:D) SQL Server Express, even Oracle do a free, cut-down version.


  • #6
    fasty
    Registered Users, Registered Users 2 Posts: 981 ✭✭✭fasty


    Tom Dunne wrote: »
    Last time I checked, Access wasn't free.

    Haha, maybe the original poster has it installed and didn't realize you could use it to make a DB that would work with JDBC. :rolleyes:


  • Advertisement
  • #7
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    fasty wrote: »
    Haha, maybe the original poster has it installed and didn't realize you could use it to make a DB that would work with JDBC. :rolleyes:
    Still isn't free though is it?


  • #8
    fasty
    Registered Users, Registered Users 2 Posts: 981 ✭✭✭fasty


    Maybe not, but perhaps a bit less pedantry will save the poor chap having to install and configure MySQL or similar.


  • #9
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    Yeah true.
    But then again, getting familar with MySQL isn't such a bad thing after. Plus it is fairly simple to install.


  • #10
    smcelhinney
    Registered Users, Registered Users 2 Posts: 1,127 ✭✭✭smcelhinney


    Webmonkey wrote: »
    Yeah true.
    But then again, getting familar with MySQL isn't such a bit thing after. Plus it is fairly simple to install.

    and a damn side nicer than Access too. Free databases FTW!


  • #11
    lukin
    Registered Users, Registered Users 2 Posts: 4,325 ✭✭✭lukin


    Try HSQLDB. It's an RDBMS written in Java so it integrates well with JDBC.


  • Advertisement
Advertisement