Unable to database introspect with Oracle

[sathyakumar]

Hi,
I installed and started OSGI bundles for oracle. When I do a database introspect I get

Unable to get connection from driver

My database properties file read

database.password=am_user
database.url=jdbc\:oracle\:thin\:@10.40.51.43\:152 1
database.username=am_user
database.driverClassName=oracle.jdbc.OracleDriver

Am using Roo 1.1.1-RELEASE.

Regards
Sathya

[ziller]

hi,

it's not normal to have a space in the port number (152 1)

bye

[sathyakumar]

The actual properties does not have space in it.

[Alan Stewart]

When you execute an osgi ps command in Roo, do you see:

[  74] [Active     ] [    1] Java Transaction API (1.1.0)
[  75] [Active     ] [    1] Java Resource API (1.5.0)
[  76] [Active     ] [    1] Oracle JDBC Driver (10.2.0.2)

(numbers at front are not important)

Your database.url doesn't have the database name either. I use Oracle XE and it must be appended like this

database.url=jdbc:oracle:thin:@10.22.35.237:1521:XE

However, I can't advise here if you are not running XE.

[sathyakumar]

Sorry. My bad, I was missing SID. Now it works super.

Regards
Sathya