Announcement Announcement Module
Collapse
No announcement yet.
Unable to database introspect with Oracle Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to database introspect with Oracle

    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

  • #2
    hi,

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

    bye

    Comment


    • #3
      Some copy and paste error

      The actual properties does not have space in it.

      Comment


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

        Code:
        [  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
        Code:
        database.url=jdbc:oracle:thin:@10.22.35.237:1521:XE
        However, I can't advise here if you are not running XE.

        Comment


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

          Regards
          Sathya

          Comment

          Working...
          X