[opencms-dev] Problems with SQL Server - JDBC Parameter errors

[Alexander Kandzior]

I think a fix for this is already available. Please see 

http://www.opencms.org/bugzilla/show_bug.cgi?id=91

if you (or someone else) can confirm that this fix actually solves the
MS-SQL issues then I would gladly apply it to the CVS and include it in the
next bugfix update (obviously 5.0.2). We at Alkacon do currently not work
with MS-SQL server so I have no way of testing these fixes.

Best Regards,
Alex.

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

> -----Original Message-----
> From: opencms-dev-admin at opencms.org 
> [mailto:opencms-dev-admin at opencms.org] On Behalf Of Geoff Winkless
> Sent: Wednesday, January 28, 2004 4:40 PM
> To: opencms-dev at opencms.org
> Subject: [opencms-dev] Problems with SQL Server - JDBC 
> Parameter errors
> 
> 
> Hi all
> 
> I'm using MS SQL Server with the MS JDBC drivers and keep 
> coming across problems with errors about invalid parameters 
> within OpenCMS. I found a couple of messages which suggest 
> changing the query.properties file in the 
> com/opencms/file/mssql directory.
> 
> So far I've commented out the SQLServer-specific entries for 
> C_RESOURCES_GET_SUBFOLDER and C_RESOURCES_GET_FILESINFOLDER, 
> which fix problems with deleting folders and getting files 
> (respectively).
> 
> So two questions.
> 
> First, is there a reason why these are "wrong"? Is it 
> specific to the MS drivers or to SQL Server in general?
> 
> Second, are there any more "known" changes I should make to 
> OpenCMS to work better with SQL Server?
> 
> Cheers
> 
> Geoff
> 
> 
> ______________________________________________________________
> __________
> This email has been scanned for all viruses by the 
> MessageLabs Email Security System. For more information on a 
> proactive email security service working around the clock, 
> around the globe, visit http://www.messagelabs.com 
> ______________________________________________________________
> __________
> _______________________________________________
> 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
> 
>