oracle anyone?

[Tore Halset <ha...@pvv.ntnu.no>]

Hello.

I currently have access to PostgreSQL, Derby, hsql, MySQL and MS SQL  
Server. I really want to be able to run junit tests on some more  
databases like Oracle, DB2 and so on. Anyone know how we can set that  
up?

Regards,
  - Tore.

Re: oracle anyone?

[Ellis Miller <ou...@gmail.com>]

Good reference for Solaris/Linux Oracle RDBMS installations (better/easier
to follow than the OTN documentation):

http://www.dbspecialists.com/presentations.html

Solaris:

http://www.dbspecialists.com/files/presentations/oracle10gsolaris.html

Linux:

http://www.dbspecialists.com/files/presentations/oracle10glinux.html

On specific catch: If installing on Fedora or some other flavor of Linux
must "fool" the Oracle installer by editing the /etc release file (on Fedora
7 edit file and change "Fedora Release 7" to "redhat release 5")

*$ cat /etc/fedora-release

*

 Thanks.


On Sun, Jun 22, 2008 at 7:55 AM, Tore Halset <ha...@pvv.ntnu.no> wrote:

> On 22. juni. 2008, at 02.05, Aristedes Maniatis wrote:
>
>  If you mean, run Cayenne unit and integration tests,
>>
>
> Yes.
>
>  then my goal is to install a range of databases in our Cayenne zone and
>> have Hudson run them automatically. I've spent quite a few hours on this
>> already, but am finding it very difficult to install things in the
>> restricted sandbox we have inside the zone. If you have more Solaris
>> experience and can navigate around the limits imposed by the zone, I'd love
>> help to get them installed. Unfortunately from tomorrow I am travelling for
>> a month, so I'll not be very available for a little while.
>>
>
> So what have you installed? It is some years since I used Solaris for
> anything serious.
>
>
>> Oracle has a free license for Windows/Linux (but not Solaris I think) with
>> the limitation of only being able to create a single database. We do our
>> testing in our office with this version running on Windows. You have to
>> register on the Oracle web site and they send you endless marketing
>> information.
>>
>
> I have downloaded this for linux and have a box to install it on. Should
> probably try to install it.. Just afraid of all the uninteresting
> oracle-trouble I will get into...
>
> - Tore.
>

Re: oracle anyone?

[Tore Halset <ha...@pvv.ntnu.no>]

On 22. juni. 2008, at 02.05, Aristedes Maniatis wrote:

> If you mean, run Cayenne unit and integration tests,

Yes.

> then my goal is to install a range of databases in our Cayenne zone  
> and have Hudson run them automatically. I've spent quite a few hours  
> on this already, but am finding it very difficult to install things  
> in the restricted sandbox we have inside the zone. If you have more  
> Solaris experience and can navigate around the limits imposed by the  
> zone, I'd love help to get them installed. Unfortunately from  
> tomorrow I am travelling for a month, so I'll not be very available  
> for a little while.

So what have you installed? It is some years since I used Solaris for  
anything serious.

>
> Oracle has a free license for Windows/Linux (but not Solaris I  
> think) with the limitation of only being able to create a single  
> database. We do our testing in our office with this version running  
> on Windows. You have to register on the Oracle web site and they  
> send you endless marketing information.

I have downloaded this for linux and have a box to install it on.  
Should probably try to install it.. Just afraid of all the  
uninteresting oracle-trouble I will get into...

- Tore.

Re: oracle anyone?

[Aristedes Maniatis <ar...@ish.com.au>]

On 22/06/2008, at 7:26 AM, Tore Halset wrote:

> Hello.
>
> I currently have access to PostgreSQL, Derby, hsql, MySQL and MS SQL  
> Server. I really want to be able to run junit tests on some more  
> databases like Oracle, DB2 and so on. Anyone know how we can set  
> that up?


If you mean, run Cayenne unit and integration tests, then my goal is  
to install a range of databases in our Cayenne zone and have Hudson  
run them automatically. I've spent quite a few hours on this already,  
but am finding it very difficult to install things in the restricted  
sandbox we have inside the zone. If you have more Solaris experience  
and can navigate around the limits imposed by the zone, I'd love help  
to get them installed. Unfortunately from tomorrow I am travelling for  
a month, so I'll not be very available for a little while.

It is frustrating because on an OS I know (eg FreeBSD) these things  
would take me several minutes.

Oracle has a free license for Windows/Linux (but not Solaris I think)  
with the limitation of only being able to create a single database. We  
do our testing in our office with this version running on Windows. You  
have to register on the Oracle web site and they send you endless  
marketing information.

I tried to extract some better information about licensing from an  
Oracle sales person at the recent CeBIT in Sydney, but I just got some  
smarmy employee who knew little about the licensing and thought that  
Windows and RHEL were the only two 'enterprise' operating systems:  
anyone using something else was worthy of ridicule.

I was going to ask on infra that someone with root zone access install  
a range of databases for us, but I was going to have one more crack at  
installing mysql first. The Hudson part should be really quite simple.

Ari


-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001   fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A