You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Paul Sprague (JIRA)" <ji...@apache.org> on 2010/06/02 23:15:37 UTC
[jira] Created: (CAY-1441) cdbimport doesn't find any tables
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.
[jira] Commented: (CAY-1441) cdbimport doesn't find any tables
Posted by "Andrus Adamchik (JIRA)" <ji...@apache.org>.
[ 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.