You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by ed...@gmail.com on 2005/03/26 08:15:25 UTC
tomcat 5.5.7 / windowsXP / access database
Hi,
I've recently started to experiment with tomcat 5.5.7 on windows XP,
trying to access an Access (.mdb) database.
I've set up a datasource in windowsXP administration tools and used
the the tomcat administration (which had to be installed separately)
to configure a datasource in tomcat.
this gave me the following in 'server.xml' under GlobalNamingResources:
_______________
/
<Resource
name="movies"
type="javax.sql.DataSource"
password=""
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
maxIdle="2"
maxWait="5000"
username=""
url="jdbc:odbc:movies"
maxActive="4"/>
\_______________
I then got a servlet going with the following:
_______________
/
Connection con = null;
try {
// Load the Driver class file
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("Getting Connection!");
// Make a connection to the ODBC datasource Movie Catalog
// In this example we are opening a connection to the
// database with every request.
con = DriverManager.getConnection("jdbc:odbc:movies","","");
if ( con == null ) {
out.println("no Connection!");
}
else {
out.println("we have a connection");
}
\_______________
restarted tomcat and tried but get the following message after an
SqlException is thrown.
_______________
/
SQLException -- [Microsoft][ODBC Driver Manager] Data source name
not found and no default
driver specified
\_______________
In other words it chokes at:
_______________
/
con = DriverManager.getConnection("jdbc:odbc:movies","","");
\_______________
any hints as to what I'm doing wrong?
thanks,
kind regards,
Luke
--
/ / _
/_ /_/ /< /=
0421 276 282
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: tomcat 5.5.7 / windowsXP / access database
Posted by U K Laxmi <la...@yahoo.com>.
I was watching this mailing list and found this
posting useful. Even my environment is same except
that i'm using MS Access on windows 2000 machine. I
followed what Mr. Luke has done and it works fine for
me too. Earlier i was using JDBC connection as
follows:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn =
DriverManager.getConnection("jdbc:odbc:driver={Microsoft
Access Driver
(*.mdb)};DBQ=C:/tomcat/webapps/db1/db1.mdb");
Now i included following in srever.xml under
GlobalNamingResources.
<Resource
name="db1"
type="javax.sql.DataSource"
password=""
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
maxIdle="2"
maxWait="5000"
username=""
url="jdbc:odbc:db1"
maxActive="4"/>
and changed the code on my JSP follows:
Connection conn = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:db1");
And it works fine. I'm able to work on database.
What is the drawback in doing like this? Is it fine to
do this way? If not, what changes i need to do to the
existing set-up? Pls inform.
Thanks.
--- Parsons Technical Services
<pa...@earthlink.net> wrote:
> Luke,
>
> I should have read closer. What you have done is to
> create a connection
> without pooling. The language in the servlet does
> not call the resource that
> you created in the server.xml . If you don't need
> pooling you can remove the
> Global resource. If you want pooling, you need to
> change the servlet.
>
> As for why all three work, you need to look at your
> setup.
> Is the database protected with a password?
> Did you declare a password in the DSN?
>
> Glad you got things working, but I wanted you to
> know that they were not
> working as you thought.
>
> Doug
>
>
> ----- Original Message -----
> From: <ed...@gmail.com>
> To: <to...@jakarta.apache.org>
> Sent: Saturday, March 26, 2005 4:27 AM
> Subject: Re: tomcat 5.5.7 / windowsXP / access
> database
>
>
> > Hi,
> >
> > I've solved the problem.
> > I needed to declare a 'system-wide' datasource on
> the windowsXP box.
> > In adminstrative tools, firstup I declared a user
> DSN, that has to be
> > a System DSN,
> > then it worked.
> >
> > NOTE: the DriverManager.getConnection() method has
> a few different
> > constructors. Once you have the System wide DSN,
> any of the following
> > constructors work:
> > DriverManager.getConnection("jdbc:odbc:db");
> > DriverManager.getConnection("jdbc:odbc:db","","");
> >
>
DriverManager.getConnection("jdbc:odbc:db","user","pass");
> >
> > these all worked regardless of the settings for
> 'username' and
> > 'password' in server.xml, even deleting those to
> settings from
> > server.xml didn't affect access to the access
> database.
> > THis was once again confirmed by rebooting the
> windows box and
> > (obviously) starting all services again.
> >
> > Have a great Easter!
> > Luke
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Hi,
> >
> > I've recently started to experiment with tomcat
> 5.5.7 on windows XP,
> > trying to access an Access (.mdb) database.
> > I've set up a datasource in windows administration
> tools and used the
> > the tomcat administration (which had to be
> installed separately) to
> > configure a datasource in tomcat.
> >
> > this gave me the following in 'server.xml' under
> GlobalNamingResources:
> > _______________
> > /
> > <Resource
> > name="movies"
> > type="javax.sql.DataSource"
> > password=""
> > driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> > maxIdle="2"
> > maxWait="5000"
> > username=""
> > url="jdbc:odbc:movies"
> > maxActive="4"/>
> > \_______________
> >
> > I then got a servlet going with the following:
> > _______________
> > /
> > Connection con = null;
> > try {
> > // Load the Driver class file
> >
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > out.println("Getting Connection!");
> > // Make a connection to the ODBC datasource
> Movie Catalog
> > // In this example we are opening a
> connection to the
> > // database with every request.
> > con =
>
DriverManager.getConnection("jdbc:odbc:movies","","");
> > if ( con == null ) {
> > out.println("no Connection!");
> > }
> > else {
> > out.println("we have a connection");
> > }
> > \_______________
> >
> > restarted tomcat and tried but get the following
> message after an
> > SqlException is thrown.
> > _______________
> > /
> > SQLException -- [Microsoft][ODBC Driver Manager]
> Data source name
> > not found and no default
> > driver specified
> > \_______________
> >
> > In other words it chokes at:
> > _______________
> > /
> > con =
>
DriverManager.getConnection("jdbc:odbc:movies","","");
> > \_______________
> >
> > any hints as to what I'm doing wrong?
> >
> > thanks,
> > kind regards,
> > Luke
> >
> > --
> > / / _
> > /_ /_/ /< /=
> > 0421 276 282
> >
> >> > Hi,
> >> >
> >> > I've recently started to experiment with tomcat
> 5.5.7 on windows XP,
> >> > trying to access an Access (.mdb) database.
> >> > I've set up a datasource in windowsXP
> administration tools and used
> >> > the the tomcat administration (which had to be
> installed separately)
> >> > to configure a datasource in tomcat.
> >> >
> >> > this gave me the following in 'server.xml'
> under GlobalNamingResources:
> >> > _______________
> >> > /
> >> > <Resource
> >> > name="movies"
> >> > type="javax.sql.DataSource"
> >> > password=""
> >> >
> driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> >> > maxIdle="2"
> >> > maxWait="5000"
> >> > username=""
> >> > url="jdbc:odbc:movies"
> >> > maxActive="4"/>
> >> > \_______________
> >> >
> >> > I then got a servlet going with the following:
> >> > _______________
> >> > /
> >> > Connection con = null;
> >> > try {
> >> > // Load the Driver class file
> >> >
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> >> > out.println("Getting Connection!");
> >> > // Make a connection to the ODBC
> datasource Movie Catalog
> >> > // In this example we are opening a
> connection to the
> >> > // database with every request.
> >> > con =
>
DriverManager.getConnection("jdbc:odbc:movies","","");
> >> > if ( con == null ) {
> >> > out.println("no Connection!");
> >> > }
> >> > else {
> >> > out.println("we have a connection");
> >> > }
> >> > \_______________
> >> >
> >> > restarted tomcat and tried but get the
> following message after an
> >> > SqlException is thrown.
> >> > _______________
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: tomcat 5.5.7 / windowsXP / access database
Posted by Parsons Technical Services <pa...@earthlink.net>.
Luke,
I should have read closer. What you have done is to create a connection
without pooling. The language in the servlet does not call the resource that
you created in the server.xml . If you don't need pooling you can remove the
Global resource. If you want pooling, you need to change the servlet.
As for why all three work, you need to look at your setup.
Is the database protected with a password?
Did you declare a password in the DSN?
Glad you got things working, but I wanted you to know that they were not
working as you thought.
Doug
----- Original Message -----
From: <ed...@gmail.com>
To: <to...@jakarta.apache.org>
Sent: Saturday, March 26, 2005 4:27 AM
Subject: Re: tomcat 5.5.7 / windowsXP / access database
> Hi,
>
> I've solved the problem.
> I needed to declare a 'system-wide' datasource on the windowsXP box.
> In adminstrative tools, firstup I declared a user DSN, that has to be
> a System DSN,
> then it worked.
>
> NOTE: the DriverManager.getConnection() method has a few different
> constructors. Once you have the System wide DSN, any of the following
> constructors work:
> DriverManager.getConnection("jdbc:odbc:db");
> DriverManager.getConnection("jdbc:odbc:db","","");
> DriverManager.getConnection("jdbc:odbc:db","user","pass");
>
> these all worked regardless of the settings for 'username' and
> 'password' in server.xml, even deleting those to settings from
> server.xml didn't affect access to the access database.
> THis was once again confirmed by rebooting the windows box and
> (obviously) starting all services again.
>
> Have a great Easter!
> Luke
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Hi,
>
> I've recently started to experiment with tomcat 5.5.7 on windows XP,
> trying to access an Access (.mdb) database.
> I've set up a datasource in windows administration tools and used the
> the tomcat administration (which had to be installed separately) to
> configure a datasource in tomcat.
>
> this gave me the following in 'server.xml' under GlobalNamingResources:
> _______________
> /
> <Resource
> name="movies"
> type="javax.sql.DataSource"
> password=""
> driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> maxIdle="2"
> maxWait="5000"
> username=""
> url="jdbc:odbc:movies"
> maxActive="4"/>
> \_______________
>
> I then got a servlet going with the following:
> _______________
> /
> Connection con = null;
> try {
> // Load the Driver class file
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> out.println("Getting Connection!");
> // Make a connection to the ODBC datasource Movie Catalog
> // In this example we are opening a connection to the
> // database with every request.
> con = DriverManager.getConnection("jdbc:odbc:movies","","");
> if ( con == null ) {
> out.println("no Connection!");
> }
> else {
> out.println("we have a connection");
> }
> \_______________
>
> restarted tomcat and tried but get the following message after an
> SqlException is thrown.
> _______________
> /
> SQLException -- [Microsoft][ODBC Driver Manager] Data source name
> not found and no default
> driver specified
> \_______________
>
> In other words it chokes at:
> _______________
> /
> con = DriverManager.getConnection("jdbc:odbc:movies","","");
> \_______________
>
> any hints as to what I'm doing wrong?
>
> thanks,
> kind regards,
> Luke
>
> --
> / / _
> /_ /_/ /< /=
> 0421 276 282
>
>> > Hi,
>> >
>> > I've recently started to experiment with tomcat 5.5.7 on windows XP,
>> > trying to access an Access (.mdb) database.
>> > I've set up a datasource in windowsXP administration tools and used
>> > the the tomcat administration (which had to be installed separately)
>> > to configure a datasource in tomcat.
>> >
>> > this gave me the following in 'server.xml' under GlobalNamingResources:
>> > _______________
>> > /
>> > <Resource
>> > name="movies"
>> > type="javax.sql.DataSource"
>> > password=""
>> > driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
>> > maxIdle="2"
>> > maxWait="5000"
>> > username=""
>> > url="jdbc:odbc:movies"
>> > maxActive="4"/>
>> > \_______________
>> >
>> > I then got a servlet going with the following:
>> > _______________
>> > /
>> > Connection con = null;
>> > try {
>> > // Load the Driver class file
>> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>> > out.println("Getting Connection!");
>> > // Make a connection to the ODBC datasource Movie Catalog
>> > // In this example we are opening a connection to the
>> > // database with every request.
>> > con = DriverManager.getConnection("jdbc:odbc:movies","","");
>> > if ( con == null ) {
>> > out.println("no Connection!");
>> > }
>> > else {
>> > out.println("we have a connection");
>> > }
>> > \_______________
>> >
>> > restarted tomcat and tried but get the following message after an
>> > SqlException is thrown.
>> > _______________
>> > /
>> > SQLException -- [Microsoft][ODBC Driver Manager] Data source name
>> > not found and no default
>> > driver specified
>> > \_______________
>> >
>> > In other words it chokes at:
>> > _______________
>> > /
>> > con = DriverManager.getConnection("jdbc:odbc:movies","","");
>> > \_______________
>> >
>> > any hints as to what I'm doing wrong?
>> >
>> > thanks,
>> > kind regards,
>> > Luke
>> >
>> > --
>> > / / _
>> > /_ /_/ /< /=
>> > 0421 276 282
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>> >
>> >
>> >
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: tomcat 5.5.7 / windowsXP / access database
Posted by ed...@gmail.com.
Hi,
I've solved the problem.
I needed to declare a 'system-wide' datasource on the windowsXP box.
In adminstrative tools, firstup I declared a user DSN, that has to be
a System DSN,
then it worked.
NOTE: the DriverManager.getConnection() method has a few different
constructors. Once you have the System wide DSN, any of the following
constructors work:
DriverManager.getConnection("jdbc:odbc:db");
DriverManager.getConnection("jdbc:odbc:db","","");
DriverManager.getConnection("jdbc:odbc:db","user","pass");
these all worked regardless of the settings for 'username' and
'password' in server.xml, even deleting those to settings from
server.xml didn't affect access to the access database.
THis was once again confirmed by rebooting the windows box and
(obviously) starting all services again.
Have a great Easter!
Luke
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi,
I've recently started to experiment with tomcat 5.5.7 on windows XP,
trying to access an Access (.mdb) database.
I've set up a datasource in windows administration tools and used the
the tomcat administration (which had to be installed separately) to
configure a datasource in tomcat.
this gave me the following in 'server.xml' under GlobalNamingResources:
_______________
/
<Resource
name="movies"
type="javax.sql.DataSource"
password=""
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
maxIdle="2"
maxWait="5000"
username=""
url="jdbc:odbc:movies"
maxActive="4"/>
\_______________
I then got a servlet going with the following:
_______________
/
Connection con = null;
try {
// Load the Driver class file
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("Getting Connection!");
// Make a connection to the ODBC datasource Movie Catalog
// In this example we are opening a connection to the
// database with every request.
con = DriverManager.getConnection("jdbc:odbc:movies","","");
if ( con == null ) {
out.println("no Connection!");
}
else {
out.println("we have a connection");
}
\_______________
restarted tomcat and tried but get the following message after an
SqlException is thrown.
_______________
/
SQLException -- [Microsoft][ODBC Driver Manager] Data source name
not found and no default
driver specified
\_______________
In other words it chokes at:
_______________
/
con = DriverManager.getConnection("jdbc:odbc:movies","","");
\_______________
any hints as to what I'm doing wrong?
thanks,
kind regards,
Luke
--
/ / _
/_ /_/ /< /=
0421 276 282
> > Hi,
> >
> > I've recently started to experiment with tomcat 5.5.7 on windows XP,
> > trying to access an Access (.mdb) database.
> > I've set up a datasource in windowsXP administration tools and used
> > the the tomcat administration (which had to be installed separately)
> > to configure a datasource in tomcat.
> >
> > this gave me the following in 'server.xml' under GlobalNamingResources:
> > _______________
> > /
> > <Resource
> > name="movies"
> > type="javax.sql.DataSource"
> > password=""
> > driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> > maxIdle="2"
> > maxWait="5000"
> > username=""
> > url="jdbc:odbc:movies"
> > maxActive="4"/>
> > \_______________
> >
> > I then got a servlet going with the following:
> > _______________
> > /
> > Connection con = null;
> > try {
> > // Load the Driver class file
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > out.println("Getting Connection!");
> > // Make a connection to the ODBC datasource Movie Catalog
> > // In this example we are opening a connection to the
> > // database with every request.
> > con = DriverManager.getConnection("jdbc:odbc:movies","","");
> > if ( con == null ) {
> > out.println("no Connection!");
> > }
> > else {
> > out.println("we have a connection");
> > }
> > \_______________
> >
> > restarted tomcat and tried but get the following message after an
> > SqlException is thrown.
> > _______________
> > /
> > SQLException -- [Microsoft][ODBC Driver Manager] Data source name
> > not found and no default
> > driver specified
> > \_______________
> >
> > In other words it chokes at:
> > _______________
> > /
> > con = DriverManager.getConnection("jdbc:odbc:movies","","");
> > \_______________
> >
> > any hints as to what I'm doing wrong?
> >
> > thanks,
> > kind regards,
> > Luke
> >
> > --
> > / / _
> > /_ /_/ /< /=
> > 0421 276 282
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: tomcat 5.5.7 / windowsXP / access database
Posted by Parsons Technical Services <pa...@earthlink.net>.
Check to see if you have a resource link in your context.xml .
Without it your app can't see the resource.
Doug
----- Original Message -----
From: <ed...@gmail.com>
To: <to...@jakarta.apache.org>
Sent: Saturday, March 26, 2005 2:15 AM
Subject: tomcat 5.5.7 / windowsXP / access database
> Hi,
>
> I've recently started to experiment with tomcat 5.5.7 on windows XP,
> trying to access an Access (.mdb) database.
> I've set up a datasource in windowsXP administration tools and used
> the the tomcat administration (which had to be installed separately)
> to configure a datasource in tomcat.
>
> this gave me the following in 'server.xml' under GlobalNamingResources:
> _______________
> /
> <Resource
> name="movies"
> type="javax.sql.DataSource"
> password=""
> driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> maxIdle="2"
> maxWait="5000"
> username=""
> url="jdbc:odbc:movies"
> maxActive="4"/>
> \_______________
>
> I then got a servlet going with the following:
> _______________
> /
> Connection con = null;
> try {
> // Load the Driver class file
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> out.println("Getting Connection!");
> // Make a connection to the ODBC datasource Movie Catalog
> // In this example we are opening a connection to the
> // database with every request.
> con = DriverManager.getConnection("jdbc:odbc:movies","","");
> if ( con == null ) {
> out.println("no Connection!");
> }
> else {
> out.println("we have a connection");
> }
> \_______________
>
> restarted tomcat and tried but get the following message after an
> SqlException is thrown.
> _______________
> /
> SQLException -- [Microsoft][ODBC Driver Manager] Data source name
> not found and no default
> driver specified
> \_______________
>
> In other words it chokes at:
> _______________
> /
> con = DriverManager.getConnection("jdbc:odbc:movies","","");
> \_______________
>
> any hints as to what I'm doing wrong?
>
> thanks,
> kind regards,
> Luke
>
> --
> / / _
> /_ /_/ /< /=
> 0421 276 282
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org