• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

VAJava EJB reading MS Access

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm attempting to create and test an EJB that reads an MS Access database. The EJB test client loads fine and I'm able to enter my key. When invoking the request it terminates with:

"java.rmi.ServerException: RemoteException occurred in server thread; nested exception is: com.ibm.ejs.persistence.EJSPersistenceException: getPStmt failed; nested exception is: java.sql.SQLException: [Microsoft]{ODBC Microsoft Access Driver]Option feature not implemented"

From what I can make of it, I'm missing an ODBC driver, but I can't figure out where to get the uninstalled feature and most likely even when (or if) I do, how to install it.

Any help?
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
u need to use sun.jdbc.odbc.Drivers ..when u run EJB Server..Right click that server u will get properties....go to that and your drivers over there...u don't have to install any drivers for MS access...its only with Oracle u need client to install on your machine.....
Need any more help
let me know
Deepak
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic