610 likes | 623 Views
Learn how to use Eclipse IDE for CVS source management system, Step-by-step instructions on checking out, updating, and committing changes in CVS, Toad extension integration for SQL object handling in Eclipse.
E N D
CVS usage with Eclipse IDE 10-May-2012 Raghavendra Prasad Cholleti J rcholleti@triniti.com
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
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
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 are any unwanted statements being committed. Ex: debug statements 16
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 IS003585: 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
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. 2. Clicking on it will show the next difference 3. Click on Replace to replace the file with the selected version 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/free-tagging/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
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 ExtensionProject 48
Saving the project 1. Provide project name 2. Click Finish 49
Moving to Java prospective Click on Java prospective 50