[Andromda-user] [Hibernate cartridge] [Datetime doesn't work]

joegaber Tue, 14 Jun 2005 08:19:55 -0700

Finally getting back to this issue.  Somehow I got past the errors above and 
now its simply a compiling issue of "symbol cannot be resolved".  This is due 
to the fact that my mapping is putting in a value of:  TIMESTAMPinto the .java 
files where I specified DateTime&#91;datatype&#93;




I was under the impression that the mapping was used just to create the proper 
.sql file???  How do I get the correct java type inserted into the .java files 
and the proper sql type inserted into the .sql files?



CONFIGURATION:



/project.properties

# Change this to generate to the correct MDA database mappings

# For MySql use&#58; MySQL

# For Hypersonic use&#58; HypersonicSql

# For Oracle9i use&#58; Oracle9i

sql.mappings=MySQL



/mda/project.xml

 <dependency>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <groupId>andromda</groupId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<artifactId>maven-andromda-plugin</artifactId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<version>$&#123;andromda.version&#125;</version>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<type>plugin</type>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<properties>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<languageMappingsUri>Java</languageMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<wrapperMappingsUri>JavaWrapper</wrapperMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<sqlMappingsUri>$&#123;sql.mappings&#125;</sqlMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<jdbcMappingsUri>JDBC</jdbcMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<maxSqlNameLength>30</maxSqlNameLength>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<foreignKeySuffix>_FK</foreignKeySuffix>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<ejbJndiNamePrefix>$&#123;pom.groupId&#125;</ejbJndiNamePrefix>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<!-- these 
masking properties allow you to configure the way

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
your model element names are generated -->

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<classifierNameMask>none</classifierNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<classifierPropertyNameMask>none</classifierPropertyNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<operationNameMask>none</operationNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<roleNameMask>none</roleNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<enumerationNameMask>none</enumerationNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<enumerationLiteralNameMask>none</enumerationLiteralNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<entityNameMask>none</entityNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<entityPropertyNameMask>none</entityPropertyNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<parameterNameMask>none</parameterNameMask>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</properties>

&nbsp; &nbsp; &nbsp; &nbsp; </dependency>

&nbsp; &nbsp; &nbsp; &nbsp; <dependency>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <groupId>andromda</groupId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<artifactId>andromda-spring-cartridge</artifactId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<version>$&#123;andromda.version&#125;</version>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <type>jar</type>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <properties>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<username>$&#123;dataSource.user&#125;</username>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<password>$&#123;dataSource.password&#125;</password>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<driver>$&#123;dataSource.driver.class&#125;</driver>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<connectionUrl>$&#123;dataSource.url&#125;</connectionUrl>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateDialect>$&#123;hibernate.db.dialect&#125;</hibernateDialect>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateShowSql>$&#123;hibernate.db.showSql&#125;</hibernateShowSql>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateUseQueryCache>false</hibernateUseQueryCache>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateQueryUseNamedParameters>true</hibernateQueryUseNamedParameters>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateCacheProvider>net.sf.hibernate.cache.EhCacheProvider</hibernateCacheProvider>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateInheritanceStrategy>$&#123;hibernate.inheritance.strategy&#125;</hibernateInheritanceStrategy>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateQueryCacheFactory>net.sf.hibernate.cache.StandardQueryCacheFactory</hibernateQueryCacheFactory>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<springTypesPackage>$&#123;pom.package&#125;</springTypesPackage>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<daos>$&#123;maven.andromda.core.generated.dir&#125;</daos>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<dao-impls>$&#123;maven.andromda.core.manual.dir&#125;</dao-impls>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<spring-configuration>$&#123;maven.andromda.core.generated.dir&#125;</spring-configuration>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<services>$&#123;maven.andromda.core.generated.dir&#125;</services>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<service-impls>$&#123;maven.andromda.core.manual.dir&#125;</service-impls>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </properties>

&nbsp; &nbsp; &nbsp; &nbsp; </dependency>

&nbsp; &nbsp; &nbsp; &nbsp; <dependency>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <groupId>andromda</groupId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<artifactId>andromda-hibernate-cartridge</artifactId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<version>$&#123;andromda.version&#125;</version>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <type>jar</type>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <properties>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateTypeMappingsUri>Hibernate</hibernateTypeMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateInheritanceStrategy>$&#123;hibernate.inheritance.strategy&#125;</hibernateInheritanceStrategy>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<defaultHibernateGeneratorClass>$&#123;hibernate.generatorClass&#125;</defaultHibernateGeneratorClass>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<hibernateDefaultCascade>none</hibernateDefaultCascade>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<entities>$&#123;maven.andromda.core.generated.dir&#125;</entities>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<entity-impls>$&#123;maven.andromda.core.manual.dir&#125;</entity-impls>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<customTypesPackage>$&#123;pom.package&#125;</customTypesPackage>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<compositionDefinesEagerLoading>true</compositionDefinesEagerLoading>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </properties>

&nbsp; &nbsp; &nbsp; &nbsp; </dependency>

&nbsp; &nbsp; &nbsp; &nbsp; <dependency>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <groupId>andromda</groupId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<artifactId>andromda-java-cartridge</artifactId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<version>$&#123;andromda.version&#125;</version>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <properties>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<enumerations>$&#123;maven.andromda.common.generated.dir&#125;</enumerations>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<exceptions>$&#123;maven.andromda.common.generated.dir&#125;</exceptions>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<value-objects>$&#123;maven.andromda.common.generated.dir&#125;</value-objects>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </properties>

&nbsp; &nbsp; &nbsp; &nbsp; </dependency>

&nbsp; &nbsp; &nbsp; &nbsp; <dependency>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <groupId>andromda</groupId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<artifactId>andromda-bpm4struts-cartridge</artifactId>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
<version>$&#123;andromda.version&#125;</version>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <properties>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<forms>$&#123;maven.andromda.web.generated.dir&#125;</forms>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<pages>$&#123;maven.andromda.web.generated.dir&#125;</pages>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<actions>$&#123;maven.andromda.web.generated.dir&#125;</actions>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<controllers>$&#123;maven.andromda.web.generated.dir&#125;</controllers>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<controller-impls>$&#123;maven.andromda.web.manual.java.dir&#125;</controller-impls>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<decorators>$&#123;maven.andromda.web.manual.java.dir&#125;</decorators>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<messages>$&#123;maven.andromda.web.generated.dir&#125;/WEB-INF/classes</messages>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<configuration>$&#123;maven.andromda.web.generated.dir&#125;/WEB-INF</configuration>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<security>false</security>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<securityRealm>other</securityRealm>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<serviceAccessorPattern>$&#123;pom.package&#125;.ServiceLocator.instance&#40;&#41;.get&#123;1&#125;&#40;&#41;</serviceAccessorPattern>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<manageableServiceAccessorPattern>$&#123;pom.package&#125;.ManageableServiceLocator.instance&#40;&#41;.get&#123;1&#125;&#40;&#41;</manageableServiceAccessorPattern>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;<mergeMappingsUri>file&#58;$&#123;maven.conf.dir&#125;/mappings/Bpm4StrutsMergeMappings.xml</mergeMappingsUri>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </properties>

&nbsp; &nbsp; &nbsp; &nbsp; </dependency>





maven-andromda-plugin-3.0/plugin-resource/andromda/mappings/MySQLMappings.xml

<mappings name="MySQL">

&nbsp; &nbsp; <mapping>

&nbsp; &nbsp; &nbsp; &nbsp; <from>datatype&#58;&#58;String</from>

&nbsp; &nbsp; &nbsp; &nbsp; <to>VARCHAR&#40;255&#41; BINARY</to>

&nbsp; &nbsp; </mapping>

&nbsp; &nbsp; <mapping>

&nbsp; &nbsp; &nbsp; &nbsp; <from>datatype&#58;&#58;Date</from>

&nbsp; &nbsp; &nbsp; &nbsp; <to>DATETIME</to>

&nbsp; &nbsp; </mapping>

&nbsp; &nbsp; <mapping>

&nbsp; &nbsp; &nbsp; &nbsp; <from>datatype&#58;&#58;Time</from>

&nbsp; &nbsp; &nbsp; &nbsp; <to>BIGINT</to>

&nbsp; &nbsp; </mapping>

&nbsp; &nbsp; <mapping>

&nbsp; &nbsp; &nbsp; &nbsp; <from>datatype&#58;&#58;Timestamp</from>

&nbsp; &nbsp; &nbsp; &nbsp; <from>datatype&#58;&#58;DateTime</from>

&nbsp; &nbsp; &nbsp; &nbsp; <to>TIMESTAMP</to>

&nbsp; &nbsp; </mapping>
_________________________________________________________
Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=1214#1214
Posting to http://forum.andromda.org/ is preferred over posting to the mailing 
list!


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.  
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
Andromda-user mailing list
Andromda-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/andromda-user

[Andromda-user] [Hibernate cartridge] [Datetime doesn't work]

Reply via email to