Hi,
In my application, I am using Hibernate 3 and MySQL 5.1.
I try to insert name in data base using Session.save(object) and it works fine, untill, when I use Chracter ['] in the name, like D'souza.
It gives JDBC exception and insertion fail.
I found the root cause of the exception, Hibernate internally creates SQL insert statement, like,
INSERT INTO table_name (name) VALUES ('D'souza');
If we tried this example in MySQL, it also give exception, actually it is confused regarding the Character symbol.

Is there any possible solution??

Hi team, please help me, I can't find any solution......

Hibernate shouldn't have this problem. Insert queries are generated with parameter placeholders. Eg.



You'll need to post more information if you want help. Mappings files, code, log output, etc.

Hi Nordborg,
Thank you for suggested reply.
What you said, I agree and I mention same in my post also.

Here is my Mappings file,

<class name="Patientname" table="patientname">
<id name="ehrid" column="ehrid" type="java.lang.String" >
</id>
<property name="firstname" column="firstname" type="java.lang.String"></property>
<property name="lastName" column="lastName" type="java.lang.String"></property>
<property name="middlename" column="middlename" type="java.lang.String"></property>
</class>

Here is my code,

patientname.setEhrid(uuid.toString());
patientname.setFirstname(pName.getFirstName());
patientname.setLastName(pName.getLastName());
patientname.setMiddlename(pName.getMiddleName());
session.save(patientname);
session.flush();
session.clear();

Here is log output,

at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)

Now please suggest me some improvement

That's is not the log output. Please enable Hibernate logging and make sure that the SQL statements Hibernate generates are included (http://docs.jboss.org/hibernate/core/3. ... on-logging). This will usually generate a huge log file, so it would be good if you could find and post the relevant parts.