is there a standard way to define a JDBC Datasource for Java EE containers?

by

Is there a standard way to define a JDBC datasource and deploy it?

Yes, there is. It’s done via the <data-source> element, which you can put in web.xml, ejb-jar.xml and application.xml. If you don’t like XML, you can also use an annotation for this instead: @DataSourceDefinition

Example of a web.xml entry

<data-source>
    <name>java:app/myDS</name>
    <class-name>org.postgresql.xa.PGXADataSource</class-name>
    <server-name>pg.myserver.com</server-name>
    <database-name>my_db</database-name>
    <user>foo</user>
    <password>bla</password>
    <transactional>true</transactional>
    <isolation-level>TRANSACTION_READ_COMMITTED</isolation-level>
    <initial-pool-size>2</initial-pool-size>
    <max-pool-size>10</max-pool-size>
    <min-pool-size>5</min-pool-size>
    <max-statements>0</max-statements>
</data-source>

Further reading:

p.s. I’m surprised all other answers say this doesn’t exist, while it clearly does, even at the time this question was originally asked.

More Related Contents:

  1. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  2. Proper usage of JDBC Connection Pool (Glassfish)
  3. How to get the insert ID in JDBC?
  4. To prevent a memory leak, the JDBC Driver has been forcibly unregistered
  5. Is java.sql.Timestamp timezone specific?
  6. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  7. Why use @PostConstruct?
  8. JDBC connection failed, error: TCP/IP connection to host failed
  9. How can I get the SQL of a PreparedStatement?
  10. Is java.sql.Connection thread safe?
  11. How to create and handle composite primary key in JPA
  12. The meaning of NoInitialContextException error
  13. How does Java’s PreparedStatement work?
  14. Create a jTDS connection string
  15. How to get all table names from a database?
  16. Understanding JSF as a MVC framework
  17. Should I use java.util.Date or switch to java.time.LocalDate
  18. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  19. How do I use the Jersey JSON POJO support?
  20. Finding your application’s URL with only a ServletContext
  21. How are Threads allocated to handle Servlet request?
  22. How to reference JSF managed beans which are provided in a JAR file?
  23. MappedSuperclass – Change SequenceGenerator in Subclass
  24. java error (No suitable driver found)
  25. Cannot use a LIKE query in a JDBC PreparedStatement?
  26. Besides EAR and EJB, what do I get from a Java EE app server that I don’t get in a servlet container like Tomcat?
  27. MyBatis executing multiple sql statements in one go, is that possible?
  28. how to share a jsf error page between multiple wars
  29. A persistent connection with JDBC to MySQL
  30. Is package by feature approach good? [closed]

Leave a Comment