This week's book giveaway is in the Java in General forum.
We're giving away four copies of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 and have ishori Sharan & Adam L Davis on-line!
See this thread for details.
Win a copy of Beginning Java 17 Fundamentals: Object-Oriented Programming in Java 17 this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

java.lang.IllegalStateException: jboss.jca:name=MySQLDS,service=ManagedConnectionFactory is already

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi everyone,
I have a big big problem. When i deploy my ear project composed by a dynamin web project and an ejb project in jboss i have this error:
i'm sure that i have only one mysql-ds.xml under meta inf and i deleted the mysql-ds.xml of jboss_home/server/default/deploy:
i need your help, pleaaaaaaaase

 
abir jelassi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Voilà mon mysql-ds.xml



Does anyone have a solution??
 
abir jelassi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I don't have errors anymore following this forum
but, can't see the execution of my application
Thanks anyway
 
Sheriff
Posts: 10445
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Where is that -ds.xml located? And do you have more than one such file somewhere within your application?
 
abir jelassi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
mysql-ds.xml is under meta inf of the ejb project with persistence.xml,orm.xml, ejb-jar.xml and beans.xml
thanks for your reply
 
Greenhorn
Posts: 26
Eclipse IDE Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Abir,

The issue is due to a conflict with already existing JNDI MySQLDS. You can try one of the following

1. Remove your application .ear file and start JBOSS as such. Now check in the admin console under datasources link if you already have one with the given JNDI name.
Two things could be possible
a. If you have a datasource with the JNDI name as MySQLDS, then there is a -ds.xml in your deploy folder with the same JNDI name. All you could do is a search for the word "MySQLDS" in your folder search/file search of the folder.
b. If there are no data sources listed then it must be inside of your .ear file.

2. Change the JNDI name ( Probably not the right way to do but would work).

Please note that there are few other ds.xml files even inside the folders of the deploy folder. For instance there is a folder called jbossesb.esb under the deploy folder which has a message-store-ds.xml which also creates a JNDI binding of the data source.

Just a word of advice, do not manually edit the ds.xml file for your server configuration even while changing the DB from HSQLDB. Run the ant script available in /jboss-as/tools/schema. Its is scripted beautifully and is very user-friendly.


Thanks and regards
Raghav.V



 
WHAT is your favorite color? Blue, no yellow, ahhhhhhh! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic