|
From: Its Me <it...@gm...> - 2013-03-13 10:31:16
|
Hello,
After some tweaking all seems to start and installed. (running Ubuntu
12.04) and all packages are there.
However in my orkweb.log I see that the database is not created:
2013-03-13 11:14:59,462 net.sf.oreka.orktrack.OrkTrack INFO -
========================================
2013-03-13 11:14:59,462 net.sf.oreka.orktrack.OrkTrack INFO -
OrkTrack starting ...
2013-03-13 11:14:59,870 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- Unsuccessful: create table orkdomain (id integer not null
auto_increment, name varchar(255), description varchar(255), primary
key (id)) type=InnoDB
2013-03-13 11:14:59,870 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- 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 'type=InnoDB' at line 1
2013-03-13 11:14:59,870 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- Unsuccessful: create table orkloginstring (id integer not null
auto_increment, loginString varchar(255), domain_id integer, user_id
integer, primary key (id)) type=InnoDB
2013-03-13 11:14:59,871 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- 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 'type=InnoDB' at line 1
2013-03-13 11:14:59,871 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- Unsuccessful: create table orkport (id integer not null
auto_increment, primary key (id)) type=InnoDB
2013-03-13 11:14:59,871 org.hibernate.tool.hbm2ddl.SchemaUpdate ERROR
- 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 'type=InnoDB' at line 1
etc etc etc....
This is my config file: (my dbase name is oreka) and with the correct
user I can access that database with mysql -u {user} -p {passwd}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property
name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="hibernate.connection.maxconnections">100</property>
<property
name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="hibernate.connection.url">jdbc:mysql://localhost/oreka</property>
<property name="hibernate.connection.password">passwd</property>
<property name="hibernate.connection.username">user</property>
<property name="hibernate.hbm2ddl.auto">update</property> <!--
update, create, create-drop -->
<property name="hibernate.show_sql">false</property>
<property name="hibernate.jdbc.use_scrollable_resultset">true</property>
<property name="hibernate.max_fetch_depth">1</property>
<property
name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
</session-factory>
</hibernate-configuration>
However I need to get it created.... who can guide me....?
Cheers....
|