TIP: Click on subject to list as thread! ANSI
echo: linuxhelp
to: Joe Barr
from: Adam Flinton
date: 2003-02-18 18:08:30
subject: Re: Mailmerge in OO.o using MySQL/ODBC

From: "Adam Flinton" 

You have to have:

A) the zip/jar file on the classpath so the JRE can find it B) The URL of the DB
C) The classname to call (driver).

e.g. some settings:

  
   COM.ibm.db2.jdbc.net.DB2Driver
   jdbc:db2://MACHINE/PORT/DATABASE

  
  
   oracle.jdbc.driver.OracleDriver
   jdbc:oracle:thin:{at}MACHINE:PORT:DATABASE

  
  
   org.postgresql.Driver
   jdbc:postgresql://MACHINE:PORT/DATABASE;


For MySQl go to:

http://www.mysql.com/products/connector-j/

& dl the driver.

the driver classname =   "org.gjt.mm.mysql.Driver"

The URL format =  jdbc:mysql://MACHINE:PORT/DATABASE

Usual ports:
PGSQL:  jdbc:postgresql://servername:5432/name MYSQL:  
jdbc:mysql://servername:3306/name
DB2 net: jdbc:db2://servername/6789/name Oracle:
jdbc:oracle:thin:{at}servername:1521:name

Adam

"Joe Barr"  wrote in message
news:3e526775$1{at}w3.nls.net...
> On Tue, 18 Feb 2003 17:03:53 +0000, Adam Flinton wrote:
>
> > Walk in the park....
> >
>
> I haven't done this yet, but I have heard a couple of warnings about
> knowing what some Java class name or resource name or some kind of name is
> before proceeding.  Any truth to that?
>
>
> --
>

--- BBBS/NT v4.01 Flag-4
* Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/1.45)
SEEN-BY: 633/267 270
@PATH: 379/1 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.