Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
    Bookmark Topic Watch 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown
  • Mark post as helpful
  • send pies
  • Report post to moderator
I'm on Unix/Linux and don't have ODBC. Now what?

Check out unixODBC

How can I create a dynamic DSN?

Dynamic DSN's are created with connection strings that contain information about the driver to use as well as where to find the source data.

Here is an example of a dynamic DSN for Access

for 32-bit Java:


for 64-bit Java:


Here is an example of a dynamic DSN for SQL-Server



Please note the above is given as a further example but for SQL-Server you should really use one of the freely available type-4 drivers.

Can I use the Bridge Driver in an applet?

No. All things are possible in some way but in this particular case it is difficult, and unwieldy enough to render it highly impractical. Amongst the problems:


You can use other drivers (types 3 and 4 preferred) to connect your applet to a database except for Access. Access is a desktop database product and it can only work with commercial type 4 JDBC driver at http://www.hxtt.com/access.html for Applet.

How can I use Hibernate with Access?

Hibernate doesn't support Access out of the box, but you can use HXTT's Hibernate dialect.

The HXTT driver (linked above) supports Hibernate 3.

If you're serious enough about databases to use ORM, you should probably consider using some other database.



JdbcFaq
 
I was born with webbed fish toes. This tiny ad is my only friend:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic