-->
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: Error when using Hibernate
PostPosted: Thu Feb 26, 2004 6:55 pm 
Beginner
Beginner

Joined: Thu Feb 26, 2004 6:42 pm
Posts: 24
I am getting the following exception when I try to run the example that comes along with hibernate with sql server 7 and InetDriver. I have tried debugging into the code but does did not help me a lot, I am a beginner with hibernate. I put the logger in debug mode and looked at what statements are creating the problem, the problem is with EntityParser.java when it tries to insert data into the table. The tables are created just fine in the schema. Any help will be appreciated.
Thanks
p.s. I set the hibernate.properties in the java code as follows

cfg.setProperty("hibernate.dialect","net.sf.hibernate.dialect.SQLServerDialect");
cfg.setProperty("hibernate.connection.username","fmla");
cfg.setProperty("hibernate.connection.password","fmlaowner01");
cfg.setProperty("hibernate.connection.driver_class","com.inet.tds.TdsDriver");
cfg.setProperty("hibernate.connection.url","jdbc:inetdae7:132.201.89.8:1433?database=FMLATest");

cfg.setProperty("hibernate.show_sql", "true");

Hibernate version = 2.1
Java code is from example that comes with Hibernate

System.out.println("Setting up some test data");

Session s = factory.openSession();
Transaction tx = s.beginTransaction();

User seller = new User();
seller.setUserName("oldirty");
seller.setName( new Name("ol' dirty", null, "bastard") );
seller.setEmail("oldirty@hibernate.org");
seller.setAuctions( new ArrayList() );
s.save(seller);
User bidder1 = new User();
bidder1.setUserName("1E1");
bidder1.setName( new Name( "oney", new Character('1'), "one") );
bidder1.setEmail("oney@hibernate.org");
bidder1.setBids( new ArrayList() );
s.save(bidder1);
User bidder2 = new User();
bidder2.setUserName("izi");
bidder2.setName( new Name("iz", null, "inizi") );
bidder2.setEmail("izi@hibernate.org");
bidder2.setBids( new ArrayList() );
s.save(bidder2);

Stack trace in debug mode is as follows:

16:28:41,676 INFO Environment:462 - Hibernate 2.1.2
16:28:41,692 INFO Environment:491 - hibernate.properties not found
16:28:41,707 INFO Environment:519 - using CGLIB reflection optimizer
16:28:41,723 INFO Configuration:329 - Mapping resource: org/hibernate/auction/AuctionItem.hbm.xml
16:28:42,410 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
16:28:42,457 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
16:28:42,676 INFO Binder:229 - Mapping class: org.hibernate.auction.AuctionItem -> AuctionItem
16:28:42,801 DEBUG Binder:462 - Mapped property: id -> id, type: long
16:28:42,832 DEBUG Binder:462 - Mapped property: description -> description, type: string
16:28:42,832 DEBUG Binder:462 - Mapped property: ends -> ends, type: timestamp
16:28:42,832 DEBUG Binder:462 - Mapped property: condition -> condition, type: integer
16:28:42,848 DEBUG Binder:462 - Mapped property: seller -> seller, type: org.hibernate.auction.User
16:28:42,848 DEBUG Binder:462 - Mapped property: successfulBid -> successfulBid, type: org.hibernate.auction.Bid
16:28:42,864 DEBUG Binder:462 - Mapped property: bids, type: java.util.Collection
16:28:42,864 DEBUG Binder:1294 - Import: AuctionInfo -> org.hibernate.auction.AuctionInfo
16:28:42,879 INFO Configuration:329 - Mapping resource: org/hibernate/auction/Bid.hbm.xml
16:28:42,879 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
16:28:42,895 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
16:28:42,942 INFO Binder:229 - Mapping class: org.hibernate.auction.Bid -> Bid
16:28:42,942 DEBUG Binder:462 - Mapped property: id -> id, type: long
16:28:42,942 DEBUG Binder:462 - Mapped property: amount -> amount, type: float
16:28:42,957 DEBUG Binder:462 - Mapped property: datetime -> datetime, type: timestamp
16:28:42,957 DEBUG Binder:462 - Mapped property: bidder -> bidder, type: org.hibernate.auction.User
16:28:42,957 DEBUG Binder:462 - Mapped property: item -> item, type: org.hibernate.auction.AuctionItem
16:28:43,051 INFO Binder:169 - Mapping subclass: org.hibernate.auction.BuyNow -> Bid
16:28:43,067 INFO Configuration:329 - Mapping resource: org/hibernate/auction/User.hbm.xml
16:28:43,067 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
16:28:43,067 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
16:28:43,129 INFO Binder:229 - Mapping class: org.hibernate.auction.User -> AuctionUser
16:28:43,129 DEBUG Binder:462 - Mapped property: id -> id, type: long
16:28:43,129 DEBUG Binder:462 - Mapped property: userName -> userName, type: string
16:28:43,129 DEBUG Binder:462 - Mapped property: password -> password, type: string
16:28:43,145 DEBUG Binder:462 - Mapped property: email -> email, type: string
16:28:43,145 DEBUG Binder:462 - Mapped property: firstName -> firstName, type: string
16:28:43,145 DEBUG Binder:462 - Mapped property: initial -> initial, type: character
16:28:43,145 DEBUG Binder:462 - Mapped property: lastName -> lastName, type: string
16:28:43,426 INFO ReflectHelper:160 - reflection optimizer disabled for: org.hibernate.auction.Name, IllegalArgumentException: Cannot find matching method/constructor
16:28:43,426 DEBUG Binder:462 - Mapped property: name -> firstName, initial, lastName, type: org.hibernate.auction.Name
16:28:43,426 DEBUG Binder:462 - Mapped property: bids, type: java.util.Collection
16:28:43,426 DEBUG Binder:462 - Mapped property: auctions, type: java.util.Collection
16:28:43,426 INFO Configuration:595 - processing one-to-many association mappings
16:28:43,426 DEBUG Binder:1326 - Second pass for collection: org.hibernate.auction.AuctionItem.bids
16:28:43,442 INFO Binder:1154 - Mapping collection: org.hibernate.auction.AuctionItem.bids -> Bid
16:28:43,442 DEBUG Binder:1341 - Mapped collection key: item, one-to-many: org.hibernate.auction.Bid
16:28:43,442 DEBUG Binder:1326 - Second pass for collection: org.hibernate.auction.User.bids
16:28:43,442 INFO Binder:1154 - Mapping collection: org.hibernate.auction.User.bids -> Bid
16:28:43,442 DEBUG Binder:1341 - Mapped collection key: bidder, one-to-many: org.hibernate.auction.Bid
16:28:43,442 DEBUG Binder:1326 - Second pass for collection: org.hibernate.auction.User.auctions
16:28:43,442 INFO Binder:1154 - Mapping collection: org.hibernate.auction.User.auctions -> AuctionItem
16:28:43,442 DEBUG Binder:1341 - Mapped collection key: seller, one-to-many: org.hibernate.auction.AuctionItem
16:28:43,442 INFO Configuration:604 - processing one-to-one association property references
16:28:43,442 INFO Configuration:629 - processing foreign key constraints
16:28:43,442 DEBUG Configuration:639 - resolving reference to class: org.hibernate.auction.User
16:28:43,442 DEBUG Configuration:639 - resolving reference to class: org.hibernate.auction.Bid
16:28:43,442 DEBUG Configuration:639 - resolving reference to class: org.hibernate.auction.AuctionItem
16:28:43,457 DEBUG Configuration:639 - resolving reference to class: org.hibernate.auction.User
16:28:43,489 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.SQLServerDialect
16:28:43,489 INFO SettingsFactory:62 - Use outer join fetching: true
16:28:43,504 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
16:28:43,504 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
16:28:43,535 INFO DriverManagerConnectionProvider:71 - using driver: com.inet.tds.TdsDriver at URL: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest
16:28:43,535 INFO DriverManagerConnectionProvider:72 - connection properties: {user=fmla, password=fmlaowner01}
16:28:43,551 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
16:28:43,551 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
16:28:43,551 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
16:28:43,926 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest, Isolation Level: 2
16:28:43,926 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
16:28:43,942 INFO SettingsFactory:102 - Use scrollable result sets: true
16:28:43,942 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
16:28:43,942 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
16:28:43,942 INFO SettingsFactory:114 - echoing all SQL to stdout
16:28:43,942 INFO SettingsFactory:117 - Query language substitutions: {}
16:28:43,942 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
16:28:43,957 INFO Configuration:1080 - instantiating and configuring caches
16:28:44,004 INFO SessionFactoryImpl:119 - building session factory
16:28:44,004 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.connection.password=fmlaowner01, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_03\jre\bin, java.vm.version=1.4.2_03-b02, hibernate.connection.username=fmla, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\SoftWare\eclipse\workspace\hibernate, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\j2sdk1.4.2_03\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\sm8971\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=C:\j2sdk1.4.2_03\bin;.;C:\WINNT\system32;C:\WINNT;C:\Program Files\Seagate Software\NOTES\;C:\Program Files\Seagate Software\NOTES\DATA\;C:\PROGRA~1\FileNET\IDM;C:\PROGRA~1\FileNET\Shared;C:\orant\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\FileNET\FNSW\CLIENT\BIN;C:\Program Files\FileNET\FNSW\CLIENT\SHOBJ;C:\Program Files\Symantec\pcAnywhere;C:\Program Files\Common Files\OpSession\Shared;C:\Program Files\Common Files\OpSession\Viewer Shared;C:\software\jwsdp-1.3\jwsdp-shared\bin;C:\j2sdk1.4.2_03\bin, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Documents and Settings\sm8971, user.timezone=America/Chicago, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.inet.tds.TdsDriver, user.name=sm8971, java.class.path=C:\SoftWare\eclipse\workspace\hibernate\classes;C:\SoftWare\hibernate\hibernate2.jar;C:\SoftWare\hibernate-2.1\lib\jboss-jmx.jar;C:\SoftWare\hibernate-2.1\lib\ant-optional-1.5.3.jar;C:\SoftWare\hibernate-2.1\lib\c3p0-0.8.3.jar;C:\SoftWare\hibernate-2.1\lib\cglib-2.0-rc2.jar;C:\SoftWare\hibernate-2.1\lib\commons-collections-2.1.jar;C:\SoftWare\hibernate-2.1\lib\commons-dbcp-1.1.jar;C:\SoftWare\hibernate-2.1\lib\commons-lang-1.0.1.jar;C:\SoftWare\hibernate-2.1\lib\commons-logging-1.0.3.jar;C:\SoftWare\hibernate-2.1\lib\commons-pool-1.1.jar;C:\SoftWare\hibernate-2.1\lib\concurrent-1.3.2.jar;C:\SoftWare\hibernate-2.1\lib\connector.jar;C:\SoftWare\hibernate-2.1\lib\dom4j-1.4.jar;C:\SoftWare\hibernate-2.1\lib\ehcache-0.6.jar;C:\SoftWare\hibernate-2.1\lib\jaas.jar;C:\SoftWare\hibernate-2.1\lib\jboss-cache.jar;C:\SoftWare\hibernate-2.1\lib\jboss-common.jar;C:\SoftWare\hibernate-2.1\lib\ant-1.5.3.jar;C:\SoftWare\hibernate-2.1\lib\jboss-system.jar;C:\SoftWare\hibernate-2.1\lib\jcs-1.0-dev.jar;C:\SoftWare\hibernate-2.1\lib\jdbc2_0-stdext.jar;C:\SoftWare\hibernate-2.1\lib\jgroups-2.2.jar;C:\SoftWare\hibernate-2.1\lib\jta.jar;C:\SoftWare\hibernate-2.1\lib\junit-3.8.1.jar;C:\SoftWare\hibernate-2.1\lib\log4j-1.2.8.jar;C:\SoftWare\hibernate-2.1\lib\odmg-3.0.jar;C:\SoftWare\hibernate-2.1\lib\oscache-2.0.jar;C:\SoftWare\hibernate-2.1\lib\proxool-0.8.3.jar;C:\SoftWare\hibernate-2.1\lib\swarmcache-1.0rc2.jar;C:\SoftWare\hibernate-2.1\lib\xalan-2.4.0.jar;C:\SoftWare\hibernate-2.1\lib\xerces-2.4.0.jar;C:\SoftWare\hibernate-2.1\lib\xml-apis.jar;C:\SoftWare\datadirectsqldriver\lib\sqlserver.jar;C:\SoftWare\datadirectsqldriver\lib\base.jar;C:\SoftWare\datadirectsqldriver\lib\util.jar;C:\SoftWare\inetmerlia\Merlia.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_03\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:inetdae7:132.201.89.8:1433?database=FMLATest, hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_03, java.ext.dirs=C:\j2sdk1.4.2_03\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_03\jre\lib\endorsed\dom.jar;C:\j2sdk1.4.2_03\jre\lib\endorsed\sax.jar;C:\j2sdk1.4.2_03\jre\lib\endorsed\xalan.jar;C:\j2sdk1.4.2_03\jre\lib\endorsed\xercesImpl.jar;C:\j2sdk1.4.2_03\jre\lib\endorsed\xsltc.jar;C:\j2sdk1.4.2_03\jre\lib\rt.jar;C:\j2sdk1.4.2_03\jre\lib\i18n.jar;C:\j2sdk1.4.2_03\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_03\jre\lib\jsse.jar;C:\j2sdk1.4.2_03\jre\lib\jce.jar;C:\j2sdk1.4.2_03\jre\lib\charsets.jar;C:\j2sdk1.4.2_03\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, hibernate.hbm2ddl.auto=create, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.cpu.isalist=pentium i486 i386}
16:28:44,801 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
16:28:44,801 DEBUG SessionFactoryObjectFactory:76 - registered: 8ad8a863faf3f1a500faf3f1a8810000 (unnamed)
16:28:44,817 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
16:28:44,817 DEBUG SessionFactoryImpl:196 - instantiated session factory
16:28:44,817 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.SQLServerDialect
16:28:44,817 INFO Configuration:595 - processing one-to-many association mappings
16:28:44,832 INFO Configuration:604 - processing one-to-one association property references
16:28:44,832 INFO Configuration:629 - processing foreign key constraints
16:28:44,832 INFO Configuration:595 - processing one-to-many association mappings
16:28:44,832 INFO Configuration:604 - processing one-to-one association property references
16:28:44,832 INFO Configuration:629 - processing foreign key constraints
16:28:44,832 INFO SchemaExport:98 - Running hbm2ddl schema export
16:28:44,848 INFO SchemaExport:117 - exporting generated schema to database
16:28:44,848 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
16:28:44,848 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
16:28:44,848 INFO DriverManagerConnectionProvider:71 - using driver: com.inet.tds.TdsDriver at URL: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest
16:28:44,848 INFO DriverManagerConnectionProvider:72 - connection properties: {user=fmla, password=fmlaowner01}
16:28:44,848 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
16:28:44,848 DEBUG DriverManagerConnectionProvider:94 - opening new JDBC connection
16:28:45,082 DEBUG DriverManagerConnectionProvider:100 - created connection to: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest, Isolation Level: 2
16:28:45,145 DEBUG SchemaExport:132 - alter table AuctionItem drop constraint FK522A9BD6C9FF4F7F
16:28:45,192 DEBUG SchemaExport:132 - alter table AuctionItem drop constraint FK522A9BD657291C03
16:28:45,223 DEBUG SchemaExport:132 - alter table Bid drop constraint FK104DD317B13
16:28:45,270 DEBUG SchemaExport:132 - alter table Bid drop constraint FK104DDAD3189F4
16:28:45,301 DEBUG SchemaExport:132 - drop table AuctionItem
16:28:45,332 DEBUG SchemaExport:132 - drop table AuctionUser
16:28:45,379 DEBUG SchemaExport:132 - drop table Bid
16:28:45,410 DEBUG SchemaExport:149 - create table AuctionItem (
id NUMERIC(19,0) IDENTITY NOT NULL,
description VARCHAR(255) null,
ends DATETIME null,
condition INT null,
seller NUMERIC(19,0) not null,
successfulBid NUMERIC(19,0) null,
primary key (id)
)
16:28:45,457 DEBUG SchemaExport:149 - create table AuctionUser (
id NUMERIC(19,0) IDENTITY NOT NULL,
userName VARCHAR(255) not null,
[password] VARCHAR(255) null,
email VARCHAR(255) null,
firstName VARCHAR(255) null,
[initial] CHAR(1) null,
lastName VARCHAR(255) null,
primary key (id)
)
16:28:45,504 DEBUG SchemaExport:149 - create table Bid (
id NUMERIC(19,0) IDENTITY NOT NULL,
isBuyNow CHAR(1) not null,
amount FLOAT not null,
datetime DATETIME not null,
bidder NUMERIC(19,0) not null,
item NUMERIC(19,0) not null,
primary key (id)
)
16:28:45,551 DEBUG SchemaExport:149 - alter table AuctionItem add constraint FK522A9BD6C9FF4F7F foreign key (seller) references AuctionUser
16:28:45,582 DEBUG SchemaExport:149 - alter table AuctionItem add constraint FK522A9BD657291C03 foreign key (successfulBid) references Bid
16:28:45,614 DEBUG SchemaExport:149 - alter table Bid add constraint FK104DD317B13 foreign key (item) references AuctionItem
16:28:45,660 DEBUG SchemaExport:149 - alter table Bid add constraint FK104DDAD3189F4 foreign key (bidder) references AuctionUser
16:28:45,707 INFO SchemaExport:160 - schema export complete
16:28:45,707 DEBUG JDBCExceptionReporter:18 - SQL Warning
java.sql.SQLWarning: [MOSTLS1HRTRAN03]Changed database context to 'FMLATest'.
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.<init>(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95)
at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:198)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:750)
at org.hibernate.auction.Main.main(Main.java:377)
16:28:45,707 WARN JDBCExceptionReporter:20 - SQL Warning: 5701, SQLState: 01000
16:28:45,707 WARN JDBCExceptionReporter:28 - [MOSTLS1HRTRAN03]Changed database context to 'FMLATest'.
16:28:45,723 WARN JDBCExceptionReporter:20 - SQL Warning: 5703, SQLState: 01000
16:28:45,723 WARN JDBCExceptionReporter:28 - [MOSTLS1HRTRAN03]Changed language setting to us_english.
16:28:45,723 DEBUG DriverManagerConnectionProvider:114 - returning connection to pool, pool size: 1
16:28:45,723 INFO DriverManagerConnectionProvider:137 - cleaning up connection pool: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest
Setting up some test data
16:28:45,832 INFO DriverManagerConnectionProvider:137 - cleaning up connection pool: jdbc:inetdae7:132.201.89.8:1433?database=FMLATest
16:28:45,879 DEBUG SessionImpl:531 - opened session
16:28:45,879 DEBUG JDBCTransaction:37 - begin
16:28:45,895 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
16:28:45,895 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
16:28:45,895 DEBUG JDBCTransaction:41 - current autocommit status:false
16:28:45,895 DEBUG SessionImpl:807 - saving [org.hibernate.auction.User#<null>]
16:28:45,895 DEBUG SessionImpl:2273 - executing insertions
16:28:45,895 DEBUG Cascades:497 - processing cascades for: org.hibernate.auction.User
16:28:45,910 DEBUG Cascades:506 - done processing cascades for: org.hibernate.auction.User
16:28:54,879 DEBUG EntityPersister:490 - Inserting entity: org.hibernate.auction.User (native id)
16:29:35,879 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
16:30:12,411 DEBUG SQL:237 - insert into AuctionUser (userName, [password], email, firstName, [initial], lastName) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into AuctionUser (userName, [password], email, firstName, [initial], lastName) values (?, ?, ?, ?, ?, ?)
16:31:07,724 DEBUG BatcherImpl:241 - preparing statement
16:32:00,709 DEBUG EntityPersister:388 - Dehydrating entity: [org.hibernate.auction.User#<null>]
16:32:39,756 DEBUG JDBCExceptionReporter:36 - SQL Exception
com.inet.tds.SQLException: java.net.SocketException: Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at com.inet.tds.j.if(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.p.if(Unknown Source)
at com.inet.tds.p.do(Unknown Source)
at com.inet.tds.p.executeQuery(Unknown Source)
at com.inet.tds.p.int(Unknown Source)
at com.inet.tds.b.try(Unknown Source)
at com.inet.tds.b.executeUpdate(Unknown Source)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:527)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432)
at net.sf.hibernate.impl.ScheduledIdentityInsertion.execute(ScheduledIdentityInsertion.java:29)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:906)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:839)
at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:757)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720)
at org.hibernate.auction.Main.createTestAuctions(Main.java:291)
at org.hibernate.auction.Main.main(Main.java:379)



Name and version of database that I am using : Sql Server 7.0

Driver that I am using : INetDirect Merlia/Opta(both give same error). Merlia is the version that they recommend for jdk1.4

JDK version 1.4.2_03.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 01, 2004 11:48 am 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
Use the connnection validation capability of your favorite connection pool

_________________
Emmanuel


Top
 Profile  
 
 Post subject: using validation, need more help
PostPosted: Mon Mar 01, 2004 12:56 pm 
Beginner
Beginner

Joined: Thu Feb 26, 2004 6:42 pm
Posts: 24
Hey Emmanuel,
Can you be a little more specific, I am not really very familiar with validation using connection pooling. Do you want me to actually modify the hibernate code to do the validation since the Connection Object is handled by the hibernate code.
Thanks,
Sohil


Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 03, 2004 6:44 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
No,
connection pool such as c3p0 or the one in your favorite app server have the capability to test connections (usually with a simple SQL request). Read the doc of your conenction pool.

_________________
Emmanuel


Top
 Profile  
 
 Post subject: Problem solved
PostPosted: Thu Mar 04, 2004 12:47 pm 
Beginner
Beginner

Joined: Thu Feb 26, 2004 6:42 pm
Posts: 24
Hi,
I changed over from SQL Server 7 to SQL Server 2000 and it works fine. I guess the problem was that the default example does something that is supported by SQL Server 2000 but not SQL Server 7. I however do not know either hibernate (not yet) well enough or SQL Server to be able to tell what exactly the problem was. Will update this post if and when I figure it out.
Thanks for your help Emmanuel,
Sohil


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.