Re: [sandbox/OpenPGP] Encryption capabilities

2012-08-25 Thread Dennis Lundberg
On 2012-08-23 16:00, Matt Benson wrote:
> FWIW, [openpgp] started as a brainchild of the Ant and Maven PMCs, IIRC.  :)

Yes, I did some local changes on it a while back, but haven't
contributed them back yet. I had grand plans to make a Maven plugin on
top of opengpg, but unfortunately haven't had the time for it yet.

> 
> Matt
> 
> On Thu, Aug 23, 2012 at 8:50 AM, Stefan Bodewig  wrote:
>> On 2012-08-22, Christopher Schultz wrote:
>>
>>> Are there any plans or is there any interest in the sandbox's OpenPGP
>>> project to support encryption (or decryption)?
>>
>> I think the component is pretty much dormant and wouldn't expect any
>> plans at all.  Feel free to revive it 8-)
>>
>>> I'm building a tool on top of Apache Ant and I'd like to be able to
>>> support PGP operations -- specifically file encryption -- and this
>>> project seems like a likely place for such things to live.
>>
>> Sounds right.
>>
>> Stefan
> 
> -----
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: [xml-rpc] How to use ssl in client and server?

2011-04-25 Thread Dennis Lundberg
Hi

Apache Commons consists of several components. Which component are you
asking about?

Kurt Xu skrev 2011-04-25 03:41:
> Hi all:
>there's so few material about ssl usage on the official website, all
> of existing example is just incomplete. Who can offer me an complete
> sample of using ssl in both client and server side?
> 
>I've spent 2 days googling.
> 
>thanks.
> 
> 
> Kurt
> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: [logging] Problem with Eclipse infocenter WAR file - org.apache.commons.logging.LogConfigurationException: No suitable Log constructor

2011-02-08 Thread Dennis Lundberg
apperValve.invoke(StandardWrapperValve.java:230)
>   at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:173)
>   at 
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
>   at 
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
>   at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>   at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
>   at 
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
>   at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>   at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
>   at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
>   at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
>   at 
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
>   at java.lang.Thread.run(Thread.java:619)
> Caused by: org.apache.commons.logging.LogConfigurationException: No
> suitable Log constructor [Ljava.lang.Class;@cfd22a for
> org.apache.commons.logging.impl.Log4JLogger (Caused by
> java.lang.NoClassDefFoundError: org/apache/log4j/Category)
>   at 
> org.apache.commons.logging.impl.LogFactoryImpl.getLogConstructor(LogFactoryImpl.java:413)
>   at 
> org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
>   ... 34 more
> Caused by: java.lang.NoClassDefFoundError: org/apache/log4j/Category
>   at java.lang.Class.getDeclaredConstructors0(Native Method)
>   at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
>   at java.lang.Class.getConstructor0(Class.java:2699)
>   at java.lang.Class.getConstructor(Class.java:1657)
>   at 
> org.apache.commons.logging.impl.LogFactoryImpl.getLogConstructor(LogFactoryImpl.java:410)
>   ... 35 more
> Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Category
>   at 
> org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:506)
>   at 
> org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
>   at 
> org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
>   at 
> org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
>   at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
>   ... 40 more
> 
> On Thu, Feb 3, 2011 at 5:10 PM, Dennis Lundberg  wrote:
>> On 2011-02-03 22:55, Peter Desjardins wrote:
>>> Hi. I am trying to run the Eclipse infocenter as a WAR file and I'm
>>> seeing problems when using JBoss 4.2.0 EAP CP05. The WAR application
>>> runs fine using Tomcat 6.0 and JBoss 4.0.1. The Eclipse infocenter is
>>> the user assistance component of the Eclipse IDE. I packaged it as a
>>> WAR file as described here (http://bit.ly/gw85YN).
>>
>> First thing to check is if JBoss 4.2.0 has its own copy of
>> commons-logging somewhere. That JAR would then be in a different class
>> loader than the JAR that you put inside your WAR. If that is the case
>> then you either need to put a copy of log4j inside JBoss class path, or
>> you try to replace the JBoss commons-logging JAR with the official
>> Apache Commons Logging version 1.1.1. That version has much better error
>> reporting on issues like these.
>>
>>>
>>> The Eclipse infocenter WAR file includes this JAR file:
>>> org.apache.commons.logging_1.0.4.v201005080501.jar. I'm using Windows
>>> XP and jdk1.6.0_18.
>>>
>>> The error I see is pasted below. It occurs when I try to open the
>>> application in a browser for the first time.
>>>
>>> 15:41:32,468 ERROR [ContainerBase] Servlet.service() for servlet
>>> equinoxbridgeservlet threw exception
>>> org.apache.commons.logging.LogConfigurationException:
>>> org.apache.commons.logging.LogConfigurationException: No suitable Log
>>> constructor [Ljava.lang.Class;@1e4d960 for
>>> org.apache.commons.logging.impl.Log4JLogger (Caused by
>>> java.lang.NoClassDefFoundError: org/apache/log4j/Category) (Caused by
>>> org.apache.commons.logging.LogConfigurationException: No suitable Log
>>> constructor [Ljava.lang.Class;@1e4d960 for
>>> org.apache.commons.logging.impl.Log4JLogger (Caused by
>>> java.lang.NoClassDefFoundError: org/apache/log4j/Category))
>

Re: [logging] Problem with Eclipse infocenter WAR file - org.apache.commons.logging.LogConfigurationException: No suitable Log constructor

2011-02-03 Thread Dennis Lundberg
On 2011-02-03 22:55, Peter Desjardins wrote:
> Hi. I am trying to run the Eclipse infocenter as a WAR file and I'm
> seeing problems when using JBoss 4.2.0 EAP CP05. The WAR application
> runs fine using Tomcat 6.0 and JBoss 4.0.1. The Eclipse infocenter is
> the user assistance component of the Eclipse IDE. I packaged it as a
> WAR file as described here (http://bit.ly/gw85YN).

First thing to check is if JBoss 4.2.0 has its own copy of
commons-logging somewhere. That JAR would then be in a different class
loader than the JAR that you put inside your WAR. If that is the case
then you either need to put a copy of log4j inside JBoss class path, or
you try to replace the JBoss commons-logging JAR with the official
Apache Commons Logging version 1.1.1. That version has much better error
reporting on issues like these.

> 
> The Eclipse infocenter WAR file includes this JAR file:
> org.apache.commons.logging_1.0.4.v201005080501.jar. I'm using Windows
> XP and jdk1.6.0_18.
> 
> The error I see is pasted below. It occurs when I try to open the
> application in a browser for the first time.
> 
> 15:41:32,468 ERROR [ContainerBase] Servlet.service() for servlet
> equinoxbridgeservlet threw exception
> org.apache.commons.logging.LogConfigurationException:
> org.apache.commons.logging.LogConfigurationException: No suitable Log
> constructor [Ljava.lang.Class;@1e4d960 for
> org.apache.commons.logging.impl.Log4JLogger (Caused by
> java.lang.NoClassDefFoundError: org/apache/log4j/Category) (Caused by
> org.apache.commons.logging.LogConfigurationException: No suitable Log
> constructor [Ljava.lang.Class;@1e4d960 for
> org.apache.commons.logging.impl.Log4JLogger (Caused by
> java.lang.NoClassDefFoundError: org/apache/log4j/Category))
> 
> I've tried adding log4j.jar and a log4j.xml file in my WAR file as
> described here:
> http://osdir.com/ml/jakarta.log4j.user/2003-08/msg00210.html. That did
> not help. I'm not sure my log4j.xml file was configured correctly but
> using it didn't change the error message at all.
> 
> Can anyone suggest a possible cause for this problem? If this isn't a
> commons-logging issue, can you tell me where I might look?
> 
> Thanks for your help.
> 
> Peter Desjardins
> 
> -----
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: Bug with StringEscapeUtilities' escapeHTML/unescapeHTML for certain characters

2010-12-18 Thread Dennis Lundberg
On 2010-12-18 09:07, Burt Leung wrote:
> Hello,
> 
> I recently used the StringEscapeUtilities to encode/decode a character
> into its equivalent HTML entity. While I haven't used it much I do
> notice that a couple cases in particular seem "wrong".
> 
> case1: StringEscapeUtils.escapeHtml4("ä")
> This appears to give "ã". This should actually be "ä".
> 
> case2: StringEscapeUtils.escapeHtml4("å");
> This gives "å" but should actually be "ã".

This one is correct "å" should give "å"

> Using the unescape functional also gives the (incorrect) reverse results.
> 
> Is this an actual bug or am I missing something?
> 
> Thanks,
> Burt
> 
> -----
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: [lang] common-lang3 mvn repo

2010-11-04 Thread Dennis Lundberg
On 2010-11-04 11:18, JammyZ wrote:
> Hi,
>   I am using the 3.0-SNAPSHOT of commons-lang3 and it seems like something
> changed in the repository yesterday.
>   See the dates at
> https://repository.apache.org/content/repositories/snapshots/org/apache/commons/commons-lang3/3.0-SNAPSHOT/
> 
>   However the version has not changed, it is the same since September.
> Someone from my team just checked out our project yesterday and this library
> wouldn't download. I've not had the time to look at why yet, but it seems
> strange that the files have changed if the version has not changed, possible
> tampering?

It is the checksum files that have changed, not the artifact itself.
Perhaps someone is running a maintenance job on the Nexus instance (the
repository manager we use) at repository.apache.org?

> 
> Regards,
> Iker.
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: [dbcp] connection error while querying to db after being 7+ hours idle.

2010-07-23 Thread Dennis Lundberg
On 2010-07-22 23:48, Minhaj wrote:
> Hi Dennis,
> 
> Thanks for your reply.
> 
> Well, some one told me to put the testWhileIdle property true but it's not
> working for me still same issue; no luck :(
> 
> Secondly, You must be talking about "minEvictableIdleTimeMillis" property?
> Aren't you?

No, I don't use DBCP. I was referring to a feature we have in our home
made connection pool. That feature allows you to have a validation tread
run that periodically runs a validation query to make sure the
connections in the pool are kept alive. For MySQL we use the value
"SELECT 1" for this validation query.

As Mark hinted in his reply there is an option in DBCP called
"validationQuery" that you can use. The difference is that in DBCP this
query runs every time you get a connection from the pool.

> 
> Following is my setting for "minEvictableIdleTimeMillis" property.
> # The minimum amount of time an object may sit idle in the pool before it is
> # eligable for eviction by the idle object evictor (if any).
> # [Default: 18 (30 min)]
> dbcp.minEvictableIdleTimeMillis=18
> Here you can find the complete configuration details.
> http://commons.apache.org/dbcp/configuration.html
> 
> So rather then DBCP what do use? what are your recommendation? c3p0? my
> application is a spring+hibernate based app.
> 
> 
> Kind Regards
> 
> Minhaj
> 
> PS: for your information my application is a mulithreaded application where
> lots of threads running concurrently.
> 
> On Fri, Jul 23, 2010 at 12:50 AM, Dennis Lundberg wrote:
> 
>> On 2010-07-21 07:37, Minhaj wrote:
>>> Hi,
>>>
>>> I'm facing the following problem when I'm trying to access database in
>> the
>>> morning. which means after use application after being 7+ hours idle. I
>> even
>>> tried to append autoReconnect=true into db connection string but no luck
>> yet
>>> :( and the most strangest thing is that this error rise only once in very
>>> first query, but when i try next time it works perfectly alright.
>>>
>>> Anyone ever faced such issue?
>>
>> Yes. What happens is that the MySQL server closes the connecion at the
>> server end, due to it not being used for an extended period of time. In
>> our experience this timeout is 8 hours. The server does not notify DBCP
>> or the calling application. So you end up with a JDBC connection on the
>> Java end that is unusable.
>>
>> What you need to do is make sure that each connection in the pool is
>> used every 8 hours or less. I don't use DBCP myself, but there usually
>> is a timer you can set in  a connection pool that runs a really simple
>> keep-alive query in a given interval.
>>
>>>
>>>
>>> 2010-07-21 07:00:48,554  WARN (JDBCExceptionReporter.java:100)
>>> [org.hibernate.util.JDBCExceptionReporter, logExceptions] - SQL Error: 0,
>>> SQLState: 08S01
>>> 2010-07-21 07:00:48,555 ERROR (JDBCExceptionReporter.java:101)
>>> [org.hibernate.util.JDBCExceptionReporter, logExceptions] - The last
>> packet
>>> successfully received from the server was 677,246,024 milliseconds ago.
>>  The
>>> last packet sent successfully to the server was 677,246,024 milliseconds
>>> ago. is longer than the server configured value of 'wait_timeout'. You
>>> should consider either expiring and/or testing connection validity before
>>> use in your application, increasing the server configured values for
>> client
>>> timeouts, or using the Connector/J connection property
>> 'autoReconnect=true'
>>> to avoid this problem.
>>>
>>>
>>>
>>> Thanks are in advance.
>>>
>>
>>
>> --
>> Dennis Lundberg
>>
>> -
>> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
>> For additional commands, e-mail: user-h...@commons.apache.org
>>
>>
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: [dbcp] connection error while querying to db after being 7+ hours idle.

2010-07-22 Thread Dennis Lundberg
On 2010-07-21 07:37, Minhaj wrote:
> Hi,
> 
> I'm facing the following problem when I'm trying to access database in the
> morning. which means after use application after being 7+ hours idle. I even
> tried to append autoReconnect=true into db connection string but no luck yet
> :( and the most strangest thing is that this error rise only once in very
> first query, but when i try next time it works perfectly alright.
> 
> Anyone ever faced such issue?

Yes. What happens is that the MySQL server closes the connecion at the
server end, due to it not being used for an extended period of time. In
our experience this timeout is 8 hours. The server does not notify DBCP
or the calling application. So you end up with a JDBC connection on the
Java end that is unusable.

What you need to do is make sure that each connection in the pool is
used every 8 hours or less. I don't use DBCP myself, but there usually
is a timer you can set in  a connection pool that runs a really simple
keep-alive query in a given interval.

> 
> 
> 2010-07-21 07:00:48,554  WARN (JDBCExceptionReporter.java:100)
> [org.hibernate.util.JDBCExceptionReporter, logExceptions] - SQL Error: 0,
> SQLState: 08S01
> 2010-07-21 07:00:48,555 ERROR (JDBCExceptionReporter.java:101)
> [org.hibernate.util.JDBCExceptionReporter, logExceptions] - The last packet
> successfully received from the server was 677,246,024 milliseconds ago.  The
> last packet sent successfully to the server was 677,246,024 milliseconds
> ago. is longer than the server configured value of 'wait_timeout'. You
> should consider either expiring and/or testing connection validity before
> use in your application, increasing the server configured values for client
> timeouts, or using the Connector/J connection property 'autoReconnect=true'
> to avoid this problem.
> 
> 
> 
> Thanks are in advance.
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: FaltFile.jar

2010-01-06 Thread Dennis Lundberg
Jörg Schaible wrote:
> Matt Benson wrote:
> 
>> FWIW, there is a [flatfile] M2 snapshot published at
>> repository.apache.org.
> 
> Which should be definitely not there! Only official reelases can go to the 
> repository.

repository.apache.org contains several separate repositories, for
snapshots and releases. This SNAPSHOT is published in the repository
called "Snapshots" so it is fine.

> - Jörg
> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: DBCP woes (running out of cursors).

2009-10-14 Thread Dennis Lundberg
Bill Davidson wrote:
> Redhat 5.2 Server
> Java: Sun JDK 1.6.0_16 (64-bit)
> Tomcat 6.0.20 (and whichever version of DBCP that includes)
> Oracle 10g  (10.2.0.3)
> JDBC: ojdbc14.jar
> 
> I've been trying to convert an old J2EE application to use DBCP connection
> pools from an old custom connection pool class (not a DataSource
> interface).
> 
> The old pool worked acceptably, and DBCP seemed to work fine in
> development, but then I got it into a test environment and had a bunch
> of people beating on it and I started running out of cursors.  Looking
> through the old code, it turns out that the old pool manager, when
> freeing a Connection, had kept track of when it created that Connection
> and if it was more than 120 seconds old, it closed it and made a new one.
> As a result, a given Connection wouldn't hit the cursor limit because it
> wouldn't get reused for more than 2 minutes.
> 
> So, I think: "We must have code that's not closing ResultSet/Statement
> objects" so I go off looking for them.  With a little research, I come up
> with queries like this:
> 
> SELECT a.sid,
>   b.status,
>   b.osuser,
>   b.machine,
>   to_char(b.logon_time, 'dd-mon- hh24:mi:ss') logon_time,
>   a.user_name,
>   a.sql_id,
>   a.sql_text
>  FROM v$session b,
>   v$open_cursor a
> WHERE a.sid = b.sid
>   AND a.user_name = 'APPUSERNAME'
> ORDER BY upper(a.sql_text),
> b.status;
> 
> SELECT count(a.sql_text) count,
>   a.sql_text
>  FROM v$session b,
>   v$open_cursor a
> WHERE a.sid = b.sid
>   AND a.user_name = 'APPUSERNAME'
>   AND b.status = 'INACTIVE'
> GROUP BY a.sql_text
> ORDER BY count desc,
> upper(a.sql_text);
> 
> I run these against production (which is still using the old pools) and
> I find all sorts of queries lying around on inactive sessions, which
> I'm guessing are Connections that were closed.  I then start tracking
> the SQL down and every single one has an iron clad close() call in
> a "finally" clause.  There is absolutely no way the close() is not being
> called on the Statement objects.  Many of them even explicitly close()
> the ResultSet objects even though that should be handled by closing
> the Statement objects.  These close() calls are happening immediately
> after the data is gathered from the ResultSet's.
> 
> I then went looking in active sessions in the test environment and it's
> the same thing.  I can't find any lingering cursors for SQL that doesn't
> have a Statement.close() call that's guaranteed to run.  I've got lots
> of open cursors.  I can't explain why.
> 
> The config I'm using for DBCP (other than connection info):
>  maxActive="245"
>  maxIdle="16"
>  validationQuery="SELECT 1 FROM dual"
>  poolPreparedStatements="true"
>  accessToUnderlyingConnectionAllowed="true"
> 
> Since I've eliminated the possibility that close() is not being called
> on Statement/ResultSet's, I'm wondering a number of things:
> 
> 1.Could this be a bug in the Oracle JDBC driver?

Yes! We're not using DBCP, but are using Oracle's own JDBC-driver
against an old Oracle 8 instance. You cannot rely on Oracle's driver to
close everything for you. You need to explicitly close all your
ResultSets, Statements and Connections. :-(

> 2. Should I change parameters for DBCP?
> 
> - Should I get rid of poolPreparedStatements?  Note: That noticeably
> hurts performance.
> - Should I use timeBetweenEvictionRunsMillis - What's an "eviction" run?
> - Should I reduce maxIdle?
> 
> 3.  Is there a newer version of DBCP than the one that comes with
>Tomcat that might mitigate this problem and is it a good idea to
>drop that into Tomcat?
> 
> Any useful advice would be appreciated.
> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
> 
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: What's required to convert from DBUtils 1.1 to DBUtils 1.2?

2009-08-27 Thread Dennis Lundberg
You could try using the jTDS driver instead and see if that works for you:

http://jtds.sourceforge.net/

Watkin, James wrote:
> Here's a recent related post to a Microsoft website where Microsoft
> seems to be admitting flaws in their JDBC driver. Although my queries
> don't use table aliases, they still fail.
> 
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=mi
> crosoft.public.sqlserver.jdbcdriver&tid=95a47cdd-72ce-450b-9bca-3bee0203
> 8b17&cat=en_US_22326e25-7529-45bb-a7af-96ec8a2601d7&lang=en&cr=US&sloc=&
> p=1
> 
> Has anyone gotten DBUtils 1.2 to work with the Microsoft JDBC driver? I
> haven't used the jTDS driver in a long time, does jTDS work for this
> issue? Does the most recent version of jTDS work well generally?
> 
> Jim
> 
> -Original Message-
> From: Watkin, James [mailto:james.wat...@anderson.ucla.edu] 
> Sent: Wednesday, August 26, 2009 7:45 PM
> To: Commons Users List
> Subject: RE: What's required to convert from DBUtils 1.1 to DBUtils 1.2?
> 
> Within DBUtils 1.2, these exceptions are being thrown from the call to
> stmt.getParameterMetaData() within QueryRunner.fillStatement:
> 
> public void fillStatement(PreparedStatement stmt, Object[] params)
> throws SQLException {
> 
> if (params == null) {
> return;
> }
> 
> ParameterMetaData pmd = stmt.getParameterMetaData();
> ...
> ...
> 
> Some earlier SELECT queries without parameters are getting executed
> without throwing any exceptions.
> 
> DBUtils 1.1 doesn't seem to use the stmt.getParameterMetaData() call.
> 
> This is failing with the latest Microsoft JDBC driver, version 2.0,
> sqljdbc4.jar, with Java 1.6.0_11. I suppose I can try updating my JDK.
> 
> Jim
> 
> -Original Message-
> From: Watkin, James [mailto:james.wat...@anderson.ucla.edu] 
> Sent: Wednesday, August 26, 2009 6:32 PM
> To: Commons Users List
> Subject: RE: What's required to convert from DBUtils 1.1 to DBUtils 1.2?
> 
> Mark,
> 
> Thank you for your reply. My app breaks with the following exception:
> 
> java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException:
> Incorrect syntax near the keyword 'FROM'. Query: SELECT program FROM
> programs WHERE (code = ?) Parameters: [MFE]
>   at
> org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:540)
>   at
> org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:397)
>   at
> org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:352)
> 
> I've tried replacing my MS SQL Driver with the latest download, but that
> doesn't help. When I comment out the code throwing the error, I get an
> error on the next query:
> 
> Caused by: java.sql.SQLException:
> com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near
> ','. Query: SELECT a.serial FROM applicants_ext ae JOIN applicants a ON
> ae.applicant_serial = a.serial WHERE (ae.applicant_ext_serial = ?) AND
> (ae.app_type = ?) AND (a.year = ?) Parameters: [XXX, A, 2010]
>   at
> org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:540)
>   at
> org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:397)
>   at
> org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:369)
> 
> Jim
> 
> -Original Message-
> From: Mark Shifman [mailto:mark.shif...@yale.edu] 
> Sent: Wednesday, August 26, 2009 4:40 AM
> To: Commons Users List
> Subject: Re: What's required to convert from DBUtils 1.1 to DBUtils 1.2?
> 
> Almost nothing is required to convert to 1.2.  Read the release notes
> and see if any of the changes affect you.
> http://commons.apache.org/dbutils/changes-report.html
> 
> I was burned by the way they changed CaseInsensitiveHashMap so I just
> overrode it with the old one.  I also had a problem because of
> oracle (so what else is new) but when I upgraded to the newest driver
> things worked fine.
> 
> How does 1.2 break your app?
> mas
> 
> 
> Watkin, James wrote:
>> I'm experiencing a well-known problem with DBUtils 1.1 where sometimes
>> NULLs are converted to 0 when read from the database --
>> http://issues.apache.org/jira/browse/DBUTILS-42
>>
>>  
>>
>> I see that DBUtils 1.2 fixes this problem. However, DBUtils 1.2 breaks
>> my app. Before I commit to "fixing" my app, can anyone outline the
>> amount of work required to upgrade one's app for use with DBUtils 1.2?
>> I'm using the MS SQL Server JDBC driver.
>>
>>  
>>
>> Thank you.
>>
>>  
>>
>> Jim
>>
>>   
>>
>>  
>>
>>
> 


-- 
Dennis Lundberg

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org



Re: Turning off commons logging

2008-06-02 Thread Dennis Lundberg

John B. Moore wrote:
I'm using a number of org.apache.commons libraries in a web project and 
I need to turn off the logging that is occurring within the commons.  I 
must confess that, though I have used Log4j for years, I only use it at 
a very basic level and still rely on a very basic property file. (shown 
at the bottom of this message)


The commons libraries are generating massive amounts of output and I 
need to shut that off.


I keep my log4j.properties file for a given webapp in:

../tomcat/webapps/applicationroot/conf/log4j.properties


The place where we put our log4j configuration file in webapps is

.../tomcat/webapps/myWebapp/WEB-INF/classes/logj4.properties

That puts it on the classpath for the webapp.

If you have it in the place you mentioned above, I don't think that it 
will be found by Log4j being called through Commons Logging.


My first guess wast that it is seeing my core instance of Log4j and 
using that.. but when I add


log4j.logger.org.apache.commons=ERROR

..it has no effect.. which makes me question that it is seeing my 
configuration file.


Anyone have some hints as to getting the commons logging turned off 
without affecting my application logging.


Thanks..

John..


 current log4j property file contents ===

log4j.rootLogger=DEBUG, A1, R1

# A1 is a Console Appender
log4j.appender.A1=org.apache.log4j.ConsoleAppender

# R1 is a Rolling file appender
log4j.appender.R1=org.apache.log4j.RollingFileAppender
log4j.appender.R1.File=application.log
# File Size
log4j.appender.R1.MaxFileSize=100KB
# Keep one backup file
log4j.appender.R1.MaxBackupIndex=2


# Output Patterns
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-4r [%t](%F:%L) %-5p - %m%n

log4j.appender.R1.layout=org.apache.log4j.PatternLayout
log4j.appender.R1.layout.ConversionPattern=%-4r [%t](%F:%L) %-5p - %m%n

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Release of commons-cli?

2008-05-29 Thread Dennis Lundberg

Russel Winder wrote:

Paul,

On Wed, 2008-05-28 at 21:27 +0100, Paul Cager wrote:

I have done some work on CLI-137 as part of the Debian packaging. I 
think it is quite a severe bug, as it does not allow you to handle (for 
example) multiple "-D" arguments (as found in Maven or ant).


Exactly.  For the Groovy and Gant projects, this is not so much severe
as a complete blocker.  We upgraded 1.0 -> 1.1, made changes for the
hasArg(s) problems and still nothing about multiple options worked.
Worse all the non option parameters were absorbed into the options
processing.

I've prepared a patch for it for the Debian build (although I do not 
necessarily think that's the best way to fix it), and amended the JUnit 
tests to demonstrate the problem.


I sent an email to the -dev list a few weeks ago, but I think it might 
have gone missing. Here it is:


I certainly saw the email and was hoping there would be a response.  I
appreciate Hen is trying his best to keep Commons CLI ticking over, but
it really needs someone with commit access to take ownership of the
Commons CLI package.

Step 1 for me is to give the 1.x branch a Maven 2 build.  I will take a
Bazaar branch and see if dropping the POM from trunk in and editing
suitably does the trick.


I've checked in a working Maven 2 POM in the 1.x branch. It is missing 
the assembly bits, but we can look at that later on. Let me know if it 
needs anything more.




--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Problem when using ant task SCP

2008-04-27 Thread Dennis Lundberg
OK, but the task you are using is one of Ant's optional tasks. The 
documentation for that task is here:


  http://ant.apache.org/manual/OptionalTasks/scp.html

Ant != Commons

Daphna Deutsch wrote:

http://commons.apache.org/vfs/mail-lists.html


-Original Message-
From: Dennis Lundberg [mailto:[EMAIL PROTECTED] 
Sent: Sunday, April 27, 2008 3:35 PM

To: Commons Users List
Subject: Re: Problem when using ant task SCP

Which site is that?

Daphna Deutsch wrote:

Hi,

When I click on the "post" link in the site, it creates new e-mail
address to [EMAIL PROTECTED]

Is there another way to post the question?

-Original Message-
From: sebb [mailto:[EMAIL PROTECTED] 
Sent: Sunday, April 27, 2008 3:19 PM

To: Commons Users List
Subject: Re: Problem when using ant task SCP

This is really an question for the Ant user mailing list.

Try posting the question there.


2008/4/27 Daphna Deutsch <[EMAIL PROTECTED]>:

Hello,

 I'm trying to use the ant task SCP to copy a file from sftp server.



 I manage to copy a local file to the SFTP server, with no errors.

But

 when I'm trying to copy a file from the SFTP server to a local
 directory, the file is being copied but I'm getting error message at

the

 end of the task.





 This is the task that I wrote:



 

 

 



 And I'm getting the following result:



 get_from_sftp:

  [scp] Connecting to IP_ADDRESS:22

  [scp] Receiving file: /daphna/res1.xml

  [scp] Receiving: res1.xml : 127

  [scp] File transfer time: 0.02 Average Rate: 8,466.67 B/s



 BUILD FAILED

 D:\projects\ANT\build.xml:41: com.jcraft.jsch.JSchException: 2: No

such

 file





 Thanks for your help,

 Daphna





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]








--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Problem when using ant task SCP

2008-04-27 Thread Dennis Lundberg

Which site is that?

Daphna Deutsch wrote:

Hi,

When I click on the "post" link in the site, it creates new e-mail
address to [EMAIL PROTECTED]

Is there another way to post the question?

-Original Message-
From: sebb [mailto:[EMAIL PROTECTED] 
Sent: Sunday, April 27, 2008 3:19 PM

To: Commons Users List
Subject: Re: Problem when using ant task SCP

This is really an question for the Ant user mailing list.

Try posting the question there.


2008/4/27 Daphna Deutsch <[EMAIL PROTECTED]>:

Hello,

 I'm trying to use the ant task SCP to copy a file from sftp server.



 I manage to copy a local file to the SFTP server, with no errors. But
 when I'm trying to copy a file from the SFTP server to a local
 directory, the file is being copied but I'm getting error message at

the

 end of the task.





 This is the task that I wrote:



 

 

 



 And I'm getting the following result:



 get_from_sftp:

  [scp] Connecting to IP_ADDRESS:22

  [scp] Receiving file: /daphna/res1.xml

  [scp] Receiving: res1.xml : 127

  [scp] File transfer time: 0.02 Average Rate: 8,466.67 B/s



 BUILD FAILED

 D:\projects\ANT\build.xml:41: com.jcraft.jsch.JSchException: 2: No

such

 file





 Thanks for your help,

 Daphna






-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: No javadoc or source downloads

2008-03-02 Thread Dennis Lundberg

sebb wrote:

On 02/03/2008, Oliver Heger <[EMAIL PROTECTED]> wrote:

Dennis Lundberg schrieb:


Parks, Bill (CDC/CCHIS/NCPHI) wrote:

 >> Please add javadoc and source downloads for version 1.5. The files on
 >> the ibiblio site are corrupt.
 >
 > You might want to contact ibiblio about that. All Apache artifacts are
 > deployed to the central repository, ibiblio is just a mirror of that. I
 > found the files you are looking for at this address and they work fine:
 >
 > 
http://repo1.maven.org/maven2/commons-configuration/commons-configuration/1.5/
 >
 >


Something strange seems to be going on here. As Dennis pointed out the
 jars are available in the central maven2 repository. In the maven1
 repository [1] they are listed, but cannot be accessed (404 not found).

 The release was maven1-based, and according to the release guidelines
 the artifacts were copied to the ibiblio rsync directory - where they
 obviously still are.

 No idea why they cannot be accessed any more.


Could it be the same cause as:

http://jira.codehaus.org/browse/MEV-572

i.e. rewrite rule problems?


That seems to be the case. Here's the rewritten URL that I get when 
clicking on the javadoc jar:


/maven2/commons-configuration/commons-configuration/1.5-javadoc/commons-configuration-1.5-javadoc.jar

The real file is at:

/maven2/commons-configuration/commons-configuration/1.5/commons-configuration-1.5-javadoc.javadoc.jar 



Two error in there:
- The classifier "-javadoc" is added to the version directory.
- The actual file has a strange name with an extra ".javadoc" near the end.




 Oliver

 [1] http://repo1.maven.org/maven/commons-configuration/jars/


 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: No javadoc or source downloads

2008-03-02 Thread Dennis Lundberg

Parks, Bill (CDC/CCHIS/NCPHI) wrote:

Please add javadoc and source downloads for version 1.5. The files on
the ibiblio site are corrupt.


You might want to contact ibiblio about that. All Apache artifacts are 
deployed to the central repository, ibiblio is just a mirror of that. I 
found the files you are looking for at this address and they work fine:


http://repo1.maven.org/maven2/commons-configuration/commons-configuration/1.5/

--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Help for SQL parsing library

2007-11-29 Thread Dennis Lundberg
You might want to check the Squirrel SQL project at sourceforge. It has 
an SQL validator plugin.


Vijay wrote:

Hi,


I am looking for library which can parse SQL statement for correctness 
before handled to PreparedStatement/Statement in JDBC. I have urgent 
requirement.


Thanks if anyone can help me.

Vijay


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[ANNOUNCEMENT] Commons Logging 1.1.1 released

2007-11-28 Thread Dennis Lundberg
The Commons team is pleased to announce the release of Commons Logging 
1.1.1. Commons Logging is an ultra-thin bridge between different logging 
implementations.


Release notes:
  http://commons.apache.org/logging/commons-logging-1.1.1/RELEASE-NOTES.txt

Commons Logging website:
  http://commons.apache.org/logging/

Download:
  http://commons.apache.org/downloads/download_logging.cgi

Fixed bugs:
* [LOGGING-106] - AccessControlException when loading LogFactory class 
without system properties permission

* [LOGGING-107] - AccessController use
* [LOGGING-114] - Silent Swallowing of NoClassDefFoundError
* [LOGGING-115] - NPE thrown due to exception message logging
* [LOGGING-117] - Unit tests fail on linux with java16

Improvements:
* [LOGGING-111] - Small patch to make debugging easier
* [LOGGING-113] - pom.xml in maven repository does not list dependencies 
as optional

* [LOGGING-118] - Generate source and binary archives


Dennis Lundberg,
on behalf of the Commons community

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: commons-logging jar keeps tomcat process runing

2007-11-20 Thread Dennis Lundberg

simon wrote:

Yes, the ServletContextListener approach documented there in the wiki is
certainly worth a try. 


In the almost-released version of commons-logging, a class is included
in the jar to implement exactly this:
  org.apache.commons.logging.impl.ServletContextCleaner.

I suggest you download the commons-logging 1.1.1 release candidate and
configure the class as a ServletContextListener for your app and see
what happens. Whether it resolves the problem or not, it would be
appreciated if you emailed this list with info about the result.

See:
http://people.apache.org/~dennisl/

Hmm..we should probably have published a 1.1.1-snapshot to the apache
maven snapshot repo, but looks like this has never been done. Ah well,
the release is coming very soon...


It's here:

http://people.apache.org/maven-snapshot-repository/commons-logging/commons-logging/1.1.1-SNAPSHOT/


Regards,

Simon

On Tue, 2007-11-20 at 20:00 +0100, Dennis Lundberg wrote:

Have a look at the second last entry in the FAQ at
   http://wiki.apache.org/commons/Logging/FrequentlyAskedQuestions
"A memory leak occurs when undeploying/redeploying a webapp that uses 
Commons Logging. How do I fix this?"


I don't know it is what you are looking for, but it's worth a try.

Vaduvoiu Tiberiu wrote:

Hi, I have a small axis application that queries a web service. The application 
need commons-logging jar. Everything works ok but when I try to stop tomcat, 
the process is still running. If i delete commons-logging jar then tomcat stops 
normally. I don't know what can cause this. I tried using several versions of 
commons-logging, I tried deleteing commons-logging jar from web-inf/lib and 
copying commons-logging-api in tomcat/lib but still same problem. tomcat 
process is still running after executing shutdown.sh. I am running tomcat 6.0 
on Ubuntu. Does anyone know what can cause this problem or how can I solve it? 
10x a lot in advance




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: commons-logging jar keeps tomcat process runing

2007-11-20 Thread Dennis Lundberg

Have a look at the second last entry in the FAQ at
  http://wiki.apache.org/commons/Logging/FrequentlyAskedQuestions
"A memory leak occurs when undeploying/redeploying a webapp that uses 
Commons Logging. How do I fix this?"


I don't know it is what you are looking for, but it's worth a try.

Vaduvoiu Tiberiu wrote:

Hi, I have a small axis application that queries a web service. The application 
need commons-logging jar. Everything works ok but when I try to stop tomcat, 
the process is still running. If i delete commons-logging jar then tomcat stops 
normally. I don't know what can cause this. I tried using several versions of 
commons-logging, I tried deleteing commons-logging jar from web-inf/lib and 
copying commons-logging-api in tomcat/lib but still same problem. tomcat 
process is still running after executing shutdown.sh. I am running tomcat 6.0 
on Ubuntu. Does anyone know what can cause this problem or how can I solve it? 
10x a lot in advance




  

Be a better pen pal. 
Text or chat with friends inside Yahoo! Mail. See how.  http://overview.mail.yahoo.com/


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [JCL] LogConfigurationException headache

2007-10-18 Thread Dennis Lundberg
tart(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

I actually do not understand this exception at all since I do not use
LogKitLogger in the "searcher servlet". In my servlet I have something
like:

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * Simple wrapper class to easier debug/log.
 *
 */
public class LoggableSearcher {

  protected final Log log =
LogFactory.getLog(this.getClass().getCanonicalName());

  public LoggableSearcher() {
super();
  }

}

Which I then extend with a Spring Controller. 
public class SearchController extends LoggableSearcher implements

Controller {
...
}

I am looking for a solution for a while now but actually have not found
any solution only reports about similar problems. 


Can somebody please give me some hints what the problem is and how I can
fix it?

Any input is highly appreciated.

salu2



--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: unsubscribe

2007-08-22 Thread Dennis Lundberg
We have several mailing lists here at commons, and after the recent TLP 
move we added more. If the mails that you get do not have instructions 
on how to unsubscribe at the bottom of all mails, there is another way 
to find out how do it. Check the headers of the mail. Look for a header 
called "List-Unsubscribe". It will contain the unsubscribe address that 
you are looking for.


Is you need to find out which of your email-addresses the mails get sent 
to, look for the header called "Return-Path". It contains your, slightly 
encoded, email-address. You need to send your unsubscribe request from 
that address.


Jeff Marendo wrote:

I have tried repeatedly to unsubscribe to the
following addresses without success:

[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]

I'm grateful for all of the work that others around
the world have contributed (and continue to do so) to
the open source community, but I just want to
unsubscribe from the mailing lists for the time being.

Note that I've also sent messages to the mailing list
admin account/email address as well.

Please remove me from the mailing lists.  Thank you.

Jeff


  

Luggage? GPS? Comic books? 
Check out fitting gifts for grads at Yahoo! Search

http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: unsubscribe

2007-08-22 Thread Dennis Lundberg
The "[component] my question" subject lines are purely by convention. It 
is up to the subscribers of the list to uphold this convention.


Paolo Viappiani wrote:

I find also very annoying that the subject "style" of messages has
been modified. Before, subjects indicate they were belonging to the
mailing list, and to which particular project or subprojects, in
parenthesis. I had automatic rules for classifying messages as
belonging to jakarta mailing lists so that they would not make my
inbox full.

Paolo

On 8/22/07, Kristian Mandrup <[EMAIL PROTECTED]> wrote:

I have also had the same problem. Please unsubscribe me

- Original Message -
From: "Jeff Marendo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; 
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2007 3:03 PM
Subject: unsubscribe



I have tried repeatedly to unsubscribe to the
following addresses without success:

[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]

I'm grateful for all of the work that others around
the world have contributed (and continue to do so) to
the open source community, but I just want to
unsubscribe from the mailing lists for the time being.

Note that I've also sent messages to the mailing list
admin account/email address as well.

Please remove me from the mailing lists.  Thank you.

Jeff




Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]








--
Dennis Lundberg

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]