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 [EMAIL PROTECTED] it
would be greatly appreciated.
|
|
|
| >
| >
|
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3892139#3892139
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3892139
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
