Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

JDBC for sql server

  Asked By: Daryl    Date: Oct 20    Category: Java    Views: 2029

Anyone can tell me good native JDBC for SQL server and Access?
I've used ODBC-JDBC from Sun, but it's too bad.



9 Answers Found

Answer #1    Answered By: Lurlene Fischer     Answered On: Oct 20

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

Answer #2    Answered By: Helene Stewart     Answered On: Oct 20

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

Answer #3    Answered By: Feodora Bonkob     Answered On: Oct 20

Here is a sample chapter on JDBC
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.

Answer #4    Answered By: Della Simpson     Answered On: Oct 20

Use jdbc  Tutorial kept on sun  site.


It covers these things.

Answer #5    Answered By: Devrim Yilmaz     Answered On: Oct 20

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 java.sql.DriverManager.getConnection(Unknown
at java.sql.DriverManager.getConnection(Unknown
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...?

Answer #6    Answered By: Ella Brown     Answered On: Oct 20

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.

Answer #7    Answered By: Liam Bouchard     Answered On: Oct 20

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

Answer #8    Answered By: Hababah Younis     Answered On: Oct 20

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

Answer #9    Answered By: Edfu Massri     Answered On: Oct 20
Didn't find what you were looking for? Find more on JDBC for sql server Or get search suggestion and latest updates.