собстна ерор... | Цитата | 21 черв 2007 2:01:48 net.sf.hibernate.JDBCException <init> SEVERE: Could not save object org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:228) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:57) at net.sf.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:67) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:727) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:717) at models.combo.Zaklad.addData(Zaklad.java:63) at forms.toolbars.MedZakladBar$1.keyReleased(MedZakladBar.java:76) at java.awt.Component.processKeyEvent(Unknown Source) at javax.swing.JComponent.processKeyEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. invalid request BLR at offset 78 generator HIBERNATE_SEQUENCE is not defined at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:82) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:244) at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188) at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792) at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87) ... 32 more net.sf.hibernate.JDBCException: Could not save object at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:744) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:717) at models.combo.Zaklad.addData(Zaklad.java:63) at forms.toolbars.MedZakladBar$1.keyReleased(MedZakladBar.java:76) at java.awt.Component.processKeyEvent(Unknown Source) at javax.swing.JComponent.processKeyEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(Unknown Source) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:228) at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:57) at net.sf.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:67) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:727) ... 26 more Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. invalid request BLR at offset 78 generator HIBERNATE_SEQUENCE is not defined at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:82) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:244) at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188) at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792) at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87) ... 32 more
|
данные читает на ура... но все же... | Код |
public void addData(String name,String text,int ind) throws HibernateException { session = sessionFactory.openSession(); tr=session.beginTransaction(); PopUpData pop=new PopUpData(name,text,ind); //pop.setFieldname(name); //pop.setFormind(ind); //pop.setId(text); session.save(pop); tr.commit(); }
|
| Код | package dataSource;
public class PopUpData { private String fieldname; private String id; private int formind; public PopUpData() { } public PopUpData(String fieldname,String id,int formind) { this.fieldname=fieldname; this.id=id; this.formind=formind; } public String getFieldname() { return fieldname; } public void setFieldname(String fieldname) { this.fieldname = fieldname; }
public int getFormind() { return formind; } public void setFormind(int formind) { this.formind = formind; } public String getId() { return id; } public void setId(String id) { this.id = id; } }
|
так все читает... | Код | <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping> <class name="dataSource.PopUpData" table="POPUP"> <meta attribute="class-description"> </meta> <id name="id" type="string" column="FieldText"> <meta attribute="scope-set">private</meta> <generator class="sequence"> </generator> </id> <property name="fieldname" type="string" not-null="true"/> <property name="formind" type="int" not-null="true"/> </class> </hibernate-mapping>
|
есть грех на xml...у меня в таблице нет ключей... | Код | <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping> <class name="dataSource.PopUpData" table="POPUP"> <meta attribute="class-description"> </meta> <property name="fieldtext" type="string" not-null="true"/> <property name="fieldname" type="string" not-null="true"/> <property name="formind" type="int" not-null="true"/> </class> </hibernate-mapping>
|
а так и не читает... пишет... | Цитата | 21 черв 2007 2:10:15 net.sf.hibernate.hql.QueryTranslator concreteQueries WARNING: no persistent classes found for query class: from dataSource.PopUpData as pData where pData.fieldname='zaklad' and pData.formind=1
|
Добавлено через 5 минут и 52 секундыпардон... достаточно было убрать генератор...с предидущего примера брал там был...сдесь-нет...вот он и ругалсо... | Код | <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping> <class name="dataSource.PopUpData" table="POPUP"> <meta attribute="class-description"> </meta> <id name="id" type="string" column="FieldText"> <meta attribute="scope-set">private</meta> </id> <property name="fieldname" type="string" not-null="true"/> <property name="formind" type="int" not-null="true"/> </class> </hibernate-mapping>
|
|