[opencms-dev] need SQL connection example

[Jordi Martí]

You can get the java.sql connection that opencms provides through this
sentence:

java.sql.Connection con =
org.opencms.main.OpenCms.getSqlManager().getConnection(org.opencms.db.CmsDbP
ool.getDefaultDbPoolName());

You can use it directly in your jsp or in whatever servlet or class you
would like to use.

It's a good practice to create your jsp inside a module in opencms.
   
 
JORDI MARTÍ 
Email: jmarti _at_ theinit *dot. com

 
PRIVADO Y CONFIDENCIAL
Este mensaje va dirigido a la persona(s) indicada(s). Puede contener
información confidencial de carácter legal o personal de THE INIT SERVICES,
La transmisión errónea del presente mensaje en ningún momento supone
renuncia a su confidencialidad. Si el lector del mensaje no es el
destinatario indicado, o el empleado encargado de su entrega a dicha
persona, por favor, notifíquelo inmediatamente por teléfono y remita el
mensaje original a la dirección de correo electrónico indicada. Cualquier
copia o distribución de esta comunicación queda estrictamente prohibida.


 
 
 
 

-----Mensaje original-----
De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org]
En nombre de Christoph P. Kukulies
Enviado el: viernes, 29 de febrero de 2008 9:25
Para: Pere Torrodellas
CC: The OpenCms mailing list
Asunto: Re: [opencms-dev] need SQL connection example

On Fri, Feb 29, 2008 at 09:03:12AM +0100, Pere Torrodellas wrote:
> 
> ----- Original Message ----- 
> From: "Christoph P. Kukulies" <kuku at physik.rwth-aachen.de>
> To: <opencms-dev at opencms.org>
> Sent: Thursday, February 28, 2008 6:17 PM
> Subject: [opencms-dev] need SQL connection example
> 
> 
> >How would one start with a database application in OpenCms?
> >
> You just have to build your application as an OpenCms module. See the 
> documentation that comes with OpenCms to learn how to create a module.
> OpenCms has its own tables and definitions, and you build your own DB and 
> application.

Creating a module is not my problem. My problem is how I keep the
connection state during the session.
> 
> >How is a database context kept during a session?
> >
> >Would one use a bean?
> >
> You can do the same as  in any other Java application.
> 
> >Which API would one use?
> >
> Plain java.sql.*, unless you decide to use some framework (Ibatis, 
> Hibernate,...)
> 
> >I need a starting point and a bit of code. Advice welcome.


I picked a snippet out of from the archive:
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<sql:setDataSource
    driver="org.gjt.mm.mysql.Driver"
    url="jdbc:mysql://localhost:3306/steuer?autoReconnect=true"
    user="root"
    password="mysqlb3"
    scope="page"
    var="dir" />

Or would I better use java.sql.* and code it in java?
As said, I have no idea at the moment, what happens, when my code is
in a jsp template and the page reloads. How would be the technique to
store the fact that a connection is already made to the database?

I'm not yet familar with that technique despite of oving done some
java examples with a single jdbc request running in a self contained
java application.


> >
> The included documentation provides information and examples.

Also on SQL programming? I saw very little on this also in the 
list archives.

--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev