You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Henning P. Schmiedehausen" <ma...@hometree.net> on 2001/04/25 18:03:31 UTC
Re: cvs commit: jakarta-turbine/conf/torque/templates/sql/security
Travis Low <tr...@dawnstar.org> writes:
>Dan said "-- ", not "--". "-- " is the most portable (as well as the butt-ugliest).
And I said:
>> MySQL 3.23.3 and above supports the `--' comment style only if the
>> comment is followed by a space. This is because this degenerate
there are lots and lots of 3.22 installations out there. All of them break.
Use /* */
Regards
Henning
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen -- Geschaeftsfuehrer
INTERMETA - Gesellschaft fuer Mehrwertdienste mbH hps@intermeta.de
Am Schwabachgrund 22 Fon.: 09131 / 50654-0 info@intermeta.de
D-91054 Buckenhof Fax.: 09131 / 50654-20
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: cvs commit: jakarta-turbine/conf/torque/templates/sql/security
Posted by Daniel Rall <dl...@finemaltcoding.com>.
"Henning P. Schmiedehausen" <ma...@hometree.net> writes:
> Travis Low <tr...@dawnstar.org> writes:
>
> >Dan said "-- ", not "--". "-- " is the most portable (as well as the butt-ugliest).
>
> And I said:
>
> >> MySQL 3.23.3 and above supports the `--' comment style only if the
> >> comment is followed by a space. This is because this degenerate
>
> there are lots and lots of 3.22 installations out there. All of them break.
>
> Use /* */
We had reports on the Scarab list of /* */ not working under certain
Windows configurations...
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: cvs commit: jakarta-turbine/conf/torque/templates/sql/security
Posted by Bruno Unna <br...@iac.com.mx>.
Jon Stevens wrote:
> on 4/25/01 9:03 AM, "Henning P. Schmiedehausen" <ma...@hometree.net>
> wrote:
>
>
>> Use /* */
>>
>> Regards
>> Henning
>
>
> Right, but I don't think /* */ is portable either...
>
For PostgreSQL (at least for the 7.1 version) both types of comments do
work, but in previous versions *the* way to comment was with "--".
From the official documentation of 7.1:
--- 8< ---
A comment is an arbitrary sequence of characters beginning with double
dashes and extending to the end of the line, e.g.:
-- This is a standard SQL92 comment
Alternatively, C-style block comments can be used:
/* multi-line comment
* with nesting: /* nested block comment */
*/
where the comment begins with /* and extends to the matching occurrence
of */. These block comments nest, as specified in SQL99 but unlike C, so
that one can comment out larger blocks of code that may contain existing
block comments.
A comment is removed from the input stream before further syntax
analysis and is effectively replaced by whitespace.
--- 8< ---
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
BEA Weblogic 6
Posted by Gareth Coltman <ga...@majorband.co.uk>.
Hi!
I know some of you guys have used BEA Weblogic before, so I wonder if you
know why I might get the following exception when trying to access my
servlet:
org.apache.turbine.services.InstantiationException: ServiceBroker: unknown
servi
ce TurbinePoolService requested
at
org.apache.turbine.services.BaseServiceBroker.getServiceInstance(Base
ServiceBroker.java:312)
at
org.apache.turbine.services.BaseServiceBroker.getService(BaseServiceB
roker.java:257)
at
org.apache.turbine.util.RunDataFactory.putRunData(RunDataFactory.java
:230)
at org.apache.turbine.Turbine.doGet(Turbine.java:488)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:213)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:1265)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:1622)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
DETAILS:
Weblogic 6 on W2K
It seems to me that the TurbineResources.props file wasn't loaded. I have
tried using both a relative (to the current dir and also the docbase) and
absolute paths to specify it in the web.xml file.
<param-name>properties</param-name>
<!-- This is relative to the docBase -->
<param-value>/bea/wlserver6.0sp1/config/rightmove/applications/devsite/WEB-I
NF/conf/TurbineResources.props
</param-value>
Also tried using a windows path like C:\asksak\skadaskjlsdakl\jkasdk
but no joy.
Has anyone experienced similar problems?
Gareth
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: cvs commit: jakarta-turbine/conf/torque/templates/sql/security
Posted by Jon Stevens <jo...@latchkey.com>.
on 4/25/01 9:03 AM, "Henning P. Schmiedehausen" <ma...@hometree.net>
wrote:
> Use /* */
>
> Regards
> Henning
Right, but I don't think /* */ is portable either...
-jon
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: cvs commit: jakarta-turbine/conf/torque/templates/sql/security
Posted by Jon Stevens <jo...@latchkey.com>.
on 4/25/01 9:03 AM, "Henning P. Schmiedehausen" <ma...@hometree.net>
wrote:
> Use /* */
>
> Regards
> Henning
Ok, Oracle supports /* */
You need to register to see this...but...
<http://technet.oracle.com/doc/server.815/a67779/ch2.htm#31715>
Comments Within SQL Statements
Comments within SQL statements do not affect the statement execution, but
they may make your application easier for you to read and maintain. You may
want to include a comment in a statement that describes the statement's
purpose within your application.
A comment can appear between any keywords, parameters, or punctuation marks
in a statement. You can include a comment in a statement using either of
these means:
* Begin the comment with a slash and an asterisk (/*). Proceed with the
text of the comment. This text can span multiple lines. End the comment with
an asterisk and a slash (*/). The opening and terminating characters need
not be separated from the text by a space or a line break.
* Begin the comment with -- (two hyphens). Proceed with the text of the
comment. This text cannot extend to a new line. End the comment with a line
break.
A SQL statement can contain multiple comments of both styles. The text of a
comment can contain any printable characters in your database character set.
Can other people confirm that their database supports /* */?
-jon
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org