cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (CAY-1441) cdbimport doesn't find any tables
Date Wed, 02 Jun 2010 21:21:36 GMT

    [ 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.


Mime
View raw message