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.
From: Lee Namba <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 run. My setup:
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
The error I'm getting is during EJB deployment:
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 hrowable: (java.sql.SQLException: Unexpected token: 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...
JBoss "mysql-ds.xml" file:
<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>
JBoss startup log excerpts:
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 12:53:52,577 INFO [MainDeployer] Deployed package: 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 [EMAIL PROTECTED] 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
------------------------------------------------------- This SF.net email is sponsored by Dice.com. Did you know that Dice has over 25,000 tech jobs available today? From careers in IT to Engineering to Tech Sales, Dice has tech jobs from the best hiring companies. http://www.dice.com/index.epl?rel_code=104 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
