Hi Antony,
I downloaded postgres and installed on my m/c. I
installed it as a service.
Can you pls give step by step instruction as how to
connect to postgresql database.
Thank you so much.
--- Antony Paul [EMAIL PROTECTED] wrote:
You can name it the name of the context(web). The
content
In fact I hadnt installed it in windlws. You can connect to server
suing psql. it will be in the bin directory. There is one GUI front
end available PgAdmin. The documentation will be in doc directory.
This contains installation, administration and tutorials on SQL. For
further you can ask
It seems you still have problem. You can google for the answer. One
thing I know is GlobalNamingResources should come inside the Server
element and not inside Context element.
rgds
Antony Paul
On Fri, 18 Feb 2005 22:47:06 -0800 (PST), U K Laxmi [EMAIL PROTECTED] wrote:
I could able to get
As just moved the GlobalNamingResources inside the
main server in my server.xml residing in
TOMCAT_HOME/conf directory. When i restart tomcat
5.5.7 it's throwing up following exception.
INFO: Starting Servlet Engine: Apache Tomcat/5.5.7
Feb 22, 2005 11:51:46 AM
By default server.xml contains have a GlobalNamingResources. You
have to add your resources in there.
rgds
Antony Paul
On Mon, 21 Feb 2005 19:56:23 -0800 (PST), U K Laxmi [EMAIL PROTECTED] wrote:
As just moved the GlobalNamingResources inside the
main server in my server.xml residing in
I tried without GlobalNamingResources. No luck. When
googled, i found that if we include
GlobalNamingResource tag, then it will be available in
all web context.
After spending enough time on that, now i coded all
database related stuff in JSP in the way we do in
stand alone application. I mean -
U K,
It works as you said, but there are a couple of things I'll recommend:
First, you should move your Connection, ResultSet and Statement
declarations before
the try {} block and add a finally {} block where you check for null
values and close
the resources if not null.
Connection conn =
If you followed the tomcat docs you will have no problem in DBCP
getting to work. Going for Globalnamingresources is needed if you need
to access it will all applications. Try to configure it as per the doc
in following URL.
Sure to do the changes you mentioned. Pls do send the
config file for connection pooling and also guidelines
for how to use it in my program. It will be a great
help.
I'm developing web based application for using it
inhouse. Later part of time, it may grow to a big MRP
application based on the
Yes i read and did as per the document. When it didn't
work, i followed the suggetions given to many users in
the mailing lists in the internet and now i guess i
messed up. Actually in the error, it says, no suitable
driver found.
I'm using Ms Access as it's free. Do we have any free
driver
I dont whether MS Access is considered as RDBMS. For serious
development it is not recommended. Using ODBC have several problems. I
will recommend PostgreSQL. Now it runs very well on Windows. But
requires Windows 2000 or higher. You can find it at
Thank you for the replies. Ms Access is not a
relational databaase. It's just DBMS. I didn't know
that PostGreSQL is a open source RDBMS system. All the
sqls, table creation etc.. works similar to Oracle or
any other RDBMS? I'm working on windows 2000 machine.
--- Antony Paul [EMAIL PROTECTED]
Most SQL is same and it supports a subset of SQL 92 and SQL 99
standards. Every RDBMS vendor have some proprietory code which dont
work in other databases. There is one RDBMS
Firebird(http://firebird.sourceforge.net/). The site claims that it is
more like Oracle.
rgds
Antony Paul
On Mon, 21
Thanks for the replies. What do u mean by the
following in ur erlier mail.
Did you defined your newly created context web
in
server.xml or at
TOMCAT_HOME\conf\Catalina\localhost\some
name.xml
Does it mean i need to create a new xml file in
TOMCAT_HOME\conf\Catalina\localhost?
You can name it the name of the context(web). The content should be
similar to any other file there. I am giving a sample
Context docBase=${catalina.home}/webapps/web
antiResourceLocking=false antiJARLocking=false
/Context
rgds
Antony Paul
On Mon, 21 Feb 2005 23:18:55 -0800 (PST), U
I could able to get thro' JarperException. Thanks for
replies.
Now facing new problem.
I'm getting NameNotFoundException - Name jdbc is
not bound in this Context
Environment what i'm using is: Apache 2, Tomcat 5.5,
Netscape 7.2, MsAccess 2003 on windows 2000 machine.
I integrated tomcat and
16 matches
Mail list logo