Eclipse Community Forums: BIRT » I have install JDBC for Oracle but....!!!

Home » Archived » BIRT » I have install JDBC for Oracle but....!!!

I have install JDBC for Oracle but....!!! [message #72060]

Mon, 05 September 2005 10:32

Eclipse User

Originally posted by: cesar.flores.ax.pirelli.com

Hi good guys.

I have install JDBC for Oracle but....!!! I can't connect to the DB. There
two drivers:
- oracle.jdbc.OracleDriver (v1.0)
- oracle.jdbc.driver.OracleDriver (v1.0)

Which one do I use?

And is this correct? --
DATABASE URL : jdbc:oracle:thin:@GRTIR:1534:GRTIR
or tell me what to do!! ;-(

THANKS in advance....GRAZIE MILLE!!!

Re: I have install JDBC for Oracle but....!!! [message #72139 is a reply to message #72060]

Mon, 05 September 2005 18:15

Eclipse User

> - oracle.jdbc.driver.OracleDriver (v1.0)
this and get last jdbc jar from oracle
>
> Which one do I use?
>
> And is this correct? --
> DATABASE URL : jdbc:oracle:thin:@GRTIR:1534:GRTIR
> or tell me what to do!! ;-(

jdbc:oracle:thin:@localhost:1521:orcl

it can be 1534 if you set sqlnet with 1534 (this is only port and default is
1521)

@GRTIR - this is server name, try with @localhost
last GRTR (after 1534) is database name (I think that default is orcl or
ORCL - I change this always)

Thanks....Grazie!.... also try... [message #72224 is a reply to message #72139]

Tue, 06 September 2005 04:46

Eclipse User

Originally posted by: cesar.flores.ax.pirelli.com

snpe wrote:

>> - oracle.jdbc.driver.OracleDriver (v1.0)
> this and get last jdbc jar from oracle
>>
>> Which one do I use?
>>
>> And is this correct? --
>> DATABASE URL : jdbc:oracle:thin:@GRTIR:1534:GRTIR
>> or tell me what to do!! ;-(

> jdbc:oracle:thin:@localhost:1521:orcl

> it can be 1534 if you set sqlnet with 1534 (this is only port and default is
> 1521)

> @GRTIR - this is server name, try with @localhost
> last GRTR (after 1534) is database name (I think that default is orcl or
> ORCL - I change this always)

Thanks again!!

Instead the localhost name, I've tried to insert the IP address. And It
worked, with the localhost name it didn't..?!?!?! maybe, there's some
problem with my computer settings.... It happens sometimes. Anyway, If
someone have this problem, it is a good idea to try with the IP address.
Ex:

- jdbc:oracle:thin:@151.10.12.123:1521:orcl
- 1521 is the port connection, so write your port connection
- and orcl is the name of the database.

In this case I've solve the problem. Thanks anyway snpe.

Previous Topic:	Binding a Data Set Parameter to Report Parameter Not Working
Next Topic:	Choosing a 'Letter' report template

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 09:14:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter