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
