Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbcodbc for mac os x

 
Anbanandhan Dhanavelan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64858
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What database on the Mac are you using that requires ODBC?
 
Anbanandhan Dhanavelan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic