--- /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>Creating a QuantumDB Bookmark</title>
+ <link rel="stylesheet" href="book.css" charset="ISO-8859-1" type="text/css"></head>
+</head>
+<body>
+<h1>Creating a QuantumDB Bookmark</h1>
+<p>Author: jparrai<br>
+Date: 28-03-2003<br>
+<p>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.</p>
+
+<img src="images/newbookmark_menu.gif" />
+
+<p>Once this menu item is selected, you will see the "New Bookmark" wizard:</p>
+
+<img src="images/newbookmark_wizard.gif" />
+
+<p>The data that the form asks of you is:
+<ul>
+ <li><b>Bookmark name:</b> 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><b>Username:</b> The username for accessing the database. For
+ example <span style="font-weight: bold;">SCOTT</span> for the classical Oracle
+ examples.</li>
+ <li><b>Password:</b> The password for that username. For example
+ "TIGER" for the "SCOTT" user.</li>
+ <li><b>Prompt for Password:</b> Check this box if you want to be prompted for a password
+ every time you try to connect to the database.</li>
+ <li><b>Schema</b>: (optional): The schema of the user. We can leave
+ it blank.</li>
+ <li><b>Connect</b>: 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><b>Driver</b>: 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><b>Type</b>: 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><b>Driver Filename</b>: 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>
+<p>Other examples (only as orientation, your particular data may be
+different)<br>
+<p>
+For <span style="font-weight: bold;">MySql</span> (in Windows):</p>
+<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>
+</pre>
+ <p>For <span
+ style="font-weight: bold;">PostgreSql</span> (in Linux):</p>
+<pre>
+ <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></pre>
+</body>
+</html>
git://secure.phpeclipse.com / phpeclipse.git / blobdiff