aspose file tools*
The moose likes JDBC and the fly likes jdbcodbc for mac os x Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbcodbc for mac os x" Watch "jdbcodbc for mac os x" New topic
Author

jdbcodbc for mac os x

Anbanandhan Dhanavelan
Greenhorn

Joined: Jun 12, 2007
Posts: 8
hi all
i am a new user of java and mac,
is it possible to use jdbcodbc driver in Mac os x,
if so would any one help me how to do this,
if not, any one tell me how to do database application in mac using java.

Any mac user's kindly help me

Thank you in advance
Anbu
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61760
    
  67

What database on the Mac are you using that requires ODBC?


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Anbanandhan Dhanavelan
Greenhorn

Joined: Jun 12, 2007
Posts: 8
hi
i am having a .mdb (MS Access file) this file has only one table , i wants to create search engine using this table, that has to be work in windows and mac os x

Thank you
Anbu
Anbanandhan Dhanavelan
Greenhorn

Joined: Jun 12, 2007
Posts: 8
i am having .mdb(MS Access database) file, my clients require an application in cd version, on installing my application the user can use my application as a search engine for this .mdb file.so i decided to develop my application in java, while connecting the access database i use the following method,

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbcdbc:jobbankdb","user","user");

in this :jobbankdb is a system DSN, this is created in "ODBC Data Source Administrator" in windows "Administrator tools" by manually

i wants to create this DSN(Data Source Name) on runtime
could you please give me sample code so that i can give my application in cd


Thank you
Anbu
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42912
    
  68
I'm not sure if this works on OS X, but it is possible to use the JDBC/ODBC bridge without setting up a DSN. This article describes how that works.
Anbanandhan Dhanavelan
Greenhorn

Joined: Jun 12, 2007
Posts: 8
hi Ulf Dittmer
thank you for you post
i can convert my .mdb (ms access file ) to a xml is it possible to use this xml file as like a database, but the converted xml file is about 30 MB

Thank you
Anbu
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42912
    
  68
I'm sure someone has written a JDBC driver that reads an XML file, even though it seems a bit pointless to me. Look like Google knows of a few.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbcodbc for mac os x