Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jboss cmp sql server 2000  RSS feed

 
alec stewart stewart
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am using jboss 3.2.3 and sqlserver2000
my problem is that the tables are being created in master database although i have specified it to be in another database.i am clue less why is this happening.waiting for An early response
my datadirect-ds.xml is as follows:-

<?xml version="1.0" encoding="UTF-8"?>

<!-- =========================================================== -->
<!-- -->

<!-- DataDirect Data Sources -->
<!-- -->
<!-- =========================================================== -->

<!--
See the generic_ds.xml file in the doc/examples/jca folder
for examples of properties and other tags you can specify
in data sources
-->

<datasources>

<!-- JBossTest Data Source -->
<local-tx-datasource>

<jndi-name>ds/TestDS</jndi-name>
<connection-url>
jdbc:JSQLConnect://localhost:1433/databasename=jbossdb
</connection-url>
<driver-class>
com.jnetdirect.jsql.JSQLDriver
</driver-class>

<user-name>sa</user-name>
<password></password>

<!-- Driver Specific Options -->
<connection-property name="sendStringParametersAsUnicode">

false
</connection-property>

<!--pooling parameters-->
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>

<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>

</local-tx-datasource>

</datasources>
 
Rajesh K. Ilango
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
The datadirect-ds.xml would only create a data source that can be used by any application.

For it to be used by your application you will have to set it as the default Datasource in jbosscmp-jdbc.xml

e.g.
...
<jbosscmp-jdbc>

<defaults>
<datasource>java:/TestDS</datasource>
....
....
....


regards,
Rajesh K. Ilango
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!