Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.
Unable to connect with Jchem Manager -- ORA-12514 error
To watch this topic for replies  Register (enables digests) or give email address:
Reply to topic
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Guy Oshiro

Joined: 04 Mar 2009
Posts: 27

View user's profile

Back to top
Link to postPosted: Tue Sep 20, 2011 6:25 pmPost subject: Unable to connect with Jchem Manager -- ORA-12514 error Reply with quote

Hi,

I am unable to connect to our Oracle database with Jchem Manager.

I am hitting an Oracle ORA-12514 error (ORA-12514, TNS:listener does not currently know of service requested in connect descriptor). However, I can connect via other tools such as SQL Plus and SQL Developer. All other programs are able to connect to the database except for JChem Manager using the exact same connection URL.

Driver: oracle.jdbc.driver.OracleDriver

database URL: jdbc:oracle:thin:@//myDB:1521/MYSID

Any thoughts?

 

Thanks,

Guy

pkovacs
ChemAxon personnel
Joined: 23 Jul 2004
Posts: 1938

View user's profile
Visit poster's website

Back to top
Link to postPosted: Tue Sep 20, 2011 6:27 pmPost subject: Reply with quote

Hi Guy,

What about this url:

jdbc:oracle:thin:@myDB:1521:MYSID

? (http://www.chemaxon.com/jchem/doc/admin/JChemBaseFAQ.html#dburl)

Peter

jlee

Joined: 11 Aug 2008
Posts: 724

View user's profile

Back to top
Link to postPosted: Tue Sep 20, 2011 6:33 pmPost subject: Reply with quote

You may also try removing the package name, "driver", from the Driver name:

Driver: oracle.jdbc.driver.OracleDriver

 

Jon


Guy Oshiro

Joined: 04 Mar 2009
Posts: 27

View user's profile

Back to top
Link to postPosted: Tue Sep 20, 2011 6:35 pmPost subject: Reply with quote

pkovacs wrote:

Hi Guy,

What about this url:

jdbc:oracle:thin:@myDB:1521:MYSID

? (http://www.chemaxon.com/jchem/doc/admin/JChemBaseFAQ.html#dburl)

Peter

 

Thanks Peter.

It works now -- my bad.

The strange thing is that the other URL worked (sometimes)

Reply to topic
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum