connector/mxj

Thread view:

Lionel - 15 Sep 2006 00:42 GMT

Has anyone got any experience with connector/mxj? I was trying it out
last night and using some example from MySQL to start the server. I knew
that MySQL was running already so I wanted to see what would happen. The
first time I used the MysqldResource to check if the database was
running and if not start it worked fine. But every time after that it
claimed that it wasn't running. It's quite slow too, certainly something
you only want to do once.

Thanks

Lionel.

Reply to this Message

Arne Vajhøj - 15 Sep 2006 00:58 GMT

> Has anyone got any experience with connector/mxj? I was trying it out
> last night and using some example from MySQL to start the server. I knew
> that MySQL was running already so I wanted to see what would happen.

Now I am confused.

Connector/J is for MySQL daemon where MySQL can be running.

Connector/MXJ is for embedded MySQL.

Are you testing whether MySQL daemon and embedded MySQL
can coexist without conflicts or ?

Arne

Reply to this Message

Lionel - 15 Sep 2006 01:07 GMT

>> Has anyone got any experience with connector/mxj? I was trying it out
>> last night and using some example from MySQL to start the server. I
[quoted text clipped - 8 lines]
> Are you testing whether MySQL daemon and embedded MySQL
> can coexist without conflicts or ?

Hmmm, maybe you have a point there . . . gees I was finding all the
documentation by google searches and I didn't notice anything about
embedded. So is connector/J able to test if MySQL is running and if not
start it also? I'm going to go look now and straighten out my head.

Lionel.

Reply to this Message

Arne Vajhøj - 15 Sep 2006 01:11 GMT

> So is connector/J able to test if MySQL is running and if not
> start it also?

I do not think so.

It is a standard JDBC driver.

You get an exception if you connect and the server
is down.

And I guess you can start MySQL with Runtime.getRuntime().exec(),
but that is not the driver.

Arne

Reply to this Message

Lionel - 15 Sep 2006 01:13 GMT

>> So is connector/J able to test if MySQL is running and if not start it
>> also?
[quoted text clipped - 5 lines]
> You get an exception if you connect and the server
> is down.

Yeah, just looking back. I've been using JDBC all along obviously. It's
funny that connector/mxj appeared to at least partially work.

> And I guess you can start MySQL with Runtime.getRuntime().exec(),
> but that is not the driver.

Ok, something along these lines is what I'm looking for. I want to try
to do everything possible to get a server up and running before I tell
the user that I don't know what's going on and they need to contact
someone to sort it out. connector/mxj appeared to offer this but
obviously not :).

Lionel.

Reply to this Message

connector/mxj

Free Magazines