Thanks for the hints, I got it working like this:
The latest (and default) Oracle JDBC-driver is still located in the server lib folder
(available for all applications) and also jboss-common-jdbc-wrapper.jar and
jboss-[local/xa]-jdbc.rar remain untouched.
The "old" JDBC-driver and a copy of jboss-common-jdbc-wrapper.jar is included in a
'custom' .rar inside the scoped .ear. This results in following RARDeployment:
jboss.jca:service=RARDeployment,name=MyCustomResourceAdapter. The jboss-service.xml in
the .sar configures the actual datasource, using this custom resource adapter. (It
doesn't work with a -ds.xml, since this would use the default one!)
.ear
|- ...
|- .sar
|-META-INF/jboss-service.xml
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
...>
<depends>
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" ...>
<depends>
<mbean
code="org.jboss.resource.connectionmanager.RARDeployment" ...>
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,name=MyCustomResourceAdapter
</depends>
...
|- .rar
|- classes12.jar
|- jboss-common-jdbc-wrapper.jar
|- META-INF/ra.xml
Thanks again
Wonne
REAL SOFTWARE GROUP
Industry DivisionPrins Boudewijnlaan 26 B-2550 KONTICH http://www.realsoftware.be <http://www.realsoftware.be> This e-mail may contain information which is privileged or confidential. If you received this e-mail in error, please notify us immediately by e-mail or telephone and delete the e-mail without reading, copying or disclosing its contents to any other person. -----Original Message----- From: David Jencks [mailto:[EMAIL PROTECTED] Sent: Fri 6/27/2003 14:11 To: [EMAIL PROTECTED] Cc: Subject: RE: [JBoss-user] RE: Deploy DataSources with different versions of JDBC driver You would need to include jboss-common-jdbc-wrapper.jar jboss-[local/xa]-jdbc.rar in each ear, and remove them from the lib and deploy dirs. (Of course, include the driver itself also) Be sure to scope every ear. This much should solve the jboss classloading problems. With local tx (non-xa driver) there is a good chance the DriverManager implementation will prevent this from working. I think there is a better chance of it working with xa drivers. If you try this please let us know how it works. thanks david jencks On 2003.06.27 02:52 Keysers Wonne wrote: > And there is no other sollution? > Isn't it posssible to deploy an ear-private resource adapter, > specifically configured for this DataSource? > > It would be a pity if I had to include the old jdk 1.3 Oracle drivers in > the server lib folder, only for 1 application using an old database > version... > > > Wonne > > -----Original Message----- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: Thu 6/26/2003 17:19 > To: [EMAIL PROTECTED] > Cc: > Subject: [JBoss-user] RE: Deploy DataSources with different > versions of JDBC driver > > > > I don't think this is possible unless you deploy > a copy of jboss jca and the resource adaptor with > the driver. > I haven't tried this myself. > > There are some fundamental brain deaths in java.sql.DriverManager > where it implements driver accessiblity based on the caller's > classloader. > It is also caching classes somewhere, so hotdeployment > might not won't work at all. It doesn't in the non-scoped > environment. > > Regards, > Adrian > > xxxxxxxxxxxxxxxxxxxxxxxx > Adrian Brock > Director of Support > Back Office > JBoss Group, LLC > xxxxxxxxxxxxxxxxxxxxxxxx > > -----Original Message----- > From: Keysers Wonne [mailto:[EMAIL PROTECTED] > On > Behalf Of Keysers Wonne > Sent: 26 June 2003 15:31 > To: [EMAIL PROTECTED] > Subject: Deploy DataSources with different versions of JDBC > driver > > > Hi, > > On JBoss 3.2.x, is it possible to deploy 2 Oracle DataSources, > each one > using a different version of the JDBC driver? > If so, how? > Because, when I include the driver jar-file with the scoped .ear, > it > gives me a ClassCast Exception. > > I need this, because Oracle JDBC driver 9.x (JDK 1.4) crashes on > database version 8.0.x when using TimeStamps... (It's a known > problem.) > > Thanks in advance! > > Wonne > > REAL SOFTWARE GROUP > Industry Division > > Prins Boudewijnlaan 26 > B-2550 KONTICH > http://www.realsoftware.be > > This e-mail may contain information which is privileged or > confidential. > If you received this e-mail in error, please notify us > immediately by > e-mail or telephone and delete the e-mail without reading, > copying or > disclosing its contents to any other person. > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: INetU > Attention Web Developers & Consultants: Become An INetU Hosting > Partner. > Refer Dedicated Servers. We Manage Them. You Get 10% Monthly > Commission! > INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > > <META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1"> > <TITLE>[JBoss-user] RE: Deploy DataSources with different versions of > JDBC driver</TITLE> > </HEAD> > <BODY dir=ltr> > <DIV>And there is no other sollution?</DIV> > <DIV>Isn't it posssible to deploy an ear-private resource adapter, > specifically > configured for this DataSource? </DIV> > <DIV> </DIV> > <DIV>It would be a pity if I had to include the old jdk 1.3 Oracle > drivers > in the server lib folder, only for 1 application using an old database > version...</DIV> > <DIV> </DIV> > <DIV> </DIV> > <DIV>Wonne</DIV> > <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> > <DIV><FONT size=2>-----Original Message----- <BR><B>From:</B> Adrian > Brock > [mailto:[EMAIL PROTECTED] <BR><B>Sent:</B> Thu 6/26/2003 17:19 > <BR><B>To:</B> > [EMAIL PROTECTED] <BR><B>Cc:</B> <BR><B>Subject:</B> > [JBoss-user] RE: Deploy DataSources with different versions of JDBC > driver<BR><BR></FONT></DIV> > <P><FONT size=2>I don't think this is possible unless you deploy<BR>a > copy of > jboss jca and the resource adaptor with<BR>the driver.<BR>I haven't > tried this > myself.<BR><BR>There are some fundamental brain deaths in > java.sql.DriverManager<BR>where it implements driver accessiblity based > on the > caller's<BR>classloader.<BR>It is also caching classes somewhere, so > hotdeployment<BR>might not won't work at all. It doesn't in the > non-scoped > environment.<BR><BR>Regards,<BR>Adrian<BR><BR>xxxxxxxxxxxxxxxxxxxxxxxx<BR>Adrian > > Brock<BR>Director of Support<BR>Back Office<BR>JBoss Group, > LLC<BR>xxxxxxxxxxxxxxxxxxxxxxxx<BR> <BR>-----Original > Message-----<BR>From: Keysers Wonne [<A > href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>] > > On<BR>Behalf Of Keysers Wonne<BR>Sent: 26 June 2003 15:31<BR>To: > [EMAIL PROTECTED]<BR>Subject: Deploy DataSources with > different > versions of JDBC driver<BR><BR><BR>Hi,<BR><BR>On JBoss 3.2.x, is it > possible > to deploy 2 Oracle DataSources, each one<BR>using a different version > of the > JDBC driver?<BR>If so, how?<BR>Because, when I include the driver > jar-file > with the scoped .ear, it<BR>gives me a ClassCast Exception.<BR><BR>I > need > this, because Oracle JDBC driver 9.x (JDK 1.4) crashes on<BR>database > version > 8.0.x when using TimeStamps... (It's a known > problem.)<BR><BR>Thanks in > advance!<BR><BR>Wonne<BR><BR>REAL SOFTWARE GROUP<BR>Industry > Division<BR><BR>Prins Boudewijnlaan 26 <BR>B-2550 KONTICH<BR><A > href="http://www.realsoftware.be";>http://www.realsoftware.be</A><BR><BR>This > > e-mail may contain information which is privileged or > confidential.<BR>If you > received this e-mail in error, please notify us immediately > by<BR>e-mail or > telephone and delete the e-mail without reading, copying > or<BR>disclosing its > contents to any other > person.<BR><BR><BR><BR><BR><BR>-------------------------------------------------------<BR>This > > SF.Net email is sponsored by: INetU<BR>Attention Web Developers & > Consultants: Become An INetU Hosting Partner.<BR>Refer Dedicated > Servers. We > Manage Them. You Get 10% Monthly Commission!<BR>INetU Dedicated Managed > > Hosting <A > href="http://www.inetu.net/partner/index.php";>http://www.inetu.net/partner/index.php</A><BR>_______________________________________________<BR>JBoss-user > > mailing list<BR>[EMAIL PROTECTED]<BR><A > href="https://lists.sourceforge.net/lists/listinfo/jboss-user";>https://lists.sourceforge.net/lists/listinfo/jboss-user</A><BR></FONT></P></BLOCKQUOTE> > > </BODY> > </HTML> ------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
<<winmail.dat>>
