can someone tell me about any possible connection methods between
java and database. also any differences between each connection type.

DO you know any sites including help or source codes about Java
Database Connectivity...?
I have a project about connectivity with MS Access...

Here is a sample chapter on JDBC
vig.pearsoned.com/samplechapter/0139016619.pdf
By reading this chapter you will get the basic
regarding JDBC. They don't explain how to create the
ODBC, if you don't know how to create an ODBC search
on google, it's relative easy how to create one.

Use jdbc  Tutorial kept on sun  site.

http://java.sun.com/docs/books/tutorial/jdbc/

It covers these things.

I hava some code to access database (DBConector.java)
I use Mysql and the table structure in db_simaba.sql
file. if run that code i have some error like ;

java.sql.SQLException: Unable to connect to any hosts
due to exception:
java.lang.ArrayIndexOutOfBoundsException: 42
at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
at
com.mysql.jdbc.Connection.<init>(Connection.java:562)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:361)
at java.sql.DriverManager.getConnection(Unknown
Source)
at java.sql.DriverManager.getConnection(Unknown
Source)
at
hen.tools.DBConector.getConnection(DBConector.java:34)
at
hen.tools.DBConector.getInstance(DBConector.java:25)
at hen.tools.DBConector.main(DBConector.java:56)

------
But if the data base name is change for example
'db_test', the code run well....

what wrong any body know...?

actually i m also using back end as mysql.
and my program is running well.

so i have checked my database after ur mail
but i didn't find database like .sql.
so i think databse of mysql won't be like that.
so u might get problem bcoz of that.

Well, the error message says that some array index does not fit into
the array given to this function as a parameter.

As you mentioned that the DB name "db_test" works, I dare to suppose
that the variable you are using to store the DB name is too small;
have you defined it as a StringBuffer of limited size, or anything
similar? Maybe a char array instead of a String? Then make the array
larger.

Hey i want help abt jaca data based can
any one give me the code of the simple java databased
code which contains the
add,delete,update,next,previus,first,last this method
is include pls send me as early as posssible

check out this sites , it could be so helpful..

http://www.sourceforge.net/
http://www.planetsourcecode.com/
http://www.javagalaxy.com/Java.jsp
http://www.hotscripts.com/
http://www.java2s.com/
http://www.javaalmanac.com/
http://www.javapractices.com/index.cjp
http://www.sys-con.com/java/sourcec.cfm

and of course sun  java official forums:
http://forum.java.sun.com/forum.jspa?forumID=31