I have SQLexplorer (2.2.4, Eclipse 3.1) installed to the point where I can open a perspective in Eclipse, but how do I get it to connect to an Oracle database ?
Also, I can't find any documentation - am I blind :)
cheers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Documentation - I too must ber blind.
But, on the connection point of view ...
In the drivers view, findOracle OCI Driver (for example), right click and select 'change the selected driver'. Click on 'extra classpath' and then add, and navigate to the oracle classes12.zip (for example)`.
Once thats completed to you satisfaction, in the aliases view, create a new one, filling in the details for your connection as appropriate.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We don't have any documentation at this point, just some posts here or in the older host (https://sqlexplorer.dev.java.net/)
Anyone knows how to setup a Wiki here on sourceforge? It would be the easiest way to write some basic documentation.
Anyway here are some basic info:
First you have to configure the jdbc driver you want to use:
1 - On the "Drivers" view select the one you want to configure, or create a new one.
2 - Click on the "Extra classpath" to add the jar with the JDBC driver
3 - Click on "list drivers" to refresh the available drivers classes
4 - Click "OK"
Then you need to create a new "Alias" on the Aliases panel:
1- click on "create new alias"
2- write a name for this connection
3- select the driver you want to use (MySQL in this case)
4- write the jdbc url to connect (this varies from driver to driver, for
MMMySql will be something like jdbc:mysql://<hostname>/<dbname>
5- put the user and password (optional)
Then on the connection windows you can open the Alias you have just created.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have SQLexplorer (2.2.4, Eclipse 3.1) installed to the point where I can open a perspective in Eclipse, but how do I get it to connect to an Oracle database ? I can connect to the Oracle DB with Jdev and other IDEs but not SQL Explorer. Can I some one post an example or a walk through for oracle. Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have SQLexplorer (2.2.4, Eclipse 3.1) installed to the point where I can open a perspective in Eclipse, but how do I get it to connect to an Oracle database ?
Also, I can't find any documentation - am I blind :)
cheers
Documentation - I too must ber blind.
But, on the connection point of view ...
In the drivers view, findOracle OCI Driver (for example), right click and select 'change the selected driver'. Click on 'extra classpath' and then add, and navigate to the oracle classes12.zip (for example)`.
Once thats completed to you satisfaction, in the aliases view, create a new one, filling in the details for your connection as appropriate.
We don't have any documentation at this point, just some posts here or in the older host (https://sqlexplorer.dev.java.net/)
Anyone knows how to setup a Wiki here on sourceforge? It would be the easiest way to write some basic documentation.
Anyway here are some basic info:
First you have to configure the jdbc driver you want to use:
1 - On the "Drivers" view select the one you want to configure, or create a new one.
2 - Click on the "Extra classpath" to add the jar with the JDBC driver
3 - Click on "list drivers" to refresh the available drivers classes
4 - Click "OK"
Then you need to create a new "Alias" on the Aliases panel:
1- click on "create new alias"
2- write a name for this connection
3- select the driver you want to use (MySQL in this case)
4- write the jdbc url to connect (this varies from driver to driver, for
MMMySql will be something like jdbc:mysql://<hostname>/<dbname>
5- put the user and password (optional)
Then on the connection windows you can open the Alias you have just created.
I have SQLexplorer (2.2.4, Eclipse 3.1) installed to the point where I can open a perspective in Eclipse, but how do I get it to connect to an Oracle database ? I can connect to the Oracle DB with Jdev and other IDEs but not SQL Explorer. Can I some one post an example or a walk through for oracle. Thanks in advance.