Hello All,
I have searched the archives and not seen an answer to this, but I am having
the
same trouble with the torque "insert-sql" task, as called from the OJB
build.xml.
I have attached an old post that shows the exact same problem I am seeing here.
My project is assembled from ojb-blank.jar and my settings are similar to what
is
reported below, except that I am not running inside of tomcat, simply trying to
develop in eclipse at this stage and run from there.
"ant setup-db" always returns BUILD SUCESSFUL but the ant task prints all the
sql statements together and says 0 of 2 statements executed sucessfully, the
problem being a MySQLSyntaxErrorException thrown when torque is trying to
create the OJB_HL_SEQ table. I have tried this in ojb-blank.jar also and the
same problem happened from day one.
I am running OJB 1.0.4 with mysql 5.0.51a and version 5.0.8 of the mysql JDBC
driver. Java version is 1.5.0_16. If anyone out there is able to shed any light
on
this I would appreciate it, as I have been tearing my hair out for days on this
now
and I cannot think what is wrong. Obviously ojb-blank should just work out of
the
box with MySQL, and I think i have set everything up correctly (profile=mysql,
edit the profile/mysql.profile, torque.database=mysql, dbmsName=MySQL). I have
tested that the driver works with SQuirreL and mysql-query-browser is able to
execute the generated SQL statements *individually* from
build/database/project-schema.sql (but not if i simply paste the whole file).
TIA
-Brian
>Hai,
>
>I have a problem in doing an ant build
>
>The sql statements throw
>
>[torque-sql-exec] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>You have an error
>in your SQL syntax; check the manual that corresponds to your MySQL server
>version for the
>right syntax to use near 'CREATE TABLE Product ( id INTEGER NOT NULL, name
>VARCHAR (100),
>price FLOAT, sto' at line 3
>
>I want the ant script to create the database "productmanager" at runtime. I'm
>using MySQL
>Server version 5.1.6
>
>Below shown is my build.properties file:
>
>jcdAlias=default
>databaseName=productmanager
>databaseUser=root
>databasePassword=root
>
>tomcat.home=${env.CATALINA_HOME}
>tomcat.url=http://localhost:8080
>tomcat.manager.url=${tomcat.url}/manager
># This user should be present in the $CATALINA_HOME/conf/tomcat-users.xml file
>with the role
>'manager':
>tomcat.username=tomcat
>tomcat.password=tomcat
>
>embeddedDatabase=false
>
>dbmsName=MySQL
>jdbcLevel=3.0
>jdbcRuntimeDriver=com.mysql.jdbc.Driver
>urlProtocol=jdbc
>urlSubprotocol=mysql
>urlDbalias=//localhost:3306/${databaseName}
>
>torque.database=mysql
>
>torque.database.createUrl=${urlProtocol}:${urlSubprotocol}://localhost:3306/${databaseName}
>
>torque.database.driver=${jdbcRuntimeDriver}
>
>torque.database.user=${databaseUser}
>
>torque.database.password=${databasePassword}
>
>torque.database.buildUrl=${torque.database.createUrl}
>
>source.dir=src
>source.java.dir=${source.dir}/java
>source.resource.dir=${source.dir}/resources
>source.test.dir=${source.dir}/test
>source.schema.dir=${source.dir}/schema
>source.webapp.dir=${source.dir}/webapp
>
>build.dir=build
>lib.dir=lib
>lib.webapp.excludes=xdoclet*.jar,xjavadoc*.jar,torque*.jar,velocity*.jar
>
>target.dir=target
>
>servlet.lib=${tomcat.home}/common/lib/servlet-api.jar
>jsp.lib=${tomcat.home}/common/lib/jsp-api.jar
>deploy.dir=${tomcat.home}/webapps
>
>embedded.database.excludes=*schema.xml,*.sql,*.sql.generation,sqldb.map
>
>
>
>Below shown is the log details: (see the highlighted text in red color)
>
>C:\Users\karthiksg\Desktop\webapp-sample\webapp-sample>ant
>Buildfile: build.xml
>
>compile:
>
>xdoclet:
>[ojbdoclet] 2008-11-09 17:51:00,188 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning <ojbrepository/>
>[ojbdoclet] 2008-11-09 17:51:00,783 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning <torqueschema/>
>
>war:
>
>compile:
>
>xdoclet:
>[ojbdoclet] 2008-11-09 17:51:02,105 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning <ojbrepository/>
>[ojbdoclet] 2008-11-09 17:51:02,604 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning <torqueschema/>
>
>setup-db:
>
>check-use-classpath:
>
>check-run-only-on-schema-change:
>
>sql-check:
>
>sql:
>[echo] +------------------------------------------+
>[echo] | |
>[echo] | Generating SQL for YOUR Torque project! |
>[echo] | |
>[echo] +------------------------------------------+
>
>sql-classpath:
>[echo] loading templates from classpath
>[torque-sql] Using contextProperties file:
>C:\Users\karthiksg\Desktop\webapp-sam
>ple\webapp-sample\build.properties
>[torque-sql] Using classpath
>[torque-sql] Generating to file
>C:\Users\karthiksg\Desktop\webapp-sample\webapp-
>sample\build\database\report.productmanager.sql.generation
>[torque-sql] 2008-11-09 17:51:04,499 [main] INFO
>org.apache.torque.engine.datab
>ase.transform.XmlToAppData - Parsing file: 'ojbcore-schema.xml'
>[torque-sql] 2008-11-09 17:51:04,522 [main] INFO
>org.apache.torque.engine.datab
>ase.transform.DTDResolver - Resolver: used database.dtd from
>'org.apache.torque.
>engine.database.transform' package
>[torque-sql] 2008-11-09 17:51:04,595 [main] INFO
>org.apache.torque.engine.datab
>ase.transform.XmlToAppData - Parsing file: 'project-schema.xml'
>[torque-sql] 2008-11-09 17:51:04,600 [main] INFO
>org.apache.torque.engine.datab
>ase.transform.DTDResolver - Resolver: used
>'http://db.apache.org/torque/dtd/data
>base_3_0_1.dtd'
>
>sql-template:
>
>create-db-check:
>
>create-db:
>[torque-data-model] Using classpath
>[torque-data-model] Generating to file
>C:\Users\karthiksg\Desktop\webapp-sample\
>webapp-sample\build\database\create-db.sql
>[torque-data-model] 2008-11-09 17:51:25,378 [main] INFO
>org.apache.torque.engin
>e.database.transform.XmlToAppData - Parsing file: 'ojbcore-schema.xml'
>[torque-data-model] 2008-11-09 17:51:25,392 [main] INFO
>org.apache.torque.engin
>e.database.transform.DTDResolver - Resolver: used database.dtd from
>'org.apache.
>torque.engine.database.transform' package
>[torque-data-model] 2008-11-09 17:51:25,457 [main] INFO
>org.apache.torque.engin
>e.database.transform.XmlToAppData - Parsing file: 'project-schema.xml'
>[torque-data-model] 2008-11-09 17:51:25,463 [main] INFO
>org.apache.torque.engin
>e.database.transform.DTDResolver - Resolver: used
>'http://db.apache.org/torque/d
>td/database_3_0_1.dtd'
>
>shutdown-check:
>
>append-shutdown-sql:
>[echo]
>[echo] Executing the create-db.sql script ...
>[echo]
>[sql] Executing resource: C:\Users\karthiksg\Desktop\webapp-sample\webapp-
>sample\build\database\create-db.sql
>[sql] 2 of 2 SQL statements executed successfully
>
>insert-sql:
>
>shutdown-check:
>
>add-shutdown-sql-file:
>[torque-sql-exec] Our new url -> jdbc:mysql://localhost:3306/productmanager
>[torque-sql-exec] Executing file:
>C:\Users\karthiksg\Desktop\webapp-sample\webap
>p-sample\build\database\project-schema.sql
>[torque-sql-exec] Failed to execute: #
>-----------------------------------------
>------------------------------
>[torque-sql-exec] # Product #
>-------------------------------------------------
>----------------------
>[torque-sql-exec] drop table if exists Product; CREATE TABLE Product ( id
>INTEG
>ER NOT NULL, name VARCHAR (100), price FLOAT, stock INTEGER, PRIMARY KEY(id) );
>[torque-sql-exec] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>You
>have an error in your SQL syntax; check the manual that corresponds to your MyS
>QL server version for the right syntax to use near 'CREATE TABLE Product ( id
>IN
>TEGER NOT NULL, name VARCHAR (100), price FLOAT, sto' at line 3
>[torque-sql-exec] Executing file:
>C:\Users\karthiksg\Desktop\webapp-sample\webap
>p-sample\build\database\ojbcore-schema.sql
>[torque-sql-exec] Failed to execute: #
>-----------------------------------------
>------------------------------
>[torque-sql-exec] # OJB_HL_SEQ #
>----------------------------------------------
>-------------------------
>[torque-sql-exec] drop table if exists OJB_HL_SEQ; CREATE TABLE OJB_HL_SEQ (
>TA
>BLENAME VARCHAR (250) NOT NULL, MAX_KEY BIGINT, GRAB_SIZE INTEGER, VERSION
>INTEG
>ER, PRIMARY KEY(TABLENAME) ); #
>------------------------------------------------
>-----------------------
>[torque-sql-exec] # OJB_NRM #
>-------------------------------------------------
>----------------------
>[torque-sql-exec] drop table if exists OJB_NRM; CREATE TABLE OJB_NRM ( NAME
>VAR
>CHAR (250) NOT NULL, OID_ LONGBLOB, PRIMARY KEY(NAME) ); #
>---------------------
>--------------------------------------------------
>[torque-sql-exec] # OJB_DLIST #
>-----------------------------------------------
>------------------------
>[torque-sql-exec] drop table if exists OJB_DLIST; CREATE TABLE OJB_DLIST ( ID
>I
>NTEGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
>---------------------------
>--------------------------------------------
>[torque-sql-exec] # OJB_DLIST_ENTRIES #
>---------------------------------------
>--------------------------------
>[torque-sql-exec] drop table if exists OJB_DLIST_ENTRIES; CREATE TABLE
>OJB_DLIS
>T_ENTRIES ( ID INTEGER NOT NULL, DLIST_ID INTEGER NOT NULL, POSITION_ INTEGER,
>O
>ID_ LONGBLOB, PRIMARY KEY(ID) ); #
>---------------------------------------------
>--------------------------
>[torque-sql-exec] # OJB_DSET #
>------------------------------------------------
>-----------------------
>[torque-sql-exec] drop table if exists OJB_DSET; CREATE TABLE OJB_DSET ( ID
>INT
>EGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
>-----------------------------
>------------------------------------------
>[torque-sql-exec] # OJB_DSET_ENTRIES #
>----------------------------------------
>-------------------------------
>[torque-sql-exec] drop table if exists OJB_DSET_ENTRIES; CREATE TABLE
>OJB_DSET_
>ENTRIES ( ID INTEGER NOT NULL, DLIST_ID INTEGER NOT NULL, POSITION_ INTEGER,
>OID
>_ LONGBLOB, PRIMARY KEY(ID) ); #
>-----------------------------------------------
>------------------------
>[torque-sql-exec] # OJB_DMAP #
>------------------------------------------------
>-----------------------
>[torque-sql-exec] drop table if exists OJB_DMAP; CREATE TABLE OJB_DMAP ( ID
>INT
>EGER NOT NULL, SIZE_ INTEGER, PRIMARY KEY(ID) ); #
>-----------------------------
>------------------------------------------
>[torque-sql-exec] # OJB_DMAP_ENTRIES #
>----------------------------------------
>-------------------------------
>[torque-sql-exec] drop table if exists OJB_DMAP_ENTRIES; CREATE TABLE
>OJB_DMAP_
>ENTRIES ( ID INTEGER NOT NULL, DMAP_ID INTEGER NOT NULL, KEY_OID LONGBLOB,
>VALUE
>_OID LONGBLOB, PRIMARY KEY(ID) );
>[torque-sql-exec] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>You
>have an error in your SQL syntax; check the manual that corresponds to your MyS
>QL server version for the right syntax to use near 'CREATE TABLE OJB_HL_SEQ (
>TA
>BLENAME VARCHAR (250) NOT NULL, MAX_KEY BIGINT, GRAB' at line 3
>[torque-sql-exec] 0 of 2 SQL statements executed successfully
>
>copy-database-files:
>
>BUILD SUCCESSFUL
>Total time: 46 seconds
>
>I can see the files build\database\createdb.sql ,
>build\database\ojbcore-schema.sql ,
>build\database\project-schema.sql
>
>I can copy the statements from the .sql listed above and execute successfully
>in mysql command
>window.
>
>kindly do the needfull.
Make Yahoo!7 your homepage and win a trip to the Quiksilver Pro. Find out
more
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscr...@db.apache.org
For additional commands, e-mail: ojb-user-h...@db.apache.org
