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

VAJava EJB reading MS Access JDBC/ODBC

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I'm learning VAJava and new to Java in general. I'm using VAJ 3.5.3 on NT 4.0(SP6)and attempting to create and test an EJB that reads an MS Access database. My Access database was created using MS Office 2000. I have also tried to convert back to MS Access 97.
I have configured the ODBC source and tested the connection during the creation of the database schema.
All seems to be fine up to when I'm using the EJB test client. It loads fine and I'm able to enter my database key, but 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?
 
The only thing that kept the leeches off of me was this tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic