Connector/j PreparedStatement DOESn't work

6 Message(s) by 2 Author(s) originally posted in mysql java

From: ProgDario

Date: Monday, July 17, 2006

Hi,

I'm using JAVA 5 with connect

<library, networking> {Unix} socket library routine to connect
	a socket that has been created on the local hosts to one at a
	specified socket address on the remote host.

	{Unix manual pages}: connect(2), accept(2).

	(1995-03-21)

or/j 3.1.13.

I've a stupid query

1. <database, information science> A user's (or {agent}'s)
	request for information, generally as a formal request to a
	{database} or {search engine}.

	{SQL} is the most common {database query language}.

	2. <character> {question mark}.

	(1997-04-09)

with two string

<programming> A sequence of {data} values, usually {bytes},
	which usually stand for {characters} (a "character string").
	The {mapping} between values and characters is determined by
	the {character set} which is itself specified implcitly or
	explicitly by the environment in which the string is being
	interpreted.

	The most common character set is {ASCII} but, since the late
	1990s, there has been increased interest in larger character
	sets such as {Unicode} where each character is represented by
	more than eight {bits}.

	Most programming languages consider strings (e.g.
	"124:shabooya:\n", "hello world") basically distinct from
	numbers which are typically stored in fixed-length {binary} or
	{floating-point} representation.

	A {bit string} is a sequence of {bits}.

	(1999-12-21)

parameters.

When I set the parameters and execute

<operating system, programming> The process of carrying out
	the {instructions} in a computer program by a computer.

	See also {dry run}.

	(1996-05-13)

the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.

If I do not use the preparedstatement, it works.

I'm really get frustrated with this. Any hint?Thanks!!Dario

From: ProgDario

Date: Monday, July 17, 2006

SOLVED!!

I respond to myself: you are a stupid guy!!

It was a mistake due to a distraction. I was compairing an md5-ed
wrote in message:

Hi,
I'm using JAVA 5 with connector/j 3.1.13.
I've a stupid query with two string parameters.
When I set the parameters and execute the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.
If I do not use the preparedstatement, it works.
I'm really get frustrated with this. Any hint?
Thanks!!
Dario

From: Joseph

Date: Sunday, August 27, 2006

Hi Dario,
I'm trying to get my JAVA with my connector to work for a small example.
if you can help here as I'm not sure how to get this accomplish that
would be great.
Thanks
wrote in message:

SOLVED!!
I respond to myself: you are a stupid guy!!
It was a mistake due to a distraction. I was compairing an md5-ed
password
<security> An arbitrary string of characters chosen by a user
	or {system administrator} and used to authenticate the user
	when he attempts to log on, in order to prevent unauthorised
	access to his account.

	A favourite activity among unimaginative {computer nerds} and
	{crackers} is writing programs which attempt to discover
	passwords by using lists of commonly chosen passwords such as
	people's names (spelled forward or backward).  It is
	recommended that to defeat such methods passwords use a
	mixture of upper and lower case letters or digits and avoid
	proper names and real words.  If you have trouble remembering
	random strings of characters, make up an acronym like
	"ihGr8trmP" ("I have great trouble remembering my password").

	(1994-10-27)
with a not md5-ed password.
Dario
wrote in message:
Hi,

I'm using JAVA 5 with connector/j 3.1.13.

I've a stupid query with two string parameters.

When I set the parameters and execute the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.

If I do not use the preparedstatement, it works.

I'm really get frustrated with this. Any hint?

Thanks!!

Dario

From: ProgDario

Date: Wednesday, August 30, 2006

Here are some useful link:

http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html

In my example, I used a datasource with a JNDI name configured in the
webserver.

Please can you tell me what's wrong with your example, so I can give
you some hint?By

DarioJoseph ha scritto:

Hi Dario,
I'm trying to get my JAVA with my connector to work for a small example.
if you can help here as I'm not sure how to get this accomplish that
would be great.
Thanks
Joseph
wrote in message:
> SOLVED!!
>
> I respond to myself: you are a stupid guy!!
>
> It was a mistake due to a distraction. I was compairing an md5-ed
> password with a not md5-ed password.
>
>
> Dario
>
>
wrote in message:
>
Hi,
I'm using JAVA 5 with connector/j 3.1.13.
I've a stupid query with two string parameters.
When I set the parameters and execute the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.
If I do not use the preparedstatement, it works.
I'm really get frustrated with this. Any hint?
Thanks!!
Dario
>
>

From: Joseph

Date: Friday, September 15, 2006

Hi Dario,
I am running Fedora, and downloaded connector/J the last one. Also have
JAVA "/usr/JAVA/jdk1.5.0_05/bin/JAVA" installed. I also got MySql
installed but need to write

1. <chat> {Unix}'s simple {talk} command and {protocol}.
	write has been largely superseded by {talk} and then {irc}.

	An enhancement, {RWP}, has been proposed.

	2. <tool> A simple {text editor} for {Windows}.

	(1998-04-28)

some code

<software> Instructions for a computer in some programming
	language, often {machine language}.  The word "code" is often
	used to distinguish instructions from {data} (e.g. "The code
	is marked 'read-only'") whereas "{software}" is used in
	contrast with "{hardware}" and may consist of more than just
	code.

	(2000-04-08)

in JAVA to access the database

1. <database> One or more large structured sets of persistent
	data, usually associated with software to update and {query}
	the data.  A simple database might be a single file containing
	many {records}, each of which contains the same set of
	{fields} where each field is a certain fixed width.

	A database is one component of a {database management system}.

	See also {ANSI/SPARC Architecture}, {atomic}, {blob}, {data
	definition language}, {deductive database}, {distributed
	database}, {fourth generation language}, {functional
	database}, {object-oriented database}, {relational database}.

	{Carol E. Brown's tutorial
	(http://accounting.rutgers.edu/raw/aies/www.bus.orst.edu/faculty/brownc/lectures/db_tutor/db_tutor.htm)}.

	2. <hypertext> A collection of {nodes} managed and stored in
	one place and all accessible via the same {server}.  {Links}
	outside this are "external", and those inside are "internal".

	On the {World-Wide Web} this is called a {website}.

	3. All the facts and rules comprising a {logic programming}
	program.

	(2005-11-17)

and
can not do that. I'm newbie

<jargon> /n[y]oo'bee/ (Originally from British public-school
	and military slang variant of "new boy") An inexperienced user
	of {Usenet} or other system.

	This term surfaced in the {newsgroup} {news:talk.bizarre} but
	is now in wide use.  Criteria for being considered a newbie
	vary wildly; a person can be called a newbie in one newsgroup
	while remaining a respected regular in another.  The label
	"newbie" is sometimes applied as a serious insult to a person
	who has been around {Usenet} for a long time but who carefully
	hides all evidence of having a clue.

	See {BIFF}.

	[{Jargon File}]

	(1998-02-18)

here so a little more of details from you
might put me on the right path.
wrote in message:

Here are some useful link:
http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html
In my example, I used a datasource with a JNDI name configured in the
webserver.
Please can you tell me what's wrong with your example, so I can give
you some hint?
By
Dario
Joseph ha scritto:
Hi Dario,
I'm trying to get my JAVA with my connector to work for a small example.
if you can help here as I'm not sure how to get this accomplish that
would be great.
Thanks
Joseph

wrote in message:

SOLVED!!
I respond to myself: you are a stupid guy!!
It was a mistake due to a distraction. I was compairing an md5-ed
password with a not md5-ed password.
Dario
wrote in message:
Hi,

I'm using JAVA 5 with connector/j 3.1.13.

I've a stupid query with two string parameters.

When I set the parameters and execute the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.

If I do not use the preparedstatement, it works.

I'm really get frustrated with this. Any hint?

Thanks!!

Dario

From: ProgDario

Date: Tuesday, September 19, 2006

HI Joseph,

I will try to be more detailed.

There are two ways you can access a DB:

1- You directtly create a connection, and use it for querying the
tables
2- By using a Pooled connection, but this approach involves some
configuring stuff on web server

1. A program which provides some service to other ({client})
	programs.  The connection between client and server is
	normally by means of {message passing}, often over a
	{network}, and uses some {protocol} to encode the client's
	requests and the server's responses.  The server may run
	continuously (as a {daemon}), waiting for requests to arrive
	or it may be invoked by some higher level daemon which
	controls a number of specific servers ({inetd} on {Unix}).

	There are many servers associated with the {Internet}, such as
	those for {HTTP}, {Network File System}, {Network Information
	Service} (NIS), {Domain Name System} (DNS), {FTP}, {news},
	{finger}, {Network Time Protocol}.  On Unix, a long list can
	be found in /etc/services or in the {NIS} database "services".
	See {client-server}.

	2. A computer which provides some service for other computers
	connected to it via a network.  The most common example is a
	{file server} which has a local disk and services requests
	from remote clients to read and write files on that disk,
	often using {Sun}'s {Network File System} (NFS) {protocol} or
	{Novell Netware} on {PCs}.  Another common example is a {web
	server}.

	[{Jargon File}]

	(2003-12-29)

files.

I assume you prefer to directly connect to the db WITHOUT the pool
connection feature.

First of all, you've to include

[{Usenet}] 1. To duplicate a portion (or whole) of another's
	message (typically with attribution to the source) in a reply
	or followup, for clarifying the context of one's response.
	See the discussion of inclusion styles under "Hacker Writing
	Style".

	2. [{C}] "#include <disclaimer.h>" has appeared in {sig
	blocks} to refer to a notional "standard {disclaimer} file".

	[{Jargon File}]

the connector jar

<file format, filename extension> (jar) A compressed {archive}
	file containing {Java} {class} files, filename extension:
	".jar".  The {Java Development Kit} contains a tool called
	"jar" for creating .jar files, similar to the standard {Unix}
	{tar} command.  As well as archiving and compressing the Java
	class files, it also inserts a "manifest" file which can
	contain information about the class files, such as a {digital
	signature}.  Combining class files into a single archive file
	makes it possible to download them in a single {HTTP}
	transaction.  This, and the {compression}, speeds up execution
	of Java programs delivered via the {Internet}.

	(2001}-02-03)

into your classpath
(I hope you are using eclipse).

Then, these are the lines you basically have to write (didn't tested
this code):

dbUrl = "jdbc:mysql://server:port;database_name=db_name";
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(dbUrl, user, password);For the URL

<World-Wide Web> (URL, previously "Universal") A {standard}
	way of specifying the location of an object, typically a {web
	page}, on the {Internet}.  Other types of object are described
	below.  URLs are the form of address used on the {World-Wide
	Web}.  They are used in {HTML} documents to specify the target
	of a {hyperlink} which is often another HTML document
	(possibly stored on another computer).

	Here are some example URLs:

	 http://www.w3.org/default.html
	 http://www.acme.co.uk:8080/images/map.gif
	 http://www.foldoc.org/?Uniform+Resource+Locator
	 http://www.w3.org/default.html#Introduction
	 ftp://wuarchive.wustl.edu/mirrors/msdos/graphics/gifkit.zip
	 ftp://spy:secret@ftp.acme.com/pub/topsecret/weapon.tgz
	 mailto:fred@doc.ic.ac.uk
	 news:alt.hypertext
	 telnet://dra.com

	The part before the first colon specifies the access scheme or
	{protocol}.  Commonly implemented schemes include: {ftp},
	{http} (World-Wide Web), {gopher} or {WAIS}.  The "file"
	scheme should only be used to refer to a file on the same
	host.  Other less commonly used schemes include {news},
	{telnet} or mailto ({e-mail}).

	The part after the colon is interpreted according to the
	access scheme.  In general, two slashes after the colon
	introduce a {hostname} (host:port is also valid, or for {FTP}
	user:passwd@host or user@host).  The {port} number is usually
	omitted and defaults to the standard port for the scheme,
	e.g. port 80 for HTTP.

	For an HTTP or FTP URL the next part is a {pathname} which is
	usually related to the pathname of a file on the server.  The
	file can contain any type of data but only certain types are
	interpreted directly by most {browsers}.  These include {HTML}
	and images in {gif} or {jpeg} format.  The file's type is
	given by a {MIME} type in the HTTP headers returned by the
	server, e.g. "text/html", "image/gif", and is usually also
	indicated by its {filename extension}.  A file whose type is
	not recognised directly by the browser may be passed to an
	external "viewer" {application}, e.g. a sound player.

	The last (optional) part of the URL may be a query string
	preceded by "?" or a "fragment identifier" preceded by "#".
	The later indicates a particular position within the specified
	document.

	Only alphanumerics, reserved characters (:/?#"<>%+) used for
	their reserved purposes and "$", "-", "_", ".", "&", "+" are
	safe and may be transmitted unencoded.  Other characters are
	encoded as a "%" followed by two {hexadecimal} digits.  Space
	may also be encoded as "+".  Standard {SGML} "&<name>;"
	character entity encodings (e.g. "&eacute;") are also accepted
	when URLs are embedded in HTML.  The terminating semicolon may
	be omitted if &<name> is followed by a non-letter character.

	{The authoritative W3C URL specification
	(http://www.w3.org/hypertext/WWW/Addressing/Addressing.html)}.

	(2000-02-17)

variable, you've to consult the connector/j documentation
in order to compose the correct url.

Useful links:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html#connector-j-examples-connection-drivermanager
http://www.stardeveloper.com/articles/display.html?article=2003090401&page=1
Hope

<language> A {functional programming} language designed by
	R.M. Burstall, D.B. MacQueen and D.T. Sanella at {University
	of Edinburgh} in 1978.  It is a large language supporting
	user-defined {prefix}, {infix} or {distfix} operators.  Hope
	has {polymorphic} typing and allows {overloading} of operators
	which requires explicit type declarations.  Hope has {lazy
	lists} and was the first language to use {call-by-pattern}.

	It has been ported to {Unix}, {Macintosh}, and {IBM PC}.

	See also {Hope+}, {Hope+C}, {Massey Hope}, {Concurrent Massey
	Hope}.

	{(ftp://brolga.cc.uq.oz.au/pub/hope)}.

	[R.M.Burstall, D.B.MacQueen, D.T.Sanella, "HOPE: An
	experimental applicative language", Proc. 1980 Lisp conf.,
	Stanford, CA, p.136-143, Aug 1980].

	["A HOPE Tutorial", R. Bailey, BYTE Aug 1985, pp.235-258].

	["Functional Programming with Hope", R. Bailey, Ellis Horwood
	1990].

	(1992-11-27)

this helps!!Dario
Joseph ha scritto:

Hi Dario,
I am running Fedora, and downloaded connector/J the last one. Also have
JAVA "/usr/JAVA/jdk1.5.0_05/bin/JAVA" installed. I also got MySql
installed but need to write some code in JAVA to access the database and
can not do that. I'm newbie here so a little more of details from you
might put me on the right path.
Thanks
wrote in message:
> Here are some useful link:
>
> http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html
>
> In my example, I used a datasource with a JNDI name configured in the
> webserver.
>
> Please can you tell me what's wrong with your example, so I can give
> you some hint?
>
>
> By
>
> Dario
>
>
> Joseph ha scritto:
>
>
Hi Dario,
I'm trying to get my JAVA with my connector to work for a small example.
if you can help here as I'm not sure how to get this accomplish that
would be great.
Thanks
Joseph
wrote in message:
>SOLVED!!
>
>I respond to myself: you are a stupid guy!!
>
>It was a mistake due to a distraction. I was compairing an md5-ed
>password with a not md5-ed password.
>
>
>Dario
>
>
wrote in message:
>
>
Hi,
I'm using JAVA 5 with connector/j 3.1.13.
I've a stupid query with two string parameters.
When I set the parameters and execute the query, it simply does not
work, and the worst is that it does not show throw any exceptions. The
result set is empty.
If I do not use the preparedstatement, it works.
I'm really get frustrated with this. Any hint?
Thanks!!
Dario
>
>
>

Next Message: trying to "connect"

Blogs related to Connector/j PreparedStatement DOESn't work

MySQL and Prepared Statements
As a result the MySQL Connector/J JDBC driver has now been modified so that calls ... to prepare the statement but the server doesn't have the appropriate support yet. ... The work around for me was to use createStatement() instead of ...

MySQL :: MySQL Connector/J 3.1.13 Has Been Released
MySQL Connector/J 3.1.13, a new version of the Type-IV all-Java JDBC ... Fixed BUG#19615, PreparedStatement.setObject(int, Object, int) doesn't respect scale of BigDecimals. ... getSomeNumeric() didn't work for the BIT type. ...