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 question
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
> conten
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
rgds
Antony Paul
On Mon, 21 Feb 2005 23:18:55 -0800 (PST), U K Laxmi <[EMAIL PROTECTED]> wrote:
> Thanks for the replies. What do u mean by the
> following in ur erlier m
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\Catalin
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 Feb
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]>
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
http://www.postgresql.org/ftp/binary/v8.0.1/win32/
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 avail
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
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.
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-
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 =
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 -
By default server.xml contains have a . 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 in my server.xml residing in
> TOMCAT_HOME/conf directory
As just moved the GlobalNamingResources inside the
main 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
org.apache.catalina.realm.UserDatabaseRealm
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 th
Hi,
I bet it's just your webapp code that's looking for "jdbc" instead of
"jdbc/myapp" ;) Your config (original: you don't need to do the
GlobalResources stuff, your original config is better) looks fine.
Yoav Shapira
>-Original Message-
>From: Mauro Romano Trajber [mailto:[EMAIL
On Sat, 09 Oct 2004 19:48:45 +0200, Michael Echerer <[EMAIL PROTECTED]> wrote:
> If you put the ResourceParams stuff in server.xml as GlobalResource,
> you must put e.g. this into your server.xml's context respectively your
> myapp.xml context descriptor.
Ok, did it
> type="javax.sql.DataSource
If you put the ResourceParams stuff in server.xml as GlobalResource,
you must put e.g. this into your server.xml's context respectively your
myapp.xml context descriptor.
Of course name and global can differ, but I think this is easiest.
There's some hint in the Tomcat 5 docu that this is neede
available and my app works.
odd.
> -Original Message-
> From: Kelly C. Goedert [mailto:[EMAIL PROTECTED]
> Sent: 09 September 2004 15:09
> To: Tomcat Users List
> Subject: Re: Name jdbc is not bound in this Context
>
>
> I fixed this on the code and it sti
I fixed this on the code and it still didn't work. I put my datasource
as a global resource and used than the error stoped. But
when it is not global it doesn't, I don't know why.
Kelly.
Shapira, Yoav wrote:
Hi,
I'm getting this error " Name jdbc is not bound in this Context" on my
applicati
Apologies.
My response may be in other thread.
I will created a new.
Thank's David.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi,
>I'm getting this error " Name jdbc is not bound in this Context" on my
>application. My tomcat version is 5.0.27.
>
>The servlet that is causing this error is trying to access a database
>with the following code:
>
>protected IDatabaseConnection getConnection() throws Exception {
>
>
Please don't hijack other peoples threads. Create a new thread and also
post your web.xml stuff. Otherwise read my reply to the original post.
--David
Angel Cervera Claudio wrote:
Idem error to me, but with realm using DataSource:
problem is that DataSourceRealm can not find JNDI name in contex
I'm using Tomcat 5.0.28
El jue, 09-09-2004 a las 15:56, Angel Cervera Claudio escribió:
> Idem error to me, but with realm using DataSource:
> problem is that DataSourceRealm can not find JNDI name in context.
> There are a bug in tomcat 4.1, but this was resolved.
> My xml in Catalina/localhost c
Right. is used when you want to use a global resource in
your app. Not necessary when the resource is local to the app.
--David
Kelly C. Goedert wrote:
I thought I only needed if I had made the datasource
Global. Do I need it even if it is not declared globally?
QM wrote:
On Thu, Sep 09, 2
Idem error to me, but with realm using DataSource:
problem is that DataSourceRealm can not find JNDI name in context.
There are a bug in tomcat 4.1, but this was resolved.
My xml in Catalina/localhost content:
url
jdbc:mysql://localhost:3306/yeguadas?autoReconnect=true
Most of it looks good. driverClassName on a recent mysql jar should be
com.mysql.jdbc.Driver instead of the ancient org.gjt. stuff. The
mysql jar should be located in common/lib if you're using the container
supplied dbcp pooling. If you happen to move the mysql jar file, you'll
have to
I thought I only needed if I had made the datasource
Global. Do I need it even if it is not declared globally?
QM wrote:
On Thu, Sep 09, 2004 at 10:28:32AM -0300, Kelly C. Goedert wrote:
: I'm getting this error " Name jdbc is not bound in this Context" on my
: application. My tomcat version i
On Thu, Sep 09, 2004 at 10:28:32AM -0300, Kelly C. Goedert wrote:
: I'm getting this error " Name jdbc is not bound in this Context" on my
: application. My tomcat version is 5.0.27.
?
See the Tomcat docs for details.
-QM
--
software -- http://www.brandxdev.net
tech news -- http://www.Roa
Remove this from your ... definition:
You don't need it and it may interfere since you didn't define your data
as a global resource.
--David
Ben Halton wrote:
Hi,
I am getting the problem : "javax.naming.NameNotFoundException: Name jdbc is not bound in
this Context" using Tomcat 5.025.
I hav
Hi,
I think this might be because I have the .war file that is using the JNDI
connection pooling loading as the default context.
Because it is in the /webapps folder it is also loading as the /
context, even though I have nothing specified for this in server.xml.
But this one I have no JNDI reso
31 matches
Mail list logo