Oracle Jdbc invalid url problem
Hallo,
I have a problem similar to the one described in this thread but I couldn't fix it so far.
http://forum.springframework.org/showthread.php?t=10870
I am running an application using Spring but no Hibernate on Tomcat 5. Using MySQL is no problem but trying to connect to an Oracle 10g database is impossible. I am using these connection details for my DataSource:
Code:
<property name="username"><value>user</value></property>
<property name="password"><value>pw</value></property>
<property name="url"><value>jdbc:oracle:thin:@servername:1521:teacup</value></property>
<property name="driver"><value>oracle.jdbc.driver.OracleDriver</value></property>
Running it on a desktop with W2k the log file shows an Invalid Jdbc Url error after displaying that spring obviously translated the url into
jdbc:oracle://servername:1521/teacup. Connecting to the database from the commandline is no problem using simple jdbc code.
When I try to run either the application or the little test program on the WinXP machine it says 'Io exception: The Network Adapter could not establish the connection'.
What is the problem? Is it ok that Spring changes the database url? If not, how can I prevent this? It's fine with MySQL but the application has to run with Oracle so I need to sort that out. Any ideas?
Thanks,
Joachim