Ok, I will do that first :-)
Thanks again for your time. bye Michael ----- Original Message ----- From: "David Jencks" <[EMAIL PROTECTED]> To: "Michael Delamere" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:45 AM Subject: Re: [JBoss-user] jboss3.0 + mysql > This mostly looks ok, but that does not mean I didn't miss something > obvious;-) > > I haven't seen the > <default-resource-principal> > > <name>petstore</name> > > <password>sh0pp1ng</password> > > </default-resource-principal> > > > element before and don't know what it is supposed to do, and whether the > container or the app is supposed to use it. AFAIK (and I could be wrong) > it is ignored by jboss. > > I strongly suggest you write a simple cmp bean and bmp bean and make sure > they are working properly before tackling the petstore. AFAIK noone has > run it on jboss 3 yet. > > david jencks > > > On 2002.05.01 19:33:51 -0400 Michael Delamere wrote: > > David, > > > > Thanks very much for your time. > > > > I think that´s me setup with mysql then, as I´m not receiving anymore > > errors. > > > > My only problem is that I´m still not able to connect to a database. Is > > this more likely to be because my > > xml-files contained in my ear-file are wrong? > > > > I´m actually trying to get the petstore working. I´ve added the > > jboss-patch, made the necessary db changes, which I think are correct, > > and > > rebuilt it. However I keep on getting the error that it cannot connect > > (on > > the webpage). > > > > ===== jboss-web.xml ===== > > <jboss-web> > > <resource-ref> > > <res-ref-name>jdbc/EstoreDataSource</res-ref-name> > > <res-type>javax.sql.DataSource</res-type> > > <jndi-name>java:/MySqlDS</jndi-name> > > </resource-ref> > > [...] > > > > ===== estore_ejbruntime.xml ===== > > <enterprise-beans> > > <ejb> > > <ejb-name>TheOrder</ejb-name> > > <jndi-name>estore/order</jndi-name> > > <resource-ref> > > <res-ref-name>jdbc/EstoreDataSource</res-ref-name> > > <jndi-name>jdbc/MySqlDS</jndi-name> > > <default-resource-principal> > > <name>petstore</name> > > <password>sh0pp1ng</password> > > </default-resource-principal> > > </resource-ref> > > <ejb-ref> > > <ejb-ref-name>ejb/account/Account</ejb-ref-name> > > <jndi-name>estore/account</jndi-name> > > </ejb-ref> > > </ejb> > > [...] > > > > I don´t want to waste you time much further, but could you just have a > > look > > if my xml files are correct. I´m not sure if there is something wrong > > with > > the server or if it has something to do with my xml-configuration in my > > ear > > files. > > > > Thanks very much > > > > Michael > > > > > > > > ----- Original Message ----- > > From: "David Jencks" <[EMAIL PROTECTED]> > > To: "Michael Delamere" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Thursday, May 02, 2002 1:25 AM > > Subject: Re: [JBoss-user] jboss3.0 + mysql > > > > > > > The warning is totally irrelevant here and probably everywhere and > > probably > > > should be removed...I'll think about whether it ever has any use. > > > > > > thanks > > > > > > david jencks > > > > > > On 2002.05.01 19:17:06 -0400 Michael Delamere wrote: > > > > Hi, > > > > > > > > Thanks for your help, > > > > > > > > Just one more question: > > > > > > > > Does your answer also include the warning: > > > > > > -------------------------------------------------------------------------- > > -- > > > > ------- > > > > 2002-05-02 00:29:13,936 WARN [org.jboss.system.ServiceController] > > > > jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any > > Service > > > > methods > > > > > > -------------------------------------------------------------------------- > > -- > > > > -------- > > > > > > > > What does the above mean? > > > > > > > > Thanks, I appreciate your help. > > > > > > > > bye Michael > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > From: "David Jencks" <[EMAIL PROTECTED]> > > > > To: "Michael Delamere" <[EMAIL PROTECTED]> > > > > Cc: "David Jencks" <[EMAIL PROTECTED]>; > > > > <[EMAIL PROTECTED]> > > > > Sent: Thursday, May 02, 2002 1:11 AM > > > > Subject: Re: [JBoss-user] jboss3.0 + mysql > > > > > > > > > > > > > I believe you have the most recent config file but not the most > > recent > > > > > jboss_3_0. I added the attribute it is complaining about this > > morning > > > > or > > > > > yesterday. You can probably just remove that attribute if you > > don't > > > > want > > > > > to update jboss just yet, although there have been several other > > config > > > > > file changes recently. > > > > > > > > > > david jencks > > > > > > > > > > On 2002.05.01 18:35:03 -0400 Michael Delamere wrote: > > > > > > Hi, > > > > > > > > > > > > Thanks. I had a look at the posts you suggested (and many more) > > and > > > > I > > > > > > think > > > > > > I´m getting there.... > > > > > > > > > > > > I´m now getting the following errors: > > > > > > > > > > > > =========================================================== > > > > > > org.jboss.deployment.DeploymentException: Exception setting > > attribute > > > > > > javax.management.Attribute@1ae90c on mbean > > > > > > jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable is: > > > > > > javax.management.AttributeNotFoundException: Writable attribute > > > > > > 'JaasSecurityManagerService' not found > > > > > > javax.management.AttributeNotFoundException: Writable attribute > > > > > > 'JaasSecurityManagerService' not found > > > > > > at > > > > > > > > > > > > org.jboss.mx.capability.ReflectedMBeanDispatcher.setAttribute(ReflectedMBean > > > > > > Dispatcher.java:190) > > > > > > at > > > > > > > > > > > > org.jboss.mx.server.MBeanServerImpl.setAttribute(MBeanServerImpl.java:446) > > > > > > at > > > > > > > > > > > > org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4 > > > > > > 89) > > > > > > at > > > > > > > > > > > > org.jboss.system.ServiceConfigurator.configure(ServiceConfigurator.java:391) > > > > > > at > > > > > > > > > > > > org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.jav > > > > > > a:202) > > > > > > at > > > > > > > > > > > > org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:149) > > > > > > at > > > > org.jboss.system.ServiceController.install(ServiceController.java:193) > > > > > > at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) > > > > > > at > > > > > > > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl > > > > > > .java:25) > > > > > > at java.lang.reflect.Method.invoke(Method.java:324) > > > > > > at > > > > > > > > > > > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat > > > > > > cher.java:284) > > > > > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:492) > > > > > > at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174) > > > > > > at $Proxy3.install(Unknown Source) > > > > > > at org.jboss.deployment.SARDeployer.create(SARDeployer.java:244) > > > > > > at org.jboss.deployment.MainDeployer.create(MainDeployer.java:62 > > > > > > > > > > > > [..] > > > > > > > > > > > > 2002-05-02 00:29:13,936 WARN > > [org.jboss.system.ServiceController] > > > > > > jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any > > > > Service > > > > > > methods > > > > > > > > > > > > ==================================================================== > > > > > > > > > > > > I would really appreciate any help given. Thanks very much, > > > > > > > > > > > > Michael > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "David Jencks" <[EMAIL PROTECTED]> > > > > > > To: "Michael Delamere" <[EMAIL PROTECTED]> > > > > > > Cc: <[EMAIL PROTECTED]> > > > > > > Sent: Wednesday, May 01, 2002 11:04 PM > > > > > > Subject: Re: [JBoss-user] jboss3.0 + mysql > > > > > > > > > > > > > > > > > > > Please look at the forum FAW "Help! My Datasource isn't > > working!" > > > > and > > > > > > the > > > > > > > posts in the jca forum. You have the wrong example config > > file. > > > > > > > > > > > > > > david jencks > > > > > > > > > > > > > > On 2002.05.01 16:27:39 -0400 Michael Delamere wrote: > > > > > > > > Hi, > > > > > > > > > > > > > > > > I´m having problems getting mysql configured. I´ve tried > > several > > > > > > > > examples > > > > > > > > but I don´t seem to be able to get it to work. > > > > > > > > > > > > > > > > I get the following error message at start up: > > > > > > > > > > > > > > > > 2002-05-01 22:14:24,607 DEBUG > > [org.jboss.deployment.MainDeployer] > > > > > > found > > > > > > 0 > > > > > > > > subpackages of > > > > > > > > > > > > file:/usr/local/java/jboss3.0/server/default/deploy/mysql-service.xml > > > > > > > > 2002-05-01 22:14:24,608 DEBUG > > [org.jboss.deployment.MainDeployer] > > > > > > > > Watching > > > > > > > > new file: > > > > > > > > > > > > file:/usr/local/java/jboss3.0/server/default/deploy/mysql-service.xml > > > > > > > > 2002-05-01 22:14:24,608 DEBUG > > [org.jboss.deployment.MainDeployer] > > > > > > create > > > > > > > > step for deployment > > > > > > > > > > > > file:/usr/local/java/jboss3.0/server/default/deploy/mysql-service.xml > > > > > > > > 2002-05-01 22:14:24,608 DEBUG > > [org.jboss.deployment.SARDeployer] > > > > > > > > Deploying > > > > > > > > SAR, create step: url > > > > > > > > > > > > file:/usr/local/java/jboss3.0/server/default/deploy/mysql-service.xml > > > > > > > > 2002-05-01 22:14:24,609 DEBUG > > [org.jboss.system.ServiceCreator] > > > > About > > > > > > to > > > > > > > > create bean: > > jboss.jca:service=ConnectionFactoryLoader,name=MysqlDS > > > > > > > > 2002-05-01 22:14:24,609 DEBUG > > [org.jboss.system.ServiceCreator] > > > > code: > > > > > > > > org.jboss.resource.ConnectionFactoryLoader > > > > > > > > ============ ERROR =========================================== > > > > > > > > 2002-05-01 22:14:25,026 DEBUG > > [org.jboss.system.ServiceCreator] > > > > Class > > > > > > not > > > > > > > > found for mbean: > > > > jboss.jca:service=ConnectionFactoryLoader,name=MysqlDS > > > > > > > > ============================================================== > > > > > > > > > > > > > > > > I have taken the following steps: > > > > > > > > > > > > > > > > - downloaded mysql driver and copied it to "jboss3.0/lib" > > > > > > > > > > > > > > > > - changed the jaws.xml and the standardjbosscmp-jdbc.xml > > > > > > > > > > > > > > > > - created a mysql-service.xml and inserted it into the > > deploy > > > > > > directory > > > > > > > > > > > > > > > > Any help would be very much appreciated. > > > > > > > > > > > > > > > > Michael > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________________________ > > > > > > > > > > > > > > > > Have big pipes? SourceForge.net is looking for download > > mirrors. > > > > We > > > > > > > > supply > > > > > > > > the hardware. You get the recognition. Email Us: > > > > > > > > [EMAIL PROTECTED] > > > > > > > > _______________________________________________ > > > > > > > > JBoss-user mailing list > > > > > > > > [EMAIL PROTECTED] > > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________________________ > > > > > > > > > > > > > > Have big pipes? SourceForge.net is looking for download > > mirrors. > > We > > > > > > supply > > > > > > > the hardware. You get the recognition. Email Us: > > > > > > [EMAIL PROTECTED] > > > > > > > _______________________________________________ > > > > > > > JBoss-user mailing list > > > > > > > [EMAIL PROTECTED] > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user