Forum Stats

  • 3,826,577 Users
  • 2,260,666 Discussions
  • 7,897,006 Comments

Discussions

No support for OLE DB in Java

2»

Comments

  • 843859
    843859 Member Posts: 35,905 Bronze Trophy
    If by "closed" you mean propreitary then in a word, "hosed".
    Well, that comes pretty close to summing it up. If I was in a pinch, I might look to third party vendors to help, but I honestly don't now if there is a practical solution:

    Here is the type of link that I thought may be interesting to you: http://openaccesssoftware.com/
  • 843859
    843859 Member Posts: 35,905 Bronze Trophy
    Free tool for using OLE DB from Java

    http://www.javakonkurs.ru/show_project.screen?project_id=191

    Retreive data from MS EXchange folders, Address books, Outlook mailboxes, Active Directory accounts e.t.c
  • 843859
    843859 Member Posts: 35,905 Bronze Trophy
    Re:
    Free tool for using OLE DB from Java
    http://www.javakonkurs.ru/show_project.screen?project_id=191
    Unfortunately, there's not too much non Russian support beyond google translate. English (or German, French, Spanish ;) would be nice.

    I have the same question/problem as fidge:
    There's a windows based system, providing access via their own oledb provider.
    This works fine in the windows world: (ADO, ADO.net, linked server in MS-SQLserver2000 or 2005, etc.).
    They do not have an ODBC driver any more :-(

    Problem now: how to easily build a jdbc driver for this scenario?
    All SQL queries should be simply passed to the oledb provider.

    Additionally: this jdbc driver should run native java, thus requiring some middleware (windows based) bridge.

    Up to now, I found
    - jadozoom http://www.infozoom.de/en_jadoZoom.shtml (jdbc to ado)
    - RMIJDBC http://rmijdbc.objectweb.org (jdbc to jdbc bridge)

    Combining both bridges works somehow... Besides performance, there's some loss regarding data type info, so I'm not too happy.

    I want to avoid building the whole stuff from scratch...

    Questions:
    - is javakonkurs.ru project 191 (more) suitable for my need? can someone check/translate, (beyond google translate) please ?
    - any other possible solution?

    I agree with fidge's suspect: I (we) cannot be alone with this task ...

    Thanks
  • 843859
    843859 Member Posts: 35,905 Bronze Trophy
    . Your premise that you want to access these databases using OLE DB through Java is flawed and makes no sense, so that is not a concern and does not affect the ability of competing technologies (JDBC, OLE DB) to successfully access a single database instance.


    whenever we talk about jdbc think odbc , and jdbc will connect to db which support odbc. The databases which can be accessed only using OLE db use com, now java does not suppport com , so its not possible to use OLE db to access db.
This discussion has been closed.