Follow the step-by-step installation guide from this link. Thanks Javin for such a useful document. Talking to a DBA may help. Once you have these two things, we are ready to connect to any local or remote Oracle database instance from Eclipse IDE. JayVeelnCorp I modified the connection string.

Uploader: Dolmaran
Date Added: 19 September 2004
File Size: 58.15 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 47866
Price: Free* [*Free Regsitration Required]

Anonymous December 3, at 4: I have verified this by going as far as copy-pasting the values from my code in the connection manager of SQLDeveloper, where connecting works fine. Follow the step-by-step installation guide from this link. Can you please give some more details?

JDBC with Oracle using MyEclipse and NetBeans

I have now tried with the alternative connection pattern you suggested – I get the same error. Unknown June 27, at Thib can use telnet command to check that.

Should i specify my class name after o3? You can code and run a Java program using a simple text editor such as Notepad and use command prompt to run the program.

A good tutorial indeed!

The Oracle XE installation is very simple. And now – hold on to your hats: Myeclipsee Kapeutini Voisin March 2, at 7: Below configurations would work. Thanks for your reply though!


Now the database and table setup is done. Now do the same but write “java -Doracle.

java – ORA when connecting through jdbc thin driver – Stack Overflow

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Similar exception can occur if username and password is specified even empty values in oracle thin wallet connection configurations. Specify this only if the default Oracle Net listener port is not used. OracleDriver is the jdbc driver class.

When you click add JAR option a dialog will open and you just need to choose the ojdbc Run the above program to get the following output.

Have you tried anoother conenction pattern like jdbc: Good work done by you people.

MyEclipse Database Explorer cannot connect Oracle

I am trying to connect to the database using your guide but keep on getting ping failed while testing connection. For example, if you connect to a local database using default port number, then the Oracle database connection URL is:. I’m not sure I get this – why are they bringing out new versions of this driver if it fails on connecting you to the database properly?


A friendly DB admin came to the rescue, and found that this is actually an Oracle bug: After clicking on test connection I am receiving below error: Thanks Javin for such a useful document.

Seems this would be the first issue everybody runs into when using the thin driver? I’ve created a small test application to demonstrate the problem: Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policymyeclipze that your continued use of the website is subject to these policies.

JayVeeInCorp 31 2 6.