File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NameNotFoundException: MSAccessDS not bound

 
Chirag Jakharia
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 47
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
norman richards
Author
Ranch Hand
Posts: 367
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 47
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic