[opencms-dev] MS-SQL Support

"De Gea García, Alfonso" adegea at chs.mma.es
Tue Sep 27 20:28:37 CEST 2005


Lots of thanks Michael.


-----Mensaje original-----
De: Michael Moossen [mailto:m.moossen at alkacon.com]
Enviado el: martes, 27 de septiembre de 2005 12:39
Para: The OpenCms mailing list
Asunto: RE: [opencms-dev] MS-SQL Support


Hi, Alfonso!
  the "right" way to use ours (and in general any) ant build file in eclipse is
using the ant view. the major benefit doing so is that you will have to
configure it once for all targets:

1. open the ant view: window -> show view -> other... -> ant
2. in the ant view, add your build files: right click on a clear area or the
first icon (l2r). 
3. double clic the target you want to execute, targets with a white circle as
icon are internal targets and should not be execute (you can hide them with the
3rd icon l2r)
4. at the first execution of a target in a new ant file a default configuration
is created, that can/should be edited: Run -> External Tools -> External
Tools... 
the name of the configuration is composed as following:
${PROJECT_NAME} ${BUILDFILE_NAME} ${OPTIONAL_INCREMENTAL_COUNTER}
5. for opencms you should configure it as following:
- disable Build -> Build before launch  
- disable Properties -> Use global properties as specified in the Ant runtime
preferences and add at least one property:
opencms.output=/path/to/build/opencms
6. for building a war file you just need to execute the war target nothing else
is needed (of course executing the clean target before executing the war target
could be helpful)

-- 
Regards
Michael Moossen

Alkacon Software GmbH - The OpenCms Experts
http://www.alkacon.com


Quoting "\"De Gea García, Alfonso\"" <adegea at chs.mma.es>:

> I've almost attained it.
> 
> As Andras Balogh said, you have to build a new war file using the build.xml
> file provided.
> This is achieved in eclipse as follows: select the build.xml file, right
> click, run as ->
> ant build (to modify attributes and launch).
> 
> I've checked the 'init, checklibs, compile and war' options.
> And in the end it seems the mssql support is working fine.
> 
> Thanks Shishank, A.Durga and Andras.
> 
> -----Mensaje original-----
> De: shishank.mathur at wipro.com [mailto:shishank.mathur at wipro.com]
> Enviado el: martes, 27 de septiembre de 2005 5:01
> Para: opencms-dev at opencms.org
> Asunto: RE: [opencms-dev] MS-SQL Support
> 
> 
> 
> Hi,
> 
> One more thing that you need to do is copy across the mssql folder from
> webapp\setup\database to the app server war location.
> 
> Kind Regards,
> Shishank
> http://goshishank.blogspot.com
> 
> 
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of apoorv.durga at wipro.com
> Sent: Monday, September 26, 2005 6:08 PM
> To: opencms-dev at opencms.org
> Subject: RE: [opencms-dev] MS-SQL Support
> 
> 
> I am not sure.
> 
> In our case, I manually copied it to the lib directory of 6.0. After that, I
> used tomcat target of build.xml to update the existing opencms 6.0
> installation with the newly compiled 6.0.1.
> 
> 
> 
> 
> 
> > -----Original Message-----
> > From: opencms-dev-bounces at opencms.org
> 
> > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of "De Gea
> 
> > García, Alfonso"
> > Sent: Monday, September 26, 2005 5:46 PM
> > To: The OpenCms mailing list
> > Subject: RE: [opencms-dev] MS-SQL Support
> >
> 
> > And, shall I have to change the build.xml file to make
> 
> > reference to the new added jtds.jar JDBC driver in order to
> 
> > build the war file? or any other configuration file as well?
> >
> 
> > Thank you.
> >
> 
> > -----Mensaje original-----
> > De: apoorv.durga at wipro.com [mailto:apoorv.durga at wipro.com]
> 
> > Enviado el: lunes, 26 de septiembre de 2005 14:05
> > Para: opencms-dev at opencms.org
> > Asunto: RE: [opencms-dev] MS-SQL Support
> >
> 
> >
> 
> >
> 
> > Download the patch. It is an xml file. Name it, say patch.xml
> >
> 
> > Open eclipse, select  your project. Right click, Teams ->
> 
> > apply patch and select the patch.xml
> >
> 
> > That's is all.
> >
> 
> > > -----Original Message-----
> > > From: opencms-dev-bounces at opencms.org
> >
> 
> > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of "De Gea
> >
> 
> > > García, Alfonso"
> > > Sent: Monday, September 26, 2005 5:19 PM
> > > To: The OpenCms mailing list
> > > Subject: RE: [opencms-dev] MS-SQL Support
> > >
> >
> 
> > > Hello,
> > > I have a basic question?
> > > How do I apply the patch?
> > >
> >
> 
> > > I've generated a new project with eclipse based on the
> >
> 
> > > OpenCms cvs repository and downloaded an copyied the
> >
> 
> > > jtds-1.1.jar into the webapp/WEB-INF/lib, but I don't know
> >
> 
> > > the way to patch OpenCms.
> > >
> >
> 
> > > When I downloaded the file attached to the bug 935 its name
> >
> 
> > > was something like 'attachement.cgi', but reading the file It
> >
> 
> > > seemed to be 'CmsBackupDriver.java'. Despite of that,
> >
> 
> > > whatever the name of the file was, what is the next step?
> > >
> >
> 
> > > Regards.
> > >
> >
> 
> > > -----Mensaje original-----
> > > De: apoorv.durga at wipro.com [mailto:apoorv.durga at wipro.com]
> >
> 
> > > Enviado el: viernes, 23 de septiembre de 2005 14:49
> > > Para: opencms-dev at opencms.org
> > > Asunto: RE: [opencms-dev] MS-SQL Support
> > >
> >
> 
> > >
> >
> 
> > >
> >
> 
> > >
> >
> 
> > > Hi,
> > > Yes we have been able to run MS SQL as suggested by Andras.
> > >
> >
> 
> > > Do you have a specific question?
> > >
> >
> 
> > > BR,
> > > /a
> > > http://apoorv.info
> > >
> >
> 
> > >
> >
> 
> > >
> >
> 
> > > > -----Original Message-----
> > > > From: opencms-dev-bounces at opencms.org
> > >
> >
> 
> > > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of "De Gea
> > >
> >
> 
> > > > García, Alfonso"
> > > > Sent: Friday, September 23, 2005 5:12 PM
> > > > To: opencms-dev at opencms.org
> > > > Subject: [opencms-dev] MS-SQL Support
> > > >
> > >
> >
> 
> > > > Hello,
> > > >
> > >
> >
> 
> > > > I'm wondering if there is an OpenCms *binary* distribution
> > >
> >
> 
> > > > with MS-SQL 2000 support, that's tho say, a binary exe (for
> > >
> >
> 
> > > > win32 systems) which you do not have to re-compile the
> >
> 
> > > source package.
> > > >
> > >
> >
> 
> > > > I have been reading the Andras Balogh how-to to apply his
> > >
> >
> 
> > > > patch. Has anyone applied it yet?
> > > >
> > >
> >
> 
> > > >
> > >
> >
> 
> > > > Kind regards and TIA.
> > > >
> > >
> >
> 
> > > >
> > >
> >
> 
> > > >
> > >
> >
> 
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> >
> 
> > >
> >
> 
> > >
> >
> 
> > >
> >
> 
> > > Confidentiality Notice
> > >
> >
> 
> > >
> >
> 
> > > The information contained in this electronic message and any
> >
> 
> > > attachments to this message are intended for the exclusive
> >
> 
> > > use of the addressee(s) and may contain confidential or
> >
> 
> > > privileged information. If you are not the intended
> >
> 
> > > recipient, please notify the sender at Wipro or
> >
> 
> > > Mailadmin at wipro.com immediately and destroy all copies of
> >
> 
> > > this message and any attachments.
> > >
> >
> 
> > >
> >
> 
> > > _______________________________________________
> > > 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
> > >
> >
> 
> > >
> >
> 
> > > _______________________________________________
> > > 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
> > >
> >
> 
> >
> 
> >
> 
> >
> 
> > Confidentiality Notice
> >
> 
> >
> 
> > The information contained in this electronic message and any
> 
> > attachments to this message are intended for the exclusive
> 
> > use of the addressee(s) and may contain confidential or
> 
> > privileged information. If you are not the intended
> 
> > recipient, please notify the sender at Wipro or
> 
> > Mailadmin at wipro.com immediately and destroy all copies of
> 
> > this message and any attachments.
> >
> 
> >
> 
> > _______________________________________________
> > 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
> >
> 
> >
> 
> > _______________________________________________
> > 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
> >
> 
> 
> 
> 
> Confidentiality Notice
> 
> 
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain confidential or privileged information. If you are not the intended
> recipient, please notify the sender at Wipro or Mailadmin at wipro.com
> immediately and destroy all copies of this message and any attachments.
> 
> 
> _______________________________________________
> 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
> 
> 
> 
> Confidentiality Notice
> 
> 
> The information contained in this electronic message and any attachments to
> this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or
> Mailadmin at wipro.com immediately
> and destroy all copies of this message and any attachments.
> 
> 
> _______________________________________________
> 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
> 
> 
> _______________________________________________
> 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
> 


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



_______________________________________________
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



More information about the opencms-dev mailing list