activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yuen Chi Lian" <yuenchi.l...@gmail.com>
Subject Re: Couldn't get jdbcPersistenceAdapter working
Date Wed, 10 Oct 2007 03:15:23 GMT
Hi Glen,

I still haven't got this working. I noticed that ActiveMQ was able to create
the activemq_locks and activemq_msgs tables but activemq_acks is missing in
my `show tables;` list. The same behaviour is reproducible by dropping the
database and start ActiveMQ on a clean one.

Any idea?


On 10/7/07, Yuen-Chi Lian <yuenchi.lian@gmail.com> wrote:
>
>
> Hi Glen,
>
> I have only one MySQL server instance running at that time (on port 3306).
> And the username/password used in the configuration is "root":"".
>
> I have tried, by specifying an invalid (non-existing) database name, a
> different error will be thrown instead.
>
> My Windows machine is not around and I'm with my Ubuntu right now. I will
> see if I can reproduce the problem, otherwise, I will have to come back
> here
> on Monday or Tuesday.
>
> Thanks for your reply.
>
> Cheers,
> Yuen-Chi Lian
>
>
> Glen Mazza-2 wrote:
> >
> > Am Freitag, den 05.10.2007, 02:20 -0700 schrieb Yuen-Chi Lian:
> >
> >> Hi all,
> >>
> >> This is strange. I have poked around Google and the mailing list, but
> >> couldn't really find the exact solution to my problem.
> >>
> >> I am trying to enable jdbc persistence and I am getting the error
> below:
> >>
> >> to start ActiveMQ JMS Message Broker. Reason: java.io.IOException:
> Failed
> >> to
> >> get last broker message id:
> >> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> >> 'activemq.activemq_acks' doesn't exist
> >
> > Normally the reason for an exception like this is rather
> > unambiguous--the database driver cannot find the database table
> > "activemq_acks" within the activemq schema, either (a) because it does
> > not exist or (b) the username/password you are supplying for that
> > database does not have access rights to that table.  Can you use an
> > external query tool to make sure the table exists (pay attention to case
> > sensitivity), and that the username you have accessing it can select
> > from that table?  Also, how many mysql installations do you have on your
> > machine?  That could be another problem.
> >
> > HTH,
> > Glen
> >
> >
> >> 1. I have MySQL JDBC driver in my classpath,
> >> mysql-connector-java-5.0.7-bin.jar
> >> 2. I have tried making things "clean" by removing my
> >> ${activemq.home}/activemq-data
> >> 3. I have tried uncommenting the mysql-ds in the default config as well
> >> as
> >> using my own simple one:
> >>
> >
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Couldn%27t-get-jdbcPersistenceAdapter-working-tf4574013s2354.html#a13079934
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>


-- 
Cheers,
Yuen-Chi Lian

"I do not seek; I find." - Pablo Picasso

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message