hibernate ʹÓÃÊý¾Ý¿âmysql ²åÈëÊý¾Ý ÂÒÂëÎÊÌâ
³öÏÖÒÔÏÂÎÊÌâ:Çë´ó¼Ò°ïæ½â¾ö
´ÓÍøÉϲéÕÒÁËһϷ½·¨µ«ÊDz»ÐÐ,
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate_basemapping?useUnicode=true&characterEncoding=GBK</property>
ÎҵľßÌå²Ù×÷ÈçÏÂ:
дÁËÒ»¸ö²âÊÔ·½·¨:
public void testSaveUser1(){
Session session = null;
Transaction transaction = null;
User1 user = null;
try {
session = HibernateUtils.getSession();
transaction = session.beginTransaction();
user = new User1();
user.setName("ÍúÍú");
user.setPassword("123");
user.setCreateTime(new Date());
user.setExpireTime(new Date());
session.save(user);
transaction.commit();
} catch (Exception e) {
// TODO: handle exception
transaction.rollback();
} finally {
HibernateUtils.closeSession(session);
}
}
³öÏÖÈçϵĴíÎó,²»ÄܲåÈëÖØ¸´,ÒòΪÎÒÉèÖÃÁËΨһÐÔÔ¼Êø,µ«ÊÇÃû³µ³öÏÖÁË????ÂÒÂëÎÊÌâ
Caused by: java.sql.BatchUpdateException: Duplicate entry '?—??—?' for key 2
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1213)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:912)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)<
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬
Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿
ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......