-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: A problem with Day 1 of "getting Started"
PostPosted: Wed Oct 26, 2005 4:31 pm 
Newbie

Joined: Wed Oct 26, 2005 4:54 am
Posts: 4
Hi,
I'm trying to carry out what reported @ http://www.hibernate.org/152.html - DAY 1.

I'm using H3.1 and mysql 3.51.

The tutorial says:

1. place your JDBC driver jar file in the lib directory

DONE
Code:
mysql-connector-java-3.1.7-bin.jar


2. edit etc/hibernate.properties, specifying connection settings for your database (Hibernate will create a schema for the demo automatically)

DONE
Code:

######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions yes 'Y', no 'N'


## select the classic query parser

#hibernate.query.factory_class org.hibernate.hql.classic.ClassicQueryTranslatorFactory



#################
### Platforms ###
#################


## MySQL

hibernate.dialect org.hibernate.dialect.MySQLDialect
#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql:///test
hibernate.connection.username gavin
hibernate.connection.password



#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

#hibernate.c3p0.max_size 2
#hibernate.c3p0.min_size 2
#hibernate.c3p0.timeout 5000
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.idle_test_period 3000
#hibernate.c3p0.acquire_increment 2
#hibernate.c3p0.validate false



##############################
### Proxool Connection Pool###
##############################

## Properties for external configuration of Proxool

hibernate.proxool.pool_alias pool1

## Only need one of the following

#hibernate.proxool.existing_pool true
#hibernate.proxool.xml proxool.xml
#hibernate.proxool.properties proxool.properties



#################################
### Plugin ConnectionProvider ###
#################################

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)

#hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.ProxoolConnectionProvider



#######################
### Transaction API ###
#######################

## Enable automatic flush during the JTA beforeCompletion() callback
## (This setting is relevant with or without the Transaction API)

#hibernate.transaction.flush_before_completion


## Enable automatic session close at the end of transaction
## (This setting is relevant with or without the Transaction API)

#hibernate.transaction.auto_close_session


## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory


## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction
## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class

#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction


## to use the second-level cache with JTA, Hibernate must be able to obtain the JTA TransactionManager

#hibernate.transaction.manager_lookup_class org.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.ResinTransactionManagerLookup



##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

#hibernate.show_sql true


## format SQL in log and console

hibernate.format_sql true


## add comments to the generated SQL

#hibernate.use_sql_comments true


## generate statistics

#hibernate.generate_statistics true


## auto schema export

#hibernate.hbm2ddl.auto create-drop
#hibernate.hbm2ddl.auto create
#hibernate.hbm2ddl.auto update
#hibernate.hbm2ddl.auto validate


## specify a default schema and catalog for unqualified tablenames

#hibernate.default_schema test
#hibernate.default_catalog test


## enable ordering of SQL UPDATEs by primary key

#hibernate.order_updates true


## set the maximum depth of the outer join fetch tree

hibernate.max_fetch_depth 1


## set the default batch size for batch fetching

#hibernate.default_batch_fetch_size 8


## rollback generated identifier values of deleted entities to default values

#hibernate.use_identifer_rollback true


## enable CGLIB reflection optimizer (enabled by default)

#hibernate.cglib.use_reflection_optimizer false



#####################
### JDBC Settings ###
#####################

## specify a JDBC isolation level

#hibernate.connection.isolation 4


## enable JDBC autocommit (not recommended!)

#hibernate.connection.autocommit true


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

#hibernate.jdbc.batch_size 5
#hibernate.jdbc.batch_size 0


## enable batch updates even for versioned data

hibernate.jdbc.batch_versioned_data true


## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true


## use JDBC 3 PreparedStatement.getGeneratedKeys() to get the identifier of an inserted row

#hibernate.jdbc.use_get_generated_keys false


## choose a custom JDBC batcher

# hibernate.jdbc.factory_class


## enable JDBC result set column alias caching
## (minor performance enhancement for broken JDBC drivers)

# hibernate.jdbc.wrap_result_sets


## choose a custom SQL exception converter

#hibernate.jdbc.sql_exception_converter



##########################
### Second-level Cache ###
##########################

## optimize chache for minimal "puts" instead of minimal "gets" (good for clustered cache)

#hibernate.cache.use_minimal_puts true


## set a prefix for cache region names

hibernate.cache.region_prefix hibernate.test


## disable the second-level cache

#hibernate.cache.use_second_level_cache false


## enable the query cache

#hibernate.cache.use_query_cache true


## store the second-level cache entries in a more human-friendly format

#hibernate.cache.use_structured_entries true


## choose a cache implementation

#hibernate.cache.provider_class org.hibernate.cache.EhCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.EmptyCacheProvider
hibernate.cache.provider_class org.hibernate.cache.HashtableCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.TreeCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.OSCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.SwarmCacheProvider


## choose a custom query cache implementation

#hibernate.cache.query_cache_factory



############
### JNDI ###
############

## specify a JNDI name for the SessionFactory

#hibernate.session_factory_name hibernate/session_factory


## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction;
## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which
## is the best approach in an application server

#file system
#hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory
#hibernate.jndi.url file:/

#WebSphere
#hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory
#hibernate.jndi.url iiop://localhost:900/




3. from a command prompt in the install dir
(I haven't Ant, so I use "build eg")

--> type build eg under Windows


but the example doesn't run.

I had a look at build.bat and it looks like this:
Code:
set JDBC_DRIVER=jdbc/hsqldb.jar
java -cp "lib/ant-launcher-1.6.5.jar" org.apache.tools.ant.launch.Launcher -lib lib -Ddriver.jar=%JDBC_DRIVER% %1 %2 %3 %4 %5


You can see that the JDBC_DRIVER is setted to "hsqldb.jar", so I've changed it to "mysql-connector-java-3.1.7-bin.jar"


Here's the error. I've searched for main in org\hibernate\auction and the class "main" doesn't exist.

Code:

C:\Programmi\Apache Software Foundation\Tomcat 5.5\webapps\assistenza\WEB-INF\hi
bernate-3.1>java -cp "lib/ant-launcher-1.6.5.jar" org.apache.tools.ant.launch.La
uncher -lib lib -Ddriver.jar=jdbc/mysql-connector-java-3.1.7-bin.jar eg
Buildfile: build.xml
  [taskdef] Could not load definitions from resource checkstyletask.properties.
It could not be found.
  [taskdef] Could not load definitions from resource clovertasks. It could not b
e found.

eg:
     [echo] remember to place your JDBC driver in the lib directory
     [java] java.lang.NoClassDefFoundError: org/hibernate/auction/Main
     [java] Exception in thread "main"

BUILD FAILED
C:\Programmi\Apache Software Foundation\Tomcat 5.5\webapps\assistenza\WEB-INF\hi
bernate-3.1\build.xml:671: Java returned: 1

Total time: 1 second



Should I change build.bat again?I can't understand if my trouble is with ant or not. As the tutorial says, I'm able to use or not ant, but build.bat refers it in each cases.


Thank you!


Top
 Profile  
 
 Post subject: check the tools
PostPosted: Wed Oct 26, 2005 6:34 pm 
Newbie

Joined: Mon Sep 26, 2005 9:28 am
Posts: 1
Location: italy
The build script you are trying to execute should create some code for you.

The Emptor app is a web app, so it can have no main method (it usually doesn't have such a method).
Instead, you are trying to use org.apache.tools.ant.launch.Launcher, that is Hibernate Tools. There you should find a main method.

To solve the problem check the bat script, but also your classpath.
Finally, if you don't get any result, please post the error output (stacktrace and the like).

Have fun!

_________________
S.Peruzzi


Top
 Profile  
 
 Post subject: Re: check the tools
PostPosted: Thu Oct 27, 2005 9:13 am 
Newbie

Joined: Wed Oct 26, 2005 4:54 am
Posts: 4
peruzzi wrote:
The build script you are trying to execute should create some code for you.

The Emptor app is a web app, so it can have no main method (it usually doesn't have such a method).
Instead, you are trying to use org.apache.tools.ant.launch.Launcher, that is Hibernate Tools. There you should find a main method.

To solve the problem check the bat script, but also your classpath.
Finally, if you don't get any result, please post the error output (stacktrace and the like).

Have fun!


So I've to use Hibernate Tools?
I've already done download it, but in the tutorial no references to HT are made.
I'll try in the evening to change the script. I can't understand why tutorial doesn't say anything about.......
I guess there aren't problems in the classpath, but I'll verify it too..

Probably I'll post my error later!!

thanks a lot


Top
 Profile  
 
 Post subject: A problem with Day 1 of "getting Started"
PostPosted: Tue Nov 08, 2005 2:57 pm 
Regular
Regular

Joined: Sat Nov 06, 2004 5:20 pm
Posts: 54
Location: Collierville, TN
Hibernate version 3.1 rc2
Apache Ant version 1.6.5
MySql 5.0.15-nt
mysql-connector-java-3.1.11-bin.jar

Running "ant eg" some tables aren't created due to sql syntax. However, some are like auctionuser and bid.

[java] 12:17:10,375 ERROR SchemaExport:258 - Unsuccessful: create table AuctionItem (id bigint not null auto_increment, seller bigint not null, shortDescription varchar(200) not null, description text, ends datetime, condition integer, successfulBid bigint, primary key (id), unique (seller, shortDescription)) comment='An item that is being auctioned.'

[java] 12:17:10,375 ERROR SchemaExport:259 - 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 'condition integer, successfulBid bigint, primary key (id), unique (seller, short' at line 1

Not sure where the source of this sql lives in order to tweak it. Thanks for your feedback.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 08, 2005 3:59 pm 
Hibernate Team
Hibernate Team

Joined: Mon Aug 25, 2003 9:11 pm
Posts: 4592
Location: Switzerland
"condition" is a new keyword in MySQL 5. Put this in your mapping file and quote it:

<property name="condition" column="`CONDITION`"/>


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.