Ok the Bean is now deployed, but it seems I can get a connection from the
datasource, but somehow I cannot work with it:
ctx = new InitialContext();
| DataSource ds = (DataSource) ctx.lookup("java:/comp/env/jdbc/FencingDS");
| System.out.println(ds.toString());
| Connection con = (Connection) ds.getConnection();
| System.out.println("Connection is closed: " + con.isClosed());
| System.out.println(con.toString() + " " + con.getCatalog());
| Statement stmt = con.createStatement();
| ResultSet resultSet = stmt.executeQuery("SELECT * FROM fencer");
| while (resultSet.next()) {
| System.out.println(resultSet.getString("firstName"));
| System.out.println(resultSet.getString("lastName"));
| }
I know that the Select should work, because I have copied it from thy MySQL
console.
13:41:21,109 INFO [EJB3Deployer] Deployed: file:/C:/jboss-4.2.1.GA/server/defau
| lt/deploy/GeneralTest.jar
| 13:41:25,656 INFO [STDOUT] [EMAIL PROTECTED]
| dc4d5
| 13:41:25,656 INFO [STDOUT] Connection is closed: false
| 13:41:25,656 INFO [STDOUT] [EMAIL PROTECTED]
| b650a null
| 13:41:25,656 ERROR [STDERR] java.sql.SQLException: Table not found in
statement
| [SELECT * FROM fencer]
When I change the lookup to
anonymous wrote : DataSource ds = (DataSource) ctx.lookup("java:FencingDS");
everything works fine.
So I guess, I still have some problem with the mapping of the jndi-Names.
Can somebody help me out with this problem please?
Thanks,
Hans
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4098265#4098265
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4098265
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
