jQuery in Action, 3rd edition
The moose likes JBoss/WildFly and the fly likes ms sql server2000 and jboss Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "ms sql server2000 and jboss" Watch "ms sql server2000 and jboss" New topic

ms sql server2000 and jboss

alec stewart stewart
Ranch Hand

Joined: Dec 23, 2003
Posts: 71
i am encountring the following problem
org.jboss.deployment.DeploymentException: Error: can't find data
source: SQLServerPool; - nested throwable: (javax.naming.NameNotFoundException:
SQLServerPool not bound)]

here are my following jbosscmp-jdbc.xml and mssql-ds.xml in the meta-inf folder

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!-- ========================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ========================================================== -->
<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ========================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ========================================================== -->

<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>

<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>


Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Makes sense. You seem to have named your DataSource "java:/SQLServerPool". Try "SQLServerPool" instead.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link: http://aspose.com/file-tools
subject: ms sql server2000 and jboss
It's not a secret anymore!