Thanks for the update. I'm looking forward to what else you find out. btw your replies are now threaded in my mail client, thanks
david jencks On 2002.09.02 19:12:45 -0400 Jamie Burns wrote: > I checked out Igor's fix as you suggested and got past the compile > problem. > > I've spent the last couple of days working out why my EAR that worked on > JBoss 3 didnt work on JBoss 4. In JBoss 3.0, l removed the > hsqldb-service.xml because l was using SQL Server and l wanted to use > DefaultDS as my JNDI name. JBoss 4 wasnt happy with this. Ive had to keep > hsqldb-ds.xml and change the JNDI name for my SQL Server DS to MSSQLDS. > > What is hsqldb-ds.xml being used for and if its DS is needed to make > JBoss > work, why cant its DS be called something like JBossDS? > > I found that the tags, > > <user-name>...</user-name> > <password>...</password> > > in mssql-xa-ds.xml dont provide username and password information to the > connection. I got a login failure when l used these. I removed these tags > and added > > <xa-datasource-property name="User">sa</xa-datasource-property> > <xa-datasource-property name="Password">secret</xa-datasource-property> > > At this stage l believe they have fixed the login failure. > > I tested the wrapper with a transaction that inserts records into two > tables > with two BMP beans - which works when l use it on JBoss 3.0. The > transaction > ended up timing out. I checked the SQL Server manager and it indicated > that > two processes were blocking - lm assuming these were the two inserts. > I'll > do some simpler tests over the next couple of days to give you a better > idea > of how the wrapper is behaving. > > Hope this is helpful > > Jamie Burns > > (Sorry about the mail threads. When l post a message or reply to a > message > the list server stops sending replies back to the email address l used. > Ive > had to set up a second account so that l can see the replies to my > postings. > I was trying to find a way of making it think that my posts were coming > from > the one email address but its obvious thats not working - sorry for the > mess.) > > ----- Original Message ----- > From: "David Jencks" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, August 31, 2002 1:27 AM > Subject: Re: [JBoss-dev] XADataSource wrapper for JBoss 4 > > > > I think Igor fixed this in cvs yesterday, have you updated? For some > > reason your message is not showing as a response to anything in my mail > > viewer so I can't tell what the context of your post is. > > > > david jencks > > > > On 2002.08.30 18:16:53 -0400 Jamie Burns wrote: > > > FW: [JBoss-dev] XADataSource wrapper for JBoss 4Thanks Igor. > > > > > > Ive made the change you suggested. The transformed xml looks more > > > familiar. > > > > > > When mssql-xa-ds.xml was deployed, l got the following error in the > log > > > > > > java.lang.IllegalArgumentException: The class 'class > > > org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory' has no > > > setter for config property 'XADataSourceClass' > > > at > org.jboss.resource.connectionmanager.RARDeployment.setManagedConnectionFacto > ryAttribute(RARDeployment.java:567) > > > at > org.jboss.resource.connectionmanager.RARDeployment.setMcfProperties(RARDeplo > yment.java:670) > > > at > org.jboss.resource.connectionmanager.RARDeployment.startService(RARDeploymen > t.java:525) > > > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196) > > > > > > I had a look at XAManagedConnectionFactory and > DataSourceTemplate.xml. > > > The problem just appears to be a difference in case. > > > XAManagedConnectionFactory has setXaDataSourceClass() and > > > DataSourceTemplate creates a property XADataSourceClass. It looks > like > > > you are capitalising "XA". Should XAManagedConnectionFactory be > changed > > > to setXADataSourceClass() or should DataSourceTemplate create a > property > > > XaDataSourceClass? > > > > > > I've copied jboss-all\build\output to working location on my disk. I > can > > > only find DataSourceTemplate.xsl in > > jboss-all\connector\output\resources\stylesheet. > > > IF l wanted to change DataSourceTemplate to create a property > > > XaDataSourceClass - quicker fix than rebuilding - where do l change > this? > > > > > > How does the change you suggested to mssql-xa-ds.xml get made in the > CVS? > > > > > > Thanks > > > > > > > > > > > > > > > In mssql-xa-ds.xml try to replace "xa-tx-datasource" with > > > "xa-datasource". Internally -ds.xml files are transformed into > > > -service.xml using xslt template defined in > > > connector/src/resource/stylesheets/DataSourceTemplate.xsl. You can > look > > > > > > into this file to see if it does what you need. Also check > logs/console > > > > > > output for exception messages. > > > > > > Jamie Burns wrote: > > > > Thanks Igor. > > > > > > > > Since you have got further than me, can l compare your setup with > > > > mine? > > > > > > > > I am working in jboss-4.0.0alpha\server\default. > > > > > > > > I have the 3 MS SQL Server 2000 jars in ..\lib. > > > > > > > > Ive taken hsqldb-ds.xml out of .\deploy so that l have only one > > > > DataSource and so that l can use DefaultDS as the jndi name for > my > > > MSSQL > > > > DataSource. > > > > > > > > Ive copied mssql-xa-ds.xml from the examples folder and > configured > it > > > > > > > for my site. I used to use mssql-xa-service.xml in JBoss 3.0. It > had > > > a > > > > lot more in it than mssql-xa-ds.xml. Do l still need to the stuff > > > that > > > > was in mssql-xa-service.xml? I dont have mssql-xa-service.xml > > > installed > > > > anywhere. > > > > > > > > Ive added a <application-policy name = "MSSQLDbRealm"> to > > > > .\conf\login-config.xml because l had that in the JBoss 3. But l > dont > > > > > > > think l ever used it in JBoss 3. > > > > > > > > Is there anything l need to do/undo re setting things up for the > new > > > > XADataSource wrappers? > > > > > > > > Thanks again. > > > > > > > > > > > > > > > > > > > > -- > > > Igor Fedorenko > > > Think smart. Think automated. Think Dynamics. www.thinkdynamics.com > > > > > > > > > > > > > > > ------------------------------------------------------- > > > This sf.net email is sponsored by:ThinkGeek > > > Welcome to geek heaven. > > > http://thinkgeek.com/sf > _______________________________________________ > > > > > > Jboss-development mailing list Jboss-development@lists= > > > > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > > > <HTML><HEAD><TITLE>FW: [JBoss-dev] XADataSource wrapper for JBoss > > > 4</TITLE> > > > <META http-equiv=Content-Type content="text/html; > charset=iso-8859-1"> > > > <META content="MSHTML 6.00.2600.0" name=GENERATOR> > > > <STYLE></STYLE> > > > </HEAD> > > > <BODY bgColor=#ffffff> > > > <DIV><FONT size=2><FONT face=Arial>Thanks Igor.</FONT></FONT></DIV> > > > <DIV><FONT size=2><FONT face=Arial></FONT></FONT> </DIV> > > > <DIV><FONT size=2><FONT face=Arial>Ive made the change you suggested. > The > > > > > > transformed xml looks more familiar.</FONT></FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>When mssql-xa-ds.xml was deployed, l got > the > > > > > > following error in the log</FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT><FONT size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>java.lang.IllegalArgumentException: The > > > class > > > 'class org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory' > has > > > no > > > setter for config property 'XADataSourceClass'<BR> at > > > > org.jboss.resource.connectionmanager.RARDeployment.setManagedConnectionFacto > ryAttribute(RARDeployment.java:567)<BR> at > > > > > > > org.jboss.resource.connectionmanager.RARDeployment.setMcfProperties(RARDeplo > yment.java:670)<BR> at > > > > > > > org.jboss.resource.connectionmanager.RARDeployment.startService(RARDeploymen > t.java:525)<BR> at > > > > > > > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)</FO > NT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>I had a look at > XAManagedConnectionFactory > > > and > > > DataSourceTemplate.xml. The problem just appears to be a difference > in > > > case. > > > XAManagedConnectionFactory has setXaDataSourceClass() and > > > DataSourceTemplate > > > creates a property XADataSourceClass. It looks like you are > capitalising > > > "XA". > > > Should XAManagedConnectionFactory be changed to > setXADataSourceClass() > or > > > should > > > DataSourceTemplate create a property XaDataSourceClass?</FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>I've copied jboss-all\build\output to > > > working > > > location on my disk. I can only find DataSourceTemplate.xsl in > > > jboss-all\connector\output\resources\stylesheet. IF l wanted to > change > > > DataSourceTemplate to create a property XaDataSourceClass - quicker > fix > > > than > > > rebuilding - where do l change this?</FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>How does the change you suggested to > > > mssql-xa-ds.xml get made in the CVS?</FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>Thanks</DIV> > > > <DIV><BR></DIV></FONT> > > > <DIV><BR></DIV> > > > <BLOCKQUOTE dir=ltr > > > style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; > > > BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> > > > <P><FONT size=2>In mssql-xa-ds.xml try to replace > "xa-tx-datasource" > > > with > > > </FONT><BR><FONT size=2>"xa-datasource". Internally -ds.xml files > are > > > transformed into </FONT><BR><FONT size=2>-service.xml using xslt > > > template > > > defined in </FONT><BR><FONT > > > size=2>connector/src/resource/stylesheets/DataSourceTemplate.xsl. > You > > > can look > > > </FONT><BR><FONT size=2>into this file to see if it does what you > need. > > > Also > > > check logs/console </FONT><BR><FONT size=2>output for exception > > > messages.</FONT> </P> > > > <P><FONT size=2>Jamie Burns wrote:</FONT> <BR><FONT size=2>> > Thanks > > > Igor.</FONT> <BR><FONT size=2>> </FONT><BR><FONT > size=2>> > > > Since > > > you have got further than me, can l compare your setup with > > > </FONT><BR><FONT > > > size=2>> mine?</FONT> <BR><FONT size=2>> > </FONT><BR><FONT > > > size=2>> I am working in jboss-4.0.0alpha\server\default.</FONT> > > > <BR><FONT > > > size=2>> </FONT><BR><FONT size=2>> I have the 3 MS SQL > > > Server 2000 > > > jars in ..\lib.</FONT> <BR><FONT size=2>> </FONT><BR><FONT > > > size=2>> Ive taken hsqldb-ds.xml out of .\deploy so that l have > only > > > > > > one</FONT> <BR><FONT size=2>> DataSource and so that l can use > > > DefaultDS as > > > the jndi name for my MSSQL </FONT><BR><FONT size=2>> > > > DataSource.</FONT> > > > <BR><FONT size=2>> </FONT><BR><FONT size=2>> Ive copied > > > mssql-xa-ds.xml from the examples folder and configured it</FONT> > > > <BR><FONT > > > size=2>> for my site. I used to use mssql-xa-service.xml in > JBoss > > > 3.0. It > > > had a </FONT><BR><FONT size=2>> lot more in it than > mssql-xa-ds.xml. > > > Do l > > > still need to the stuff that </FONT><BR><FONT size=2>> was in > > > mssql-xa-service.xml? I dont have mssql-xa-service.xml installed > > > </FONT><BR><FONT size=2>> anywhere.</FONT> <BR><FONT > > > size=2>> > > > </FONT><BR><FONT size=2>> Ive added a <application-policy > name = > > > "MSSQLDbRealm"> to</FONT> <BR><FONT size=2>> > > > .\conf\login-config.xml > > > because l had that in the JBoss 3. But l dont </FONT><BR><FONT > > > size=2>> > > > think l ever used it in JBoss 3.</FONT> <BR><FONT size=2>> > > > </FONT><BR><FONT size=2>> Is there anything l need to do/undo re > > > setting > > > things up for the new</FONT> <BR><FONT size=2>> XADataSource > > > wrappers?</FONT> <BR><FONT size=2>> </FONT><BR><FONT > > > size=2>> > > > Thanks again.</FONT> <BR><FONT size=2>> </FONT><BR><FONT > > > size=2>> </FONT></P><BR> > > > <P><FONT size=2>-- </FONT><BR><FONT size=2>Igor Fedorenko</FONT> > > > <BR><FONT > > > size=2>Think smart. Think automated. Think Dynamics. > > > www.thinkdynamics.com</FONT> </P><BR><BR> > > > <P><FONT > size=2>-------------------------------------------------------</FONT> > > > > > > <BR><FONT size=2>This sf.net email is sponsored by:ThinkGeek</FONT> > > > <BR><FONT > > > size=2>Welcome to geek heaven.</FONT> <BR><FONT size=2><A > > > href="http://thinkgeek.com/sf" > target=_blank>http://thinkgeek.com/sf</A> > > > > > > _______________________________________________</FONT> <BR><FONT > > > size=2>Jboss-development mailing list > > > Jboss-development@lists=</FONT></P></BLOCKQUOTE></BODY></HTML> > > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by: OSDN - Tired of that same old > > cell phone? Get a new here for FREE! > > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > > _______________________________________________ > > Jboss-development mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-development > > > > > ------------------------------------------------------- > This sf.net email is sponsored by: OSDN - Tired of that same old > cell phone? Get a new here for FREE! > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > > ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
