Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 20762 invoked from network); 18 Feb 2006 19:08:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Feb 2006 19:08:59 -0000 Received: (qmail 28383 invoked by uid 500); 18 Feb 2006 19:08:56 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 28366 invoked by uid 500); 18 Feb 2006 19:08:56 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 28355 invoked by uid 99); 18 Feb 2006 19:08:55 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Feb 2006 11:08:55 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of olivier.voutat@gmail.com designates 64.233.162.196 as permitted sender) Received: from [64.233.162.196] (HELO zproxy.gmail.com) (64.233.162.196) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Feb 2006 11:08:54 -0800 Received: by zproxy.gmail.com with SMTP id 34so611703nzf for ; Sat, 18 Feb 2006 11:08:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=i5dKYgZueJa+2IqBNqQqE80QaUReFV3VQ60h0W2FjBfDrSuBFiP2tKNRy5/wWNN4Dkc0TvOybbJmw/BmLqmMxKrsHjStcKf+dxW7wAk8TYcwDIdKeWUYW/OrC4PuH7HsgA1oIbX2UHIFGBaLYg3T1FlWRTmsoMic2lR8gFsIUsk= Received: by 10.65.224.6 with SMTP id b6mr1647145qbr; Sat, 18 Feb 2006 11:08:33 -0800 (PST) Received: by 10.64.220.14 with HTTP; Sat, 18 Feb 2006 11:08:33 -0800 (PST) Message-ID: <124d285e0602181108m10f93133m72455634e6f3ce08@mail.gmail.com> Date: Sat, 18 Feb 2006 17:08:33 -0200 From: "Olivier Voutat" To: user@geronimo.apache.org Subject: Re: Using Firebird through Jaybird in a JEE application in Geronimo In-Reply-To: <124d285e0602171540q74f2d991rdd21224dea1ffd98@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8203_14895509.1140289713479" References: <124d285e0602161822q29fd4877g582708b34eb7db94@mail.gmail.com> <8B1E2D0B-733B-4EB7-828D-56F5FBE7FE21@yahoo.com> <124d285e0602170342y220aa935o79f8e4d0413c9445@mail.gmail.com> <74e15baa0602170638x7213eb00v7618021c22f706df@mail.gmail.com> <124d285e0602171523h38dc45dak39f11ffc0194c98c@mail.gmail.com> <124d285e0602171540q74f2d991rdd21224dea1ffd98@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_8203_14895509.1140289713479 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I did some research and find out another way to add the jaybird to the ear instead put in the geronimo-application.xml location of your jar in the common libraries example: jaybird/jaybird-full/2.0.1/jar Olivier On 2/17/06, Olivier Voutat wrote: > > Oh, just a detail for those who would like to do this too. I included the > following lines in the geronimo-application.xml (cause it's a ejb that > does the sql connection with Jaybird): > > http://geronimo.apache.org/xml/ns/deployment-1.0"> > jay/jaybird-full/2.0.1/jar > > > Olivier Voutat > > On 2/17/06, Olivier Voutat wrote: > > > > Thanks Aaron, > > > > This worked perfectly, but now I have a little problem....u made me get > > curious about using a database pool... u see I'm a student of computer > > sciences in Brazil and we use Java as our main programming language. Ou= r > > teacher uses JBoss, and since I knew Geronimo now I call it JBosta (mea= ning > > Jshit, sorry the word)... > > > > I easily create the database pool but how should I configure my ejb to > > be able to use it ? > > > > David, the tip that Aaron gaved me is very easy to use and works > > perfectly for Jaybird for simple connections. > > > > Olivier > > > > On 2/17/06, Aaron Mulder < ammulder@alumni.princeton.edu> wrote: > > > > > > Ah, I see... If you don't want to use the connection pool then the > > > technique is a little different. You need a element in > > > the Geronimo deployment plan for your J2EE module (e.g. > > > geronimo-web.xml for a web app). > > > > > > If you want to know exactly what the dependency element should look > > > like you can go through the database pool screen in the console just > > > like you did and then after you test it hit "Show Plan" instead of > > > deploying the pool, and just take the element from out of > > > that plan, and put it in the plan for your J2EE module instead. It's > > > not necessary to go through the console this way, but it'll give you > > > somethign to copy and paste exactly. :) Anyway, it'll be something > > > like this, depending on exactly where you put it in the repository: > > > > > > something/jaybird-full/2.0.1/jar > > > > > > Thanks, > > > Aaron > > > > > > On 2/17/06, Olivier Voutat wrote: > > > > Hi again, > > > > > > > > For those who doesn't know, I'm trying to establish a connection > > > between my > > > > J2EE application and Firebird Database using > > > Jaybird-2.0.1JDK_1.5.zip > > > > http://firebird.sourceforge.net/index.php?op=3Dfiles&id=3Djaybird > > > > > > > > (yeah,yeah, I know that Geronimo is only certified for J2EE 1.4 bu= t > > > so far > > > > it hasn't be a big issue). > > > > > > > > Extra information: The application that I'm testing already worked > > > under > > > > Geronimo using a connection to Firebird through unixODBC without a > > > database > > > > pool. > > > > > > > > Thanks everybody who replied. Didn't understand very well your .ra= r > > > issue > > > > David, but anyway here is my situation: > > > > > > > > I wasn't trying to create a database pool to do a connection (it i= s > > > really > > > > necessary ?). > > > > I was trying to make the jaybird-full-2.0.1.jar avaliable to my > > > J2EE. > > > > > > > > Current situation, I created a database pool connection with the > > > Database > > > > Type "Other". > > > > In the next config page I put: > > > > > > > > JDBC Driver Class: org.firebirdsql.jdbc.FBDriver > > > > Driver JAR: jaybird-full-2.0.1.jar (deployed in the repository > > > trough the > > > > common libraries page) > > > > JDBC Connect URL: > > > > jdbc:firebirdsql:localhost/3050:/firebirdData/mydatabase.fdb > > > > DB User Name: ******* > > > > DB Password: ******* > > > > > > > > After that I did a "Test Connection" and no problem alert was give= n > > > so I > > > > deployed it. > > > > > > > > Deployed my application and it stills gives me the message > > > > ClassNotFoundException... > > > > > > > > Olivier Voutat > > > > > > > > > > > > > > > > > > > > On 2/17/06, David Jencks < david_jencks@yahoo.com> wrote: > > > > > > > > > > On Feb 16, 2006, at 6:22 PM, Olivier Voutat wrote: > > > > > > > > > > > I'm not getting how to install the driver to make this one > > > > > > avaliable to my applications in Geronimo. Tried many ways, and > > > > > > can't find a way that makes it works. Didn't find any documents > > > > > > about it neither. > > > > > > > > > > > > Can somebody help me about it ? > > > > > > > > > > I tried deploying the latest rar from the downloads, but it has a > > > > > problem in ra.xml (see firebird issue 1433327). I fixed the > > > problem > > > > > in firebird cvs, so if you build the rar yourself it will work. > > > > > (I'll also send you a copy privately). If you want to use > > > something > > > > > closer to the current release, you need to change in ra.xml > > > > > > > > > > > > > > > > > > interface>javax.resource.security.PasswordCredential > > > > interface> > > > > > to > > > > > > > > > > > > > interface>javax.resource.spi.security.PasswordCredential > > > > > > > interface> > > > > > > > > > > and repack the rar. > > > > > > > > > > Anyway, after obtaining a correct rar, you can modify the plan I > > > will > > > > > also send privately to suit your environment and deploy to a > > > running > > > > > server using > > > > > > > > > > java -jar target/geronimo- 1.1-SNAPSHOT/bin/deployer.jar --user > > > system > > > > > --password manager deploy jaybird-2.1.0.rar jaybird-plan.xml > > > > > > > > > > This deployed OK for me but I don't have a firebird installation > > > > > handy so I don't know if there are other problems. Please let me > > > > > know of your progress, I would like there to be a wiki page on > > > using > > > > > firebird/jaybird with Geronimo. > > > > > > > > > > If anyone else would like a copy of the plan I can perhaps get > > > > > started on the wiki page and attach it there. > > > > > > > > > > thanks > > > > > david jencks > > > > > > > > > > > > > > > > > > > > > > Olivier > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Olivier & Cidiane Voutat > > > > Rua Praia de Muri=FA, 9188 > > > > Cep 59092-390 / Natal - RN > > > > Tel: (84) 3219-0427 Cel: (84) 9977-3917 > > > > > > > > > > > -- > > Olivier & Cidiane Voutat > > Rua Praia de Muri=FA, 9188 > > Cep 59092-390 / Natal - RN > > Tel: (84) 3219-0427 Cel: (84) 9977-3917 > > > > > > -- > Olivier & Cidiane Voutat > Rua Praia de Muri=FA, 9188 > Cep 59092-390 / Natal - RN > Tel: (84) 3219-0427 Cel: (84) 9977-3917 > -- Olivier & Cidiane Voutat Rua Praia de Muri=FA, 9188 Cep 59092-390 / Natal - RN Tel: (84) 3219-0427 Cel: (84) 9977-3917 ------=_Part_8203_14895509.1140289713479 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I did some research and find out another way to add the jaybird to the ear<= br>
instead put in the geronimo-application.xml

  <sys:de= pendency>
    <sys:uri>location of your jar in t= he common libraries</sys:uri>
  </sys:dependency>

example:

  <sys:de= pendency>
    <sys:uri>jaybird/jaybird-full/2.0.= 1/jar</sys:uri>
  </sys:dependency>

Olivier
<= br>
On 2/17/06, Olivier Voutat <olivier.voutat@gmail.com> wrote:
Oh, just a detail for those who would like to do this too. I included the f= ollowing lines in the geronimo-application.xml (cause it's a ejb that does = the sql connection with Jaybird):

    <dep:depende= ncy xmlns:dep=3D" http://geronim= o.apache.org/xml/ns/deployment-1.0">
    = ;    <dep:uri>jay/jaybird-full/2.0.1/jar</dep:uri&g= t;
    </dep:dependency>

Olivier Voutat

On 2/17/06= , Olivier Voutat < olivier.voutat@gmail.com> wrote:
Thanks Aaron,

This worked perfectly, but now I have a little proble= m....u made me get curious about using a database pool... u see I'm a stude= nt of computer sciences in Brazil and we use Java as our main programming l= anguage. Our teacher uses JBoss, and since I knew Geronimo now I call it JB= osta (meaning Jshit, sorry the word)...

I easily create the database pool but how should I configure my ejb= to be able to use it ?

David, the tip that Aaron gaved me is very e= asy to use and works perfectly for Jaybird for simple connections.

Olivier


On 2/17/0= 6, Aaron Mulder < ammulder@alumni.princeton.edu> wrote:
Ah, I see...  If you don't want to use the connection pool then t= he
technique is a little different.  You need a <dependency= > element in
the Geronimo deployment plan for your J2EE module (e.g.<= br>geronimo-web.xml for a web app).

If you want to know exactly what the dependency ele= ment should look
like you can go through the database pool screen in the= console just
like you did and then after you test it hit "Show Pla= n" instead of
deploying the pool, and just take the <depenency> element from ou= t of
that plan, and put it in the plan for your J2EE module instead.&nbs= p; It's
not necessary to go through the console this way, but it'll= give you
somethign to copy and paste exactly.  :)  Anyway, i= t'll be something
like this, depending on exactly where you put it in th= e repository:

<dependency><url>something/jaybird-full/2.= 0.1/jar</uri></dependency>

Thanks,
    Aaron

On 2/17/06, Olivier= Voutat <olivier.voutat@gmai= l.com> wrote:
> Hi again,
>
>  For those who doesn't know, I'm t= rying to establish a connection between my
> J2EE application and Firebird Database using Jaybird-2.0.1JDK_1.5.= zip
> http://firebird.sourceforge.net/index.php?op=3Dfiles&id=3Djaybird
>
>  (yeah,yeah, I know that Geronimo is only ce= rtified for J2EE 1.4 but so far
> it hasn't be a big issue).
><= br>>  Extra information: The application that I'm testing alre= ady worked under
> Geronimo using a connection to Firebird through unixODBC without a= database
> pool.
>
>  Thanks everybody who rep= lied. Didn't understand very well your .rar issue
> David, but anyway= here is my situation:
>
>  I wasn't trying to create a database pool to do= a connection (it is really
> necessary ?).
>  I was = trying to make the jaybird-full-2.0.1.jar avaliable to my J2EE.
>
= >  Current situation, I created a database pool connection wit= h the Database
> Type "Other".
>  In the next config page= I put:
>
>  JDBC Driver Class: org.firebirdsql.jdbc.= FBDriver
> Driver JAR: jaybird-full-2.0.1.jar (deployed in the reposi= tory trough the
> common libraries page)
> JDBC Connect URL:
> jdbc:firebird= sql:localhost/3050:/firebirdData/mydatabase.fdb
>  DB User = Name: *******
>  DB Password: *******
>
> =  After that I did a "Test Connection" and no problem alert w= as given so I
> deployed it.
>
>  Deployed my application an= d it stills gives me the message
> ClassNotFoundException...
><= br>>  Olivier Voutat
>
>
>
>
> O= n 2/17/06, David Jencks < david_jencks@yahoo.com> wr= ote:
> >
> > On Feb 16, 2006, at 6:22 PM, Olivier Voutat = wrote:
> >
> > > I'm not getting how to install the driver t= o make this one
> > > avaliable to my applications in Geronimo. Tried many way= s, and
> > > can't find a way that makes it works. Didn't find = any documents
> > > about it neither.
> > >
> > > Can somebody help me about it ?
> >
> > I = tried deploying the latest rar from the downloads, but it has a
> >= ; problem in ra.xml (see firebird issue 1433327).  I fixed the pr= oblem
> > in firebird cvs, so if you build the rar yourself it will work.> > (I'll also send you a copy privately).  If you want t= o use something
> > closer to the current release, you need to cha= nge in=20 ra.xml
> >
> >       &= nbsp;<credential-
> >
> interface>javax.resource.secur= ity.PasswordCredential</credential-
> > interface>
> &= gt; to
> >        <cred= ential-
> >
> interface>javax.resource.spi.security.PasswordCred= ential</credential-
> > interface>
> >
> >= and repack the rar.
> >
> > Anyway, after obtaining a co= rrect rar, you can modify the plan I will
> > also send privately to suit your environment and deploy to a = running
> > server using
> >
> > java -jar targe= t/geronimo- 1.1-SNAPSHOT/bin/deployer.jar --user system
> > --pass= word manager deploy=20 jaybird-2.1.0.rar jaybird-plan.xml
> >
> > This deployed = OK for me but I don't have a firebird installation
> > handy so I = don't know if there are other problems.  Please let me
> &g= t; know of your progress, I would like there to be a wiki page on using
> > firebird/jaybird with Geronimo.
> >
> > If = anyone else would like a copy of the plan I can perhaps get
> > st= arted on the wiki page and attach it there.
> >
> > thank= s
> > david jencks
> >
> >
> > >
&= gt; > > Olivier
> >
> >
>
>
>
= > --
> Olivier & Cidiane Voutat
> Rua Praia de Muri=FA, = 9188
> Cep 59092-390 / Natal - RN
> Tel: (84) 3219-0427 Cel: (84) 9= 977-3917



--
Olivier & Cidiane Voutat
Rua Praia de Muri=FA, 9188
Cep 59092-390 / Natal - RN
Tel: (84) 3219-0427 Cel: (84) 9977-3917



-- <= div>
Olivier & Cidiane= Voutat
Rua Praia de Muri=FA, 9188
Cep 59092-390 / Natal - RN
Tel:= (84) 3219-0427 Cel: (84) 9977-3917


--
Olivier &a= mp; Cidiane Voutat
Rua Praia de Muri=FA, 9188
Cep 59092-390 / Natal -= RN
Tel: (84) 3219-0427 Cel: (84) 9977-3917 ------=_Part_8203_14895509.1140289713479--