CVS usage with Eclipse IDE Raghavendra Prasad Cholleti

CVS usage with Eclipse IDE Raghavendra Prasad Cholleti J rcholleti@triniti. com 10 -May-2012

Agenda • Using Eclipse for CVS, Source Management • • • System Checking out project from CVS Updating project from CVS Synchronizing CVS Repository Commit Changes to CVS Compare & Replace with other Versions Toad extension in Eclipse 2

Steps to follow • Execute Eclipse • Run Eclipse • Checkout Project or Update Project • Checking out code • Commit Changes to CVS • Commit modified code to CVS • Execute/modify queries using Toad • Run/modify SQL objects

Let’s see how to Checkout from CVS using Eclipse • Eclipse doesn’t need Installation • Download the Eclipse IDE for Java • • Developers, zip file from below Location http: //www. eclipse. org/downloads/ Unzip the downloaded zip file Launch Eclipse Application by double clicking on eclipse. exe file in eclipse folder 4

Checkout From CVS using Eclipse Choose a Folder where Eclipse will organize the projects 5

Eclipse Welcome Window Close this to Explore 6

To Checkout, we need to open CVS Perspective 7

Eclipse : Accessing CVS Perspective Click Other 8

Select CVS Repository Perspective Select CVS Repository Exploring perspective 9

Specifying a Repository Location Right click on the Panel and select New -> Repository Location 10

CVS Repository Location Enter CVS Server details and login Credentials 11

CVS Repositories : Check Out Project Right click on the Folder and select Check Out As… option 12

Enter Project Name 1. Select Checkout as Project in the workspace 2. Click on Finish 13

Open Java Perspective To see the downloaded Project open Java perspective Window -> Open Perspective -> Java 14

CVS Module Checked out Successfully 15

Let’s see how to Check-in to CVS using Eclipse • Eclipse allows to compare the Local and Remote objects. • Before Committing, compare to see if there any unwanted statements being committed. Ex: debug statements 16

Modified File Names will precede with > Character 17

Commit file to CVS Right click on the File/Folder and select -> Team-> Synchronize 18

Select the Modified File Double Click on Modified file 19

Commit Modified File Right Click on Modified file and select -> Commit 20

Add Comments IS 003585: Changed query Added sysdate Mention issue number in the comments while committing the code 21

All the changes at one glance Incoming Change, shown in Blue Color Conflicts shown in Red Color Outgoing changes are shown in Gray Color 22

Taking incoming changes 1. Right click on the incoming change file. 2. Click Update 23

Conflict Resolution mode Double click on the conflicting file to see the differences. 24

Committing outgoing change 1. Right click on the outgoing change file. 2. Click Commit 25

Let’s see how to compare a file with other revisions… 26

Comparing with other revisions Right Click on the required file and select Compare With->History 27

Available revisions Double click on the required version for comparision 28

Comparision of two revisions Clicking on it will show the next difference 29

Replacing file with other revisions Right click on the required file. Select Replace With->History… 30

Available revisions 1. Double click on the required file. 3. Click on Replace to replace the file with the selected version 2. Clicking on it will show the next difference 31

Let’s see how to use Toad to modify/execute SQL objects through Eclipse 32

Let’s see how to install toad in the Eclipse • Open url http: //marketplace. eclipse. org/category/freetagging/pl/sql • Drag the image into the Eclipse work space. 33

Drag & Drop Install Icon Drag and drop the image here. 34

Toad Extension Installation starts… This will install Toad Extension 35

Toad Extension Installation Contd… This will install Toad Extension 36

Toad Extension Installation Completed Accept the license and Click Finish 37

Using Toad extension in Eclipse Click Window->Open Perspective->Other 38

Select Toad prospective 1. Select Toad Extension 2. Click OK 39

Adding new connection 1. click on the link to add connection. 2. Enter the connection details(rounded up in red color) 3. Click OK 40

Connecting to the required database 1. Right click on the connection. 2. Click Connect 41

Editing a View Right click on the required view and click Edit Modify view 42

Let’s see the editors for executing SQL objects 43

Opening new SQL worksheet Click on this link to open a new SQL worksheet Queries can be written in this window 44

SQL window to write queries After writing query, click on this link to execute Query results will be shown here 45

Stored procedure editor Click on this link to open a stored procedure editor Editor will be opened 46

Let’s see how to create toad Project for sql files and see how they can be executed 47

Adding project 1. Click on the arrow. 2. Click on Toad Extension Project 48

Saving the project 1. Provide project name 2. Click Finish 49

Moving to Java prospective Click on Java prospective 50

Newly added toad project… On expanding, it will show the files, folders in the newly added toad project 51

Creating a new file under sql folder Right click on sql folder select New->File 52

Saving the file where in which commands can be entered Enter File Name Click Finish 53

Opening the file in SQL File Editor Select Open With ->SQL Script Editor 54

Writing queries to be executed 1. Write queries to be executed. 2. Click on the link, select connection 55

Executing the query Execute the query by clicking on arrow link. 56

Viewing query results Query result will be shown here 57

Let’s see how to execute/modify objects using different connections 58

Connecting to required database… 1. Right Click on the required connection. 2. Click Connect 59

Executing different queries with different connections 2. Click on the arrow. 3. Select required connection to execute 1. Writing queries in the editor and execute them by selecting the required connection 60

Thank You