Usually when connecting to the db you need to pass certain parameters which are: Driver, username, password and database url.
Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.com This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. :: -----Original Message----- :: From: Walter Truitt [mailto:[EMAIL PROTECTED] :: Sent: Tuesday, March 30, 2004 12:50 AM :: To: [EMAIL PROTECTED]; [EMAIL PROTECTED] :: Subject: Re: JSP does not connect postgresql with jdbc :: :: Not having used postgreSQL with JDBC yet, I would guess that the :: properties you are passing to create a DB Connection did not include :: the user property. This may be the username of the person running the :: server or something similar. :: :: If you are using a property file, a line like this might do: :: user=yui :: :: Otherwise, you could add a line to your program: :: props.put("user", "yui"); :: :: These properties are used in the DriverManager.getConnection() method. :: :: I usually also store the server URL in these properties, and do :: something like this: :: :: con = DriverManager.getConnection( :: props.getProperty("server"), props); :: :: -walter :: :: From: Hiro <[EMAIL PROTECTED]> :: Subject: JSP does not connect postgresql with jdbc :: Date: Tue, 30 Mar 2004 07:28:07 +0900 :: :: > HI! :: > :: > I am using JSP through JDBC with postgreSQL. But I can not connect :: > postgreSQL with JDBC. So I got a error message. The :: > message is "org.postgresql.util.PSQLException: The user property is :: > missing. It is mandatory. " :: > :: > Please give me a advice or help. :: > :: > :: > postgresql.jar and postgresql-examples.jar are generated by ANT. :: > :: > :: > :: > :: > The evironment is: :: > OS : Redhat8 :: > Kernel : 2.4.18-14 :: > Tomcat : tomcat-5.0.18 :: > PostgreSQL : postgresql-7.4 :: > ANT : apache-ant-1.6.1 :: > :: CLASSPATH=.:/usr/local/pgsql/share/java/postgresql.jar:/usr/local/pgsql/shar e/java :: /postgresql-examples.jar :: > java : j2sdk1.4.2_03 :: > :: > Regards, :: > hiro :: :: --------------------------------------------------------------------- :: To unsubscribe, e-mail: [EMAIL PROTECTED] :: For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
