Oracle Express database on windows on Parallels

[falconb]

Hello everybody,

I didn't know where to create this thread whether here in this section or in the programming section...

let's get to the point. I'm creating a java application on my mac using NetBeans IDE but I have to connect the NetBeans application to a database (Oracle Express) and as Oracle Express is not available for OS X I had to install it a VM using Parallels on Windows 7

and the question is that if the database was on the same OS as the one i'm creating the app on (in our case the Mac OS X) i would put this line of code to the app to locate the database (this line is gonna be inside the "DatabaseManager.java" class responsible for the connection)


String url = "jdbc: oracle:thin127.0.0.1:1521:XE";


but then what would the value of the variable "url" have to be if the database is on a windows 7 VM (Virtual Machine) on Parallels


thank you in advance and any help is appreciated

but please don't tell me to get a Windows PC

 

[hiddenmarkov]

offhand I'd say replace loopback address (127.) with the ip of the windows client.


Life will be easier if you made this static in someway. If your only parallels vm it should always have the same address on startup. If not and you run a few at a time...there are a few ways to get statics in parallels if something else takes that IP first.


Also make sure both the parallels firewall (if on), mac os firewall (if on) and the windows client allow port 1521 as its needed by the look of the address.

 

[falconb]

many thanks...
as time was running out i had to install NetBeans on the Win 7 VM and migrated my project their to save time

but in the future i think i definitely need to know how to solve this as i may face the problem again