Re: Sun J2EE server (default with J2EE package) + PostgreSQL jdbc

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