How-To Connect SquirreL to the Store and Corporate Databases

Squirrel Overview

If it becomes necessary to connect directly to the store or corporate databases, SQuirreL is considered one of the best clients to use.

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Getting Started and Introduction. The minimum version of Java supported is 1.6.x as of SQuirreL version 3.0. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

Assumptions

Windows XP

Java 1.6.x is installed

JAVA_HOME points to the Java 1.6.x installation

Required Software

SQuirreL

Oracle Thin JDBC driver (ojdbc6.jar)

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html

Solution

Install SQuirreL

java -jar squirrel-sql--install.jar

Add the Oracle Driver

Click the ‘Drivers’ tab

Scroll down to ‘Oracle Thin Driver’

‘Drivers | Modify Driver…’

Click the ‘Extra Class Path’ tab

Click the ‘Add’ button

Navigate to ojdbc6.jar and click ‘Open’

Click ‘OK’

Create a New Alias for the Store Database

‘Aliases | New Alias…’

Set ‘Name’ to:

Store Database

Select ‘Oracle Thin Driver’ from the Driver drop-down list

Edit the URL to:

jdbc:oracle:thin:@orstores:1521:oretail

Set ‘User Name’ to:

bo

Set ‘Password’ to:

bo

Check the ‘Auto logon’ box

Click the ‘Test’ button

If successful, click the ‘OK’ button

Click the ‘OK’ button

Create a New Alias for the Store Database

‘Aliases | New Alias…’

Set ‘Name’ to:

Corporate Database

Select ‘Oracle Thin Driver’ from the Driver drop-down list

Edit the URL to:

jdbc:oracle:thin:@orstores:1521:oretail

Set ‘User Name’ to:

co

Set ‘Password’ to:

co

Check the ‘Auto logon’ box

Click the ‘Test’ button

If successful, click the ‘OK’ button

Click the ‘OK’ button

Connect to the Database :-

Select one of the aliases

‘Aliases | Connect’

How to connect with Offline DB..

For detail ...

http://squirrel-sql.sourceforge.net/