[jboss-user] [Installation, Configuration & Deployment] - Deployment Exception Error while creating table : Unexpecte
suziesirena
do-not-reply at jboss.com
Wed Sep 6 22:07:33 EDT 2006
Hi everybody,
I'm absolutely newbie on JBoss and I'm searching hard in all forums, mailling archives, newsletter, etc..... to understand what is wrong with my deployement.
I'm now tired of searching and I ask for your help :
I try to install Tambur Message Gateway (http://www.tambur.org/)
I put a "Tambur" directory in /usr/local/jboss4/server/default/deploy with the following structure :
tambur-ds.xml
tambur.ear
lib/commons-httpclient-2.0.jar
lib/tambur-mmslib.jar
lib/tambur-wbxml.jar
lib/jakarta-regexp-1.2.jar
lib/jdom.jar
lib/tl-netty2-1.6.1.jar
I put a "rowset.jar" file into server/default/lib directory
and a "tambur.properties" file into the server/default/conf
I tell you about this because I followed Tambur installation notes but I d'ont know the purpose of all this files.
So !
When I launch Jboss, I have these errors :
anonymous wrote :
| 2006-09-07 13:33:11,434 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Service] Executing SQL: CREATE TABLE BILLINGSERVICE (id INTEGER NOT NULL, account INTEGER NOT NULL, weight INTEGER NOT NULL, type INTEGER NOT NULL, enabled TINYINT, validFrom BIGINT NOT NULL, validTo BIGINT NOT NULL, ident VARCHAR(250) BINARY, descr VARCHAR(64), shortnumber VARCHAR(16), operator VARCHAR(16), transCost DOUBLE NOT NULL, transRevenue DOUBLE NOT NULL, monthlyCost DOUBLE NOT NULL, CONSTRAINT PK_BILLINGSERVICE PRIMARY KEY (id))
| 2006-09-07 13:33:11,434 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Service] Could not create table BILLINGSERVICE
| 2006-09-07 13:33:11,434 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
| 2006-09-07 13:33:11,434 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
| 2006-09-07 13:33:11,434 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
| 2006-09-07 13:33:11,444 DEBUG [org.jboss.ejb.EjbModule] Starting failed jboss.j2ee:service=EjbModule,module=tambur-billing.jar
| org.jboss.deployment.DeploymentException: Error while creating table BILLINGSERVICE; - nested throwable: (java.sql.SQLException: Unexpected token: BINARY in statement [CREATE TABLE BILLINGSERVICE (id INTEGER NOT NULL, account INTEGER NOT NULL, weight INTEGER NOT NULL, type INTEGER NOT NULL, enabled TINYINT, validFrom BIGINT NOT NULL, validTo BIGINT NOT NULL, ident VARCHAR(250) BINARY])
|
A lot of peopple have this error : Unexpected token: BINARY in statement but I don't find how to fix it.
My tambur-ds.xml is :
anonymous wrote :
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!-- Use MySQL database on localhost
| <local-tx-datasource>
| <jndi-name>TamburDS</jndi-name>
| <connection-url>jdbc:mysql://localhost:3306/tambur</connection-url>
| <driver-class>org.gjt.mm.mysql.Driver</driver-class>
| <user-name>tambur</user-name>
|
| <min-pool-size>5</min-pool-size>
| </local-tx-datasource>
| -->
|
| <!-- HQSLDB -->
| <local-tx-datasource>
| <jndi-name>TamburDS</jndi-name>
| <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}TamburDB</connection-url>
| <driver-class>org.hsqldb.jdbcDriver</driver-class>
| <user-name>sa</user-name>
|
| <min-pool-size>5</min-pool-size>
| <max-pool-size>20</max-pool-size>
| <idle-timeout-minutes>0</idle-timeout-minutes>
| <track-statements/>
|
| <type-mapping>Hypersonic SQL</type-mapping>
|
| jboss:service=Hypersonic,database=localDB
| </local-tx-datasource>
|
|
| TamburDB
| true
|
|
|
|
and I found a file "build/billing/META-INF/jbosscmp-jdbc.xml" in source like as follow but nothing about binary Type :
anonymous wrote :
| <?xml version="1.0" encoding="UTF-8"?>
| <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
|
| <jbosscmp-jdbc>
|
| java:/TamburDS
| <datasource-mapping>mySQL</datasource-mapping>
| <create-table>true</create-table>
| <alter-table>false</alter-table>
|
|
| <enterprise-beans>
|
| <!--
| To add beans that you have deployment descriptor info for, add
| a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml
| that contains the markup for those beans.
| -->
|
|
| <ejb-name>Summary</ejb-name>
|
| <table-name>billingsummary</table-name>
|
| <cmp-field>
| <field-name>id</field-name>
| <column-name>id</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>dateTime</field-name>
| <column-name>datetime</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>sid</field-name>
| <column-name>sid</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>account</field-name>
| <column-name>account</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>count</field-name>
| <column-name>count</column-name>
|
| </cmp-field>
|
| <!-- jboss 3.2 features -->
| <!-- optimistic locking does not express the exclusions needed -->
|
|
|
| <ejb-name>Service</ejb-name>
|
| <table-name>billingservice</table-name>
|
| <cmp-field>
| <field-name>id</field-name>
| <column-name>id</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>account</field-name>
| <column-name>account</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>weight</field-name>
| <column-name>weight</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>type</field-name>
| <column-name>type</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>enabled</field-name>
| <column-name>enabled</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>validFrom</field-name>
| <column-name>validFrom</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>validTo</field-name>
| <column-name>validTo</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>ident</field-name>
| <column-name>ident</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>descr</field-name>
| <column-name>descr</column-name>
|
| <jdbc-type>VARCHAR</jdbc-type>
| <sql-type>VARCHAR(64)</sql-type>
|
| </cmp-field>
| <cmp-field>
| <field-name>shortNumber</field-name>
| <column-name>shortnumber</column-name>
|
| <jdbc-type>VARCHAR</jdbc-type>
| <sql-type>VARCHAR(16)</sql-type>
|
| </cmp-field>
| <cmp-field>
| <field-name>operator</field-name>
| <column-name>operator</column-name>
|
| <jdbc-type>VARCHAR</jdbc-type>
| <sql-type>VARCHAR(16)</sql-type>
|
| </cmp-field>
| <cmp-field>
| <field-name>transCost</field-name>
| <column-name>transCost</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>transRevenue</field-name>
| <column-name>transRevenue</column-name>
|
| </cmp-field>
| <cmp-field>
| <field-name>monthlyCost</field-name>
| <column-name>monthlyCost</column-name>
|
| </cmp-field>
|
|
| <query-method>
| <method-name>findAllOrderWeight</method-name>
| <method-params>
| </method-params>
| </query-method>
| <jboss-ql>[CDATA[SELECT OBJECT(s) FROM Service s ORDER BY s.weight DESC]]</jboss-ql>
|
|
|
| <query-method>
| <method-name>findByAccount</method-name>
| <method-params>
| <method-param>java.lang.Integer</method-param>
| </method-params>
| </query-method>
| <jboss-ql>[CDATA[SELECT OBJECT(s) FROM Service s WHERE s.account = ?1 ORDER BY s.weight DESC]]</jboss-ql>
|
|
|
| <!-- jboss 3.2 features -->
| <!-- optimistic locking does not express the exclusions needed -->
|
|
| </enterprise-beans>
|
| </jbosscmp-jdbc>
|
I hope I put all in this file so you can fix my problem...
Big thanks to the one who can help me !
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3969938#3969938
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3969938
More information about the jboss-user
mailing list