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 <[email protected]> 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 <[email protected] <mailto:
>> [email protected]>> 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
>> <[email protected] <mailto:[email protected]>
>> <mailto:[email protected] <mailto:[email protected]>>> 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
>> [email protected] <mailto:[email protected]>
>> <mailto:[email protected] <mailto:[email protected]>>
>>
>>
>> Mobile: (+354) 896-7963
>> Home: (+354) 565-5229
>>
>>
>>
>>
>>
>> --
>>
>> Kveðja/Regards
>> Gunnlaugur Sigurðsson
>> [email protected] <mailto:[email protected]>
>> Mobile: (+354) 896-7963
>> Home: (+354) 565-5229
>>
>
>
--
Kveðja/Regards
Gunnlaugur Sigurðsson
[email protected]
Mobile: (+354) 896-7963
Home: (+354) 565-5229
