--- /dev/null
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <meta http-equiv="content-type"
+ content="text/html; charset=ISO-8859-1">
+ <title>Making a Quantumdb connexion (bookmark)</title>
+</head>
+<body>
+Author: jparrai<br>
+Date: 28-03-2003<br>
+Subject: Making a Quantumdb connexion<br>
+<br>
+To connect to a database (create a bookmark in quantum) you use the <span
+ style="font-weight: bold;">New Bookmark</span> menu item that appears
+when right-clicking on the blank space in the <span
+ style="font-weight: bold;">Database Bookmarks</span> view.<br>
+<br>
+The data that the form asks of you is:<br>
+<br>
+<ul>
+ <li><big><b>Bookmark name:</b></big> Is your private name of the bookmark you
+ are creating. It will appear in the view after is created. For example <span
+ style="font-weight: bold;">Test</span>.</li>
+ <li><big><b>Username:</b></big> The username for accessing the database. For
+ example <span style="font-weight: bold;">SCOTT</span> for the classical Oracle
+ examples.</li>
+ <li><big><b>Password:</b></big> The password for that username. For example
+ <span
+ style="font-weight: bold;">TIGER</span> for the SCOTT user. If you leave the
+ password blank, it'll ask you for it when connection is attempted.This behaviour
+ can be customized.</li>
+ <li><big><b>Schema</b>: (optional):</big> The schema of the user. We can leave
+ it blank.</li>
+ <li><big><b>Connect</b>:</big> Connect string, the format is (for Oracle) <font
+ face="Geneva, Arial, Helvetica, sans-serif" size="2"><span
+ style="font-weight: bold;">jdbc:[database]:[type]:@[host]:[port]:[database]</span>,
+ for example, for an Oracle database called DEV based on the same computer
+ you could put <span style="font-weight: bold;">jdbc:oracle:thin:@localhost:1521:DEV</span>.</font></li>
+ <li><big><b>Driver</b>:</big> The driver name, it should be in the documentation
+ of the JDBC driver. For Oracle, is usually <span
+ style="font-weight: bold;">oracle.jdbc.OracleDriver</span> or <span
+ style="font-weight: bold;">oracle.jdbc.driver.OracleDriver </span> (Oracle before
+ version 9)</li>
+ <li><big><b>Type</b>:</big> The type of the database. It will be used by Quantum
+ to adapt the SQL queries to the particular incompatibilites of each. The generic
+ should work for most of the features, so if you don't find your database on
+ the drop-down, use the <span
+ style="font-weight: bold;">Generic SQL</span>.<br>
+ </li>
+ <li><big><b>Driver Filename</b>:</big> You can select the <span
+ style="font-weight: bold;">.jar</span> or <span
+ style="font-weight: bold;">.zip</span> file where the driver is located. For
+ example in Oracle is usually at <span
+ style="font-weight: bold;">C:\Oracle\jdbc\lib\classes12.jar</span>, being C:\Oracle
+ the installation directory of oracle.</li>
+</ul>
+<br>
+Other examples (only as orientation, your particular data may be
+different)<br>
+<br>
+For <span style="font-weight: bold;">MySql</span> (in Windows):<br>
+<pre>Connect: <span style="font-weight: bold;">jdbc:mysql://localhost/test</span><br>Driver: <span
+ style="font-weight: bold;">com.mysql.jdbc.Driver</span><br>Driver Filename: <span
+ style="font-weight: bold;">C:\mysql\jdbc\mysql-connector-java-2.0.4-bin.jar</span><br><br>For <span
+ style="font-weight: bold;">PostgreSql</span> (in Linux):<br><br>Connect: <span
+ style="font-weight: bold;">jdbc:postgresql://localhost/emsdevel</span><br>Driver: <span
+ style="font-weight: bold;">org.postgresql.Driver</span><br>driver filename: <span
+ style="font-weight: bold;">/opt/postgresql/share/java/postgresql.jar</span><br><br><br></pre>
+<br>
+</body>
+</html>
git://secure.phpeclipse.com / phpeclipse.git / blobdiff