Database Connection

**r035198x** · Nov 30 '06, 12:08 PM

Originally posted by seralasu

I have a problem database connection. I try to connect to MS Acces via ODBC.
I made data source in ODBc but I didn't run it. JDBC-ODBC driver must be in my pc because I loaded JDk 1.4.2. I don't know what I will do.

Describe your problem. Are you getting an error message?

**seralasu** · Nov 30 '06, 12:18 PM

This is my code:
<%
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") .newInstance();
java.sql.Connec tion baglanti = java.sql.Driver Manager.getConn ection("jdbc:od bc:personel","a sd","asd");
java.sql.Statem ent sorgulama = baglanti.create Statement();
java.sql.Result Set sonucVeriler = sorgulama.execu teQuery("SELECT * FROM Elemanlar");

}

catch(ClassNotF oundException cnfe)
{
System.err.prin tln("Database Driver'a ulaşılamıyor") ;
System.err.prin tln("Detay: "+cnfe);
System.exit(0);
}
%>

This is error:type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.S ervletException : General error
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:825)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:758)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :132)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

root cause

java.sql.SQLExc eption: General error
sun.jdbc.odbc.J dbcOdbc.createS QLException(Jdb cOdbc.java:6987 )
sun.jdbc.odbc.J dbcOdbc.standar dError(JdbcOdbc .java:7115)
sun.jdbc.odbc.J dbcOdbc.SQLDriv erConnect(JdbcO dbc.java:3074)
sun.jdbc.odbc.J dbcOdbcConnecti on.initialize(J dbcOdbcConnecti on.java:323)
sun.jdbc.odbc.J dbcOdbcDriver.c onnect(JdbcOdbc Driver.java:174 )
java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :101)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

**r035198x** · Nov 30 '06, 12:32 PM

Originally posted by seralasu

This is my code:
<%
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") .newInstance();
java.sql.Connec tion baglanti = java.sql.Driver Manager.getConn ection("jdbc:od bc:personel","a sd","asd");
java.sql.Statem ent sorgulama = baglanti.create Statement();
java.sql.Result Set sonucVeriler = sorgulama.execu teQuery("SELECT * FROM Elemanlar");

}

catch(ClassNotF oundException cnfe)
{
System.err.prin tln("Database Driver'a ulaşılamıyor") ;
System.err.prin tln("Detay: "+cnfe);
System.exit(0);
}
%>

This is error:type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.S ervletException : General error
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:825)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:758)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :132)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

root cause

java.sql.SQLExc eption: General error
sun.jdbc.odbc.J dbcOdbc.createS QLException(Jdb cOdbc.java:6987 )
sun.jdbc.odbc.J dbcOdbc.standar dError(JdbcOdbc .java:7115)
sun.jdbc.odbc.J dbcOdbc.SQLDriv erConnect(JdbcO dbc.java:3074)
sun.jdbc.odbc.J dbcOdbcConnecti on.initialize(J dbcOdbcConnecti on.java:323)
sun.jdbc.odbc.J dbcOdbcDriver.c onnect(JdbcOdbc Driver.java:174 )
java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :101)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

Did you try

using

Code:

String url = "jdbc:odbc:myDb";
Connection con = DriverManager.getConnection(url);

**seralasu** · Nov 30 '06, 02:03 PM

Hi,
I tried your respond but I don't solve my problem.

**r035198x** · Nov 30 '06, 02:12 PM

Originally posted by seralasu

Hi,
I tried your respond but I don't solve my problem.

Did you get the same error as before?

**seralasu** · Dec 1 '06, 06:04 AM

Originally posted by r035198x

Did you get the same error as before?

Error is same.

**AndrewG** · Dec 29 '06, 01:21 PM

The "java.sql.SQLEx ception: General error" means that there is an error accesing the database, not in you java code. You must look for any log in the database or maybe in the ODBC source. Check that the ODBC source link correctly with the database file, or that the database is not corrupted. In SQLServer you can find the source of the error in logs file, but i am not sure MS Access has them. Good luck.

Andrew.

**Shanaj** · Jan 2 '07, 08:19 AM

Originally posted by seralasu

This is my code:
<%
try
{
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") .newInstance();
java.sql.Connec tion baglanti = java.sql.Driver Manager.getConn ection("jdbc:od bc:personel","a sd","asd");
java.sql.Statem ent sorgulama = baglanti.create Statement();
java.sql.Result Set sonucVeriler = sorgulama.execu teQuery("SELECT * FROM Elemanlar");

}

catch(ClassNotF oundException cnfe)
{
System.err.prin tln("Database Driver'a ulaşılamıyor") ;
System.err.prin tln("Detay: "+cnfe);
System.exit(0);
}
%>

This is error:type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.S ervletException : General error
org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:825)
org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:758)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :132)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

root cause

java.sql.SQLExc eption: General error
sun.jdbc.odbc.J dbcOdbc.createS QLException(Jdb cOdbc.java:6987 )
sun.jdbc.odbc.J dbcOdbc.standar dError(JdbcOdbc .java:7115)
sun.jdbc.odbc.J dbcOdbc.SQLDriv erConnect(JdbcO dbc.java:3074)
sun.jdbc.odbc.J dbcOdbcConnecti on.initialize(J dbcOdbcConnecti on.java:323)
sun.jdbc.odbc.J dbcOdbcDriver.c onnect(JdbcOdbc Driver.java:174 )
java.sql.Driver Manager.getConn ection(DriverMa nager.java:512)
java.sql.Driver Manager.getConn ection(DriverMa nager.java:171)
org.apache.jsp. renkli_005fgost er_jsp._jspServ ice(renkli_005f goster_jsp.java :101)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:94)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 324)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:292)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :236)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)

hello

try this

create dsn by selecting "system dsn" tab

**gbubeshattur** · Jan 3 '07, 11:47 AM

Originally posted by Shanaj

hello

try this

create dsn by selecting "system dsn" tab

hey wat u wanna do is ..
i think u using msacces right if s
go to the control pannel select administrative tools- datasources (odbc) - select system dsn by using tab key.
then press add
select ms access driver press finish
give the data source name that u specified in ur program
and pres select to select the database .and select ur database and click ok and stop the server and restart the run
then it will work very fine.
bye
reply me if its notworking
prakash.nmsp@gm ail.com
bye

Database Connection

Database Connection

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment