Re: [Jython-users] Greeting and question

[Leo Soto M. <leo.soto@gm...>]

2008/10/9 Michał Bednarczyk <michal.bednarczyk@...>:

>> `execute` doesn't return anything. Or to be more precise, according to
>> the DB-API spec[1] "return values are not defined". If your select
>> doesn't return anything, fetchall() will return an empty sequence.
>
> It is strange because I've seen some examples with this code (http://www.jython.org/docs/zxjdbc.html).
> What should I use to get data from db?

As the example shows, you first call cursor.execute(), and then
cursor.fetchall() will give you the results. I'll gently insist that
you read the relevant documentation.

> In PHP it was simple :-/

Don't worry, Python DB-API is quite easy to use. Maybe different than
PHP database APIs (mostly in *good* ways), but very simple
nonetheless.
-- 
Leo Soto M.
http://blog.leosoto.com

Re: [Jython-users] Greeting and question

[Michał Bednarczyk <michal.bednarczyk@pe...>]

Forward

> -----Original Message-----
> From: Leo Soto M. [mailto:leo.soto@...]
> Sent: Tuesday, October 07, 2008 4:07 PM
> To: Michał Bednarczyk
> Cc: jython-users@...
> Subject: Re: [Jython-users] Greeting and question

Hi Leo,

Thank you for your quick reply.

> > And the result is: "Data inserted" but I haven't any new
> rows in my table...
> 
> You need to do `db.commit()`.

Ok, it works :-) I can add new records to db.


> `execute` doesn't return anything. Or to be more precise, according to 
> the DB-API spec[1] "return values are not defined". If your select 
> doesn't return anything, fetchall() will return an empty sequence.

It is strange because I've seen some examples with this code (http://www.jython.org/docs/zxjdbc.html). What should I use to get data from db?

 
> I suggest you take a look at the DB-API spec or some related tutorial.
> Jython's zxJDBC follows the spec very closely.

"Return values are not defined." What it means? How can I get this data?
In PHP it was simple :-/



> > there is an error:
> > DatabaseError: driver
> [com.microsoft.sqlserver.jdbc.SQLServerDriver]
> > not found I'm using Easy Eclipse on Windows XP, CLASSPATH
> is correct, jar files are added to project.
> 
> What jython version are you using? 2.2.x? Or some 2.5 alpha release?

I'm using jython 2.2.1 now.


Best regards,
Michal B.

[Jython-users] PyType.fromClass

[Ethan Glasser-Camp <ethan@10...>]

Hey guys,

If I'm understanding this correctly, PyType.fromClass doesn't change 
method names. If I have an @ExposedType called MyClass, exposed as 
"myclass", and an @ExposedMethod with the name myclass_foo, it doesn't 
show up as foo -- but seems to be exposed as myclass_foo. If this is 
correct, how come? Is it a bug or a feature? Is it because 
PyType.fromClass is for running unchanged Java classes or something, and 
it doesn't expect ExposedMethod at all?

It seems from reading

http://wiki.python.org/jython/PythonTypesInJava

that the preferred way to expose types is to use an 
ExposedTypeProcessor, probably by adding the class name to 
CoreExposed.includes. But what if I don't want to modify the jython jar 
for one reason or another? I can invoke the ExposedTypeProcessor 
manually, in a static block or something like that, but I get the 
feeling there's a more elegant way. Is there?

Thanks for your time!

Ethan