[appfuse-user] CheatSheet-Five-Step-Setup-oracle10g-Spring-Appfuse 2.0 M5

[Sandhu]

CheatSheet-Five-Step-Setup-oracle10g-Spring-Appfuse 2.0 M5
Step 1:

Install Oracle Driver to your local repository:
cd C:\dl\oracle driver\oracle 10.2.0.2.0

mvn install:install-file -Dfile=ojdbc14.jar -DgroupId=oracle.jdbc
-DartifactId=ojdbc14 -Dversion=10.2.0.2.0 -Dpackaging=jar -DgeneratePom=true

                C:\Documents and Settings\jaspsand>cd C:\dl\oracle driver\oracle
10.2.0.2.0

                C:\dl\oracle driver\oracle 10.2.0.2.0>mvn install:install-file
-Dfile=ojdbc14.ja 
                r -DgroupId=oracle.jdbc -DartifactId=ojdbc14 
-Dversion=10.2.0.2.0
-Dpackaging=ja 
                r -DgeneratePom=true [INFO] Scanning for projects... [INFO] 
Searching
repository 
                for plugin with prefix: 'install'. [INFO] 
                
-------------------------------------------------------------------------
--- 
                [INFO] Building Maven Default Project [INFO]    task-segment: 
                [install:install-file] (aggregator-style) [INFO] 
                
-------------------------------------------------------------------------
--- 
                [INFO] [install:install-file] [INFO] Installing C:\dl\oracle 
driver\oracle 
                10.2.0.2.0\ojdbc14.jar to C:\Docume nts and 
                
Settings\jaspsand\.m2\repository\oracle\jdbc\ojdbc14\10.2.0.2.0\ojdbc14- 
                10.2.0.2.0.jar [INFO] 
                
------------------------------------------------------------------------
[INFO] 
                BUILD SUCCESSFUL [INFO] 
                
------------------------------------------------------------------------
[INFO] 
                Total time: 4 seconds [INFO] Finished at: Wed Jun 06 12:48:54 
PDT 2007
[INFO] 
                Final Memory: 3M/508M [INFO] 
                
------------------------------------------------------------------------

Step 2: Change c:\work\sandbox\xxxxx\pom.xml

Make sure that 
   <dependency>
            <groupId>${jdbc.groupId}</groupId>
            <artifactId>${jdbc.artifactId}</artifactId>
            <version>${jdbc.version}</version>
        </dependency>

Check that you have profile as follows in your pom.xml

  <profile>
            <id>oracle</id>
            <properties>
               
<dbunit.dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dbunit.dataTypeFactoryName>
                <dbunit.schema>SYSTEM</dbunit.schema> <!-- Make sure to
capitalize the schema name -->
               
<hibernate.dialect>org.hibernate.dialect.Oracle9Dialect</hibernate.dialect>
                <jdbc.groupId>com.oracle</jdbc.groupId>
                <jdbc.artifactId>ojdbc14</jdbc.artifactId>
                <jdbc.version>10.2.0.2.0</jdbc.version>
               
<jdbc.driverClassName>oracle.jdbc.OracleDriver</jdbc.driverClassName>
               
<jdbc.url><![CDATA[jdbc:oracle:thin:@localhost:1521:XE]]></jdbc.url>
                <jdbc.username>system</jdbc.username>
                <jdbc.password>admin</jdbc.password>
            </properties>
        </profile>

Comment out MySQL 
   <!-- Database settings  MySQL-->
        <!--
        
<dbunit.dataTypeFactoryName>org.dbunit.dataset.datatype.DefaultDataTypeFactory</dbunit.dataTypeFactoryName>
        <dbunit.operation.type>CLEAN_INSERT</dbunit.operation.type>
       
<hibernate.dialect>org.hibernate.dialect.MySQLInnoDBDialect</hibernate.dialect>
        <jdbc.groupId>mysql</jdbc.groupId>
        <jdbc.artifactId>mysql-connector-java</jdbc.artifactId>
        <jdbc.version>5.0.5</jdbc.version>
        <jdbc.driverClassName>com.mysql.jdbc.Driver</jdbc.driverClassName>
       
<jdbc.url><![CDATA[jdbc:mysql://localhost/eitms30?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=utf-8]]></jdbc.url>
        <jdbc.username>root</jdbc.username>
        <jdbc.password>admin</jdbc.password>
    -->


    Add the following 


    <!-- Database settings  Oracle -->
    
<dbunit.dataTypeFactoryName>org.dbunit.dataset.datatype.DefaultDataTypeFactory</dbunit.dataTypeFactoryName>
       <dbunit.operation.type>CLEAN_INSERT</dbunit.operation.type> 
           <dbunit.schema>SYSTEM</dbunit.schema> <!-- Make sure to capitalize 
the
schema name -->
       
<hibernate.dialect>org.hibernate.dialect.Oracle9Dialect</hibernate.dialect>
                <jdbc.groupId>oracle.jdbc</jdbc.groupId>
                <jdbc.artifactId>ojdbc14</jdbc.artifactId>
                <jdbc.version>10.2.0.2.0</jdbc.version>
        
<jdbc.driverClassName>oracle.jdbc.driver.OracleDriver</jdbc.driverClassName>
        <jdbc.url><![CDATA[jdbc:oracle:thin:@localhost:1521:XE]]></jdbc.url>
                <jdbc.username>system</jdbc.username>
        <jdbc.password>admin</jdbc.password>


Step 3: cd core 
             mvn resources:testResources hibernate3:hbm2ddl
             mvn compile hibernate3:hbm2ddl
Step 4: mvn integration-test from main directory if you are using module
based.

Step 5: mvn jetty:run-war -Djetty.port=9090  (With Oracle, change port to
9090 since oracle uses 8080 port)

CheatSheet-Five-Step-Setup-oracle10g-Spring-Appfuse 2.0 M5
-- 
View this message in context: 
http://www.nabble.com/CheatSheet-Five-Step-Setup-oracle10g-Spring-Appfuse-2.0-M5-tf3880665s2369.html#a10998118
Sent from the AppFuse - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]