Update of /cvsroot/phpeclipse/net.sourceforge.phpeclipse.quantum.sql/doc In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11260/doc Modified Files: toc.xml getting_started_connections.html Added Files: schema_rules.html jdbc_connection_details.html bookmark_name.html jdbc_driver.html Log Message: Quantum version 2.4.1 Index: toc.xml =================================================================== RCS file: /cvsroot/phpeclipse/net.sourceforge.phpeclipse.quantum.sql/doc/toc.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** toc.xml 16 Apr 2004 19:15:45 -0000 1.1 --- toc.xml 24 Jul 2004 19:22:25 -0000 1.2 *************** *** 5,9 **** <topic label="Getting Started"> <topic label="Opening the Quantum DB Perspective" href="doc/getting_started_perspective.html" /> ! <topic label="Creating bookmarks" href="doc/getting_started_connections.html" /> </topic> </toc> --- 5,14 ---- <topic label="Getting Started"> <topic label="Opening the Quantum DB Perspective" href="doc/getting_started_perspective.html" /> ! <topic label="Creating bookmarks" href="doc/getting_started_connections.html"> ! <topic label="Choosing JDBC Drivers" href="doc/jdbc_driver.html" /> ! <topic label="JDBC Connection Details" href="doc/jdbc_connection_details.html" /> ! <topic label="Selecting a Bookmark Name" href="doc/bookmark_name.html" /> ! <topic label="Choosing Schemas" href="doc/schema_rules.html" /> ! </topic> </topic> </toc> Index: getting_started_connections.html =================================================================== RCS file: /cvsroot/phpeclipse/net.sourceforge.phpeclipse.quantum.sql/doc/getting_started_connections.html,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** getting_started_connections.html 16 Apr 2004 19:15:45 -0000 1.1 --- getting_started_connections.html 24 Jul 2004 19:22:25 -0000 1.2 *************** *** 20,77 **** <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> --- 20,34 ---- <p>Once this menu item is selected, you will see the "New Bookmark" wizard:</p> ! <img src="images/new_bookmark/page1.gif" /> ! ! <p>Creating Bookmarks involve four things: ! ! <ol> ! <li><a href="jdbc_driver.html">specify a JDBC Driver</a>; ! <li><a href="jdbc_connection_details.html">provide the connection details (userid, password and JDBC URL)</a>; ! <li><a href="bookmark_name.html">choose a name for your bookmark</a>; and ! <li><a href="schema_rules.html">optionally, specify which schemas you want to view</a>. ! </ol> </body> </html> --- NEW FILE: schema_rules.html --- <!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>Choosing Which Schemas You Want to View</title> <link rel="stylesheet" href="book.css" charset="ISO-8859-1" type="text/css"></head> </head> <body> <h1>Choosing Which Schemas You Want to View</h1> <p>Optionally, the fourth page of the Bookmark Wizard lets you choose which schemas you want to work with.</p> <img src="images/new_bookmark/page4.gif" /> <p>By default, bookmarks are set up to view all schemas. <p>If your database doesn't support schemas (like, for example, MySQL), then the schema selection rule has no effect. </body> </html> --- NEW FILE: jdbc_driver.html --- <!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>Specifying a JDBC Driver</h1> <p>QuantumDB uses standard JDBC Drivers to access databases. The first step in setting up a database bookmark is, therefore, selecting a JDBC Driver.</p> <img src="images/new_bookmark/page1.gif" /> <p>The first time you try to configure a bookmark, QuantumDB will already recognize one driver: the standard JDBC-ODBC driver provided with the Java Runtime Environment. For some people, this will be sufficient to access databases, but most people will probably choose to set up additional drivers. <p>Select the "Add Driver..." button to choose an alternate driver.</p> <img src="images/new_bookmark/add_driver.gif" /> <p>Provide the details for the new driver. Most drivers require at least one .jar file. Specify the location of the .jar file(s), and the driver class name. Note that once you specify the .jar locations, you can use the "Browse..." button beside the class name field to select valid driver class names. <p>Finally, the Add Driver Wizard asks for a database type. If you're setting up a fairly standard driver (such as, for example, the standard Oracle or DB2 driver), QuantumDB will probably recognize the driver class name and select the appropriate driver from the list. Otherwise, choose the corresponding database type or, if your database type isn't listed, select "Generic JDBC". <p>The database type helps QuantumDB provide defaults for later parts of the bookmark set-up process, and also tells the plugin how to support some of the non-standard database features (such as sequences). </body> </html> --- NEW FILE: jdbc_connection_details.html --- <!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>Specifying JDBC Connection Details</title> <link rel="stylesheet" href="book.css" charset="ISO-8859-1" type="text/css"></head> </head> <body> <h1>Specifying JDBC Connection Details</h1> <p>Once a JDBC Driver has been selected, provide the JDBC connection details such as userid, password and JDBC connection URL.</p> <img src="images/new_bookmark/page2.gif" /> <p>Please note that passwords are stored relatively unsecurely in a QuantumDB configuration file. A more secure option might be to select the "Prompt for Password" option. When this option is selected, QuantumDB will prompt the user for a password whenever it tries to connect to the database. <p>QuantumDB provides extra JDBC URL assistance for some well-known drivers. For example, if you're using the standard PostgreSQL driver, <code>org.postgresql.Driver</code>, you'll see the following screen:</p> <img src="images/new_bookmark/page2_postgresql.gif" /> <p>Similarly, the standard IBM Informix driver provides the following screen:</p> <img src="images/new_bookmark/page2_informix.gif" /> </body> </html> --- NEW FILE: bookmark_name.html --- <!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>Choosing a Bookmark Name</title> <link rel="stylesheet" href="book.css" charset="ISO-8859-1" type="text/css"></head> </head> <body> <h1>Choosing a Bookmark Name</h1> <p>Provide a unique name for your bookmark:</p> <img src="images/new_bookmark/page3.gif" /> </body> </html> |