Fadjer One

Hello,

You can use Criteria API instead. For example you can use the class : org.hibernate.criterion.Example

Please check this link :
http://docs.jboss.org/hibernate/core/3.3/reference/en/html/querycriteria.html

Hi men,

This a task to create, start , launch, configure and stop an HSQLDB database. I hope this help.

<project name="SOFTX" default="buildNewDB" basedir="."> <description> Créer une nouvelle de données pour SOFTX 5 </description> <property file="build_bdd.properties"/> <path id="classpath"> <pathelement path ="${connector.dir}"/> <pathelement path ="${logic.engine.bin.dir}"/> <pathelement path ="${logic.engine.config.dir}"/> <pathelement path ="${logic.engine.hibernate.dir}"/> <fileset dir="${logic.engine.lib.dir}" includes="*.jar"/> </path> <target name="cleanDataDir"> <echo message="Cleaning 'data' directory..." /> <delete> <fileset dir="${basedir}/data" includes="*"/> </delete> </target> <target name="startDB"> <echo message="Starting Data Base..." /> <java fork="true" spawn="true" classname="org.hsqldb.Server" classpathref="classpath"> <arg line="-database.0 file:data/SOFTX5_bdd -dbname.0 SOFTX5_bdd"/> </java> </target> <target name="generateSOFTXSQL"> <echo message="Generating SOFTX SQL..." /> <taskdef name="schemaexport" classname="org.hibernate.tool.hbm2ddl.SchemaExportTask" classpathref="classpath"/> <schemaexport haltonerror="yes" config="${logic.engine.hibernateconfig.file}" quiet="yes" text="yes" drop="no" create="yes" delimiter=";" output="${sql.dir}/bdd_script.sql"> </schemaexport> </target> <target name="configDB"> <echo message="Config new Data Base..." /> <sql classpathref="classpath" driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/SOFTX5_bdd;ifexists=true" userid="sa" password=""> <transaction src="${sql.dir}/configBdd.sql"/> </sql> </target> <target name="executeSQL"> <echo message="Execute SQL on new Data Base..." /> <sql autocommit="true" print="true" classpathref="classpath" driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/SOFTX5_bdd;ifexists=true" userid="SOFTX5_user" password="SOFTX5_user"> <transaction src="${sql.dir}/bdd_script.sql"/> <transaction src="${sql.dir}/dropUnusedConstraints.sql"/> <transaction src="${logic.engine.SOFTX.config.sql}"/> <transaction>SHUTDOWN</transaction> </sql> <echo message="SQL Executed on data base..." /> </target> <target name="buildNewDB" depends="cleanDataDir, startDB, generateSOFTXSQL, configDB, executeSQL" description="Build new SOFTX 5 DB" /> </project>

Hi,

I tried several examples in this book, and It's ok for me. I can see tables as explained below. What's exactly your problem ?

Don't forget than you can use Eclipse WPT to run examples too. I found this easer than ant tasks.

Good luck.

Hi,


See this link : http://www.oracle.com/technology/products/ias/toplink/jpa/howto/java-se-usage.html

>> Please aslo shed somelight on how j2ee containers connect with the database : by using data source witch you declare on your JEE server.


I hope this help.
Issam Sabir.

Hi,

With JPA you can speciy two types of transactions :

1- RESSOUCE_LOCAL : available in and outside a JEE environment, and rely on the underline Data Source you use. For example you can use this type to work with database transaction.

2- JTA : for Java Transaction API it's only available in a JEE environment. This kind of transaction is more rich than the first one. You can have a transaction with different Data Source for different types. For example between a database and LDAP.

When you are in a JEE environment, the JTA is the default value. However, RESSOUCE_LOCAL is the defaut value in a SE environment.

I hope this help.

Hi,

I found the solution ! I'm working on Eclipse and the problem is caused by it !

Add these two jars to your classpath : org.eclipse.jdt.core.manipulation_1.0.0.v20060605-1400.jar
org.eclipse.jdt.core_3.2.0.v_671.jar

There are in the plungin directory of Eclipse.

Hi,

Did you resolve the problem ? I'm having the same.

Thanks in advance.

Hello,

I have a very strong problem with an HQL query and I'm looking for your precious help ;-)

My HQL query is :
select distinct articles from com.iserva.model.Article as articles
inner join articles.column as column
inner join articles.state as state
where
articles.language =:language
and articles.state.stepId =:stepId
and articles.state.status =:status
and articles.column =:column

The SQL Equivalent generated by Hibernate is :
select distinct ... article fields ... from ARTICLE article0_ inner join `COLUMN` column1_ on article0_.COLUMN_ID=column1_.COLUMN_ID inner join OS_CURRENTSTEP state2_ on article0_.WORKFLOW_ID=state2_.entry_id where (article0_.LANGUAGE=? )and(state2_.step_Id=? )and(state2_.status=? )and(column1_.COLUMN_ID=? )

The problem is taht the SQL query return the good results, but not the HQL one !

I have used the P6Spy framework to obtain the exact query the Hibernate motor launches (query with all values not '?' chars) and I still having the same problem : SQL is good not the HQL one

Whant does hibernate do after executing like my SQL query ? any idea please ?

After many searching hours I have found this alternative that works fine, the difference is that I do no join on Column object :

select distinct articles from com.iserva.model.Article as articles
inner join articles.state as state
where
articles.language =:language
and articles.state.stepId =:stepId
and articles.state.status =:status
and articles.column =:column

Why this work and not the first one ?

Thanks in advance.

Hello every body,

I confirm that eplanetlabs 'books' are a big and a great lie !! dont buy their products !!! [ -EDIT by mw: Removed suggestion to violate copyright laws.- ]

Good lack for your all,

(eplanetlabs into hell)

Originally posted by Gert Gerritse:
Dear all,

I have just started preparing for the SCJA exam. Lacking a study guide,
I picked up a lot of various material based on the tips I found in this
group and the Yahoo one. Although I didn't trust the omnipresent Steve William, I downloaded the EPlanetLabs SCJA Solution Guide. The $ 29 I thus spent were a total waste of money: the guide is a copy-paste collection of things that somehow, somewhere might be connected with Java. My warm advice: DON'T buy this crap.

Cheers...Gert.

[ August 28, 2006: Message edited by: marc weber ]