R: R: R: R: R: App + ConnectorJ + MXJ deployment - tech - com.mysql.lists.java

9 messages in com.mysql.lists.javaR: R: R: R: R: App + ConnectorJ + MXJ...

From	Sent On	Attachments
tech	29 Sep 2006 03:25	.txt
Eric Herman	29 Sep 2006 05:28
tech	02 Oct 2006 05:25
Eric Herman	02 Oct 2006 06:03
tech	06 Oct 2006 07:35
Eric Herman	06 Oct 2006 07:40
Eric Herman	06 Oct 2006 09:15
tech	09 Oct 2006 03:21
tech	12 Oct 2006 00:04

Subject:	R: R: R: R: R: App + ConnectorJ + MXJ deployment
From:	tech (te...@edoss.it)
Date:	10/12/2006 12:04:35 AM
List:	com.mysql.lists.java

Hi Eric,

I added your foo table to my DB.

I created the table by means of your SQL statement and inserted a few rows by means of phpMyAdmin 2.8.2.4

As usual, my app connected properly when was unaware of connector-mxj and failed with the redeployed customized connector-mxj including the new data_dir.jar.

The error message was the same as with my anlog00f table:

061009 11:03:31 [ERROR] C:\roberto_test\mysql-mxj\bin\mysqld-nt.exe: Incorrect information in file: '.\rua142\foo.frm'

The query which fails from my app can be executed successfully from the interactive SQL query tool of phpMyAdmin 2.8.2.4

To summarize,

My data_dir.jar includes: 1) the directories META-INF, mysql, test, rua142 (my DB with my table anlog00f, your table foo and the file db.opt) 2) the files ib_logfile0, ib_logfile1, ib_data1

My data_dir.jar was added to the directory 5-0-22 of the unpacked connector-mxj where it replaced the existing data_dir.jar

The following directories: 5-0-22, com, META-INF

And files: ConnectorMXJObjectTestExample.class, ConnectorMXJUrlTestExample.class, kill.exe, TestDB.class, support-issue-8601-help-output.txt

were packed together to form the new connector-mxj.jar.

The new connector-mxj.jar was added to the directory where the previous connector-mxj.jar was and replaced it.

Two distinct paths to connector-mxj.jar and data_dir.jar are in the CLASSPATH.

Is the above configuration correct ? If that's true, can you please tell me if there is an alternative solution, as the above configuration does not work ?

Cheers Roberto

-----Messaggio originale----- Da: Eric Herman [mailto:er...@mysql.com] Inviato: venerdì 6 ottobre 2006 18.16 A: tech Cc: ja...@lists.mysql.com Oggetto: Re: R: R: R: R: App + ConnectorJ + MXJ deployment

Hi Roberto,

from the console output you attached, looking at:

060929 12:20:41 [ERROR] C:\roberto_test\mysql-mxj\bin\mysqld-nt.exe: Incorrect information in file: '.\rua142\anlog00f.frm'

That looks to me like mysqld-nt.exe 5.0.22 doesn't like the table.

What version of MySQL was used to create the custom data dir which was used to create the data_dir.jar file added to connector-mxj.jar?

Today I created a data directory using MySQL v5.0.24a (windows) and populated the "test" database with a simple table:

create table foo( \ id INTEGER NOT NULL AUTO_INCREMENT, \ stuff TEXT NOT NULL, \ PRIMARY KEY(id)) CHARACTER SET utf8 \ ENGINE=InnoDB;

Next, I inserted half a dozen rows.

Then, I used this data directory with Connector/MXJ and it worked as expected: I was able to do selects and inserts and deletes just fine.

At this point I'm not sure how to re-create the failure.

Obviously there is something slightly different between what we are seeing in your environment and what we are seeing in mine.

If you can guide me through, step-by-step, a series of instructions that will re-create the failure, I should be able to find the problem at fix it. Without a failure I can experience, it is very hard to speculate.

Cheers, -Eric