9:07 p.m.
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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...