Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-900

Can't create working example with Oracle DB

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.0.2.RELEASE, 1.1.0.M1
    • Fix Version/s: 1.1.0.M2
    • Component/s: PERSISTENCE
    • Labels:
      None
    • Environment:
      Windows Vista SP2, Oracle 10.2

      Description

      I try to create my test application with ROO.
      When I use HYPERSONIC_IN_MEMORY DB - application work right.
      When I use ORACLE DB - application doesn't work at all.
      I can't select and insert rows.
      I use next scripts to create my examples:

      Example HYPERSONIC_IN_MEMORY DB:
      [CODE]
      project --topLevelPackage com.springsource.roo.accHyp
      persistence setup --provider HIBERNATE --database HYPERSONIC_IN_MEMORY

      entity --class ~.domain.Account --testAutomatically
      field number --fieldName branchid --notNull --type java.lang.Integer
      field string --fieldName acc --notNull --sizeMin 6

      perform tests
      controller all --package ~.web
      perform eclipse
      exit
      [/CODE]

      Example Oracle DB:
      [CODE]
      project --topLevelPackage com.springsource.roo.accOra
      persistence setup --provider HIBERNATE --database ORACLE --userName scott --password tiger
      database properties set --key database.url --value jdbc:oracle:thin:@beta:1521:zoo
      database properties list

      entity --class ~.domain.Account --testAutomatically
      field number --fieldName branchid --notNull --type java.lang.Integer
      field string --fieldName acc --notNull --sizeMin 6

      perform tests
      controller all --package ~.web
      perform eclipse
      exit
      [/CODE]

      I use
      Spring Roo 1.0.2.RELEASE [rev 638]
      Spring Roo 1.1.0.M1 [rev 3a0b8a3]
      with practilally the same results.

      You can freelly download Oracle XE from here
      http://www.oracle.com/technology/software/products/database/xe/index.html
      and try my script.

      I get errors when I execute "perform tests" command.

      Paul

        Attachments

          Activity

            People

            • Assignee:
              stewarta Alan Stewart
              Reporter:
              pxp123 Paul Babachanakh
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: