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

[wootenator]

I have the same question. I have an app written to Hypersonic and now need to translate the db configs to use SQL Server 2005 with jdts.

I have the following config but getting an error in the mbean code="org.jboss.jdbc.SQLServerDatabase" line. I just guessed at that. It used to say HypersonicDatabase:



   <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>
      mypass
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <idle-timeout-minutes>0</idle-timeout-minutes>
      <track-statements/>
      
         <type-mapping>SQL Server</type-mapping>
      
      jboss:service=MSSQL-db,database=mydb
   </local-tx-datasource>

   
     1701
     true
     mydb
     false
     true
   

   


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

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