Subject: Re: Why use DAOFactory? Can't get connection From: Vic C <[EMAIL PROTECTED]> === news://news.basebeans.com:[EMAIL PROTECTED]
above is the conculsion by the same poster. (Friday OT: I was suposed to work on a paper for a client today. Can't wait for the Laker game in a bit where Yugos win. I propose that from now on, who ever posts most on a Friday be called the woden nickel (the 5th day) next week by the Struts mail list, as a sign of shame. At least next week I will be teching and not on this list.) Damien VIEL wrote: > Hi, > > Maybe this Thread will help you. > http://www.mail-archive.com/struts-user@jakarta.apache.org/msg30193.html > > Regards > Dams > ----- Original Message ----- > From: "Chen, Dean (Zhun)" <[EMAIL PROTECTED]> > To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> > Sent: Friday, May 24, 2002 10:37 PM > Subject: Why use DAOFactory? Can't get connection > > > >>Hi, >> >>I'm running into some issue with implementing a DAO. I see posts that some >>design use a DaoFactory, I don't understand the benefit of it. Is it >>possible to obtain connections instead of using a Factory? >> >>For example: >> >>In my XXXAction class, I have >> >>BeanDao beandao = new BeanDao(); >>beandao.executeQuery(sql, VO); >> >> >>The BeanDao extends BaseDao, which has the following, where name is >>"java:comp/env/jdbc/myDatasource" >> >>protected Connection getConnection(String name) throws >>DatabaseUnavailableException{ >>Connection conn = null; >>try { >>InitialContext ic = new InitialContext(); >> >>DataSource ds = (DataSource) ic.lookup(name); >> >>if (ds==null) >>throw new >>DatabaseUnavailableException("Cannot connect to database: "+name); >> >>try { >>conn = ds.getConnection(); >>} >>catch (SQLException e) { >>// log >>e.printStackTrace(); >>} >>} >>catch (NamingException e) { >>//e.printStackTrace(); >>} >>return conn; >>} >> >>This however, doesn't work, I get this error: >> >>java.sql.SQLException: No suitable driver >> at java.sql.DriverManager.getDriver(DriverManager.java:243) >> at >>tyrex.jdbc.xa.EnabledDataSource.getConnection(EnabledDataSource.java:233) >> at >>tyrex.jdbc.xa.EnabledDataSource.getConnection(EnabledDataSource.java:204) >> >>The even odder thing is that instead of >>DataSource ds = (DataSource) ic.lookup(name); >>I explicitly call using >>DataSource ds = (DataSource) >>ic.lookup("java:comp/env/jdbc/myDatasource"); >> >>I don't get the above SQL error, instead, I get a >>java.lang.NullPointerException when I try to use the connection. >> >>I'm using Tomcat 4.03 with Struts 1.1 + Sybase jconn2.jar >> >>If anyone can shed some light on this, I'd really appreciate it. I looked > > up > >>on the tomcat mailing-list archive and didn't see any solutions. >> >>Thanks, >> >>Dean Chen >> >> >> >>-- >>To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > >>For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > >> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>