[Middlegen-user] Help with sample on jboss 3.2.1 and mysql 4.0

Russell Simpkins

2003-08-19 18:23:03 UTC

For whatever reason, you have what appears to be incorrect ddl. CREATE
TABLE SEQ_BLOCK (name VARCHAR(250) BINARY NOT NULL

proper ddl would not have the word binary after the datatype. It would seem
that there is an error in one of your ejb config files. I'm not an ejb
expert, so I don't know which one.

I would recommend posting help messages to the JBoss forums, becuase no one
answers this mailing list.

Subject: [Middlegen-user] Help with sample on jboss 3.2.1 and mysql 4.0
Date: Tue, 19 Aug 2003 05:47:37 -0700 (PDT)
Hello all,
I'm having a problem getting the middlegen sample to
WinXP
MySql 4.0.12
jboss-3.2.1_tomcat-4.1.24
middlegen-2.0-b1
ant-1.5.4
xdoclet-1.2b3
mysql-connector-java-3.0.0-beta-bin.jar
12:53:57,754 INFO [EntityContainer] Starting
12:53:58,956 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while
creating table; - nested t
BINARY in statement [CREATE
TABLE SEQ_BLOCK (name VARCHAR(250) BINARY NOT NULL,
idx INTEGER NOT NULL, CONSTR
AINT PK_SEQ_BLOCK PRIMARY KEY (name))])
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStart
Command.java:178)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartComm
and.java:87)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDB
CStoreManager.java:499)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
r.java:410)
...
I can execute the sql statement to MySql manually
without any problems using a console.
I've looked through the Middlegen, XDoclet, and JBoss
forums and tried a lot of different things but I'm
still not sure if the problem lies with JBoss,
XDoclet, or the sample app.
Does anyone have any ideas?
thanks in advance for any help, I've been stuck on
this for a while...but learning a lot.
Here's some more configuration information...
<datasources>
<local-tx-datasource>
<jndi-name>airline.database</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/airline</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>sdfgsdfg</user-name>
<password></password>
<min-pool-size>50</min-pool-size>
<max-pool-size>200</max-pool-size>
<blocking-timeout-millis>10000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</local-tx-datasource>
Seems like db connection is ok...
12:53:52,076 INFO [MainDeployer] Starting deployment
of package: file:/C:/java/
jboss-3.2.1_tomcat-4.1.24/server/default/deploy/mysql-ds.xml
12:53:52,186 INFO [XSLSubDeployer] transformed into
doc: [#document: null]
12:53:52,537 INFO [RARDeployment] Creating
12:53:52,537 INFO [RARDeployment] Created
12:53:52,537 INFO [JBossManagedConnectionPool]
Creating
12:53:52,537 INFO [JBossManagedConnectionPool]
Created
12:53:52,537 INFO [RARDeployment] Starting
12:53:52,547 INFO [STDOUT] Tue Aug 19 12:53:52 CEST
2003 Listening for connecti
ons ...
12:53:52,567 INFO [RARDeployment] Started
12:53:52,567 INFO [JBossManagedConnectionPool]
Starting
12:53:52,567 INFO [JBossManagedConnectionPool]
Started
file:/C:/java/jboss-3.2.1_to
mcat-4.1.24/server/default/deploy/mysql-ds.xml
...
12:53:53,728 INFO [database] Bound connection factory
for resource adapter for
ConnectionManager
'jboss.jca:service=LocalTxCM,name=airline.database to
JNDI nam
e 'java:/airline.database'
...
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

_________________________________________________________________
<b>Get MSN 8</b> and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus