Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1441

cdbimport doesn't find any tables

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 3.0
    • None
    • Documentation
    • None

    Description

      The following example results in a DataMap file with no table definitions when either schemaName or tablePattern are lowercase. This is because all of our tablenames/schema names are stored in all uppercase which slipped my mind for several hours... I think it would be great if their was a hint on the maven plugin documentation wiki page about the case sensitivity of these fields.

      <plugin>
      <groupId>org.apache.cayenne.plugins</groupId>
      <artifactId>maven-cayenne-plugin</artifactId>
      <executions>
      <execution>
      <id>cdbimport</id>
      <configuration>
      <map>${project.build.sourceDirectory}/../resources/schema.map.xml</map>
      <overwriteExisting>true</overwriteExisting>

      <!-- must be uppercase or we don't get any tables -->
      <schemaName>SCHEMA</schemaName>

      <!-- must be uppercase or we don't get any tables -->
      <tablePattern>T_%</tablePattern>

      <adapter>org.apache.cayenne.dba.oracle.OracleAdapter</adapter>
      <driver>oracle.jdbc.driver.OracleDriver</driver>
      <url>jdbc:oracle:thin:@hostname:1521:sid</url>
      <username>username</username>
      <password>password</password>
      </configuration>
      <goals>
      <goal>cdbimport</goal>
      </goals>
      </execution>
      </executions>
      <dependencies>
      <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>oracle_jdbc</artifactId>
      <version>10.2.0.2.0</version>
      </dependency>
      </dependencies>
      </plugin>

      Oracle Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
      Maven version: 2.0.9
      Java version: 1.5.0_19
      OS name: "mac os x" version: "10.5.8" arch: "i386" Family: "unix"

      Attachments

        Activity

          People

            Unassigned Unassigned
            psprague Paul Sprague
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: