Re: Name jdbc is not bound in this Context error

2005-02-22 Thread U K Laxmi
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

Re: Name jdbc is not bound in this Context error

2005-02-22 Thread Antony Paul
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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 -

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Robert F Hall
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 =

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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.

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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]

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread U K Laxmi
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?

Re: Name jdbc is not bound in this Context error

2005-02-21 Thread Antony Paul
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

Name jdbc is not bound in this Context error

2005-02-18 Thread U K Laxmi
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