Thread: Re: Welcome to the pgsql-jdbc mailing list!
I have PostgreSQL 7.2.2 and (jdbc driver jdbc7.2dev-1.2.jar is located in /usr/share/pgsql/ ). I'm writing a project where I use technolgies like : Apache 1.3.27 + Tomcat 4.1.18 + Struts 1.x + ANT for XML files + Sun (default) J2EE 1.3.1 server. The problem is that I don't know how to set up PostgreSQL driver to be used with J2EE server (is it possible ?). I downloaded from the Sun site J2EETutorial, and bank example. To run this example I need use J2EE server, which is default delivered and configured with Cloudscape database. There is a file called $J2EE_HOME/config/resource.properties with settings for Cloudscape database. There is also a build.xml file in the bank directory which builds classes,jars,ears etc. from sources. Cloudscape setings are : <property name="cloud-lib" value="${myenv.J2EE_HOME}/lib/cloudscape" /> <property name="system-lib" value="${myenv.J2EE_HOME}/lib/system" /> <property name="cloud-path" value=".:${cloud-lib}/cloudclient.jar:${cloud-lib}/RmiJdbc.jar: ${system-lib}/cloudutil.jar:${system-lib}/cloudscape.jar"/> <property name="cloud-jvmargs" value="-ms16m -mx32m -Dij.connection.CloudscapeDB=jdbc:rmi://localhost:1099/jdbc:cloudscape: CloudscapeDB;create=true -Dcloudscape.system.home=${myenv.J2EE_HOME}\cloudscape" /> The whole thing is about how to change Cloudscape to PostgreSQL (ant config + resource.properties + JNDI in source files) ? I'll be very grsteful if anyone know the answer ! Greetings, Patryk
I have PostgreSQL 7.2.2 and (jdbc driver jdbc7.2dev-1.2.jar is located in /usr/share/pgsql/ ). I'm writing a project where I use technolgies like : Apache 1.3.27 + Tomcat 4.1.18 + Struts 1.x + ANT for XML files + Sun (default) J2EE 1.3.1 server. The problem is that I don't know how to set up PostgreSQL driver to be used with J2EE server (is it possible ?). I downloaded from the Sun site J2EETutorial, and bank example. To run this example I need use J2EE server, which is default delivered and configured with Cloudscape database. There is a file called $J2EE_HOME/config/resource.properties with settings for Cloudscape database. There is also a build.xml file in the bank directory which builds classes,jars,ears etc. from sources. Cloudscape setings are : <property name="cloud-lib" value="${myenv.J2EE_HOME}/lib/cloudscape" /> <property name="system-lib" value="${myenv.J2EE_HOME}/lib/system" /> <property name="cloud-path" value=".:${cloud-lib}/cloudclient.jar:${cloud-lib}/RmiJdbc.jar: ${system-lib}/cloudutil.jar:${system-lib}/cloudscape.jar"/> <property name="cloud-jvmargs" value="-ms16m -mx32m -Dij.connection.CloudscapeDB=jdbc:rmi://localhost:1099/jdbc:cloudscape: CloudscapeDB;create=true -Dcloudscape.system.home=${myenv.J2EE_HOME}\cloudscape" /> The whole thing is about how to change Cloudscape to PostgreSQL (ant config + resource.properties + JNDI in source files) ? I'll be very grsteful if anyone know the answer ! Greetings, Patryk
Hi everybody, I'm almost new to postgres.. I have an out of the box postgreSQL on Red Hat 7.3. I completed all the steps indicated on the Admins guide. I have done initdb <data - dir>.. and the files were created ... The point is when I try to start the postmaster... there is some indication DEBUG... and go to sleep, it takes for ever to say postgres database don't exist... Any idea please ?? Andrew
Andres Ledesma <aledes@telefonica.net> writes: > I have done initdb <data - dir>.. and the files were created ... The point is > when I try to start the postmaster... there is some indication DEBUG... and > go to sleep, it takes for ever to say postgres database don't exist... Please show us *exactly* what you typed and what responses you got. The above is too vague to let anyone offer much help. regards, tom lane ps: pgsql-jdbc is not the right place for this discussion, try pgsql-novice or pgsql-admin.
Patryk Kubiak wrote: > I have PostgreSQL 7.2.2 and (jdbc driver jdbc7.2dev-1.2.jar > is located in /usr/share/pgsql/ ). I'm writing a project where I use > technolgies like : Apache 1.3.27 + Tomcat 4.1.18 + Struts 1.x + ANT for > XML files + Sun (default) J2EE 1.3.1 server. > > The problem is that I don't know how to set up PostgreSQL driver > to be used with J2EE server (is it possible ?). Yes, it is possible. But J2EE is only standart. It is not server.Servers are Orion,BEA, IBM WebSphere and so on. > I downloaded from the Sun > site J2EETutorial, and bank example. To run this example I need > use J2EE server, which is default delivered and configured with > Cloudscape database. There is a file called $J2EE_HOME/config/resource.properties > with settings for Cloudscape database. There is also a build.xml > file in the bank directory which builds classes,jars,ears etc. from > sources. Cloudscape setings are : > > <property name="cloud-lib" value="${myenv.J2EE_HOME}/lib/cloudscape" /> > <property name="system-lib" value="${myenv.J2EE_HOME}/lib/system" /> > <property name="cloud-path" value=".:${cloud-lib}/cloudclient.jar:${cloud-lib}/RmiJdbc.jar: > ${system-lib}/cloudutil.jar:${system-lib}/cloudscape.jar"/> > <property name="cloud-jvmargs" value="-ms16m -mx32m -Dij.connection.CloudscapeDB=jdbc:rmi://localhost:1099/jdbc:cloudscape: > CloudscapeDB;create=true -Dcloudscape.system.home=${myenv.J2EE_HOME}\cloudscape" /> > > The whole thing is about how to change Cloudscape to PostgreSQL (ant > config + resource.properties + JNDI in source files) ? > It is not so easy.You will need to read much more about the SUN server. It will help you in feature. In principe you will need this steps: - read how to make jdbc connection to pg. (J2EE uses jdbc). - read the docs for SUN server to see where to put the jdbc library for pg. - read the docs for SUN server to see how to define the JNDI for the db. As I remember SUN server is not very easy for use. regards, iavn > I'll be very grsteful if anyone know the answer ! > > Greetings, > Patryk > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
Patryk Kubiak wrote: > > > I have PostgreSQL 7.2.2 and (jdbc driver jdbc7.2dev-1.2.jar > > > is located in /usr/share/pgsql/ ). I'm writing a project where I use > > > technolgies like : Apache 1.3.27 + Tomcat 4.1.18 + Struts 1.x + ANT for > > > XML files + Sun (default) J2EE 1.3.1 server. > > > > > > The problem is that I don't know how to set up PostgreSQL driver > > > to be used with J2EE server (is it possible ?). > > > > Yes, it is possible. But J2EE is only standart. It is not server.Servers are Orion,BEA, IBM WebSphere and so on. > > I send also email to Sun, they answer is below : > ************************************************************************** > Hi -- > > PostgreSQL is not a supported db for the J2EE SDK. > For supported db's, please see: > > http://java.sun.com/j2ee/sdk_1.3/techdocs/release/ReleaseNotes.html#9704 > > PostgresSQL may or may not work with the J2EE SDK-- but we haven't > tested it. > ************************************************************************** > Unfortunately it's only documented (Sun doc) how to use Oracle,Cloudscape > or MS SQL Server. There's is no information how to set up JNDI for > PostgreSQL. > I do not know.For me it is not connected to the db. As I wrote J2EE is only standart. Also I have used the SUN-server with ingres and it is similat with pg ( as I know). But the setup for each J2EE-server is not simpel. > > It is not so easy.You will need to read much more about the SUN server. It will help you in feature. > > > > In principe you will need this steps: > > - read how to make jdbc connection to pg. (J2EE uses jdbc). > > - read the docs for SUN server to see where to put the jdbc library for pg. > > - read the docs for SUN server to see how to define the JNDI for the db. > > > > As I remember SUN server is not very easy for use. > > regards, > > iavn > > thanks, for help > Patryk