users@glassfish.java.net

Re: Setup Glassfish v3 with MS SQLServer

From: <glassfish_at_javadesktop.org>
Date: Tue, 19 Jan 2010 16:45:19 PST

I still recognize strange behavior. If I deploy a simple EJB/Servlet Application which uses a datasource/pool created in the Admin Console, the deployment process creates a new Pool and modifies the JDBC Resource to use this new Pool. The new Pool name includes the Database name and the User name.

Database Server: MS SQLServer 2000
Database: pubs
User: SVApp
Driver: jTDS1.2.5

persistence.xml:
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
  <persistence-unit name="ServletStatelessPU" transaction-type="JTA">
    <jta-data-source>jdbc/jtssql</jta-data-source>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties/>
  </persistence-unit>
</persistence>

Name of JDBC Resource: jdbc/jtssql

Original Connection Pool: jtssqlpool

Created Connection Pool: jtds_sql_pubs_SVAppPool

From domain.xml:
<jdbc-connection-pool connection-validation-method="auto-commit" datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource" wrap-jdbc-objects="false" res-type="javax.sql.DataSource" name="jtds_sql_pubs_SVAppPool">
      <property name="URL" value="jdbc:jtds:sqlserver://xxx.xxx.xxx.xxx:1433/pubs" />
      <property name="Password" value="joe" />
      <property name="portNumber" value="1433" />
      <property name="databaseName" value="pubs" />
      <property name="User" value="SVApp" />
      <property name="serverName" value="xxx.xxx.xxx.xxx" />
      <property name="driverClass" value="net.sourceforge.jtds.jdbc.Driver" />
    </jdbc-connection-pool>

Deleting the driverClass Attribute and new deployment recreates the driverClass Attribute. New added attributes are preserved.

What kind of mechanism is that?
Can please someone help?
[Message sent by forum member 'sroeper' (roeper_at_roeperweise.de)]

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