• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

NameNotFoundException: MSAccessDS not bound

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Author
Posts: 367
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
If I had asked people what they wanted, they would have said faster horses - Ford. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic