By the way, to avoid confusion...I know I can specify the datasource
in web.xml with Resin, for instance like this:
<web-app xmlns="http://caucho.com/ns/resin";
xmlns:resin="http://caucho.com/ns/resin/core";>
<database jndi-name="jdbc/HogwartsStore"/>
<driver>
<type>org.postgresql.Driver</type>
<url>jdbc:postgresql://127.0.0.1:5432/hogwarts_store</url>
<user>web</user>
<password>i19web</password>
</driver>
</database>
...
<servlet servlet-name="example.TestDatabase"
servlet-class="example.TestDatabase"/>
<servlet-mapping url-pattern="/TestDatabase"
servlet-name="example.TestDatabase"/>
...
</web-app>
But that is not what I am looking for. I am looking for a container
managed connection.
best regards
Audun
On 6/3/05, Audun V. Nes <[EMAIL PROTECTED]> wrote:
> Hi
>
> This actually more of a Resin 3 question than a DBForms question, but
> I take the chance of asking it here anyway, because if anyone of you
> are using Resin, you will quickly be able to answer it.
>
> I am trying to enable enable database lookup through JNDI, so in
> dbforms-config.xml, I have the following:
>
> <dbconnection
> name = "java:/comp/env/jdbc/DBASOL"
> isJndi = "true"
> />
>
> In resin.conf I have:
> database>
> <jndi-name>jdbc/DBASOL</jndi-name>
> <driver type="oracle.jdbc.driver.OracleDriver">
> <url>jdbc:oracle:thin:@overlord:1521:PROD</url>
> <user>website</user>
> <password>secret</password>
> </driver>
> <prepared-statement-cache-size>10</prepared-statement-cache-size>
> <max-connections>20</max-connections>
> <max-idle-time>30s</max-idle-time>
> </database>
>
> However, when running an application I get the following exception:
> 03 jun 2005 14:51:05,328 ERROR
> org.dbforms.taglib.DbFormTag.doCatch(DbFormTag.java:1094)
> DbFormTag.doCatch called - java.lang.IllegalArgumentException:
> JDBC-Troubles: was not able to create connection from DbConnection =
> id=null, name=java:/comp/env/jdbc/DBASOL, jndi=true, conClass=null,
> username=null, default=true
> java.lang.IllegalArgumentException: JDBC-Troubles: was not able to
> create connection from DbConnection = id=null,
> name=java:/comp/env/jdbc/DBASOL, jndi=true, conClass=null,
> username=null, default=true
> at
> org.dbforms.config.DbFormsConfig.getConnection(DbFormsConfig.java:130)
> at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:1222)
> at _jsp._index__jsp._jspService(_index__jsp.java:72)
> at com.caucho.jsp.JavaPage.service(JavaPage.java:63)
> at com.caucho.jsp.Page.pageservice(Page.java:570)
> at
> com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)
> at
> com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163)
> at
> com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
> at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259)
> at com.caucho.server.port.TcpConnection.run(TcpConnection.java:341)
> at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
> at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
> at java.lang.Thread.run(Thread.java:534)
>
> I might be missing something in web.xml ?
> When I set up database lookup through JNDI in Tomcat, I had to add the
> following to web.xml:
> <resource-ref>
> <description>Oracle Datasource</description>
> <res-ref-name>jdbc/DBASOL</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> But the same text in web.xml doesn't work with Resin, and the Resin
> docs are pretty limited on this area I think, so I am stuck.
>
> best regards
> Audun
>
--
best regards
Audun
-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
