One of the many cool new features in Java EE 6, is support for the DataSourceDefinition annotation.

The DataSourceDefinition annotation provides a way to define a DataSource and register it with JNDI. The annotation provided annotation elements for the commonly used DataSource properties. Additional standard and vendor specific properties may also be specified.

So let us look at an example:

@DataSourceDefinition(name = "java:global/MyApp/myDS",

className = "org.apache.derby.jdbc.ClientDataSource",

portNumber = 1527,

serverName = "localhost",

databaseName = "testDB",

user = "lance",

password = "secret",

properties = {"createDatabase=create"}) )

The data source will be registered using the

One of the many cool new features in Java EE 6, is support for the DataSourceDefinition annotation.

The DataSourceDefinition annotation provides a way to define a DataSource and register it with JNDI. The annotation provided annotation elements for the commonly used DataSource properties. Additional standard and vendor specific properties may also be specified.

So let us look at an example:

@DataSourceDefinition(name = "java:global/MyApp/myDS",
className = "org.apache.derby.jdbc.ClientDataSource",
portNumber = 1527,
serverName = "localhost",
databaseName = "testDB",
user = "lance",
password = "secret",
properties = {"createDatabase=create"}) )

The data source will be registered using the value specified in the name

• Java DB/Apache Derby
• MYSQL Connector/J 5.1
• Oracle 11g
• inet software for Microsoft SQL Server(Merlia driver) and for Oracle (Oranxo driver).
• Atinav aveConnect 4.0 for Microsoft SQL Server
• DataDirect 3.7 has also introduced some JDBC 4.0 features

• Java DB/Apache Derby
• MYSQL Connector/J 5.1
• Oracle 11g
• inet software for Microsoft SQL Server(Merlia driver) and for Oracle (Oranxo driver).
• Atinav aveConnect 4.0 for Microsoft SQL Server
• DataDirect 3.7 has also introduced some JDBC 4.0 features