This looks like it might make a good wiki page. Could you make one? Thanks, Nathan
----- Original Message ----- From: "Sandhu" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, June 6, 2007 2:57:21 PM (GMT-0800) America/Los_Angeles Subject: Re: [appfuse-user] Appfuse 2.0 M5 (Modular Spring) - Oracle configuration 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&useUnicode=true&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) Sandhu wrote: > > Right now, I am using appfuse with MySQL, I want to switch to Oracle 9i. > Is there any quickguide to make it working? > -- View this message in context: http://www.nabble.com/Appfuse-2.0-M5-%28Modular-Spring%29---Oracle-configuration-tf3875888s2369.html#a10998097 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
