Solved

JDBC Type 4 Driver

Posted on 2006-07-17
12
211 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 500 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
reverse digits of a number using for loop 5 52
HashTable highest marks enumeration alternative 9 43
jdbc error in jsp application 20 63
iterator/ListIterator approach 17 39
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
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…
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:
The viewer will learn how to implement Singleton Design Pattern in Java.

829 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