```
@Target(value=TYPE)
 @Retention(value=RUNTIME)
public @interface DataSourceDefinition
```
Annotation used to define a container DataSource and be registered with JNDI. The DataSource may be configured by setting the annotation elements for commonly used DataSource properties. Additional standard and vendor-specific properties may be specified using the properties element.
The data source will be registered under the name specified in the name element. It may be defined to be in any valid Java EE namespace, and will determine the accessibility of the data source from other components.
A JDBC driver implementation class of the appropriate type, either DataSource, ConnectionPoolDataSource, or XADataSource, must be indicated by the className element. The availability of the driver class will be assumed at runtime.
DataSource properties should not be specified more than once. If the url annotation element contains a DataSource property that was also specified using the corresponding annotation element or was specified in the properties annotation element, the precedence order is undefined and implementation specific:
```
   @DataSourceDefinition(name="java:global/MyApp/MyDataSource",
      className="org.apache.derby.jdbc.ClientDataSource",
      url="jdbc:derby://localhost:1527/myDB;user=bill",
      user="lance",
      password="secret",
      databaseName="testDB",
      serverName="luckydog"
   )// DO NOT DO THIS!!!
 
```
In the above example, the databaseName, user and serverName properties were specified as part of the url property and using the corresponding annotation elements. This should be avoided.
If the properties annotation element is used and contains a DataSource property that was also specified using the corresponding annotation element, the annotation element value takes precedence. For example:
```
   @DataSourceDefinition(name="java:global/MyApp/MyDataSource",
      className="org.apache.derby.jdbc.ClientDataSource",
      user="lance",
      password="secret",
      databaseName="testDB",
      serverName="luckydog",
       properties= {"databaseName=myDB", "databaseProp=doThis"}
   )// DO NOT DO THIS!!!
 
```
Would result in the following values being used when configuring the DataSource:
- serverName=luckydog
- portNumber=1527
- databaseName=testDB
- user=lance
- password=secret
- databaseProp=doThis
Vendors are not required to support properties that do not normally apply to a specific data source type. For example, specifying the transactional property to be true but supplying a value for className that implements a data source class other than XADataSource may not be supported.
Vendor-specific properties may be combined with or used to override standard data source properties defined using this annotation.
DataSource properties that are specified and are not supported in a given configuration or cannot be mapped to a vendor specific configuration property may be ignored.
Examples:
```
   @DataSourceDefinition(name="java:global/MyApp/MyDataSource",
      className="com.foobar.MyDataSource",
      portNumber=6689,
      serverName="myserver.com",
      user="lance",
      password="secret"
   )
 
 
```
Using a URL:
```
  @DataSourceDefinition(name="java:global/MyApp/MyDataSource",
    className="org.apache.derby.jdbc.ClientDataSource",
    url="jdbc:derby://localhost:1527/myDB",
    user="lance",
    password="secret"
 )
 
```
An example lookup of the DataSource from an EJB:
```
 @Stateless
 public class MyStatelessEJB {
   @Resource(lookup="java:global/MyApp/myDataSource")
    DataSource myDB;
      ...
 }
 
```
Since:

Common Annotations 1.1

See Also:

DataSource, XADataSource, ConnectionPoolDataSource

Required Element Summary

Required Elements
Modifier and Type	Required Element and Description
`String`	`className` DataSource implementation class name which implements: `javax.sql.DataSource` or `javax.sql.XADataSource` or `javax.sql.ConnectionPoolDataSource`.
`String`	`name` JNDI name by which the data source will be registered.

Erste Seite von API Java Inhaltsverzeichnis Haut

Optional Element Summary

Optional Elements
Modifier and Type	Optional Element and Description
`String`	`databaseName` Name of a database on a server.
`String`	`description` Description of this data source
`int`	`initialPoolSize` Number of connections that should be created when a connection pool is initialized.
`int`	`isolationLevel` Isolation level for connections.
`int`	`loginTimeout` Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
`int`	`maxIdleTime` The number of seconds that a physical connection should remain unused in the pool before the connection is closed for a connection pool.
`int`	`maxPoolSize` Maximum number of connections that should be concurrently allocated for a connection pool.
`int`	`maxStatements` The total number of statements that a connection pool should keep open.
`int`	`minPoolSize` Minimum number of connections that should be allocated for a connection pool.
`String`	`password` Password to use for connection authentication.
`int`	`portNumber` Port number where a server is listening for requests.
`String[]`	`properties` Used to specify Vendor specific properties and less commonly used `DataSource` properties such as:
`String`	`serverName` Database server name.
`boolean`	`transactional` Set to `false` if connections should not participate in transactions.
`String`	`url` A JDBC URL.
`String`	`user` User name to use for connection authentication.

Erste Seite von API Java Inhaltsverzeichnis Haut

- Element Detail
  - name
```
public abstract String name
```
    JNDI name by which the data source will be registered.
    
    Since:
    
    1.1
- - className
```
public abstract String className
```
    DataSource implementation class name which implements: javax.sql.DataSource or javax.sql.XADataSource or javax.sql.ConnectionPoolDataSource.
    
    Since:
    
    1.1
- - description
```
public abstract String description
```
    Description of this data source
    
    Since:
    
    1.1
    
    Default:
    
    ""
- - url
```
public abstract String url
```
    A JDBC URL. If the url annotation element contains a DataSource property that was also specified using the corresponding annotation element, the precedence order is undefined and implementation specific.
    
    Since:
    
    1.1
    
    Default:
    
    ""
- - user
```
public abstract String user
```
    User name to use for connection authentication.
    
    Since:
    
    1.1
    
    Default:
    
    ""
- - password
```
public abstract String password
```
    Password to use for connection authentication.
    
    Since:
    
    1.1
    
    Default:
    
    ""
- - databaseName
```
public abstract String databaseName
```
    Name of a database on a server.
    
    Since:
    
    1.1
    
    Default:
    
    ""
- - portNumber
```
public abstract int portNumber
```
    Port number where a server is listening for requests.
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - serverName
```
public abstract String serverName
```
    Database server name.
    
    Since:
    
    1.1
    
    Default:
    
    "localhost"
- - isolationLevel
```
public abstract int isolationLevel
```
    Isolation level for connections. The Isolation level must be one of the following:
    - Connection.TRANSACTION_NONE,
    - Connection.TRANSACTION_READ_ UNCOMMITTED,
    - Connection.TRANSACTION_READ_COMMITTED,
    - Connection.TRANSACTION_REPEATABLE_READ,
    - Connection.TRANSACTION_SERIALIZABLE
    Default is vendor-specific.
    Since:
    
    1.1
    
    Default:
    
    -1
- - transactional
```
public abstract boolean transactional
```
    Set to false if connections should not participate in transactions.
    Default is to enlist in a transaction when one is active or becomes active.
    
    Since:
    
    1.1
    
    Default:
    
    true
- - initialPoolSize
```
public abstract int initialPoolSize
```
    Number of connections that should be created when a connection pool is initialized.
    Default is vendor-specific
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - maxPoolSize
```
public abstract int maxPoolSize
```
    Maximum number of connections that should be concurrently allocated for a connection pool.
    Default is vendor-specific.
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - minPoolSize
```
public abstract int minPoolSize
```
    Minimum number of connections that should be allocated for a connection pool.
    Default is vendor-specific.
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - maxIdleTime
```
public abstract int maxIdleTime
```
    The number of seconds that a physical connection should remain unused in the pool before the connection is closed for a connection pool.
    Default is vendor-specific
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - maxStatements
```
public abstract int maxStatements
```
    The total number of statements that a connection pool should keep open. A value of 0 indicates that the caching of statements is disabled for a connection pool.
    Default is vendor-specific
    
    Since:
    
    1.1
    
    Default:
    
    -1
- - properties
```
public abstract String[] properties
```
    Used to specify Vendor specific properties and less commonly used DataSource properties such as:
    - dataSourceName
    - networkProtocol
    - propertyCycle
    - roleName
    Properties are specified using the format: propertyName=propertyValue with one property per array element.
    If a DataSource property is specified in the properties element and the annotation element for the property is also specified, the annotation element value takes precedence.
    Since:
    
    1.1
    
    Default:
    
    {}
- - loginTimeout
```
public abstract int loginTimeout
```
    Sets the maximum time in seconds that this data source will wait while attempting to connect to a database. A value of zero specifies that the timeout is the default system timeout if there is one; otherwise, it specifies that there is no timeout.
    Default is vendor-specific.
    
    Since:
    
    1.1
    
    Default:
    
    0

Deutsche Übersetzung

Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.

Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.

Vielen Dank im Voraus.

Dokument erstellt 11/06/2005, zuletzt geändert 18/08/2025
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/java-api-javaee-rf-javax/annotation/sql/datasourcedefinition.html

Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.

Referenzen

Manuel PHP : https://docs.oracle.com/en/java/, Annotation Type DataSourceDefinition

Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor dieser Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.

Annotation Type DataSourceDefinition

Required Element Summary

Optional Element Summary

Element Detail

name

className

description

url

user

password

databaseName

portNumber

serverName

isolationLevel

transactional

initialPoolSize

maxPoolSize

minPoolSize

maxIdleTime

maxStatements

properties

loginTimeout

Referenzen