> I have installed tomcat5.5.
> In the tomcat docs it is recommended that i install Ant build tool as
> well as Concurrent Version System (CVS) too.
> Can someone tell me, how much neccesary are these to install and use?
> How it can help me for developing my application?
Not necessary - you can run without.
But I would say that ant is practical as build tool, because
it can build your app, deploy it and manage your app.
You should use source control, but CVS or something else
should not matter.
Arne
ruds - 16 Dec 2007 05:24 GMT
Does tomcat5.5 have jdbc driver or i have to install one?
I'm asking this because i tried runing my application and it is giving
me an error:
org.apache.jasper.JasperException: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
I have written the following code for db connection:
public class DataConnection
{
public static Connection connect() throws java.sql.SQLException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
System.out.println("Exception while connecting to database");
e.printStackTrace();
}
return java.sql.DriverManager.getConnection("jdbc:odbc:FTPDSN");
}
}
amd I'm calling this function in my jsp pages for accessing my data.
Arne Vajhøj - 16 Dec 2007 16:56 GMT
> Does tomcat5.5 have jdbc driver or i have to install one?
> I'm asking this because i tried runing my application and it is giving
> me an error:
> org.apache.jasper.JasperException: [Microsoft][ODBC Driver Manager]
> Data source name not found and no default driver specified
> return java.sql.DriverManager.getConnection("jdbc:odbc:FTPDSN");
I believe that error means that you do not have a DSN with the
name FTPDSN (system or user for the username Tomcat is running under).
Arne
ruds - 17 Dec 2007 03:44 GMT
> > Does tomcat5.5 have jdbc driver or i have to install one?
> > I'm asking this because i tried runing my application and it is giving
[quoted text clipped - 7 lines]
>
> Arne
The error is returned when executing the jsp page. I get the required
result if I execute the java file.
I'm importing the package in jsp page in which the code for database
connection is present.
e.g.:In my jsp page,
Connection mycon=mypack.DataConnection.connect(); //Error occured??
Statement stmt=mycon.createStatement();
ResultSet rs;
Arne Vajhøj - 17 Dec 2007 03:54 GMT
>>> Does tomcat5.5 have jdbc driver or i have to install one?
>>> I'm asking this because i tried runing my application and it is giving
[quoted text clipped - 10 lines]
> connection is present.
> e.g.:In my jsp page,
Yes. But does your standalone app and Tomcat run in the same
context ?
Arne
ruds - 17 Dec 2007 05:56 GMT
> > The error is returned when executing the jsp page. I get the required
> > result if I execute the java file.
[quoted text clipped - 6 lines]
>
> Arne-
same context? sorry but I didnt get you..
Arne Vajhøj - 18 Dec 2007 02:36 GMT
>>> The error is returned when executing the jsp page. I get the required
>>> result if I execute the java file.
[quoted text clipped - 5 lines]
>
> same context? sorry but I didnt get you..
Same username among other things.
Arne
ruds - 18 Dec 2007 04:17 GMT
> > same context? sorry but I didnt get you..
>
> Same username among other things.
>
> Arne
yes. I'm using it on same machine with my login.