Hi,
I am trying to create a connection pool for Microsoft Drivers for JDBC. These are the steps I have followed.
I have created a jbossappjdbc-service.xml. The contents are as follows:
<?xml version="1.0" encoding="UTF-8"?>
com.microsoft.jdbc.sqlserver.SQLServerDriver
JBossCodeGen
com.microsoft.jdbcx.sqlserver.SQLServerDataSource
jdbc:microsoft:sqlserver://calkeyuslab1:1433;DatabaseName=JBossCodeGen
sa
1200000 10
false
false
false
true
120000 1800000
false
true
1.0
1
I have deployed it in the server\default\deploy directory. When I start JBoss I can see that it is deploying the service file but it does not create any connection pool or the datasource context. Can anyone tell me what the problem is and if there are any links about configuring connection pool etc. in JBoss.
You are trying to use 2.4 config with 3.0
Look in folder ${jboss.home}/docs/examples/jca
Regards,
Adrian