List:Cluster« Previous MessageNext Message »
From:Serdyn du Toit Date:July 15 2013 9:54am
Subject:Re: CRUD in MySql general log
View as plain text  
Hi Craig,

> What I meant is the mysqld that you are using with the clusterjpa plugin.
You configure your openjpa with the clusterjpa plugin.
Aaah, okay - so I shouldn't expect to see clusterj and openjpa when using
SHOW PLUGINS, but it should be installed automatically.  (I do see a few
ndb plugins)

The only thing I need to configure in OpenJpa is the persistence.xml right?
 I used OpenJpa 2.2.2, but the same problem is present using the OpenJpa
1.3.x branch.

Properties in my persistence.xml are as follows:
      <!-- MySql Cluster port 5000 -->
      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"
/>
      <property name="openjpa.ConnectionDriverName"
value="com.mysql.jdbc.Driver" />
      <property name="openjpa.ConnectionURL"
value="jdbc:mysql://localhost:5000/clusterdb" />
      <property name="openjpa.ConnectionUserName" value="root" />
      <property name="openjpa.ConnectionPassword" value="" />
      <property name="openjpa.BrokerFactory" value="ndb" />
      <property name="openjpa.jdbc.DBDictionary" value="TableType=ndb" />
      <property name="openjpa.ndb.connectString" value="localhost:1186" />
      <property name="openjpa.ndb.database" value="clusterdb" />
      <property name="openjpa.Log" value="DefaultLevel=TRACE" />

My table does use the ndbcluster engine:
CREATE TABLE `testdatabean` (
  `id` bigint(20) NOT NULL,
  `createDate` datetime DEFAULT NULL,
  `lastEventTypeId` int(11) DEFAULT NULL,
  `lastUpdate` datetime DEFAULT NULL,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;

I enabled and used the general log as follows:
SET global general_log = 1;
SET global log_output = 'table';
select * from mysql.general_log;

Some entries from the general log:
| 2013-07-15 11:40:38 | root[root] @ localhost [127.0.0.1] |        34 |
 0 | Query        | INSERT INTO TestDataBean (id, createDate,
lastEventTypeId, l
astUpdate, firstName, lastName) VALUES (100, '2013-07-15 11:40:38.335', 1,
'2013
-07-15 11:40:38.335', 'testFirstName', 'testLastName')
| 2013-07-15 11:40:38 | root[root] @ localhost [127.0.0.1] |        34 |
 0 | Query        | UPDATE TestDataBean SET firstName = 'MODIFIED-Mon Jul
15 11:
40:38 CAT 2013' WHERE id = 100

Java stacktrace with OpenJpa loglevel TRACE: http://pastebin.com/JaP9dL7s

Kind regards,
Serdyn du Toit


On Mon, Jul 15, 2013 at 7:34 AM, Craig L Russell <craig.russell@stripped>
wrote:

Sorry if I was not clear.

You don't build mysqld with the clusterjpa plugin.

What I meant is the mysqld that you are using with the clusterjpa plugin.
You configure your openjpa with the clusterjpa plugin.

Regards,

Craig

Thread
CRUD in MySql general logSerdyn du Toit14 Jul
  • Re: CRUD in MySql general logSerdyn du Toit14 Jul
    • Re: CRUD in MySql general logCraig L Russell14 Jul
      • Re: CRUD in MySql general logSerdyn du Toit15 Jul
        • Re: CRUD in MySql general logCraig L Russell15 Jul
          • Re: CRUD in MySql general logSerdyn du Toit15 Jul
            • Re: CRUD in MySql general logSerdyn du Toit19 Jul
              • Re: CRUD in MySql general logSerdyn du Toit22 Jul
              • Re: CRUD in MySql general logCraig L Russell20 Aug
  • Re: CRUD in MySql general logCraig L Russell14 Jul
    • Re: CRUD in MySql general logSerdyn du Toit14 Jul
      • Re: CRUD in MySql general logSerdyn du Toit15 Jul
        • Re: CRUD in MySql general logCraig L Russell15 Jul
          • Re: CRUD in MySql general logSerdyn du Toit16 Jul
            • Re: CRUD in MySql general logSerdyn du Toit16 Jul
              • Re: CRUD in MySql general logSerdyn du Toit22 Jul
                • Re: CRUD in MySql general logCraig L Russell23 Jul
                  • Re: CRUD in MySql general logSerdyn du Toit23 Jul
                    • Re: CRUD in MySql general logSerdyn du Toit23 Jul