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/share/java/postgresql-examples.jar java : j2sdk1.4.2_03 Regards, hiro - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JSP does not connect postgresql with jdbc
Do you pass the username and password to access the database? 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: Hiro [mailto:[EMAIL PROTECTED] :: Sent: Tuesday, March 30, 2004 12:03 AM :: To: [EMAIL PROTECTED] :: Subject: JSP does not connect postgresql with jdbc :: :: 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 :: :: :: 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]
RE: JSP does not connect postgresql with jdbc
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]