Weblogic, sql-taglib and JNDI: DataSource invalid: No suitable driver found

On a Weblogic 10 environment, you may get an error like
javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: „java.sql.SQLException: No suitable driver found for jndi_ds
if you are using the sql-taglib to access your JNDI name from the Weblogic application server, configured via the Weblogic console.

The solution is quiet simple, but not that good documented. It is not possible to use the paramter „driver“ inside the sql:setDataSource – tag. You rather have to promote the JNDI name in your web.xml like this:

<resource-ref>
<res-ref-name>jndi_ds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

Than you can set the dataSource with the sql:setDataSource – tag like this:

<sql:setDataSource dataSource="jndi_ds" />

and finally use the sql-taglib as you did in any other environment like Tomcat server and so on.

Software Update: Windows Process Hacker

Process Hacker is a free and open source process viewer and memory editor with unique features such as powerful process termination and a Regex memory searcher. It can show services, processes and their threads, modules, handles and memory regions.

It requires Microsoft Windows XP SP2 or above, 32-bit or 64-bit and the .net Framework 2.0.

Download @ Sourceforge: http://sourceforge.net/processhacker

How to export only changed files of a SVN revision

1. Using TortoiseSVN, right-click on your working folder and select “Show Log” from the TortoiseSVN menu.
2. Click the revision that was last published, e.g. rev 123. This is your „base“ revision.
3. Ctrl+Click the HEAD or latest revision or the revision you want to release, e.g. rev 200 — so that both revisions are highlighted.
4. Right-click on either of the highlighted revisions and select “Compare revisions.” This will open a dialog window that lists all new/modified files.
5. Select all files from this list (Ctrl+a) then right-click on the highlighted files and select “Export selection to…”