Thanks jeff, thats a question thats been bugging me for a while.
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 10:24
To: Sean O'Donnell; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: ensuring that I'm getting the correct last insert ID
Just
what happens if you are using connection pooling though?
-Original Message-
From: denonymous [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 08:09
To: [EMAIL PROTECTED]
Subject: Re: ensuring that I'm getting the correct last insert ID
From: Jonnycattt [EMAIL PROTECTED]
Hi all,
I know
its used a lot by java. As setting up and closing down connections to the
database
is relatively expensive, you use a pool manager, when the connection is
closed by
your code, it gets returned to the pool of open connections and is'nt
actually closed.
just held open and returned next time you
if you are using a connection pool the [close database connection] part of
your
example doesnt actually close the connection. so
1. Your code might be using several connections
2. Your code might use a different connection for each statement.
3. Even if your code only does use the one
Has anyone out there tried using jboss with mysql?
Any luck/problems?
Thanks
Sean
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
this is driving me mental, I'm using asp and mysql,
I'm running a query and getting back these two records
when running the query manually through mysqlfront ,
productid
5325301445
5325301446
when the page executes the query i get back a single result
1030334149
which doesnt actually exist in
whoops, the sql is
select distinct product.productid from product,productdetails where
product.productid=productdetails.productid and product.recordstatus='O' and
product.recordstatus='O' and productdetails.price= 1234.673264 and
productdetails.price= 0 and (product.instore = 0 or
why do you have to pay? I was under the impression
innodb was free as well...
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 08:33
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running MySQL for a big, fast app without
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 07:59
To: Sean O'Donnell
Subject: Re: InnoDB books
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one
there is odbc support on linux, you
can find a link the the myodbc drive for mysql
on mysql.com
-Original Message-
From: Liyju Janardhan [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 03:30
To: Chris Stewart; [EMAIL PROTECTED]
Subject: Re: Java to MySQL connection
which Driver your
i was under the impression that unless the application will 'only' run under
mysql
(ie uses a mysql specific feature), its perfectly legitimate to use it
without a licence.
For Example, if your application uses odbc to communicate with the
database, and
standard sql to perform database queries,
Anybody have any tools/tips for converting a foxpro database to mysql
___
Sean O'Donnell
Sentia Technologies Ltd.
Sentia House
104 Coolmine Business Park
Dublin 15 Ireland
e-mail [EMAIL PROTECTED]
web http://www.sentia.ie
phone + 353 1 821 9020
fax +
When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in
When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in
to give a particular user access to the database,
log in as root and type
grant all on databasename.* to username identified by password
to restrict that user to connecting from a particular host
grant all on databasename.* to username@hostname identified by password
the two options above
I had a similar problem before, asp would not return where any bigint types
where involved in the query. The fix was to check the 'convert bigint to
int' box
in the myodbc settings and everything came back just fine. might be worth
a try
Sean
-Original Message-
From: Mariusz
whoops, right you are,
but if the average reader is like me, they'll read the main
article , a comment or two , and bug out. The article itself
is quite definately dated
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2001 10:08
To: Sean O'Donnell;
as opposed to using safe_mysqld
try starting mysql using
/etc/init.d/rc.d/mysql start
and stopping using
/etc/init.d/rc.d/mysql stop
I had the same problem on a cobalt raq
running a variant of red hat and that
solved it.
Sean
-Original Message-
From: Adrian D'Costa [mailto:[EMAIL
They give away the previous version free
(i.e if they are on 1.9 you can download 1.8
and use it free)
-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: 13 July 2001 14:30
To: '[EMAIL PROTECTED]'
Cc: MySQL List (E-mail)
Subject: RE: MASON GUI for Windows is it good?
I've been trying to think up a system
to achieve this myself, but with practically no success.
I'm not using mysql long (only about 6 months), and my
c/C++ is a little rusty, but if you get off the ground with
this and need a grunt, give me a shout.
Sean
-Original Message-
From: Trevor
I hit up against something like this a while ago,
but I didnt have time to debug so I used a quick hack to
get by.
Say you are storing a text article
--
| ArticleID | INT |
--
|ArticleName | TEXT |
--
I just
Give MyODBC a try, its on the mysql.com site
and its given my no problems at all in vb.
Sean
-Original Message-
From: Robert Skinner [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:45 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL
try
echo file.sql mysql -u username -p password databasename
or on dos
type file.sql mysql -u username -p password databasename
That should execute the scripts on the db in question,
or you can download a a tool like mysqlgui/mysqlfront and
use it to load and run the queries.
Sean
whoops,
yip,
**blush**
-Original Message-
From: Jack Challen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:23 AM
To: [EMAIL PROTECTED]
Cc: Sean O'Donnell
Subject: Re: Hello please help me out
[EMAIL PROTECTED] wrote:
try
echo file.sql mysql -u username -p
From my experiance, you cant,
you can use all table names lowercase,
but that will mean you will have to refer to
them in lowercase when issuing queries. unix, unlike windows,
tends to operate in a case sensitive manner on everything
-Original Message-
From: Rui Rosa [mailto:[EMAIL
The password starts off as nothing
i.e on a fresh install you dont need to supply a password,
another way to set the password is to log in
, switch to the mysql database (use mysql;) and issue these queries
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;
any idea where any sort of documentation/tutorial can be found?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 1:45 PM
To: Nathanial Hendler
Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Perl Script: MySQL Slow Query Log Parser
hiya,
I've had exactly the setup you describe running on a laptop,
(I've since switched to nt / linux ), download mysql,myodbc,
and optionally mysqlfront. Just run the setup programs for mysql
and myodbc (very easy), and you are all set up. If you create
a odbc connection for you database you
I had the same problem last night,
eventually grant all to root on *.* identified by 'yourpass' got me in
I must have mucked up the permissions at
(the problem was with mysqlgui not mysqlshow though)
Sean
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
29 matches
Mail list logo