jdbc:postgresql:database not bound error

Поиск
Список
Период
Сортировка
От William I. Zumwalt
Тема jdbc:postgresql:database not bound error
Дата
Msg-id 20040929161715.28323.qmail@web52410.mail.yahoo.com
обсуждение исходный текст
Ответы Re: jdbc:postgresql:database not bound error
Список pgsql-jdbc
Hey all,

I'm using ...

JBoss 3.2.5
pg74.215.jdbc3.jar
postgres7.4.5

When I load my app in jboss, jboss sees postgres as

09:32:37,214 INFO  [PostgresDS] Bound connection
factory for resource adapter for ConnectionManager
'jboss.jca:service=LocalTxCM,name=PostgresDS to JNDI
name 'java:/PostgresDS'

And I'm getting the following error ...

10:36:26,231 INFO  [STDOUT] Exception:
jdbc:postgresql:megs not bound

Anyone have ideas what the prob could be. I've got the
following code below.

---
    public static final String DRIVER =
"org.postgresql.Driver";
    public static final String DBURL =
"jdbc:postgresql:megs";

                         // megs is my dbase name
    private static transient DataSource dataSource =
null;


    static {
        try {
            Class.forName(DRIVER);
        }
        catch(ClassNotFoundException cnfe) {

System.out.println("ClassNotFoundException: " +
cnfe.getMessage());
        }
    }

    public static Connection createConnection() throws
SQLException {
        if (dataSource == null) {
            try {
                Context context = new
InitialContext();
                dataSource = (DataSource)
context.lookup(DBURL);
            }
            catch (Exception e) {
                System.out.println("Exception: " +
e.getMessage());
            }
        }


        return dataSource.getConnection();
    }

Any help much appreciated.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: XA support in JDBC driver
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: jdbc:postgresql:database not bound error