Solved

JDBC Type 4 Driver

Posted on 2006-07-17
12
210 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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

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 …
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

772 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