-->
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.  [ 1 post ] 
Author Message
 Post subject: problems with image retrieval from bytea column....
PostPosted: Sun Feb 22, 2004 12:10 pm 
Regular
Regular

Joined: Mon Jan 19, 2004 10:39 pm
Posts: 84
Location: Nottingham, England
Hi I am having a problem with image requests from a browser which in turn retrieves binary data from a postgreSQL table (ver7.4.1) and serves the data bask to the browser. There are 2 images on the page, 1.jpg and 2.jpg respectively. The first image is displayed with no problems. On trying to display the second image, the browser just sits there waiting for data which never happens and eventually you see abroken image in the browser window. My java code (snippet) is:

int imageNum = Integer.parseInt(<util:get-sitemap-parameter name="imageNum"/>);
int artistID = Integer.parseInt(<util:get-sitemap-parameter name="artistID"/>);
byte[] photo = new byte[10];
String base64;

<!-- request made to static object -->
Artist artist = Artist.getArtist(artistID);

<!-- read postgreSQL bytea into a byte[] via Hibernate, based on the image number requested -->
switch (imageNum) {
case 1: photo = artist.getArtistPhoto1(); break;
case 2: photo = artist.getArtistPhoto2(); break;
}
..............

The code retrieves two parameters, imageNum and artistID. So we ineterogate the static class with the artistID for the correct artist and then obtain the correct image data based on the imageNum. It seems from the logs that the firsrt image request is made but afterwards the second image request is made twice!!:

14:57:16,072 INFO Environment:432 - Hibernate 2.1.1
14:57:16,077 INFO Environment:461 - hibernate.properties not found
14:57:16,101 INFO Environment:481 - using CGLIB reflection optimizer
14:57:16,111 INFO Configuration:843 - configuring from resource: /hibernate.cfg.xml
14:57:16,113 INFO Configuration:815 - Configuration resource: /hibernate.cfg.xml
14:57:16,243 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath under net/sf/hibernate/
14:57:16,262 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath
14:57:16,349 DEBUG Configuration:801 - connection.driver_class=org.postgresql.Driver
14:57:16,351 DEBUG Configuration:801 - connection.url=jdbc:postgresql://localhost:5432/beyarecords
14:57:16,353 DEBUG Configuration:801 - connection.username=postgres
14:57:16,354 DEBUG Configuration:801 - connection.password=postgres
14:57:16,356 DEBUG Configuration:801 - connection.pool_size=0
14:57:16,358 DEBUG Configuration:801 - jdbc.batch_size=5
14:57:16,359 DEBUG Configuration:801 - jdbc.use_scrollable_resultset=true
14:57:16,361 DEBUG Configuration:801 - hibernate.statement_cache.size=25
14:57:16,362 DEBUG Configuration:801 - hibernate.jdbc.use_streams_for_binary=true
14:57:16,364 DEBUG Configuration:801 - show_sql=true
14:57:16,367 DEBUG Configuration:801 - use_outer_join=true
14:57:16,368 DEBUG Configuration:801 - dialect=net.sf.hibernate.dialect.PostgreSQLDialect
14:57:16,370 DEBUG Configuration:801 - hibernate.c3p0.max_size=2
14:57:16,371 DEBUG Configuration:801 - hibernate.c3p0.min_size=1
14:57:16,373 DEBUG Configuration:801 - hibernate.c3p0.timeout=5000
14:57:16,379 DEBUG Configuration:801 - hibernate.c3p0.max_statements=50
14:57:16,384 DEBUG Configuration:952 - null<-org.dom4j.tree.DefaultAttribute@8f7b56 [Attribute: name resource value "test/User.hbm.xml"]
14:57:16,386 INFO Configuration:300 - Mapping resource: test/User.hbm.xml
14:57:16,397 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
14:57:16,401 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
14:57:16,603 INFO Binder:225 - Mapping class: test.User -> usertbl
14:57:16,762 DEBUG Binder:449 - Mapped property: ID -> user_id, type: integer
14:57:16,803 DEBUG Binder:449 - Mapped property: FirstName -> first_name, type: string
14:57:16,806 DEBUG Binder:449 - Mapped property: LastName -> last_name, type: string
14:57:16,817 DEBUG Binder:449 - Mapped property: Address1 -> address1, type: string
14:57:16,826 DEBUG Binder:449 - Mapped property: Address2 -> address2, type: string
14:57:16,828 DEBUG Binder:449 - Mapped property: Address3 -> address3, type: string
14:57:16,830 DEBUG Binder:449 - Mapped property: PostCode -> postcode, type: string
14:57:16,849 DEBUG Binder:449 - Mapped property: Country -> country, type: string
14:57:16,851 DEBUG Binder:449 - Mapped property: Email -> email, type: string
14:57:16,856 DEBUG Binder:449 - Mapped property: HomeTel -> home_telephone, type: string
14:57:16,858 DEBUG Binder:449 - Mapped property: HomeMob -> mobile_telephone, type: string
14:57:16,861 DEBUG Binder:449 - Mapped property: DateJoined -> date_joined, type: timestamp
14:57:16,866 DEBUG Binder:449 - Mapped property: UserName -> username, type: string
14:57:16,868 DEBUG Binder:449 - Mapped property: UserPassword -> userpassword, type: string
14:57:16,872 INFO Binder:534 - Mapping collection: test.User.ArtistChoice -> choicetbl
14:57:16,899 DEBUG Binder:449 - Mapped property: ArtistChoice, type: java.util.Set
14:57:16,901 DEBUG Configuration:952 - null<-org.dom4j.tree.DefaultAttribute@f55def [Attribute: name resource value "test/Artist.hbm.xml"]
14:57:16,903 INFO Configuration:300 - Mapping resource: test/Artist.hbm.xml
14:57:16,909 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
14:57:16,911 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
14:57:16,933 INFO Binder:225 - Mapping class: test.Artist -> artisttbl
14:57:16,935 DEBUG Binder:449 - Mapped property: ID -> artist_id, type: integer
14:57:16,937 DEBUG Binder:449 - Mapped property: ArtistName -> artist_name, type: string
14:57:16,944 DEBUG Binder:449 - Mapped property: ArtistInfo -> artist_info, type: string
14:57:16,946 DEBUG Binder:449 - Mapped property: ArtistPhoto1 -> artist_photo1, type: binary
14:57:16,947 DEBUG Binder:449 - Mapped property: ArtistPhoto2 -> artist_photo2, type: binary
14:57:16,950 DEBUG Binder:449 - Mapped property: ArtistPhoto3 -> artist_photo3, type: binary
14:57:16,952 INFO Configuration:998 - Configured SessionFactory: null
14:57:16,954 DEBUG Configuration:999 - properties: {show_sql=true, java.vendor=Apple Computer, Inc., catalina.base=/library/tomcat, hibernate.connection.url=jdbc:postgresql://localhost:5432/beyarecords, catalina.useNaming=true, os.name=Mac OS X, sun.boot.class.path=/library/tomcat/common/endorsed/xalan-2.5.2.jar:/library/tomcat/common/endorsed/xercesImpl.jar:/library/tomcat/common/endorsed/xmlParserAPIs.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/classes.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/ui.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/laf.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/sunrsasign.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/jsse.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/jce.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/charsets.jar, hibernate.c3p0.max_size=2, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2_03-117.1, hibernate.c3p0.min_size=1, user.name=uzomaduj, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, connection.driver_class=org.postgresql.Driver, hibernate.c3p0.timeout=5000, user.language=en, java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory, sun.boot.library.path=/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Libraries, hibernate.jdbc.use_scrollable_resultset=true, dialect=net.sf.hibernate.dialect.PostgreSQLDialect, jdbc.use_scrollable_resultset=true, java.version=1.4.2_03, user.timezone=Europe/London, jdbc.batch_size=5, sun.arch.data.model=32, hibernate.use_outer_join=true, java.endorsed.dirs=/library/tomcat/common/endorsed, sun.cpu.isalist=, file.encoding.pkg=sun.io, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., file.separator=/, java.specification.name=Java Platform API Specification, log4j.debug=true, hibernate.cglib.use_reflection_optimizer=true, java.class.version=48.0, user.country=US, connection.url=jdbc:postgresql://localhost:5432/beyarecords, java.home=/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home, org.xmldb.common.xml.queries.XPathQueryFactory=org.apache.xindice.core.xupdate.XPathQueryFactoryImpl, java.vm.info=mixed mode, os.version=10.3.2, path.separator=:, connection.password=postgres, java.vm.version=1.4.2-34, hibernate.connection.password=postgres, java.util.prefs.PreferencesFactory=java.util.prefs.MacOSXPreferencesFactory, hibernate.jdbc.batch_size=5, java.awt.printerjob=apple.awt.CPrinterJob, sun.io.unicode.encoding=UnicodeBig, awt.toolkit=apple.awt.CToolkit, hibernate.connection.username=postgres, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., java.naming.factory.url.pkgs=org.apache.naming, user.home=/Users/uzomaduj, java.specification.vendor=Sun Microsystems Inc., hibernate.statement_cache.size=25, org.xml.sax.driver=org.apache.xerces.parsers.SAXParser, java.library.path=.:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java, java.vendor.url=http://apple.com/, hibernate.connection.driver_class=org.postgresql.Driver, connection.username=postgres, java.vm.vendor="Apple Computer, Inc.", gopherProxySet=false, hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect, hibernate.jdbc.use_streams_for_binary=true, common.loader=${catalina.home}/common/classes,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=/library/java/home/lib/tools.jar:/library/tomcat/bin/bootstrap.jar:/library/tomcat/bin/commons-logging-api.jar, use_outer_join=true, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, catalina.home=/library/tomcat, sun.cpu.endian=big, sun.os.patch.level=unknown, connection.pool_size=0, java.io.tmpdir=/library/tomcat/temp, java.vendor.url.bug=http://developer.apple.com/java/, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, os.arch=ppc, java.awt.graphicsenv=apple.awt.CGraphicsEnvironment, java.ext.dirs=/Library/Java/Extensions:/System/Library/Java/Extensions:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home/lib/ext, mrj.version=117.1, user.dir=/Library/Tomcat/bin, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, file.encoding=MacRoman, java.specification.version=1.4, hibernate.c3p0.max_statements=50, hibernate.show_sql=true, hibernate.connection.pool_size=0}
14:57:16,956 INFO Configuration:584 - processing one-to-many association mappings
14:57:16,958 DEBUG Binder:1301 - Second pass for collection: test.User.ArtistChoice
14:57:16,974 DEBUG Binder:1316 - Mapped collection key: user_id, element: artist_id, type: test.Artist
14:57:16,976 INFO Configuration:593 - processing one-to-one association property references
14:57:16,977 INFO Configuration:618 - processing foreign key constraints
14:57:16,979 DEBUG Configuration:628 - resolving reference to class: test.Artist
14:57:16,981 DEBUG Configuration:628 - resolving reference to class: test.User
14:57:17,038 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.PostgreSQLDialect
14:57:17,041 INFO SettingsFactory:62 - Use outer join fetching: true
14:57:17,054 INFO C3P0ConnectionProvider:48 - C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/beyarecords
14:57:17,062 INFO C3P0ConnectionProvider:49 - Connection properties: {user=postgres, password=postgres}
14:57:17,170 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
14:57:17,720 INFO SettingsFactory:89 - Use scrollable result sets: true
14:57:17,722 INFO SettingsFactory:90 - JDBC 2 max batch size: 5
14:57:17,724 INFO SettingsFactory:96 - echoing all SQL to stdout
14:57:17,725 INFO SettingsFactory:99 - Query language substitutions: {}
14:57:17,727 INFO SettingsFactory:110 - cache provider: net.sf.ehcache.hibernate.Provider
14:57:17,738 INFO Configuration:1057 - instantiating and configuring caches
14:57:17,968 INFO SessionFactoryImpl:119 - building session factory
14:57:17,971 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {show_sql=true, java.vendor=Apple Computer, Inc., catalina.base=/library/tomcat, hibernate.connection.url=jdbc:postgresql://localhost:5432/beyarecords, catalina.useNaming=true, os.name=Mac OS X, sun.boot.class.path=/library/tomcat/common/endorsed/xalan-2.5.2.jar:/library/tomcat/common/endorsed/xercesImpl.jar:/library/tomcat/common/endorsed/xmlParserAPIs.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/classes.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/ui.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/laf.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/sunrsasign.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/jsse.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/jce.jar:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/charsets.jar, hibernate.c3p0.max_size=2, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2_03-117.1, hibernate.c3p0.min_size=1, user.name=uzomaduj, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, connection.driver_class=org.postgresql.Driver, hibernate.c3p0.timeout=5000, user.language=en, java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory, sun.boot.library.path=/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Libraries, hibernate.jdbc.use_scrollable_resultset=true, dialect=net.sf.hibernate.dialect.PostgreSQLDialect, jdbc.use_scrollable_resultset=true, java.version=1.4.2_03, user.timezone=Europe/London, jdbc.batch_size=5, sun.arch.data.model=32, hibernate.use_outer_join=true, java.endorsed.dirs=/library/tomcat/common/endorsed, sun.cpu.isalist=, file.encoding.pkg=sun.io, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., file.separator=/, java.specification.name=Java Platform API Specification, log4j.debug=true, hibernate.cglib.use_reflection_optimizer=true, java.class.version=48.0, user.country=US, connection.url=jdbc:postgresql://localhost:5432/beyarecords, java.home=/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home, org.xmldb.common.xml.queries.XPathQueryFactory=org.apache.xindice.core.xupdate.XPathQueryFactoryImpl, java.vm.info=mixed mode, os.version=10.3.2, path.separator=:, connection.password=postgres, java.vm.version=1.4.2-34, hibernate.connection.password=postgres, java.util.prefs.PreferencesFactory=java.util.prefs.MacOSXPreferencesFactory, hibernate.jdbc.batch_size=5, java.awt.printerjob=apple.awt.CPrinterJob, sun.io.unicode.encoding=UnicodeBig, awt.toolkit=apple.awt.CToolkit, hibernate.connection.username=postgres, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., java.naming.factory.url.pkgs=org.apache.naming, user.home=/Users/uzomaduj, java.specification.vendor=Sun Microsystems Inc., hibernate.statement_cache.size=25, org.xml.sax.driver=org.apache.xerces.parsers.SAXParser, java.library.path=.:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java, java.vendor.url=http://apple.com/, hibernate.connection.driver_class=org.postgresql.Driver, connection.username=postgres, java.vm.vendor="Apple Computer, Inc.", gopherProxySet=false, hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect, hibernate.jdbc.use_streams_for_binary=true, common.loader=${catalina.home}/common/classes,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=/library/java/home/lib/tools.jar:/library/tomcat/bin/bootstrap.jar:/library/tomcat/bin/commons-logging-api.jar, use_outer_join=true, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, catalina.home=/library/tomcat, sun.cpu.endian=big, sun.os.patch.level=unknown, connection.pool_size=0, java.io.tmpdir=/library/tomcat/temp, java.vendor.url.bug=http://developer.apple.com/java/, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, os.arch=ppc, java.awt.graphicsenv=apple.awt.CGraphicsEnvironment, java.ext.dirs=/Library/Java/Extensions:/System/Library/Java/Extensions:/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home/lib/ext, mrj.version=117.1, user.dir=/Library/Tomcat/bin, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, file.encoding=MacRoman, java.specification.version=1.4, hibernate.c3p0.max_statements=50, hibernate.show_sql=true, hibernate.connection.pool_size=0}
14:57:19,185 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
14:57:19,195 DEBUG SessionFactoryObjectFactory:76 - registered: d1e22501faddbae700faddbaed4b0000 (unnamed)
14:57:19,197 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
14:57:19,199 DEBUG SessionFactoryImpl:196 - instantiated session factory
14:57:19,314 DEBUG SessionImpl:528 - opened session
14:57:19,320 DEBUG JDBCTransaction:37 - begin
14:57:19,323 DEBUG JDBCTransaction:41 - current autocommit status:false
14:57:19,329 DEBUG SessionImpl:1913 - loading [test.Artist#46]
14:57:19,330 DEBUG SessionImpl:2010 - attempting to resolve [test.Artist#46]
14:57:19,335 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Artist#46]
14:57:19,337 DEBUG EntityPersister:417 - Materializing entity: [test.Artist#46]
14:57:19,343 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
14:57:19,352 DEBUG SQL:223 - select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
Hibernate: select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
14:57:19,354 DEBUG BatcherImpl:227 - preparing statement
14:57:19,470 DEBUG Loader:196 - processing result set
14:57:19,472 DEBUG Loader:404 - result row: 46
14:57:19,475 DEBUG Loader:535 - Initializing object from ResultSet: 46
14:57:19,481 DEBUG Loader:604 - Hydrating entity: test.Artist#46
14:57:19,539 DEBUG Loader:225 - done processing result set (1 rows)
14:57:19,548 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
14:57:19,550 DEBUG BatcherImpl:240 - closing statement
14:57:19,552 DEBUG Loader:238 - total objects hydrated: 1
14:57:19,554 DEBUG SessionImpl:2129 - resolving associations for [test.Artist#46]
14:57:19,559 DEBUG SessionImpl:2153 - done materializing entity [test.Artist#46]
14:57:19,561 DEBUG SessionImpl:3000 - initializing non-lazy collections
14:57:19,567 DEBUG JDBCTransaction:59 - commit
14:57:19,568 DEBUG SessionImpl:2193 - flushing session
14:57:19,574 DEBUG SessionImpl:2321 - Flushing entities and processing referenced collections
14:57:19,589 DEBUG SessionImpl:2664 - Processing unreferenced collections
14:57:19,591 DEBUG SessionImpl:2678 - Scheduling collection removes/(re)creates/updates
14:57:19,593 DEBUG SessionImpl:2217 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
14:57:19,604 DEBUG SessionImpl:2222 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
14:57:19,610 DEBUG Printer:75 - listing entities:
14:57:20,702 DEBUG Printer:82 - test.Artist{ArtistPhoto2=7f587...., ArtistInfo=Artists info. can be located here......, ID=46}
14:57:20,863 DEBUG SessionImpl:2258 - executing flush
14:57:20,865 DEBUG SessionImpl:2708 - post flush
14:57:20,868 DEBUG SessionImpl:558 - transaction completion
14:57:20,870 DEBUG SessionImpl:546 - closing session
14:57:20,872 DEBUG SessionImpl:3187 - disconnecting session
14:57:20,880 DEBUG SessionImpl:558 - transaction completion
14:57:21,811 DEBUG SessionImpl:528 - opened session
14:57:21,813 DEBUG JDBCTransaction:37 - begin
14:57:21,814 DEBUG SessionImpl:528 - opened session
14:57:21,816 DEBUG JDBCTransaction:41 - current autocommit status:false
14:57:21,817 DEBUG JDBCTransaction:37 - begin
14:57:21,819 DEBUG SessionImpl:1913 - loading [test.Artist#46]
14:57:21,822 DEBUG SessionImpl:2010 - attempting to resolve [test.Artist#46]
14:57:21,824 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Artist#46]
14:57:21,826 DEBUG EntityPersister:417 - Materializing entity: [test.Artist#46]
14:57:21,831 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
14:57:21,833 DEBUG SQL:223 - select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
Hibernate: select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
14:57:21,835 DEBUG BatcherImpl:227 - preparing statement
14:57:21,849 DEBUG JDBCTransaction:41 - current autocommit status:false
14:57:21,851 DEBUG SessionImpl:1913 - loading [test.Artist#46]
14:57:21,853 DEBUG SessionImpl:2010 - attempting to resolve [test.Artist#46]
14:57:21,855 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Artist#46]
14:57:21,869 DEBUG EntityPersister:417 - Materializing entity: [test.Artist#46]
14:57:21,872 DEBUG BatcherImpl:192 - about to open: 1 open PreparedStatements, 0 open ResultSets
14:57:21,873 DEBUG SQL:223 - select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
Hibernate: select artist0_.artist_id as artist_id0_, artist0_.artist_name as artist_n2_0_, artist0_.artist_info as artist_i3_0_, artist0_.artist_photo1 as artist_p4_0_, artist0_.artist_photo2 as artist_p5_0_, artist0_.artist_photo3 as artist_p6_0_ from artisttbl artist0_ where artist0_.artist_id=?
14:57:21,875 DEBUG BatcherImpl:227 - preparing statement
14:57:21,959 DEBUG Loader:196 - processing result set
14:57:21,962 DEBUG Loader:404 - result row: 46
14:57:21,964 DEBUG Loader:535 - Initializing object from ResultSet: 46
14:57:21,966 DEBUG Loader:604 - Hydrating entity: test.Artist#46
14:57:22,566 DEBUG SessionImpl:3239 - running Session.finalize()
14:57:22,591 DEBUG Loader:225 - done processing result set (1 rows)
14:57:22,595 DEBUG BatcherImpl:199 - done closing: 1 open PreparedStatements, 0 open ResultSets
14:57:22,597 DEBUG BatcherImpl:240 - closing statement
14:57:22,609 DEBUG Loader:238 - total objects hydrated: 1
14:57:22,612 DEBUG SessionImpl:2129 - resolving associations for [test.Artist#46]
14:57:22,615 DEBUG Loader:196 - processing result set
14:57:22,616 DEBUG SessionImpl:2153 - done materializing entity [test.Artist#46]
14:57:22,617 DEBUG Loader:404 - result row: 46
14:57:22,619 DEBUG SessionImpl:3000 - initializing non-lazy collections
14:57:22,621 DEBUG Loader:535 - Initializing object from ResultSet: 46
14:57:22,623 DEBUG JDBCTransaction:59 - commit
14:57:22,625 DEBUG Loader:604 - Hydrating entity: test.Artist#46
14:57:22,626 DEBUG SessionImpl:2193 - flushing session
14:57:22,630 DEBUG SessionImpl:2321 - Flushing entities and processing referenced collections
14:57:22,637 DEBUG SessionImpl:2664 - Processing unreferenced collections
14:57:22,640 DEBUG SessionImpl:2678 - Scheduling collection removes/(re)creates/updates
14:57:22,641 DEBUG SessionImpl:2217 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
14:57:22,643 DEBUG SessionImpl:2222 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
14:57:22,652 DEBUG Printer:75 - listing entities:
14:57:22,656 DEBUG Loader:225 - done processing result set (1 rows)
14:57:22,659 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
14:57:22,661 DEBUG BatcherImpl:240 - closing statement
14:57:22,663 DEBUG Loader:238 - total objects hydrated: 1
14:57:22,666 DEBUG SessionImpl:2129 - resolving associations for [test.Artist#46]
14:57:22,676 DEBUG SessionImpl:2153 - done materializing entity [test.Artist#46]
14:57:22,679 DEBUG SessionImpl:3000 - initializing non-lazy collections
14:57:22,681 DEBUG JDBCTransaction:59 - commit
14:57:22,683 DEBUG SessionImpl:2193 - flushing session
14:57:22,685 DEBUG SessionImpl:2321 - Flushing entities and processing referenced collections
14:57:22,700 DEBUG SessionImpl:2664 - Processing unreferenced collections
14:57:22,702 DEBUG SessionImpl:2678 - Scheduling collection removes/(re)creates/updates
14:57:22,704 DEBUG SessionImpl:2217 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
14:57:22,706 DEBUG SessionImpl:2222 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
14:57:22,708 DEBUG Printer:75 - listing entities:
14:57:23,978 DEBUG Printer:82 - test.Artist{ArtistPhoto2=7f587..., ArtistInfo=Artists info. can be located here......, ID=46}
14:57:24,095 DEBUG Printer:82 - test.Artist{ArtistPhoto2=7f587..., ArtistInfo=Artists info. can be located here......, ID=46}
14:57:24,134 DEBUG SessionImpl:2258 - executing flush
14:57:24,938 DEBUG SessionImpl:2258 - executing flush
14:57:24,940 DEBUG SessionImpl:2708 - post flush
14:57:24,957 DEBUG SessionImpl:2708 - post flush
14:57:24,961 DEBUG SessionImpl:558 - transaction completion
14:57:24,963 DEBUG SessionImpl:558 - transaction completion
14:57:24,964 DEBUG SessionImpl:546 - closing session
14:57:24,965 DEBUG SessionImpl:546 - closing session
14:57:24,967 DEBUG SessionImpl:3187 - disconnecting session
14:57:24,969 DEBUG SessionImpl:3187 - disconnecting session
14:57:24,972 DEBUG SessionImpl:558 - transaction completion
14:57:24,973 DEBUG SessionImpl:558 - transaction completion
14:57:27,101 DEBUG SessionImpl:3239 - running Session.finalize()
14:57:27,103 DEBUG SessionImpl:3239 - running Session.finalize()


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

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.