[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Connecting to a database through named instance, mssql-ds

[wootenator]

Going to try and post the code again:

  | <datasources>
  | 
  |    <local-tx-datasource>
  |       <jndi-name>myDS</jndi-name>
  |       <connection-url>jdbc:jtds:sqlserver://mymachine:1433/MYDB</connection-url>
  |       <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
  |       <user-name>sa</user-name>
  |       <password>mypass</password>
  |       <min-pool-size>5</min-pool-size>
  |       <max-pool-size>20</max-pool-size>
  |       <idle-timeout-minutes>0</idle-timeout-minutes>
  |       <track-statements/>
  |       <metadata>
  |          <type-mapping>SQL Server</type-mapping>
  |       </metadata>
  |       <depends>jboss:service=MSSQL-db,database=mydb</depends>
  |    </local-tx-datasource>
  | 
  |    <mbean code="org.jboss.jdbc.SQLServerDatabase" 
  |      name="jboss:service=MSSQL-db,database=mydb">
  |      <attribute name="Port">1701</attribute>
  |      <attribute name="Silent">true</attribute>
  |      <attribute name="Database">labordb</attribute>
  |      <attribute name="Trace">false</attribute>
  |      <attribute name="No_system_exit">true</attribute>
  |    </mbean>
  | 
  |    </datasources>
  | 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4167174#4167174

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4167174