Subversion and PL/SQL Developer

W

witchi

Member
Hi,

has anyone sucessfully configured the VCS plugin for Subversion. If yes, could you post the parameters for an example project/repository?

Thanx a lot
witchi
 
Originally posted by Joachim Rupik:
Hello,

You can try a Subway:

Subway, a Source Code Control Provider for Subversion

Greetings,
Joachim Rupik
Click to expand...
I also tried some SCC Provider, but the problem is, I don't know, which options I have to set into the configuration window of VCS for the specific provider.
Here you can find further SCC Provider for Subversion:
SVNSCC
CHMSubSCC

But if you click on "Open Project" on the VCS menu, you get the configuration window. What I have to set for Project, User, Local Path and Aux Path? The svn URL is like
Code: 
svn://server/path-to-repository
Is that the Aux Path? Is Local Path a synonym for the Subversion work copy on the local hd? What means Project?

Let us say, the example repository resides on

Code: 
svn+ssh://witchi@myserver/svn/mytestrep
and the project I try to use is projectA/trunk. The complete URL is now:

Code: 
svn+ssh://witchi@myserver/svn/mytestrep/projectA/trunk
Can you give me an explanation, how I access the URL with the VCS plugin and a SCC Provider for Subversion?

Thanx a lot
~witchi
 
Oh, I understand.
I hope it should be similar to cvs access and Aux Path should be svn+ssh://witchi@myserver/svn/mytestrep/projectA/trunk:

cvs.gif


I have tried cvs with igloo and it worked for me (example above - from internet cvs repository), svn providers you mentioned do not work for me (av error).

Greetings,
Joachim Rupik
 
Hi,

Here are the results of my investigations. I use TortoiseSVN on Windows and there is a SCC Provider called TortoiseSVNSCC.

TortoiseSVNSCC Download Page

I have downloaded the install.reg (change the path to the location where you have installed the SCC Provider) and the newest Version.

Before I have installed the SCC, I also had installed the TortoiseSVN (the SCC need it). In the SCC Package there are some old files, so I have choosed only the files which don't come with the TortoiseSVN.

After that, I can choose the ToirtoiseSVNSCC in the VCS plugin. Now checkout a repository project into a local directory (working copy).

In the configuration window of the VCS plugin set the Local Path to the directory of the working copy and set the Aux Path to a Subversion Url.


Code: 
svn+ssh://user@server/repository/project/trunk
The User and Project fields are empty!

If you click on "Okay", the Log Browser will be open. Close the browser and the VCS icons and menus are enabled.

Open the "VCS preferences" and set the following properties:

vcs.jpg


If you click with the right mousebutton on a package in the object browser of PLSQL-Dev, you can see an "Add to CVS" menu point. Click on that und the package will be open, but you get the following error:

vcs2.jpg


But the package is saved to the working copy. Here is a problem within the SCC. You can click with the RMB into the open package source window and choose the menu entry "Add to VCS" again and the Tortoise Add Window comes up. You have successfully added the package file to the repository.

With the menu entry "Checkin" you can check one file into the repository, "Checkin files..." let you choose some files from a list. You have to select the files (!) from the list, don't click "Okay" without any selection. You will see now the Tortoise Commit Window and the file content is saved to the repository.

Sometimes you get, everytime you try to add a file to the repository, the error above. It seems, that the SCC lose the synchronisation to the working copy. I don't have a workaround at the moment for this "feature".

Another problem is, if the SCC is not synchron with the working copy, you can have some added files, which will never be commit to the repository. The SCC provider is file-based, so it commits only known files (which the SCC has added). It doesn't check the status of other files within the working copy.

~witchi
 
Hi

Lately I decided to use some Version Control System. I've heard that TortoiseSVN is notable so I installed TortoiseSVN-1.4.4.9706-win32-svn-1.4.4 with TortoiseSVNSCC-0.1.3-build0510011 plugin and VCS 1.2 PL\SQL Developer plugin.

In main menu appeared VCS item. I'd like to open some project but I haven't done any yet. In VCS 1.2 Plug-In User's Guide's example as project is shown file with extension pj. I've got only repository and working copy folders. What should I type in Project text-box in Open VCS window ?

Also I have strange error when checking out / in files : "Non specific error." Have anyone met such error ?
 
Hi,
I've installed TortoiseSVN 1.6.3, the VCS plugin and TortoiseSVNSCC-0.1.3-build0510011. When I try to open a project on VCS Menu (Local Path=directory of the working copy; Aux Path=Subversion URL; Project and User fields left empty), I always get the error "ProviderType undefined". What does it mean?

I think it's probably something wrong with TortoiseSVNSCC. I've installed it following the steps:
1- Downloaded the zip file and unzip it to the c:\program files\TortoiseSVN
2- Opened a DOS box
3- cd c:\program files\TortoiseSVN\TortoiseSVNSCC\bin
4- run the command regsvr32 TortoiseSVNSCC.dll
I got a success message so I don't know what can be wrong with it.

Thanks a lot.
 
Hi,
I've configured VCS plugin but TortoiseSVNSCC isn't working properly.
I can open a project (from VCS Menu) but when I right click a package and select "Add to VCS" I get an error "Function not valid for a"; it looks that it doesn't even show the complete error message. When I click OK on that error, I get another error message "Error creating file \filename". If I do this in an opened package, I get the same errors but the last message says "Error creating file \filename. Access denied"

Does anyone know what's the problem?
Thanks in advance.
 
We have had some more reports about this and we're looking into it. Are you right-clicking in the Object Browser? If so, did you dock/undock the object browser before right-clicking?
 
Hi,
how can I get tables, indexes, types, sequences into SVN? Is it possible? (or any workaround?)
(I use SVNSCC with allow verseion control over DB, but it works only with views, packeges, triggers, functions and procedures).
Thanks for reply.
 
Hello everyone !
I'm trying to install a plug-in version control system in pl/sql developer and I have been searching and following in this forum but I have not found someone yet fully achieved there.

I have pl/sql developer version 8.0.4.1514 and download the plug-in (vcs124.zip) that mention on page plug-ins (https://allroundautomations.com/), I install it but does not allow me to define or recognize the CVS I have.

I have installed TortoiseSVN (vers.1.9.4, Build 27285-64 Bit, 2016/04/24 13:59:58) in Windows environment and have as a server repository created.

When I try to define the plug-in configuration data like System, Project, local path and aux path, it generates error "Non specific error" and I could not move from there.

Therefore I have some questions:

1. There currently recognize plugin that allows TortoiseSVN (Windows environment) as version control system ...?
2. Or will definitely have to be installed in linux environment a system like Subversion (eg CollabNetSubversion-client-1.9.4-2-x64) and plug-in (vcs124.zip) if you will recognize ...?
3. If you install Subversion on a linux, the above mentioned plugin if I will recognize the Subversion Linux ...?

Someone has done....?
I appreciate some light on the matter.

 
Gustavo,

Thanks for providing this last year. It seems that open source project has retired. The current version only seems to work for 32-bit PL/SQL Developer, not 64-bit (which I'm running).

I just tried installing that plug-in and it said it couldn't see I had PSD installed. :-(

Does anyone have any other suggestions?

I don't need to archive tables, indexes and such, as jp77 asked about above. I just need to version my procedural source code.

Thanks in advance,

Stew
 
bump

I'm surprised no one has responded. I can't imagine I'm the only one using 64-bit PL/SQL Developer with TortoiseSVN. I thought about seeing if I could install the generic vcs plug-in, but only see a 32-bit installer for that.

Suggestions?
 
If I can find the time in the coming weeks I will take a look to create a 64bit version. I still have the source laying around here somewhere.
 
Before I spend some time on this, I can only get my hands on sources 0.0.17.0 which means I will be missing the following versions (from the readme...)
release 0.0.19.0
Checkout of a new Working-Directory fixed

release 0.0.18.0
Added Support for Subversion 1.7

Will it still be a good idea to try to make a 64-bit version of this?

If someone has the release 0.0.19.0 lying around somewhere, please let me know, then I can use that one...
 
I wonder if there is step by step PLSQL Developer and SVN integration. I'm trying to accomplish this following various instructions I find on internet however no luck as of yet.
I downloaded the TortoiseSVN as well as TortoiseSVNSCC, followed installation steps but still the VCS plugin is disabled. Anyone has real, working instructions to follow.
 
t,

I don't have a comprehensive solution for you. I ended up creating Tools in PL/SQL Developer:
  • SVN Commit - parameters: /command:commit /path:"#path"
  • SVN Add - parameters: /command:add /path:"#path"
I hope this helps,

Stew
 
For the File Browser, Projects and all window types with an associated file. In all cases you can view the SVN status and perform SVN operations on a file.
 
William,

I used your instructions for adding TortoiseSVN to the custom Tools menu back in the day. When PSD 14 added this support, I thought I'd drop it, but realized that the native support doesn't always recognize a file in an SVN project directory.

So I kept the custom tool, for those cases.

Thanks for providing the instructions!
 
I just got a new Windows laptop and after I imported my PSD Config settings, I was surprised that the Version Control configuration settings weren't set up for TortoiseSVN, as I've used since PSD added native Version Control support.

I looked through the Config.ini that I'd created from my old laptop and was surprised to not find a [Version Control] section or any reference to TortoiseSVN.

Marco, where are the Version Control settings saved so we can restore them?

Can someone tell me how to configure the Version Control settings for TortoiseSVN?
Specifically, I don't know what to enter for svn.exe prompt value on the Subversion window. (see attached screenshot)https://www.screencast.com/t/euBiz4W1pc

Thanks in Advance,

Stew
 
Thanks very much for the tip.

I didn't get an email notification from the forum, so I just stumbled upon it now.

For those of you who might wonder what to do with the Zip file, as I did, I created a subdirectory under the \TortoiseSVN, then copied all the files there.
Then in PSD Config, I referred to the svn.exe in the new directory. Once I closed and re-opened one of my versioned files, worked like a charm.
 
You must log in or register to reply here.

Similar threads

T
  • Discussion Discussion
PL/SQL developer simultaneous connection to OCI db with two difrerent wallets
Replies
3
Views
196
Frank Huijbreghs
Frank Huijbreghs
C
  • Discussion Discussion
Recently Completed Oracle PL/SQL Training – Looking for Automation Ideas with Allround Tools
Replies
2
Views
305
CoffeeK1d
CoffeeK1d
C
  • Discussion Discussion
Open file in existing instance of PL/SQL Developer
Replies
1
Views
229
Marco Kalter
Marco Kalter
Marco Kalter
  • Discussion Discussion
PL/SQL Developer 16.0.1 pre-release available with Ollama support and AI Language Packs
Replies
1
Views
1K
Marco Kalter
Marco Kalter
D
  • Discussion Discussion
Are licenses time-limited?
Replies
1
Views
339
Marco Kalter
Marco Kalter
Back
Top