Thread: jdbc:postgresql:database not bound error

jdbc:postgresql:database not bound error

From
"William I. Zumwalt"
Date:
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

Re: jdbc:postgresql:database not bound error

From
Oliver Jowett
Date:
William I. Zumwalt wrote:

> 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'

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

>     public static final String DBURL =
> "jdbc:postgresql:megs";

>                 Context context = new
> InitialContext();
>                 dataSource = (DataSource)
> context.lookup(DBURL);

Shouldn't you be doing a lookup of "java:/PostgresDS", not DBURL?

Either way, it sounds like a jboss/application config error, not a JDBC
driver error. You might want to try a jboss list if changing the lookup
doesn't help.

-O