Hellu there,
 
I am getting a bit frustrated as I don't seem to able to connect to my Postgres database, through the data-sources.xml file in the <home orion>/config dir.
 
I have seen about "all" newsgroup question about this issue but stilllll nothing...
 
Anyway, I do get the following error:
---
Fri Jan 26 16:09:57 GMT+01:00 2001   [warn] ERR: javax.naming.NameNotFoundException: jdbc/postgresPooledDS not found
---
 
I retrieve the name with the following code:
---
  try {
   javax.naming.InitialContext ic = new javax.naming.InitialContext();
   DataSource ds = (DataSource) ic.lookup("jdbc/postgresPooledDS");
  }
---
 
And I have the following data-sources.xml file:
----
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/d
tds/data-sources.dtd">
 
<data-sources>
        <data-source
                name="postgres"
                class="com.evermind.sql.DriverManagerDataSource"
                location="jdbc/postgresDS"
                pooled-location="jdbc/postgresPooledDS"
                xa-location="jdbc/xa/postgresXADS"
                ejb-location="jdbc/postgresEJBDS"
                connection-driver="postgresql.Driver"
                username="wwwunweb5"
                password="tpve1pw"
                url="jdbc:postgresql://localhost/wwwunweb5"
                inactivity-timeout="30"
                schema="database-schemas/postgresql.xml"
        />
</data-sources>
---
 
What am I doing wrong ??
I tried all the names (jdbc/postgresPooledDs, jdbc/postgresDS, etc..), but ... nothing.
 
BTW:
- I did put the postgres driver in  the <orion home>/lib dir (postgres.jar file). I have used this file to make a direct connection which works. The postgres.jar file is part of the J2EE_CLASSPATH variable.
- Where can I find good information about how to set this up ? Or can someone send this to me as there should an article one http://orionsupport.com/ but this server is unreachable ?
 
Please some help ??
 
Regards,
Ed Bras

Reply via email to