Re: [Informa-developer] hibernate session error

[John C. <jc...@st...>]

I think i fixed it, though I moved to mysql. I actually did not ready 
the part of your quickstart example that showed the correct way to 
commit to the db!!

thanks...I love the api!

John Case

Niko Schmuck wrote:
> John,
>
> Which version of the Informa API are you using?
>
> Thanks for reporting,
> Niko
>
>
> On 10.03.2007, at 17:47, John Case wrote:
>
>> Hello!
>>
>> I cannot seem to persist to the hsqldb datbase via hibernate.....
>>
>> This error appears when trying to insert a channel.
>>
>> 2357 [main] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error:
>> -95, SQLState: 22003
>> 2357 [main] ERROR org.hibernate.util.JDBCExceptionReporter  - Type
>> Conversion not supported
>> 2359 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener
>> - Could not synchronize database state with session
>> org.hibernate.exception.DataException: could not update:
>> [de.nava.informa.impl.hibernate.Channel#1]
>>         at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:75) 
>>
>> ....
>>
>>
>> My jdbc params:
>>
>> 531  [main] INFO
>> org.hibernate.connection.DriverManagerConnectionProvider  - Using
>> Hibernate built-in connection pool (not for production use!)
>> 531  [main] INFO
>> org.hibernate.connection.DriverManagerConnectionProvider  - Hibernate
>> connection pool size: 20
>> 531  [main] INFO
>> org.hibernate.connection.DriverManagerConnectionProvider  - autocommit
>> mode: false
>> 535  [main] INFO
>> org.hibernate.connection.DriverManagerConnectionProvider  - using
>> driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:file:c:/ftp/informa
>> 536  [main] INFO
>> org.hibernate.connection.DriverManagerConnectionProvider  - connection
>> properties: {user=sa, password=****}
>>
>>
>> ******** calling code:
>>
>>     Connection conn = TestHsqldb.getConnection();
>>                SessionHandler sh = SessionHandler.getInstance()
>>                 Session sess = sh.getSession(conn);
>>
>>
>>                 File inpFile = new
>> File("/ftp/languages/java/rss-rdf/feeds/feed.xml");
>>                 //URL inpFile = new
>> URL("http://www.washingtonpost.com/wp-dyn/rss/linkset/2005/03/25/LI2005032500977.xml"); 
>>
>>                 //URL inpFile = new
>> URL("http://paaflcio.org/media/paaflciorss/feeds/prfeed.htm");
>>                 ChannelBuilder cb = new ChannelBuilder(sess);
>>                 //cb.beginTransaction();
>>
>>                 ChannelIF channel = FeedParser.parse(new
>> ChannelBuilder(sess), inpFile);
>>                 //cb.endTransaction();
>>      many thanks for any help!
>>
>> This is a very cool api....hope i can get by this issue.
>>
>> ------------------------------------------------------------------------- 
>>
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to 
>> share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV 
>>
>> _______________________________________________
>> Informa-developer mailing list
>> Inf...@li...
>> https://lists.sourceforge.net/lists/listinfo/informa-developer
>
>
>