?
Solved

JDBC Type 4 Driver

Posted on 2006-07-17
12
Medium Priority
?
220 Views
Last Modified: 2010-08-05
Is there any free type 4 JDBC Driver??

If not which is the best commercial JDBC type 4 driver. I am having an application that uses MS Access. If I want to sell the application I should give that driver also.
0
Comment
Question by:sree032397
  • 6
  • 5
12 Comments
 
LVL 14

Expert Comment

by:StillUnAware
ID: 17127842
See this explanation, actually You don't even need any 3rd party jdbc driver at all:

http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html
0
 
LVL 92

Expert Comment

by:objects
ID: 17127850
aren't any that I'm aware of. your other option would be to switch databases to sojmething like hsqldb
0
 
LVL 1

Author Comment

by:sree032397
ID: 17127909
What are the other Such kind of database available
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 1

Author Comment

by:sree032397
ID: 17127933
I want to insert and retrieve lakhs of records from my Java Applicatio(Commercial) at a time. Which is the best database in terms of Time and Security
0
 
LVL 92

Expert Comment

by:objects
ID: 17127944
need more details of your requirements, but Access is probably not the best choice.
0
 
LVL 1

Author Comment

by:sree032397
ID: 17127983
I just want to store and retrieve some important information(Which should not be altered externally). The number of reciords will be in terms of lakhs(as of now up to 10 lakhs, It may increase a bit). It should take less time.(1 to 2 minutes for inserting 1 lakhs of records with 4 fields where in duplicates not allowed. I declared it as a primary key and inserting in try-catch block.)
0
 
LVL 92

Expert Comment

by:objects
ID: 17128010
i'd suggest hsqldb or mysql depending on your distribution needs
0
 
LVL 1

Author Comment

by:sree032397
ID: 17128026
Thanks.
Which is best suited if I want to distribute the database along with my application(Commercial) Can I distribute freely? I tried using my SQL it is very fast. But what about licence ?? Can I distribute freely?? What about HSQL DB??
0
 
LVL 92

Accepted Solution

by:
objects earned 2000 total points
ID: 17128037
both can be freely distributed
0
 
LVL 1

Author Comment

by:sree032397
ID: 17128122
Thank You. Which one you will prefer in terms of security
0
 
LVL 92

Expert Comment

by:objects
ID: 17128197
probably mysql
0
 
LVL 1

Author Comment

by:sree032397
ID: 17128227
Thank You
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Suggested Courses
Course of the Month7 days, 10 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question