[jboss-user] [JBoss Tools Users] - Re: How to create a JDBC connection

[Oliver Roell]

I know that JPA is the future of Java's database-access, but I want to use JDBC in my servlet.
There is an existing oracle-database from our SAP-system and I want to read customer-information with a select.

The "JMX Agent View" from JBoss displays under "jboss.jdbc":

datasource=DefaultDS,service=metadata
datasource=OracleDS,service=metadata

I think the deploying of the oracle-datasource was successful.

The book "EJB 3 in action" wrotes on page 148:
Moreover, application servers allow you to explicitly specify a global JNDI name using the mappedName parameter of the @Resource annotation. For example, if you are using the JBoss Application Server and you have a data source with a global JNDI name of java:/DefaultDS, you can specify the resource mapping as follows:


  | @Resource(name="jdbc/ActionBazaarDS", mappedName="java:/DefaultDS")
  | private javax.jdbc.DataSource myDB;
  | 

I do not know why the DataSource from "EJB 3 in action" belongs to the package javax.jdbc
I am working with the DataSource from the package javax.sql

In my servlet I have tried the following:


  | @Resource(name="jdbc/OracleDS", mappedName="java:/OracleDS")
  | private javax.sql.DataSource ds;
  | ...
  | Connection con = ds.getConnection();
  | Statement statement = con.createStatement();
  | ResultSet resultSet = statement.executeQuery("select...");
  | 

The ds object is always null. JBoss does not recognize the @Resource-annotation.

Do I miss something?

Do I still need a jbosscm-jdbc deployment descriptor in JBoss 4.2.3 when I work with annotations?



View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4253273#4253273

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4253273