users@glassfish.java.net

Re: DataSource Issue

From: <glassfish_at_javadesktop.org>
Date: Mon, 19 Apr 2010 14:29:56 PDT

Yes. that's the right page. On the lower-right is a link "Create jdbc connection pool"

I just created a jdbc connectin pool, AND a associated datasource for sql server. I was able to see the corresponding elements in domain.xml:

<jdbc-connection-pool datasource-classname="com.microsoft.sqlserver.jdbc.SQLServerDataSource" res-type="javax.sql.DataSource" name="SQLPool">
      <property name="ApplicationName" value="Microsoft SQL Server 2005 JDBC Driver" />
      <property name="Encrypt" value="false" />
      <property name="LastUpdateCount" value="true" />
      <property name="LockTimeout" value="-1" />
      <property name="LoginTimeout" value="0" />
      <property name="PacketSize" value="8000" />
      <property name="Password" value="password1" />
      <property name="PortNumber" value="1433" />
      <property name="ResponseBuffering" value="full" />
      <property name="SelectMethod" value="direct" />
      <property name="SendStringParametersAsUnicode" value="true" />
      <property name="ServerName" value="localhost" />
      <property name="TrustServerCertificate" value="false" />
      <property name="URL" value="jdbc:sqlserver://" />
      <property name="User" value="user1" />
      <property name="XopenStates" value="false" />
    </jdbc-connection-pool>
    <jdbc-resource pool-name="SQLPool" jndi-name="jdbc/mysql" />
[Message sent by forum member 'cf126330']

http://forums.java.net/jive/thread.jspa?messageID=397905