*
The moose likes JBoss/WildFly and the fly likes NameNotFoundException: MSAccessDS not bound Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "NameNotFoundException: MSAccessDS not bound" Watch "NameNotFoundException: MSAccessDS not bound" New topic
Author

NameNotFoundException: MSAccessDS not bound

Chirag Jakharia
Greenhorn

Joined: Dec 03, 2003
Posts: 23
I am facing an error
I am trying to configure Microsoft Access as DataSource
Therefore I copied msaccess-ds.xml to E:\jboss-3.2.3\server\default\deploy with some changes
I have made a DSN named CSO which points to cso.mdb in my Windows 2000 System
The Whole code is copied into
I am new to JBoss
Sp Please convey my shortcomings or if u need more information please convey it it me
msaccess-ds.xml



GreetingBean.java



ejb-jar.xml


jboss.xml


Greeting1.java



Error at Client Side



Error at Server Side i.e. in JBOSS Server

Thanks in advance
Jason Stull
Ranch Hand

Joined: Feb 02, 2004
Posts: 47
Because you are in the same JVM, You can use the parameterless constructor for InitialConext in your Session Bean to get a handle to the Access DB DataSource:

[ February 28, 2004: Message edited by: Jason Stull ]
[ February 28, 2004: Message edited by: Jason Stull ]

"I believe in coyotes and time as an abstract Explain the change the difference between What you want and what you need there's the key"
norman richards
Author
Ranch Hand

Joined: Jul 21, 2003
Posts: 367
You probably need to lookup java:/MSAccessDB, as that is probably where your datasource is bound. To be sure, check the JNDI view.
Chirag Jakharia
Greenhorn

Joined: Dec 03, 2003
Posts: 23
Still another error
When I looked at JMX Console
and saw the JNDI tree it is something like this


So I came to the conclusion that I have to use

Afterwards I tried what you suggested
After trying ur suggestion the same error came
But After trying the above line an extra line appeared in the error on the server side

OutPut at the Client Side

Thanks Norman that link was really usefool to make me understand the JBoss JNDI tree though i am not able to solve my problem
I mean i did not knew before this as I am new to JBOSS
Thanks in advance
Jason Stull
Ranch Hand

Joined: Feb 02, 2004
Posts: 47
Norman is quite right, should be context.lookup("java:/MSAccessDS"); Been using ServiceLocator for so long, I forgot. However, try removing resource refs from ejb-jar.xml and jboss.xml. They are not needed for what you are trying to do.
Chirag Jakharia
Greenhorn

Joined: Dec 03, 2003
Posts: 23
Yes I am successfull
I don't know how it worked
But today it shows no error
Thanks for the Help
It shows some error concerning the missing tables/queries When JBoss Server Starts
The Table names are JMS_MESSAGES and JMS_TRANSACTIONS
I created 2 tables after looking at the page
http://www.thecortex.net/clover/eg/jboss/report/org/jboss/mq/pm/jdbc2/PersistenceManager.html
The Query for 2 tables are

The problem is What DataType has to be chosen in Microsoft Access for MESSAGEBLOB. I have used OLE Object DataType in Access XP
Is it right
Thanks again
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: NameNotFoundException: MSAccessDS not bound
 
Similar Threads
Simple & Basic EJB application -- Help is needed
SAXParseException: The content of element type "enterprise-beans" is incomplete, it m
SAXParseException: The content of element type "enterprise-beans" is incomplete, it m
JBoss 4.2.2 Server Starting Issue
Unable to look home