I develop a java application which uses mysql as its database.. and after deployment every user after installation
will have to install the mysql database on its own setting the username and password as used in my program
connection string.. my is that i want to reduce the stress of installation which makes the size of the packaged
executable file heavy.. so i guess i should be able to use the \DLL of which i just download it but does not know how to use it..
Or better still if there is another means to solve this challenge..
There are several small databases that you can easily distribute together with your application. Ulf already mentioned Apache Derby. There is also Java DB, which is included with the JDK / JRE (and which is essentially the same as Apache Derby). There is also HSQLDB.
Note that all of these are 100% Java - no native DLL needed, and they work on any operating system that runs Java, not only on Windows.
How about you ShowSomeEffort instead? If you click on the "HSQLDB" link from Jesper's post, you see links to "FAQ", "Documentation" and "How To" at the top right. The "Apache Derby" link has a page with a "Documentation" tab. Likewise for the "Java DB" link. So read through these first.
So back to "Documentation", this time selection "JavaDoc" and location the JDBCConnection class on the left.
Now that should definitely be enough to help you on your way. I don't want to see any more questions without saying you "can't" without an indication of what you have tried. Like I said before, you should ShowSomeEffort. I mean, the ZIP file contains folders like "doc", "sample" and "/src/org/hsqldb/sample". I bet you haven't even checked those out.