Scott,
I strongly suggest that you remove all JDBC Driver and DataSource information
that you are not actively using from your configuration. IMHO, that is the
easiest way to determine if you are indeed connecting to the correct database.
When I first started trying to connect to an alternate database, I had the
datasource configuration slightly wrong. I would get a connection to the
default datasource instead of the one I was trying to connect to, with NO
warning.
Removing the other database entries in all of your configuration files will also
speed up your test cycle since you will not have to wait for the unused database
engines to be started and run.
- Tim
----- Original Message -----
From: "Scott Salisbury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 11:35 PM
Subject: [JBoss-user] MySQL, BMP, Table not found
Hello,
I am using the O'Reilly book to familiarize with EJB. I am using JBOSS
2.2.1 with Tomcat 3.2.1. I am able to get CMP beans to work using MySQL
without a problem however when I try to insert a row using BMP I get the
following message..
Table not found: TEST.SHIP in statement [insert into test.Ship (id, name,
capacity, tonnage) values (4,'UtopiaBMP',4500,8939.0)]
The table is there. I am using MySQL but I have a feeling that JBOSS is
trying to write to InstantDB or Hypersonic. I have included configuration
files below.
I have reviewed the archives but still can't figure it out. What have I
missed?
.
.
.
JDBC section of jboss.jcml
<!-- JDBC -->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.
gjt.mm.mysql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=mySQLDB">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="PoolName">mySQLDS</attribute>
<attribute name="URL">jdbc:mysql://165.121.243.05/test</attribute>
<attribute name="JDBCUser" />
<attribute name="Password" />
</mbean>
.
.
.
.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
