Re: sql statements execution error
able if exists OJB_DMAP; CREATE TABLE OJB_DMAP ( ID
INTEGER 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.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 OJB_HL_SEQ (
TABLENAME VARCHAR (250) NOT NULL, MAX_KEY BIGINT, GR' at line 3
[torque-sql-exec] 0 of 2 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 4 seconds
Still no luck, and now we see the same problem crop up yet again. I tried the
following to debug this:
1. Create an ant task insert-sql in build.xml that directly calls the
insert-sql task in build-torque.xml:
2. Edit the generated project-schema.sql and ojbcore-schema.sql and run "ant
insert-sql"
I found that if there is only 1 SQL statement in each .sql file this works!
For example if project-schema.sql reads:
# ---
# Product
# ---
drop table if exists Product;
CREATE TABLE Product
(
id INTEGER NOT NULL,
name VARCHAR (100),
price FLOAT,
stock INTEGER,
PRIMARY KEY(id)
);
it fails. if i remove everything before CREATE it works, but if I leave the
drop table it fails.
I can leave the comments in and it succeeds.
So my question is - how do I get torque to automatically set up the DB for me?
I thought this
would be working out of the box? It is not convinient for me to browse the .sql
files
to snip each one out into mysql manually every time i change the schema.
Anyone??? I Really need help on this one.
Thanks,
--
Brian
____________
From: Prestige Spas
To: ojb-user@db.apache.org
Sent: Friday, 13 February, 2009 9:54:00 AM
Subject: Re: sql statements execution error
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
>'mana
Re: sql statements execution error
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
>[ojbdoclet] 2008-11-09 17:51:00,783 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning
>
>war:
>
>compile:
>
>xdoclet:
>[ojbdoclet] 2008-11-09 17:51:02,105 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning
>[ojbdoclet] 2008-11-09 17:51:02,604 [main] INFO xdoclet.XDocletMain.start -
>Run
>ning
>
>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 [
