Login | Register
My pages Projects Community openCollabNet

Discussions > users > Configuring logging

maxq
Discussion topic

Hide all messages in topic

All messages in topic

Re: [maxq-users] MySQL

Author dadan <dadan8_2003 at yahoo dot com>
Full name dadan <dadan8_2003 at yahoo dot com>
Date 2007-09-13 17:48:06 PDT
Message thanks for the replay
but yesterday i tried to reinstall jython 2.2
and wrote the classpath of jython 2.2
and put the JDBC driver which is : mysql-connector-java​-5.0.7-bin.jar
in folder C:\Program Files\Java\jre1.6.0_01\lib\ext
and then i executed the command :
from com.ziclix.python.sql import zxJDBC
and weew...it succeed
and then i tried to reconnect it to MYSQL
and it succeed to!!
maybe it's my luck..because i tried that path before and i failed!!!
but now it happen as my wish!

regards
dadan

Oliver Bock wrote:
>
> On 10/09/2007, at 18:20, dadan wrote:
>> i just want to ask....i done several action to execute this command
>> in jython
>> command line:
>>>>> from com.ziclix.python.sql import zxJDBC
>> but the result is like this :
>> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg
>>
>> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit
>> you can see full error in image above..
>> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know
>> to put in
>> in CLASSPATH.
>> please tell me how to import zxJDBC.
>> thanks
>>
>
> Put the JAR in MaxQ's lib directory. If you are on Windows you will
> need to edit the CLASSPATH line in maxq.bat to include the full path
> to the new JAR.
>
>
> Oliver
>
> --------------------​--------------------​--------------------​---------
> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org
> For additional commands, e-mail: users-help at maxq dot tigris dot org
>
>
>

--
View this message in context: http://www.nabble.co​m/Fw%3A-Configuring-​logging-tf3784221.ht​ml#a12666496
Sent from the maxq - users mailing list archive at Nabble.com.

Re: [maxq-users] MySQL

Author dadan <dadan8_2003 at yahoo dot com>
Full name dadan <dadan8_2003 at yahoo dot com>
Date 2007-09-13 17:47:35 PDT
Message thanks for the replay
but yesterday i tried to reinstall jython 2.2
and wrote the classpath of jython 2.2
and put the JDBC driver which is : mysql-connector-java​-5.0.7-bin.jar
in folder C:\Program Files\Java\jre1.6.0_01\lib\ext
and then i executed the command :
from com.ziclix.python.sql import zxJDBC
and weew...it succeed
and then i tried to reconnect it to MYSQL
and it succeed to!!
maybe it's my luck..because i tried that path before and i failed!!!
but now it happen as my wish!

regards
dadan

Oliver Bock wrote:
>
> On 10/09/2007, at 18:20, dadan wrote:
>> i just want to ask....i done several action to execute this command
>> in jython
>> command line:
>>>>> from com.ziclix.python.sql import zxJDBC
>> but the result is like this :
>> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg
>>
>> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit
>> you can see full error in image above..
>> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know
>> to put in
>> in CLASSPATH.
>> please tell me how to import zxJDBC.
>> thanks
>>
>
> Put the JAR in MaxQ's lib directory. If you are on Windows you will
> need to edit the CLASSPATH line in maxq.bat to include the full path
> to the new JAR.
>
>
> Oliver
>
> --------------------​--------------------​--------------------​---------
> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org
> For additional commands, e-mail: users-help at maxq dot tigris dot org
>
>
>

--
View this message in context: http://www.nabble.co​m/Fw%3A-Configuring-​logging-tf3784221.ht​ml#a12666487
Sent from the maxq - users mailing list archive at Nabble.com.

Re: [maxq-users] MySQL

Author oliverbock
Full name Oliver Bock
Date 2007-09-12 14:51:12 PDT
Message On 10/09/2007, at 18:20, dadan wrote:
> i just want to ask....i done several action to execute this command
> in jython
> command line:
>>>> from com.ziclix.python.sql import zxJDBC
> but the result is like this :
> http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg
>
> java.lang.NoclassdefFoundError : org/python/core/ClassDictInit
> you can see full error in image above..
> i also download mysql-connector-java​-5.0.7-bin.jar. but don't know
> to put in
> in CLASSPATH.
> please tell me how to import zxJDBC.
> thanks
>

Put the JAR in MaxQ's lib directory. If you are on Windows you will
need to edit the CLASSPATH line in maxq.bat to include the full path
to the new JAR.


   Oliver

Re: [maxq-users] MySQL

Author dadan <dadan8_2003 at yahoo dot com>
Full name dadan <dadan8_2003 at yahoo dot com>
Date 2007-09-10 01:20:06 PDT
Message i just want to ask....i done several action to execute this command in jython
command line:
>>>from com.ziclix.python.sql import zxJDBC
but the result is like this :
http://www.nabble.co​m/file/p12588625/err​or%2Bziclix.jpg

java.lang.NoclassdefFoundError : org/python/core/ClassDictInit
you can see full error in image above..
i also download mysql-connector-java​-5.0.7-bin.jar. but don't know to put in
in CLASSPATH.
please tell me how to import zxJDBC.
thanks



Oliver Bock wrote:
>
> Fixed. Much obliged.
>
>
> On 29/06/2007, at 01:41, jh wrote:
>
>> Just a nit as I think either will work but I think the driver name
>> is now
>> "com.mysql.jdbc.Driver"
>>
>> instead of
>>
>> "org.gjt.mm.mysql.Dr​iver".Regards,jh
>
> --------------------​--------------------​--------------------​---------
> To unsubscribe, e-mail: users-unsubscribe@ma​xq.tigris.org
> For additional commands, e-mail: users-help at maxq dot tigris dot org
>
>
>

--
View this message in context: http://www.nabble.co​m/Fw%3A-Configuring-​logging-tf3784221.ht​ml#a12588625
Sent from the maxq - users mailing list archive at Nabble.com.

Re: [maxq-users] MySQL

Author oliverbock
Full name Oliver Bock
Date 2007-06-29 04:31:09 PDT
Message Fixed. Much obliged.


On 29/06/2007, at 01:41, jh wrote:

> Just a nit as I think either will work but I think the driver name
> is now
> "com.mysql.jdbc.Driver"
>
> instead of
>
> "org.gjt.mm.mysql.Dr​iver".Regards,jh

Re: [maxq-users] MySQL

Author hms_suprise
Full name john v hite
Date 2007-06-28 08:41:48 PDT
Message Just a nit as I think either will work but I think the driver name is now

"com.mysql.jdbc.Driver"

instead of

"org.gjt.mm.mysql.Dr​iver".Regards,jh

Re: [maxq-users] MySQL

Author hms_suprise
Full name john v hite
Date 2007-06-28 08:25:43 PDT
Message As always, thanks for posting, Oliver.

Dang, what an idiot I am, I have seen that before too. But no, I forgot
about that, probably because when I saw it I knew nothing of any flavor of
SQL. Did it slightly differently, after adding
mysql-connector-java​-5.0.6-bin.jar to the jar lib. But the snippet below
works.



from com.ziclix.python.sql import zxJDBC

class jdbc(PyHttpTestCase):
    def runTest(self):
            self.msg('Test started')

           d, u, p, v = "jdbc:mysql://localhost/", 'admin', 'data1',
"com.mysql.jdbc.Driver"
         db = zxJDBC.connect(d, u, p, v)
         #print 'db', db
         c = db.cursor()
         #print 'c', c
         c.execute("SELECT c.LastName FROM dvims_dbo.customer c")
         print 'desc', c.description
         for line in c.fetchall():
              print '~', line
         c.close()
         db.close()
         print 'done'

Re: [maxq-users] MySQL

Author oliverbock
Full name Oliver Bock
Date 2007-06-27 15:49:48 PDT
Message jh wrote:
> I want to make some MySQL queries from my test script. It looks like
> zxJDBC is available as the following lines execute OK but complain
> that the driver was not found. I picked up the driver name from the
> jython page http://www.jython.or​g/docs/zxjdbc.html. The driver name
> seems a bit unusual but other examples have multi-dotted names too. I
> also added mysql-connector-java-5.0.6-bin to maxq/lib and the
> CLASSPATH and tried their driver names to no avail.

Have you looked at "Adding SQL to Tests" in
http://maxq.tigris.o​rg/docs/recipes.html​?


  Oliver

MySQL

Author hms_suprise
Full name john v hite
Date 2007-06-27 08:13:59 PDT
Message I want to make some MySQL queries from my test script. It looks like zxJDBC is available as the following lines execute OK but complain that the driver was not found. I picked up the driver name from the jython page http://www.jython.or​g/docs/zxjdbc.html. The driver name seems a bit unusual but other examples have multi-dotted names too. I also added mysql-connector-java-5.0.6-bin to maxq/lib and the CLASSPATH and tried their driver names to no avail.

Don't know much about jython per se but if you have any insight or ideas about accessing MySQL please sing out.

Thanx,

jh

~~~~~~~~~~~~~~~~~~~~​~~~~~~~~~~~~~~~~~~~~​~~~~~~~~~~~~~~~~~~~~​~~~~~~~

from com.ziclix.python.sql import zxJDBC
        d, u, p, v = "jdbc:mysql://localhost", 'admin', 'myPassword', "org.gjt.mm.mysql.Driver"
        db = zxJDBC.connect(d, u, p, v)
Attachments

Re: [maxq-users] Fw: Configuring logging

Author oliverbock
Full name Oliver Bock
Date 2007-05-19 19:25:38 PDT
Message > P.S.: I already tried the VM argument -Dlog4j.rootCategory=ERROR
>
> It does not help. I get loggings of type DEBUG and INFO.
>
> I can't pass the program argument -q because I run the Jython script.

The logging level can only be controlled from the command line. I
think you should be running your script using bin/maxq rather than
directly using Jython.


   Oliver
Attachments

Fw: Configuring logging

Author Hans Schwaebli <hans_schwaebli at yahoo dot com>
Full name Hans Schwaebli <hans_schwaebli at yahoo dot com>
Date 2007-05-19 17:55:06 PDT
Message P.S.: I already tried the VM argument -Dlog4j.rootCategory=ERROR

It does not help. I get loggings of type DEBUG and INFO.

I can't pass the program argument -q because I run the Jython script.

I configured MaxQ to run from within Eclipse with the PyDev plugin. Everything works besides that I cannot get rid of that logging.

My half knowledge in many areas prevents me to see a why how to
configure logging with MaxQ. Can you please tell me a way for a dummy
like me?


----- Forwarded Message ----
From: Hans Schwaebli <hans_schwaebli@y​ahoo.com>
To: users at maxq dot tigris dot org
Sent: Sunday, May 20, 2007 1:45:41 AM
Subject: Configuring logging

How can I set the log level?








       
____________________​____________________​____________________​____________________​____Give spam the boot. Take control with tough spam protection in the all-new Yahoo! Mail Beta.
http://advision.webe​vents.yahoo.com/mail​beta/newmail_html.ht​ml
Attachments

Configuring logging

Author Hans Schwaebli <hans_schwaebli at yahoo dot com>
Full name Hans Schwaebli <hans_schwaebli at yahoo dot com>
Date 2007-05-19 16:45:41 PDT
Message How can I set the log level?




 
____________________​____________________​____________________​____________________​____
Don't get soaked. Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.​yahoo.com/shortcuts/​#loc_weather
Attachments
Messages per page: