• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How does one get started with JDBC

 
Ray Marsh
Ranch Hand
Posts: 458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Being a spoiled AS400 programmer, and always having the db right there when you needed it, the whole concept of having to start a db then connect to it, then access it via SQL or some other means is totally foreign to me. I'm used to defining a file spec in a program compiling it and running it.
There I ranted about the AS400, hadn't done it in a while, needed to get it out of my system.
I've had a little and I do mean a little experience with ODBC are there any similarities?
I have a shareware version of MySQL. Anyone have any suggestions on where to start with JDBC?
[This message has been edited by Ray Marsh (edited February 29, 2000).]
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
all the information that You need to know is on Sun's site however to see how it works I would recomend to connect it to access database. I assume YOu have Access on Your pc. the simplest way to do it is to read Deitel's book "java How to program" and there is a chapter on jdbc.It uses Access as a database for examples. Actually YOu can simply just download the code from that book, alter few things in odbc properties and that is it.
 
Ray Marsh
Ranch Hand
Posts: 458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, Vladan. I do not have Access on my PC, unfortunately. Is it difficult to use with MySQL or some other database? If so, is there a reasonably priced db to learn with?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have found that the simplest way to get to grips with JDBC is to use a Pure Java database. I recommend InstantDB. It's not hugely fast and it doesn't have some of the fancier SQL features, but it is very simple to install, requires no admin, and works extremely well with Java.
Once you've got things working with InstantDB, you can swap to another (MySQL, mSQL, Oracle, PostGresSQL, ...) simply by changing the JDBC URL and name/password.
have a look at http://www.instantdb.co.uk/
 
Ray Marsh
Ranch Hand
Posts: 458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Frank, I'll check it out.
 
Ray Marsh
Ranch Hand
Posts: 458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got the Instantdb downloaded and installed.
I've not had much time to play around with it thus far, but it looks pretty good.
Work has been a bear, what a pain having to earn a living!
 
Frank Hale
Ranch Hand
Posts: 230
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is InstantDB open sourced?
thanks,
Frank
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Howdy Ray,
Just dropping by as you suggested. I've done a bit of work with JDBC so if you have more specific questions, I might be able to help.
See you around! Pardna.
Heather
 
Ray Marsh
Ranch Hand
Posts: 458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, Heather.
I'm sure I'll have more specific questions, very soon.
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Hale:
Is InstantDB open sourced?
thanks,
Frank

Yes, it is, and there's a new URL to get to it:
http://instantdb.enhydra.org
Here's the notice at the old URL (http://www.instantdb.co.uk/):
---------------
We've Moved!
InstantDB and I have decided to join Lutris Technologies, an innovative Open Source enterprise software and services company based in Santa Cruz, California, USA.
Sponsors of Enhydra (www.enhydra.org), the leading Open Source Java/XML application server, Lutris is the premier provider of Enhydra-based support and professional services to customers ranging from Internet start-ups to members of the Global 2000. Enhydra is an all Java application server with industry-leading XML support. The support and services Lutris provides are sure to be a benefit to InstantDB and its loyal customers.
So, come check us out in our new home - instantdb.enhydra.org!
Regards, Peter Hearty
---------------
Haven't played with InstantDB, but hope to soon.
--Brett.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic