Is this datasource path correct
Good morning to all.
I'm trying to get the darn datasource to work with the local Oracle 11g database. I'm on a Windows XP system.
jdbc:oracle:thin@localhost:1521:SID
I keep getting a Cannot parse url. Root exception is java.net.MalformedURLException.
I think it has to do with the driver but the system I'm developing on is not connected to a network so I cannot pull anything down.
This has been plaguging me for weeks.
Thanks for looking.
Please sign in to leave a comment.
You're missing a colon after "thin". Should be: jdbc:oracle:thin:@localhost:1521:SID
sorry but I did have it there in IntelliJ. That is a typo on this post. The error is still the same. The project has an ojdbc6.jar file and teh JDBC Driver Clas is oracle.jdbc.OracleDriver if that helps to identify the issue.
Would someone post where and what .jar file I need to manually download and transfer to my development system to connect to Oracle via IntelliJ?
I am unable to directly download through the IntelliJ on the development system so I have to manually download and transfer the appropriate jar file.
Thanks.
Hi.
I use ojdbc6_g.jar and URL like:
jdbc:oracle:thin:@//host-name:1521/xe
(Notice the '//' before the host.) It works for me.
Regards,
Alexander.