[
https://issues.apache.org/jira/browse/CAY-1441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12874803#action_12874803
]
Andrus Adamchik commented on CAY-1441:
--------------------------------------
Case-sensitivity of the schema names is a function of a given DB or even a
specific configuration (e.g. MySQL can have either case sensitive or
insensitive identifiers)... I guess mentioning this in the docs is indeed a
good idea.
> cdbimport doesn't find any tables
> ---------------------------------
>
> Key: CAY-1441
> URL: https://issues.apache.org/jira/browse/CAY-1441
> Project: Cayenne
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 3.0
> Reporter: Paul Sprague
> Priority: Trivial
>
> 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"
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
