Hi Kurt. I was looking at the Database_Setup.xml file in the trunk and noticed one typo on my behalf. (i.e.<filename>The myclasses12.jar</filename>) should be (i.e.<filename>The classes12.jar</filename>)
Sorry about that. -Gunnlaugur On Mon, May 10, 2010 at 2:50 PM, Kurt T Stam <kurt.s...@gmail.com> wrote: > Thanks Gunnlauger, all checked in :). --Kurt > > > Gunnlaugur Sigurðsson wrote: > >> Hi Kurt. >> >> Here is my documentation to change to Oralce database. >> >> +++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> >> 4.4. Switch to Oracle 10g >> >> To switch over to Oracle you need to add the oracle driver (i.e. The >> myclasses12.jar) to the classpath and you will need to edit the >> persistence.xml >> >> <property name="hibernate.dialect" >> value="org.hibernate.dialect.Oracle10gDialect"/> >> >> Note: for other versions of Oracle yhe dialect might need to be something >> else than 'Oracle10gDialect' >> >> Follow the example in chapter 11.3 of the jUDDI User Guide to change the >> Oracle Sequence name and place the orm.xml file next to the persistence.xml >> file. >> >> Then the datasource. For tomcat your context.xml should look something >> like: >> >> <!-- Oracle 10 --> >> <Resource name="jdbc/JuddiDS" auth="Container" >> type="javax.sql.DataSource" username="root" password="" >> driverClassName="oracle.jdbc.driver.OracleDriver" >> url="jdbc:oracle:thin:@localhost:1521:juddiv3" >> maxActive="8"/> >> >> >> To create a Oracle database name juddiv3 with the ultimate in minimalism >> use >> >> sqlplus> create database juddiv3; >> >> then you probably want to switch to a user which is a bit less potent then >> 'root' and set the appropriate password. >> >> Warning >> >> Tomcat copies the context.xml to conf/CATALINA/localhost/juddiv3.xml, and >> if you update the context.xml it may not update this copy. You should simply >> delete the juddiv3.xml file after updating the context.xml. >> >> Start tomcat and the database tables should be created automaticaly. >> >> 4.5. Switch to <other db> >> >> If you use another database, please document, and send us what you had to >> change to make it work and we will include it here. >> >> +++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> >> Regards. >> Gunnlaugur >> >> >> >> >> >> >> On Tue, May 4, 2010 at 3:44 PM, Kurt T Stam <kurt.s...@gmail.com <mailto: >> kurt.s...@gmail.com>> wrote: >> >> It should go next to the persistence.xml, it is a JPA artifact. --K >> >> Gunnlaugur Sigurðsson wrote: >> >> Ok. But I'm not sure where I add the orm.xml file. >> The doc only says "place it within the classpath in a META-INF >> directory". >> What META-INF directory is it referring to? >> >> -Gunnlaugur >> >> >> >> On Mon, May 3, 2010 at 5:10 PM, Kurt T Stam >> <kurt.s...@gmail.com <mailto:kurt.s...@gmail.com> >> <mailto:kurt.s...@gmail.com <mailto:kurt.s...@gmail.com>>> wrote: >> >> Yes and change the dialect setting in the persistence.xml >> >> >> http://ws.apache.org/juddi/docs/3.0/userguide/html/chap-database_setup.html >> >> and maybe you want to have a juddi specific sequence >> >> >> http://ws.apache.org/juddi/docs/3.0/userguide/html/chap-Administration.html#sect-changing_oracle_sequence_name >> >> --Kurt >> >> Gunnlaugur Sigurðsson wrote: >> >> Ok, so I just have to add the correct Resource >> parameter into >> the context.xml file in >> $JUDDI_HOME/webapps/juddiv3/META-INF$ >> and drop the oracle driver jar into $JUDDI_HOME/lib >> >> -Gunnlaugur >> >> >> >> On Mon, May 3, 2010 at 4:10 PM, Kurt T Stam >> <kurt.s...@gmail.com <mailto:kurt.s...@gmail.com> >> <mailto:kurt.s...@gmail.com <mailto:kurt.s...@gmail.com>> >> <mailto:kurt.s...@gmail.com >> <mailto:kurt.s...@gmail.com> <mailto:kurt.s...@gmail.com >> <mailto:kurt.s...@gmail.com>>>> wrote: >> >> Gunnlaugur Sigurðsson wrote: >> >> Hi. >> >> Are there any sql scripts for the 3.0.1 version to >> create the >> database in oracle like it was in the old >> distributions? >> >> Thanks. >> >> -Gunnlaugur >> >> Hi Gunnlaugur, >> >> Since it is jpa based you can have the being created at >> deploytime, or you can use the ddl provided here: >> >> http://svn.apache.org/viewvc/webservices/juddi/trunk/docs/db/ddl/ >> >> --Kurt >> >> >> >> >> -- >> Kveðja/Regards >> Gunnlaugur Sigurðsson >> gunnlaugur...@gmail.com >> <mailto:gunnlaugur...@gmail.com> >> <mailto:gunnlaugur...@gmail.com <mailto:gunnlaugur...@gmail.com>> >> <mailto:gunnlaugur...@gmail.com >> <mailto:gunnlaugur...@gmail.com> >> <mailto:gunnlaugur...@gmail.com >> <mailto:gunnlaugur...@gmail.com>>> >> >> >> Mobile: (+354) 896-7963 >> Home: (+354) 565-5229 >> >> >> >> >> >> -- >> Kveðja/Regards >> Gunnlaugur Sigurðsson >> gunnlaugur...@gmail.com <mailto:gunnlaugur...@gmail.com> >> <mailto:gunnlaugur...@gmail.com <mailto:gunnlaugur...@gmail.com>> >> Mobile: (+354) 896-7963 >> Home: (+354) 565-5229 >> >> >> >> >> >> -- >> >> Kveðja/Regards >> Gunnlaugur Sigurðsson >> gunnlaugur...@gmail.com <mailto:gunnlaugur...@gmail.com> >> Mobile: (+354) 896-7963 >> Home: (+354) 565-5229 >> > > -- Kveðja/Regards Gunnlaugur Sigurðsson gunnlaugur...@gmail.com Mobile: (+354) 896-7963 Home: (+354) 565-5229
