X-Git-Url: http://secure.phpeclipse.com diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/doc/getting_started_connections.html b/archive/net.sourceforge.phpeclipse.quantum.sql/doc/getting_started_connections.html new file mode 100644 index 0000000..c14d6aa --- /dev/null +++ b/archive/net.sourceforge.phpeclipse.quantum.sql/doc/getting_started_connections.html @@ -0,0 +1,77 @@ + + + + + Creating a QuantumDB Bookmark + + + +

Creating a QuantumDB Bookmark

Author: jparrai
+Date: 28-03-2003
+

To connect to a database (create a bookmark in quantum) you use the New Bookmark menu item that appears +when right-clicking on the blank space in the Database Bookmarks view.

+ +

Once this menu item is selected, you will see the "New Bookmark" wizard:

+ +

The data that the form asks of you is: +

Bookmark name: Is your private name of the bookmark you + are creating. It will appear in the view after is created. For example Test.
Username: The username for accessing the database. For + example SCOTT for the classical Oracle + examples.
Password: The password for that username. For example + "TIGER" for the "SCOTT" user.
Prompt for Password: Check this box if you want to be prompted for a password + every time you try to connect to the database.
Schema: (optional): The schema of the user. We can leave + it blank.
Connect: Connect string, the format is (for Oracle) jdbc:[database]:[type]:@[host]:[port]:[database], + for example, for an Oracle database called DEV based on the same computer + you could put jdbc:oracle:thin:@localhost:1521:DEV.
Driver: The driver name, it should be in the documentation + of the JDBC driver. For Oracle, is usually oracle.jdbc.OracleDriver or oracle.jdbc.driver.OracleDriver (Oracle before + version 9)
Type: 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 Generic SQL.
+
Driver Filename: You can select the .jar or .zip file where the driver is located. For + example in Oracle is usually at C:\Oracle\jdbc\lib\classes12.jar, being C:\Oracle + the installation directory of oracle.

Other examples (only as orientation, your particular data may be +different)
+

+For MySql (in Windows):

Connect: jdbc:mysql://localhost/test
Driver: com.mysql.jdbc.Driver
Driver Filename: C:\mysql\jdbc\mysql-connector-java-2.0.4-bin.jar

+

For PostgreSql (in Linux):

+ 
Connect: jdbc:postgresql://localhost/emsdevel
Driver: org.postgresql.Driver
driver filename: /opt/postgresql/share/java/postgresql.jar

+ +