Strange behavior by MySQL Stored Procedure

--=_23r4lvuz3tls
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Dear All,

I have one stored procedure Which inserts data into one table.

But sometimes it does not insert record. This happens when I called it from java application. But If I called same query from mysql command line. It executes successfully.

Also I have one procedure which only retrieves data from table. and it only gives one row sometime even if there are 10 rows available in for matching condition. This too happen when I called it from Java application and if I called it from mysql command line it gives me proper result set of 10 rows.

I am not able to understand Is it something known for mysql? Or am I doing something wrong?

Any input will be a great help.

--
Thanks and Regards,
Manasi Save


--=_23r4lvuz3tls
Content-Type: multipart/related;
boundary="=_283jq3ieqoao";
start="284pjvyo2kcg@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_283jq3ieqoao
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 284pjvyo2kcg@mail.artificialmachines.com

Dear All,

 

I have one stored procedure Which inserts data into one table.

 

But sometimes it does not insert record. This happens when I called it from java
application. But If I called same query from mysql command line. It executes
successfully.

 

Also I have one procedure which only retrieves data from table. and it only
gives one row sometime even if there are 10 rows available in for matching
condition. This too happen when I called it from Java application and if I
called it from mysql command line it gives me proper result set of 10 rows. />
 

I am not able to understand Is it something known for mysql? Or am I doing
something wrong?


Any input will be a great help.

 

--
Thanks and Regards,
Manasi Save


--=_283jq3ieqoao--

--=_23r4lvuz3tls--

Re: Strange behavior by MySQL Stored Procedure

2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;

you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure (or part of it)

.... probably, a subset of all of these infos will not be enough
to understand the problem.

In any case, if you have troubles using the mysql jdbc driver
but no problem using the mysql CLI and you suspect a
Connector/J bug, maybe you better write to the "mysql java"
support mailing list: http://lists.mysql.com/java

Greetings,

Mattia.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Strange behavior by MySQL Stored Procedure

--0016e68f9c1bb8427e0487a876d2
Content-Type: text/plain; charset=ISO-8859-1

Hello Manasi,

If possible can you please send in the code that you mentioned (procedure or
trigger).

Please give a detailed technical explanation explaining the query which you
used from command line and the query used in the procedure. Please mention
the table structure, show table status and few records from the query
executed.

Cheers,
Anirudh Sundar
9594506474
DataVail Mumbai.


On Fri, May 28, 2010 at 5:44 PM, Manasi Save <
manasi.save@artificialmachines.com> wrote:

> Dear All,
>
> I have one stored procedure Which inserts data into one table.
>
> But sometimes it does not insert record. This happens when I called it from
> java application. But If I called same query from mysql command line. It
> executes successfully.
>
> Also I have one procedure which only retrieves data from table. and it only
> gives one row sometime even if there are 10 rows available in for matching
> condition. This too happen when I called it from Java application and if I
> called it from mysql command line it gives me proper result set of 10 rows.
>
> I am not able to understand Is it something known for mysql? Or am I doing
> something wrong?
>
> Any input will be a great help.
>
> --
> Thanks and Regards,
> Manasi Save
>
>

--0016e68f9c1bb8427e0487a876d2--

Re: Strange behavior by MySQL Stored Procedure

mysql Version :- 5.1.42-community-log

mysql Connector/J Version :-  mysql-connector-java-5.1.6-bin.jar
 
Sample Java Code Which Calls stored procedure :- 
 
//get the connection to database
Connection dbConnection =3D getConnection();
 
//create the call for procedure
String procedureCallStmtStr =3D "Call XYZ()";
 
//create callable statement object
CallableStatement cs =3D conn.prepareCall(procedureCallStmtStr);
 
//execute the procedure
cs.execute();
 
//obtain resultset
ResultSet result =3D cs.getResultSet();
 
//Iterate to get the resultSet, if present
 
//commit transaction
conn.commit();
 
//close resultset, callableStatement
result.close();
cs.close();

 
Stored procedure which is getting called :- 
 
CREATE DEFINER=3D`myuser`@`localhost` PROCEDURE `AddCust`(InputUserID
BigInt, InputCustID BigInt, InputDBID BigInt, InputTimeStamp DateTime)
    DETERMINISTIC
BEGIN
 
Declare DBName Varchar(45);
 
Select InputDBID into DBName;
 
Drop Temporary Table If Exists Temp;
Create Temporary Table Temp
(
  UserID BigInt,
  CustID BigInt,
  MarkForDeletion Boolean
);
 
SET @stmt =3D Concat('Insert into Temp(UserID, CustID, MarkForDeletion)
            Select FK_UserID, FK_CustID,=
MarkForDeletion
            From `',DBName,'`.Tbl1
            Where FK_UserID =3D ',InputU=
serID,'
            and FK_CustID =3D ',InputCus=
tID,';');
 
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
 
IF Exists (Select CustID From Temp Where CustID =3D InputCustID)
Then
 
                    =
 SET @stmt =3D Concat('Update `',DBName,'`.Tbl1
                    =
             Set MarkForDeletion =3D 0,
                    =
             TimeStamp =3D
','"',InputTimeStamp,'"','
                    =
             Where FK_UserID =3D
',InputUserID,'
                    =
             and FK_CustID =3D
',InputCustID,';');
 
                    =
 Prepare stmt1 From @stmt;
                    =
 Execute stmt1;
                    =
 Deallocate Prepare stmt1;
ELSE
 
                    =
SET @stmt =3D Concat('Insert into ',
'`',DBName,'`.Tbl1 (FK_CustID, FK_UserID, MarkForDeletion, TimeStamp) ',
                    =
'Select ', '"', InputCustID, '"', ',',
'"',InputUserID,'"',', False',',','"',InputTimeStamp,'"',';');
 
                    =
 Prepare stmt1 From @stmt;
                    =
 Execute stmt1;
                    =
 Deallocate Prepare stmt1;
 
                    =
 Select InputUserID as RecordInserted;
 
END IF;

 
Thanks in advance.
 
--
Regards,
Manasi Save

On Fri, 28 May 2010 15:40:05 0200, Mattia Merzi wrote:
2010/5/28 Manasi Save :
> [...]
> > Or am I doing something wrong?
> probably;
>
> you better send us another e-mail writing at least:
> - mysql version you are using
> - mysql Connector/J version you are using
> - piece of java code you are using to call the stored procedure
> - source of the stored procedure (or part of it)
>
> ... probably, a subset of all of these infos will not be enough
> to understand the problem.
>
> In any case, if you have troubles using the mysql jdbc driver
> but no problem using the mysql CLI and you suspect a
> Connector/J bug, maybe you better write to the "mysql java"
> support mailing list: http://lists.mysql.com/java
>
> Greetings,
>
> Mattia.
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Strange behavior by MySQL Stored Procedure

--0-1682339346-1275365172=:84898
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Stored procedures are not executed like a query. 
They are executed thru a Call { procedure} method.
Please check the same or let us know how you are executing the Query/Callin=
g the Procedure.
Regards,
VR Venugopal Rao


--- On Fri, 28/5/10, Manasi Save wrote=
:


From: Manasi Save
Subject: Strange behavior by MySQL Stored Procedure
To: mysql@lists.mysql.com
Date: Friday, 28 May, 2010, 5:44 PM


Dear All,
=A0
I have one stored procedure Which inserts data into one table.
=A0
But sometimes it does not insert record. This happens when I called it from=
java application. But If I called same query from mysql command line. It e=
xecutes successfully.
=A0
Also I have one procedure which only retrieves data from table. and it only=
gives one row sometime even if there are 10 rows available in for matching=
condition. This too happen when I called it from Java application and if I=
called it from mysql command line it gives me proper result set of 10 rows=
..
=A0
I am not able to understand Is it something known for mysql? Or am I doing =
something wrong?

Any input will be a great help.
=A0
--
Thanks and Regards,
Manasi Save=20


--0-1682339346-1275365172=:84898--

Re: Strange behavior by MySQL Stored Procedure

--=_46skeh2xpvuo
Content-Type: text/plain;
charset=UTF-8;
format="flowed"
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Dear Venugopal,

Here's the Sample Java Code Which Calls stored procedure :-

//get the connection to database
Connection dbConnection = getConnection();

//create the call for procedure
String procedureCallStmtStr = "Call XYZ()";

//create callable statement object
CallableStatement cs = conn.prepareCall(procedureCallStmtStr);

//execute the procedure
cs.execute();

//obtain resultset
ResultSet result = cs.getResultSet();

//Iterate to get the resultSet, if present

//commit transaction
conn.commit();

//close resultset, callableStatement
result.close();
cs.close();

But, can it be a problem if I am executing a stored procedure anywhere?
Well, I am not aware of Java so really cannot debug this.

Thanks in advance.

--
Regards,
Manasi Save

On Tue, 1 Jun 2010 09:36:12 +0530 (IST), Venugopal Rao wrote:

Stored procedures are not executed like a query.
They are executed thru a Call { procedure} method.
Please check the same or let us know how you are executing the
Query/Calling the Procedure.
Regards,
VR Venugopal Rao

--- On Fri, 28/5/10, Manasi Save wrote:

From: Manasi Save
Subject: Strange behavior by MySQL Stored Procedure
To: mysql@lists.mysql.com
Date: Friday, 28 May, 2010, 5:44 PM

Dear All,

I have one stored procedure Which inserts data into one table.

But sometimes it does not insert record. This happens when I called it
from java application. But If I called same query from mysql command
line. It executes successfully.

Also I have one procedure which only retrieves data from table. and it
only gives one row sometime even if there are 10 rows available in for
matching condition. This too happen when I called it from Java
application and if I called it from mysql command line it gives me
proper result set of 10 rows.

I am not able to understand Is it something known for mysql? Or am I
doing something wrong?

Any input will be a great help.

--
Thanks and Regards,
Manasi Save



--=_46skeh2xpvuo
Content-Type: multipart/related;
boundary="=_51iiioqx9aio";
start="51jh99bqz14w@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_51iiioqx9aio
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 51jh99bqz14w@mail.artificialmachines.com

Dear Venugopal,
 
Here's the Sample Java Code Which Calls
stored procedure :- 
 
//get the connection to database />Connection dbConnection = getConnection();
 
//create the call
for procedure
String procedureCallStmtStr = "Call XYZ()";
  />//create callable statement object
CallableStatement cs =
conn.prepareCall(procedureCallStmtStr);
 
//execute the
procedure
cs.execute();
 
//obtain resultset
ResultSet
result = cs.getResultSet();
 
//Iterate to get the resultSet, if
present
 
//commit transaction
conn.commit();
  />//close resultset, callableStatement
result.close();
cs.close(); /> 
But, can it be a problem if I am executing a stored procedure
anywhere? Well, I am not aware of Java so really cannot debug this. /> 
Thanks in advance.

--
Regards,
Manasi Save />
On Tue, 1 Jun 2010 09:36:12 +0530 (IST), Venugopal Rao wrote:

Stored procedures are not executed like a query.  They are executed thru a Call { procedure} method. Please check the same or let us know how you are executing the Query/Calling the Procedure. Regards, VR Venugopal Rao --- On Fri, 28/5/10, Manasi Save <manasi.save@artificialmachines.com> wrote: From: Manasi Save <manasi.save@artificialmachines.com> />Subject: Strange behavior by MySQL Stored Procedure To: mysql@lists.mysql.com Date: Friday, 28 May, 2010, 5:44 PM Dear All,   I have one stored procedure Which inserts data into one table.   But sometimes it does not insert record. This happens when I called it from java application. But If I called same query from mysql command line. It executes successfully. />  Also I have one procedure which only retrieves data from table. and it only gives one row sometime even if there are 10 rows available in for matching condition. This too happen when I called it from Java application and if I called it from mysql command line it gives me proper result set of 10 rows.   I am not able to understand Is it something known for mysql? Or am I doing something wrong? Any input will be a great help.   -- Thanks and Regards, Manasi Save

Re: Strange behavior by MySQL Stored Procedure

--=_7i7pmnfhtksg
Content-Type: text/plain;
charset=UTF-8;
format="flowed"
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Does anyone have any sort of any idea on how to deal with this problem?
This is happening again and again and not all the time but randomly anytime.

--
Regards,
Manasi Save

On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save wrote:

Dear Venugopal,

Here's the Sample Java Code Which Calls stored procedure :-

//get the connection to database
Connection dbConnection = getConnection();

//create the call for procedure
String procedureCallStmtStr = "Call XYZ()";

//create callable statement object
CallableStatement cs = conn.prepareCall(procedureCallStmtStr);

//execute the procedure
cs.execute();

//obtain resultset
ResultSet result = cs.getResultSet();

//Iterate to get the resultSet, if present

//commit transaction
conn.commit();

//close resultset, callableStatement
result.close();
cs.close();

But, can it be a problem if I am executing a stored procedure anywhere?
Well, I am not aware of Java so really cannot debug this.

Thanks in advance.

--
Regards,
Manasi Save

On Tue, 1 Jun 2010 09:36:12 +0530 (IST), Venugopal Rao wrote:

Stored procedures are not executed like a query.
They are executed thru a Call { procedure} method.
Please check the same or let us know how you are executing the
Query/Calling the Procedure.
Regards,
VR Venugopal Rao

--- On Fri, 28/5/10, Manasi Save wrote:

From: Manasi Save
Subject: Strange behavior by MySQL Stored Procedure
To: mysql@lists.mysql.com
Date: Friday, 28 May, 2010, 5:44 PM

Dear All,

I have one stored procedure Which inserts data into one table.

But sometimes it does not insert record. This happens when I called it
from java application. But If I called same query from mysql command
line. It executes successfully.

Also I have one procedure which only retrieves data from table. and it
only gives one row sometime even if there are 10 rows available in for
matching condition. This too happen when I called it from Java
application and if I called it from mysql command line it gives me
proper result set of 10 rows.

I am not able to understand Is it something known for mysql? Or am I
doing something wrong?

Any input will be a great help.

--
Thanks and Regards,
Manasi Save



--=_7i7pmnfhtksg
Content-Type: multipart/related;
boundary="=_vfg71trcvvk";
start="vgjw9wzlqao@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_vfg71trcvvk
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: vgjw9wzlqao@mail.artificialmachines.com

Does anyone have any sort of any idea on how to deal with this problem?

This is happening again and again and not all the time but randomly anytime. />
--
Regards,
Manasi Save 





On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save
wrote:

Dear Venugopal,
 
Here's the Sample
Java Code Which Calls stored procedure :- 
 
//get the
connection to database
Connection dbConnection = getConnection(); /> 
//create the call for procedure
String procedureCallStmtStr =
"Call XYZ()";
 
//create callable statement object />CallableStatement cs = conn.prepareCall(procedureCallStmtStr);
  />//execute the procedure
cs.execute();
 
//obtain
resultset
ResultSet result = cs.getResultSet();
 
//Iterate
to get the resultSet, if present
 
//commit transaction />conn.commit();
 
//close resultset, callableStatement />result.close();
cs.close();
 
But, can it be a problem if
I am executing a stored procedure anywhere? Well, I am not aware of Java so
really cannot debug this.
 
Thanks in advance.

-- />Regards,
Manasi Save

On Tue, 1 Jun 2010 09:36:12 +0530 (IST),
Venugopal Rao wrote:

Stored procedures are not executed like a query.  They are executed thru a Call { procedure} method. Please check the same or let us know how you are executing the Query/Calling the Procedure. Regards, VR Venugopal Rao --- On Fri, 28/5/10, Manasi Save <manasi.save@artificialmachines.com> wrote: From: Manasi Save <manasi.save@artificialmachines.com> />Subject: Strange behavior by MySQL Stored Procedure To: mysql@lists.mysql.com Date: Friday, 28 May, 2010, 5:44 PM Dear All,   I have one stored procedure Which inserts data into one table.   But sometimes it does not insert record. This happens when I called it from java application. But If I called same query from mysql command line. It executes successfully. />  Also I have one procedure which only retrieves data from table. and it only gives one row sometime even if there are 10 rows available in for matching condition. This too happen when I called it from Java application and if I called it from mysql command line it gives me proper result set of 10 rows.   I am not able to understand Is it something known for mysql? Or am I doing something wrong? Any input will be a great help.   -- Thanks and Regards, Manasi Save

 

Replication of MySQL Stored Procedure

Hi!

I have a database in the wild ignore table as table.%. Recently I
created a store procedure on it and it replicated. Does any one know
if this is normal bahvior? If I wanted to make sure store procedures
do not replicate, what should I do?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Replication of MySQL Stored Procedure

I think this is normal because stored procedures live in mysql.proc.

You would have to filter out mysql.proc by adding this to /etc/my.cnf

replicate-ignore-table=3Dmysql.proc

Rolando A. Edwards
MySQL DBA (CMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@logicworks.net
http://www.linkedin.com/in/rolandoedwards


-----Original Message-----
From: Sabika Gmail [mailto:sabika.makhdoom@gmail.com]=20
Sent: Monday, June 07, 2010 11:14 AM
To: mysql@lists.mysql.com
Subject: Replication of MySQL Stored Procedure

Hi!

I have a database in the wild ignore table as table.%. Recently I =20
created a store procedure on it and it replicated. Does any one know =20
if this is normal bahvior? If I wanted to make sure store procedures =20
do not replicate, what should I do?

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dredwards@logicworks=
..net


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Replication of MySQL Stored Procedure

I already have mysql in the replicate wild ingore table. I am running
mysql 5.1.40sp1

Could it be a bug?

On Jun 7, 2010, at 8:30 AM, Rolando Edwards
wrote:

> I think this is normal because stored procedures live in mysql.proc.
>
> You would have to filter out mysql.proc by adding this to /etc/my.cnf
>
> replicate-ignore-table=mysql.proc
>
> Rolando A. Edwards
> MySQL DBA (CMDBA)
>
> 155 Avenue of the Americas, Fifth Floor
> New York, NY 10013
> 212-625-5307 (Work)
> 201-660-3221 (Cell)
> AIM & Skype : RolandoLogicWorx
> redwards@logicworks.net
> http://www.linkedin.com/in/rolandoedwards
>
>
> -----Original Message-----
> From: Sabika Gmail [mailto:sabika.makhdoom@gmail.com]
> Sent: Monday, June 07, 2010 11:14 AM
> To: mysql@lists.mysql.com
> Subject: Replication of MySQL Stored Procedure
>
> Hi!
>
> I have a database in the wild ignore table as table.%. Recently I
> created a store procedure on it and it replicated. Does any one know
> if this is normal bahvior? If I wanted to make sure store procedures
> do not replicate, what should I do?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=redwards@logicworks.net
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Replication of MySQL Stored Procedure

I think even if you ignore the mysql database from replication and set
Is_Deterministic = YES then your stored procedures will be replicated.
Please set it to NO if you do not wish the stored procedures will not
be replicated. You can set this in mysql.proc table.

--
Regards,
Manasi Save

On Mon, 7 Jun 2010 12:31:13 -0700, Sabika Gmail wrote:
I already have mysql in the replicate wild ingore table. I am running
> mysql 5.1.40sp1
>
> Could it be a bug?
>
> On Jun 7, 2010, at 8:30 AM, Rolando Edwards
> wrote:
>
> > I think this is normal because stored procedures live in mysql.proc.
> >
> > You would have to filter out mysql.proc by adding this to /etc/my.cnf
> >
> > replicate-ignore-table=mysql.proc
> >
> > Rolando A. Edwards
> > MySQL DBA (CMDBA)
> >
> > 155 Avenue of the Americas, Fifth Floor
> > New York, NY 10013
> > 212-625-5307 (Work)
> > 201-660-3221 (Cell)
> > AIM & Skype : RolandoLogicWorx
> > redwards@logicworks.net
> > http://www.linkedin.com/in/rolandoedwards
> >
> >
> > -----Original Message-----
> > From: Sabika Gmail [mailto:sabika.makhdoom@gmail.com]
> > Sent: Monday, June 07, 2010 11:14 AM
> > To: mysql@lists.mysql.com
> > Subject: Replication of MySQL Stored Procedure
> >
> > Hi!
> >
> > I have a database in the wild ignore table as table.%. Recently I
> > created a store procedure on it and it replicated. Does any one know
> > if this is normal bahvior? If I wanted to make sure store procedures
> > do not replicate, what should I do?
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/mysql?unsub=redwards@logicworks.net
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=manasi.save@artificialmac hines.com
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Replication of MySQL Stored Procedure

--000e0cd32eaaa5296e04887eacb7
Content-Type: text/plain; charset=ISO-8859-1

SP generally goes as per the database you have created. Set you binlog off
while creating for the sql.

sql_log_bin is the variable to do it.



On Tue, Jun 8, 2010 at 1:01 AM, Sabika Gmail wrote:

> I already have mysql in the replicate wild ingore table. I am running mysql
> 5.1.40sp1
>
> Could it be a bug?
>
>
> On Jun 7, 2010, at 8:30 AM, Rolando Edwards
> wrote:
>
> I think this is normal because stored procedures live in mysql.proc.
>>
>> You would have to filter out mysql.proc by adding this to /etc/my.cnf
>>
>> replicate-ignore-table=mysql.proc
>>
>> Rolando A. Edwards
>> MySQL DBA (CMDBA)
>>
>> 155 Avenue of the Americas, Fifth Floor
>> New York, NY 10013
>> 212-625-5307 (Work)
>> 201-660-3221 (Cell)
>> AIM & Skype : RolandoLogicWorx
>> redwards@logicworks.net
>> http://www.linkedin.com/in/rolandoedwards
>>
>>
>> -----Original Message-----
>> From: Sabika Gmail [mailto:sabika.makhdoom@gmail.com]
>> Sent: Monday, June 07, 2010 11:14 AM
>> To: mysql@lists.mysql.com
>> Subject: Replication of MySQL Stored Procedure
>>
>> Hi!
>>
>> I have a database in the wild ignore table as table.%. Recently I
>> created a store procedure on it and it replicated. Does any one know
>> if this is normal bahvior? If I wanted to make sure store procedures
>> do not replicate, what should I do?
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=redwards@logicworks.net
>>
>>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumarilu@gmail.com
>
>


--
Thanks
Suresh Kuna
MySQL DBA

--000e0cd32eaaa5296e04887eacb7--

[ANN]VTD-XML 2.9

------=_NextPart_000_0221_01CB3A82.BA12E0F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

VTD-XML 2.9, the next generation XML Processing API for SOA and Cloud =
computing, has been released. Please visit =
https://sourceforge.net/projects/vtd-xml/files/ to download the latest =
version.
a.. Strict Conformance=20
a.. VTD-XML now fully conforms to XML namespace 1.0 spec=20
b.. Performance Improvement
a.. Significantly improved parsing performance for small XML files=20
c.. Expand Core VTD-XML API =20
a.. Adds getPrefixString(), and toNormalizedString2()=20
d.. Cutting/Splitting=20
a.. Adds getSiblingElementFragment() =20
e.. A number of bug fixes and code enhancement including:=20
a.. Fixes a bug for reading very large XML documents on some =
platforms=20
b.. Fixes a bug in parsing processing instruction=20
c.. Fixes a bug in outputAndReparse()=20

------=_NextPart_000_0221_01CB3A82.BA12E0F0--