Look, you gotta take it step by step. First thing, have you looked into the server.log to confirm that mysql-service.xml was actually deployed without errors.
Second, if above is true, have you browsed <machine name>:8082 and verified that the data service is there, presumably under jboss.jca Thirdly, if the above is true, can you see the data service in the JndiView list? I use Cloudscape and I had a hard time getting it going and I found that the only reason I had a hard time getting it to go was because all along the way I had made itty bitty typing errors in the various xml files. So, the moral of the story is to slow down, and take it step by step. Paul Sabadin wrote: > Unfortunately I have no help for you here except to say that I am having > EXACTLY the same problem - it is not you, it is the newness of the software > (3.0) and the lack of documentation. > Can somebody help us out here (ehemmm... Dain). They keep saying that the > new docs will be here (yesterday) but they are still vapor docs. It is > obvious that they will sell you docs from their web site (appears to be all > that the web site is for) but I am unsure of when these will come and for > how long they will be good (hours? Days?). > > In the meantime, Note the diff between the very last <mbean> element in > <JBOSSHOME>/hsqldb-service.xml (default shipped) and the > .../docs/examples/jca/mysql-service.xml (this last element does not appear > in the latter file). If it is commented out of the working > hsqldb-service.xml file we get the same error (excep that the unbound jndi > name is DeffaultDS). Where is the DTD or schema for this doc showing an > mbean attlist with "code" attribute? ... > > Hunt around with this and see if we come up with anything. I have to take my > kids to an appt. > > I am thinking of simply going back to writing a full CORBA-based custom app > server as I did in 1997. Right now it seems easier than waiting on bated > breath for these document marketers. > > Obviously I'm a bit miffed and probably don't see some obvious stuff but I > will be glad to get yelled at if I can get my code going or know to abandon > JBoss. > > Paul > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, June 11, 2002 1:56 PM > > To: sourceforge > > Subject: [JBoss-user] Jboss3.0 - mysql "not bound" error > > > > Hello: > > > > I'm attempted to get Jboss3.0 working with a mysql database and I'm > > getting these errors: > > > > Error: "can't find data source: java:/mySqlDB;" > > or > > "mySqlDB not bound" > > > > > > > > This is what I've put in my various files: > > > > ________________________________________ > > > > jaws.xml (part of my ejb): > > > > <datasource>java:/mySqlDB</datasource> > > <type-mapping>mySQL</type-mapping> > > > > ___________________________ > > > > > > standardjbosscmp-jdbc.xml: > > > > <defaults> > > <datasource>java:/mySqlDB</datasource> > > <datasource-mapping>mySQL</datasource-mapping> > > > > <create-table>true</create-table> > > <remove-table>false</remove-table> > > <read-only>false</read-only> > > <time-out>300</time-out> > > <pk-constraint>true</pk-constraint> > > <fk-constraint>false</fk-constraint> > > <row-locking>false</row-locking> > > <preferred-relation-mapping>foreign-key</preferred-relation-mapping> > > <read-ahead> > > <strategy>on-load</strategy> > > <page-size>1000</page-size> > > <eager-load-group>*</eager-load-group> > > </read-ahead> > > <list-cache-max>1000</list-cache-max> > > </defaults> > > > > _________________________________ > > > > And I've put the mysql-service.xml file, found in the /docs/examples/jca > > directory and put it in the /server/default/deploy directory. I only > > changed a few section of this file...I changed the JndiName = "mySqlDB" > > instead of "MySqlDS" (so it matches my entries in the jaws.xml and > > standardbosscmp-jdbc.xml files), I commented out this line: <attribute > > name="SecurityDomainJndiName">MySqlDbRealm</attribute> and I added my url > > and username and password info. > > > > __________________________________ > > > > Awhile ago, I got the same mysql database working with Jboss2.4.3, so the > > database is fine, etc. > > > > Is there anything that I'm missing or am I editing the mysql-service.xml > > file wrong? Should the > > > > Thanks alot! > > > > Coral Burns > > > > *********************************** > > Coral Burns > > CRITICAL MASS > > Application Development > > [EMAIL PROTECTED] > > t: 403 262 3006 > > f: 403 262 7185 > > www.criticalmass.com > > > > ------------------------------------------------------------------------ > Name: winmail.dat > winmail.dat Type: application/x-unknown-content-type-dat_auto_file > Encoding: base64 -- Greg Turner Tiburon Enterprise Systems http://www.tiburon-e-systems.com Box 1171 Tiburon, CA 94920 415-332-3363 _______________________________________________________________ Multimillion Dollar Computer Inventory Live Webcast Auctions Thru Aug. 2002 - http://www.cowanalexander.com/calendar _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
