I try to set up a servlet to connect to a firebird database. It seams that I
can lookup the Datasource and get a Connection. I then create a Statement and
do executeQuery. I get back a ResulSset. The problem is that the ResultSet is
empty. Even though it shouldn't be.
I use the Firebird-ds.xml file from the example directory and have only altered
the database location, and sysdba password to fit my Firebird setup.
The firebirdsql.rar seams to be deployed OK.
The datasource shows in the jmx-web console JNDI view as java:FirbirdDS
My web.xml :
<web-app >
| <distributable/>
|
| <servlet>
| <servlet-name>Test</servlet-name>
| <display-name>Name for Test</display-name>
| <description><![CDATA[Description for Test]]></description>
| <servlet-class>MyTestServlet</servlet-class>
| </servlet>
|
| <servlet-mapping>
| <servlet-name>Test</servlet-name>
| <url-pattern>/A</url-pattern>
| </servlet-mapping>
|
| <resource-ref >
| <res-ref-name>/jdbc/FirebirdDS</res-ref-name>
| <res-type>javax.sql.DataSource</res-type>
| <res-auth>Container</res-auth>
| </resource-ref>
|
| </web-app>
|
|
My jboss-web.xml:
| <jboss-web>
|
| <context-root>/</context-root>
|
| <resource-ref>
| <jndi-name>java:FirebirdDS</jndi-name>
| <res-ref-name>/jdbc/FirebirdDS</res-ref-name>
| </resource-ref>
|
| </jboss-web>
|
The calling code in the servlet looks like this
| ...
| ServletContext cont=config.getServletContext();
| try {
| InitialContext context=new InitialContext();
| ds=(DataSource)context.lookup("java:/comp/env/jdbc/FirebirdDS");
| } catch (NamingException e) {
| e.printStackTrace();
| }
| ...
| try{
| Connection con=ds.getConnection("sysdba","masterkey");
| Statement stmt=con.createStatement();
| ResultSet res=stmt.executeQuery("select * from test");
| p.println("<table>");
| while(res.next()){
| String s=res.getString("FNAME");
| p.println("<tr><td>"+s+"</td></tr>");
| }
| p.println("</table>");
|
| }catch(java.sql.SQLException e){
| p.println("FrÃgan misslyckades"+e.getMessage());
| }
| ...
|
I use JBoss 4.00 with Tomcat servlet container. Sun Jdk1.5.0, Win2k
Firebird 1.51, JayBird 1.54
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3855367#3855367
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3855367
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
