JNDI JDBC Datasource question
mattowen Aug 29, 2005 3:02 PM
I am having trouble getting my JDBC Datasource working properly and I was wondering if you might be able to assist. I'm sure it's something simple I'm missing. Here are the specifics. This is my entry in my web.xml: <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/SSOPool</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Here is my jboss-web.xml <jboss-web> <resource-ref> <res-ref-name>jdbc/SSOPool</res-ref-name> <res-type>javax.sql.DataSource</res-type> <jndi-name>java:/SSOPool</jndi-name> </resource-ref> </jboss-web> I have taken this verbatum out of the JBOSS AS guide example 3.10 and 3.12, simply replacing DefaultDS with SSOPool Question #1) Was this legal or is there something special about DefaultDS and I need to do that to SSOPool, my own ref name? When I ran the application, I get the following from the tomcat 55 log: >>>>>>>>>> getDataSourceName(): 'java:comp/env/jdbc/SSOPool' 13:43:31,617 INFO [STDOUT] >>>>>>>>>> jndi: 'java:comp/env/jdbc/SSOPool' 13:43:31,620 ERROR [BaseFilter] javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: SSOPool not bound] Here is the code that generated the above debug output and ERROR: try { String jndi = ServiceLocator.getDataSourceName( "SSOPool" ); System.out.println(">>>>>>>>>> jndi: '" + jndi + "'"); DataSource dataSource = ServiceLocator.getInstance().getDataSource( jndi ); System.out.println(">>>>>>>>>> got DataSource!"); <--- never gets to this line return dataSource.getConnection(); } catch ( Exception e ) { <---- this exception is caught! -----> log.error( e ); } return connection; public static String getDataSourceName( String name ) { System.out.println("\n>>>>>>>>>> getDataSourceName(): '" + "java:comp/env/jdbc/" + name + "'\n"); return "java:comp/env/jdbc/" + name; } Question #2) Am I doing something wrong here and if so, what do I need to change? Thanks in advance for any assistance. If you could please copy and response posted here to mlenkeit@smartonline.com it would be greatly appreciated. > >