I'm glad to see you got this working. I think you should be able to use a -ds.xml for the modified .rar if you use the tx-connection-factory format rather than the datasource format, since you will be able to specify which ra.xml you want via the adapter-display-name element.
david jencks On 2003.07.02 07:04 Keysers Wonne wrote: > 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 Division > > Prins 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 > > > ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
