Home » SQL & PL/SQL » Client Tools » sql developer connection using jdbc:vjdbc:servlet connection url (sql developer)
sql developer connection using jdbc:vjdbc:servlet connection url [message #678401] Sat, 30 November 2019 09:46 Go to next message
hemant-orafaq
Messages: 1
Registered: November 2019
Junior Member
Hi Experts :

I am working on BIRT report tool for which I use Oracle 10g DB as backend.
In BIRT tool I do connect using below connection string and then I put username/pwd to connect to oracle DB in BIRT report tool.

"
Driver Class : de.simplicit.vjdbc.VirtualDriverBirtWrapper (v1.6)
Database URL: jdbc:vjdbc:servlet:://testserver-stage.plateau.com/vjdbc/vjdbc,db10g
"
My ask is I wanted to know How to connect to same oracle DB using sql developer since above url can not be entered in connection details for sql developer.
Do I need to download any .jar file for sql developer to connect using sql developer??

Thanks in advance !!!

Report message to a moderator

Re: sql developer connection using jdbc:vjdbc:servlet connection url [message #678402 is a reply to message #678401] Sat, 30 November 2019 09:54 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Click on URL below to learn about JDBC Thin connection to Oracle DB

Report message to a moderator

Re: sql developer connection using jdbc:vjdbc:servlet connection url [message #678411 is a reply to message #678401] Sun, 01 December 2019 01:50 Go to previous messageGo to next message
John Watson
Messages: 8460
Registered: January 2010
Location: Global Village
Senior Member
Guessing from what you have shown so far, in SQL Developer create a new "basic" connection as follows:

host: testserver-stage.plateau.com
port: 1521
service: db10g

However, that is only a guess. You need to confirm the values. Also, are you really trying to connect to a release 10 database? I do not know if the current release of SQL Developer can connect to something so old.

Report message to a moderator

Re: sql developer connection using jdbc:vjdbc:servlet connection url [message #678640 is a reply to message #678401] Mon, 23 December 2019 13:24 Go to previous message
wvu1999
Messages: 40
Registered: April 2007
Member
you would normally use the Advanced connection type to paste in a jdbc URL

but...

vjdb

We don't support that driver, whatever it is.

Report message to a moderator

Previous Topic: How to spool the data of a clob or long column
Next Topic: connect sql developer without the tns file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 25 13:18:43 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.