I have several different databases that I connect to as several different users. Filling in the information in the configuration dialogue box is painful given the length of the URL, and driver name. Is the connection information stored in a format somewhere where I could just cut and paste, changing the details that I need to?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Put the JDBC JAR/ZIP files in your Java library extension folder. This way you won't need to frig around with CLASSPATH. If you don't know about the "ext" directory, read your Java documentation under the "Tools" section. The exact location of this directory varies: On my Windows NT 4.0 system it is C:\Program Files\JavaSoft\JRE\1.3\lib\ext.
Note: This will only work if the JDBC jar and zip files are in the Java Runtime "ext" directory -- "java -jar" doesn't look at CLASSPATH. Otherwise, use the java "-classpath" or "-cp" switch and put the location of the JDBC in one of the classpath directories.
-FROM THE DOCS in the website "Install" link.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have several different databases that I connect to as several different users. Filling in the information in the configuration dialogue box is painful given the length of the URL, and driver name. Is the connection information stored in a format somewhere where I could just cut and paste, changing the details that I need to?
Put the JDBC JAR/ZIP files in your Java library extension folder. This way you won't need to frig around with CLASSPATH. If you don't know about the "ext" directory, read your Java documentation under the "Tools" section. The exact location of this directory varies: On my Windows NT 4.0 system it is C:\Program Files\JavaSoft\JRE\1.3\lib\ext.
Note: This will only work if the JDBC jar and zip files are in the Java Runtime "ext" directory -- "java -jar" doesn't look at CLASSPATH. Otherwise, use the java "-classpath" or "-cp" switch and put the location of the JDBC in one of the classpath directories.
-FROM THE DOCS in the website "Install" link.