Toad World® Forums

Disable Subversion Login


#1

Hi,
I’m using Toad 10.6.1.3 and it’s been working fine for a few weeks now. Recently when I login to a specific connection I now get the “Subversion Login” prompt. I’ve seen that this is related to team coding but I have never used that feature or ever enabled it. It only seems to happen for a specific database. When the prompt is displayed I can click the “Cancel” button and the connection seems to proceed ok but the SQL tab is “disabled”. Is there something I’ve done to enable this behavior or is this something server related? Any help for this is appreciated. It is causing me all sorts of issues in my development.

subversion.pdf (10.3 KB)


#2

Morning Scott,

I’m wondering if someone else hasn’t installed the Team Coding stuff in
the database to which you are connecting. There are a couple of ways of
using Team Coding:

  • One which requires “objects” to be installed in the database;
  • One (Legacy Team Coding) which doesn’t.

I rather suspect someone has attempted to set up the former and now,
when you login to that user on that database, it’s asking you to login
to TC as well.

As I don’t ever use the first TC method - I’m not allowed to install
objects not related to the application - I can’t say for certain if this
is the case, but it sounds like it could be.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#3

What objects can I look for in the database to see of this is what’s happening? I will also start asking a few people and see if they know if anything has been done to the database.


#4

Hi Scott,

What objects can I look for in the database to see of this
is what’s happening? I will also start asking a few people
and see if they know if anything has been done to the database.

I’m not 100% sure I’m afraid - I’ve never used the database objects
version of Team Coding. I suspect (but please check) that there may be a
schema named TOAD in the database.

It is possible that other parts of Toad need objects within this schema,
so I’d see what’s what before deleting anything. If you choose to delete
stuff that is!

When the developers come online later, I suspect someone may jump in
with helpful information - unlike mine!

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#5

/* Java classes can access Oracle OBJECTs attributes and methods by installing
the Oracle dbms_java package */

/* here is a quick example */

public void doit (ClassProcessor processor)
throws java.lang.Exception
{
cleanup(connection);
Statement stmt = connection.createStatement();

try {
String cmd;

cmd =
"select dbms_java.longname(OBJECT_NAME) " +
"from user_objects " +
"where OBJECT_TYPE = ‘JAVA CLASS’ and " +
“dbms_java.longname(OBJECT_NAME) like '” +
packageNamePattern +
"/%’ " +
“and dbms_java.longname(OBJECT_NAME) not like '” +
packageNamePattern +
“/%/%’”;

ResultSet rset = stmt.executeQuery(cmd);

while (rset.next()) {
String className = rset.getString(1);
processor.execute(className);
counter++;
}
} catch (Exception e) {
System.out.println(" got error " + e);
}
finally {
if (stmt != null) stmt.close();
}
}

This tutorial on installing the Java Package is a bit old but …then again so am
i
http://download.oracle.com/docs/cd/B10501_01/java.920/a96656/config.htm

Cheers,
Martin Gainty


Before being confronted by hooligans with white paint a chaffeur would be well
advised to motor in a White Vehicle


#6

Hi Martin,

I’m confused now! What was this posting for?

On 14/12/10 13:58, Martin Gainty wrote:

/* Java classes can access Oracle OBJECTs attributes and methods by
installing the Oracle dbms_java package */

/* here is a quick example */

I don’t see the relevance to the Subversion problem in this thread - did
you post to the wrong thread perhaps?

Cheers,
Norm. [TeamT]


#7

Hello,

It sounds like someone else has enabled Team Coding on this database. If
you’re not using team coding and don’t want to see the prompts, go
to options > source control. In the team coding section, check “Disable
login Prompt on connection”


#8

Also, you can check to see if Team Coding is enabled by going to Utilities >
Team coding > Team coding status while connected to this database.