Datasource Configuration in JBoss

[Fady Matar]

I need to configure a datasource in JBoss using SQL Server. What are the related configurations file that need to be modified?

[Lasse Koskela]

Welcome to the JavaRanch, Fady!
Unfortunately, your post would be better posted in the JBoss forum so I'll ask someone to move this thread there.

[Andres Gonzalez]

Which JBoss version are u using?

[Fady Matar]

I'm using JBoss 3.2.2
Right now I am able to modify the default Datasource to run on SAP-DB and I have modified its JNDI name to be SapBD.
Everything works fine but I have the following ERROR on my server console
Can anyone tell me what is this error and how to solve it?
11:55:58,304 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
<none>
Incompletely deployed packages:
<none>
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
[ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
jboss.web:service=WebServer
Depends On Me: , ObjectName: jboss.mq:service=Invoker
state: DESTROYED
I Depend On: jboss.mq:service=TracingInterceptor
Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
jboss.mq:service=InvocationLayer,type=UIL2
jboss.mq:service=InvocationLayer,type=RMI
jboss.mq:service=InvocationLayer,type=JVM
jboss.mq:service=InvocationLayer,type=OIL
jboss.mq:service=InvocationLayer,type=UIL
jboss.mq:service=InvocationLayer,type=OIL2
, ObjectName: jboss.mq:service=TracingInterceptor
state: DESTROYED
I Depend On: jboss.mq:service=SecurityManager
Depends On Me: jboss.mq:service=Invoker
, ObjectName: jboss.mq:service=SecurityManager
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: jboss.mq:service=TracingInterceptor
jboss.mq.destination:service=Queue,name=DLQ
jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
, ObjectName: jboss.mq.destination:service=Queue,name=DLQ
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
state: DESTROYED
I Depend On: jboss.mq:service=DestinationManager
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
state: DESTROYED
I Depend On: jboss.mq:service=Invoker
Depends On Me: , ObjectName: jboss.mq:service=DestinationManager
state: CONFIGURED
I Depend On: jboss.mq:service=MessageCache
jboss.mq:service=PersistenceManager
jboss.mq:service=StateManager
Depends On Me: jboss.mq:service=SecurityManager
jboss.mq.destination:service=Queue,name=DLQ
jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq.destination:service=Queue,name=A
jboss.mq.destination:service=Queue,name=B
jboss.mq.destination:service=Queue,name=C
jboss.mq.destination:service=Queue,name=D
jboss.mq.destination:service=Queue,name=ex
, ObjectName: jboss.mq:service=PersistenceManager
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxCM,name=DefaultDS
Depends On Me: jboss.mq:service=DestinationManager

[Fady Matar]

I have just solved the problem! - in an MSSQL Datasource.
The problem was pretty simple All I needed is to get the JBoss Source Code and extract to the folder $JBOSS_HOME/server/default/deploy/jms the file mssql-jdbc2-service.xml.
However I can't find the file sapdb-jdbc2-service.xml
Does anybody have an idea where I can get it from?
Best Regards