• Post Reply Bookmark Topic Watch Topic
  • New Topic

mySQL

 
Paul Houser
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Basically, I need a "from scratch" method of connecting/accessing/modifying a remote mySQL database, I tried the tutorial that comes with the package, but was no help. Let's assume that all I have installed is the JDK.
 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The best place to start is Sun's JDBC Tutorial.
 
Wayne L Johnson
Ranch Hand
Posts: 399
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A few other hints. You'll need the JDBC drivers: Connector/J 3.0. Make sure that you put the driver JAR file where your JDK/JVM can find them.
To connect, you'll do something like the following:

Of course you'll have to supply the ip-address of where the database is located (you can use "localhost" if it's on the same machine), the database instance (or it can be left off), the user and password (if required). After that it's just regular ol' JDBC stuff.
[ November 06, 2003: Message edited by: Wayne L Johnson ]
 
Paul Houser
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks! Worked just as expected.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!