[opencms-dev] MySQL access from OpenCMS JSP / Java Bean

[Rene Hinojosa]

Greetings,

I've written a hack to the news  module a while back and implemented 
its own mysql access. It worked fine but using the opencms db 
connection pool would be more efficient. Just look at the 
ContentDefinition code (in the dbtab tutorial @ 
http://opencms.al-arenal.de) ContentDefinitions are basically Javabeans.

The setup and maintenance of using ContentDefinitons to handle db calls 
is a lot easier.

Regards,

Rene

On Wednesday, October 15, 2003, at 08:09 AM, ambiesense at gmx.de wrote:

> Hi,
>
> Backgroud information: I am using OpenCMS 5.0.0 with Tomcat 4.0.24 and 
> MySQL
> 4.0.13 on a Windows XP environment. I have a JSP file which calles a 
> Java
> Bean. The user accesses the JSP file, the JSP file basically forwards
> information to the Java Bean. The Java Bean does the main 
> functionality and returns
> the results to the JSP where it is displayed.
>
> Now I want to put some of the results into the MySQL database directly
> without using OpenCMS and its file structure. I am familiar with JDBC 
> and
> databases in Java. However I have some OpenCMS and MySQL related 
> questions:
>
> Is is possible to have several instances of MySQL?
> If yes, do I need to access the same instance as OpenCMS?
> If yes, how can I do that?
> Does somebody have a very simple portion of Java code of an example? I 
> think
> an example would solve all other questions here very easy :-)
>
> Thank you,
> Ralf
>
> -- 
> NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
> Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService
>
> Jetzt kostenlos anmelden unter http://www.gmx.net
>
> +++ GMX - die erste Adresse für Mail, Message, More! +++
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please 
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>