[Hibernate-JIRA] Created: (HHH-3666) mapping of varchar primary key from database as assigned but while try to get data data automatically deleted.
by Prashant k Patil. (JIRA)
mapping of varchar primary key from database as assigned but while try to get data data automatically deleted.
--------------------------------------------------------------------------------------------------------------
Key: HHH-3666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3666
Project: Hibernate Core
Issue Type: Bug
Environment: hibernate 3
Database MySql
Reporter: Prashant k Patil.
I am trying to get data from database. It is successfully receives data if it is add by hibernate.
If that data is manually added in database it is automatically deleted by hibernate.
my mapping to table like this.
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Dec 17, 2008 1:38:05 PM by Hibernate Tools 3.1.0.beta5 -->
<hibernate-mapping>
<class name="com..entity.User" table="user" dynamic-update="true" catalog="database">
<comment></comment>
<id name="userId" type="string" length="30">
<column name="USER_ID" />
</id>
<property name="password" type="string" length="30">
<column name="PASSWORD">
<comment></comment>
</column>
</property>
</class>
</hibernate-mapping>
and code using like this .
Transaction tx = null;
try {
Session currentSession = InitializeSessionFactory.getInstance().getCurrentSession();
tx = currentSession.beginTransaction();
//User temp = new User("doctor","doctor","DOCTOR",new Integer(1));
//currentSession.save(temp);
User user = (User)currentSession.get(User.class, userId);
tx.commit();
return user;
}catch(Exception e) {
tx.rollback();
logger.error(e.getMessage());
}
please help me so that data not to be deleted.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Created: (HBX-1038) NullPointerException trying to open "hibernate.reveng.xml" in Hibernate Reverse Engineering Editor
by Alex K (JIRA)
NullPointerException trying to open "hibernate.reveng.xml" in Hibernate Reverse Engineering Editor
--------------------------------------------------------------------------------------------------
Key: HBX-1038
URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1038
Project: Hibernate Tools
Issue Type: Bug
Components: reverse-engineer
Affects Versions: 3.2.0.GA
Environment: Windows XP, Eclipse 3.3.1.1.
Reporter: Alex K
I am getting an excepting trying to open "hibernate.reveng.xml" in Hibernate Reverse Engineering Editor.
Tools are 3.2.0 GA. Eclipse is 3.3.1.1.
Stack trace:
java.lang.NullPointerException
at org.eclipse.wst.sse.ui.StructuredTextEditor.update(StructuredTextEditor.java:3096)
at org.hibernate.eclipse.mapper.editors.xpl.XMLFormEditorPart.addSourcePage(XMLFormEditorPart.java:185)
at org.hibernate.eclipse.mapper.editors.xpl.XMLFormEditorPart.addPages(XMLFormEditorPart.java:50)
at org.hibernate.eclipse.mapper.editors.ReverseEngineeringEditor.addPages(ReverseEngineeringEditor.java:84)
at org.eclipse.ui.forms.editor.FormEditor.createPages(FormEditor.java:146)
at org.eclipse.ui.part.MultiPageEditorPart.createPartControl(MultiPageEditorPart.java:283)
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:661)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:426)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:592)
at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:263)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2739)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2651)
at org.eclipse.ui.internal.WorkbenchPage.access$13(WorkbenchPage.java:2643)
at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2595)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2590)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2574)
at org.eclipse.ui.actions.OpenWithMenu.openEditor(OpenWithMenu.java:340)
at org.eclipse.ui.actions.OpenWithMenu.access$0(OpenWithMenu.java:328)
at org.eclipse.ui.actions.OpenWithMenu$2.handleEvent(OpenWithMenu.java:190)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
hibernate.reveng.xml has been generated by the Reverse Engineering Wizard. Contents are (about 9 tables are referenced):
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >
<hibernate-reverse-engineering>
<table-filter match-catalog="mysql" match-name="table1"/>
<table-filter match-catalog="mysql" match-name="table2"/>
...
</hibernate-reverse-engineering>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Updated: (HHH-1015) Incorrect SQL generated when one-to-many foreign key is in a discriminated subclass table
by Krasimir Chobantonov (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1015?page=c... ]
Krasimir Chobantonov updated HHH-1015:
--------------------------------------
Attachment: hhh-1015-version2.patch
Attaching patch hhh-1015-version2.patch that will fix the HQL to SQL generation and it will include also the fixes from hhh-1015.patch
> Incorrect SQL generated when one-to-many foreign key is in a discriminated subclass table
> -----------------------------------------------------------------------------------------
>
> Key: HHH-1015
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1015
> Project: Hibernate Core
> Issue Type: Bug
> Components: core
> Affects Versions: 3.1 beta 2
> Environment: Hibernate versions 3.1 beta 3 and 3.0.5
> Reporter: Steven Grimm
> Priority: Minor
> Attachments: hhh-1015-version2.patch, hhh-1015.patch
>
>
> I have the following mappings describing a hierarchy of events and a class that the events refer to:
> <hibernate-mapping package="com.xyz">
> <class name="Event" table="event" discriminator-value="-1">
> <id name="Id" type="long" column="event_id"/>
> <discriminator column="event_type_id" type="integer" />
> <subclass name="EventPayer" discriminator-value="-3">
> <join table="event_payer">
> <key column="event_id" />
> <many-to-one name="payer" column="payer_id" class="Payer" />
> </join>
> <subclass name="EventPayerCreated" discriminator-value="1" />
> </subclass>
> </class>
> <class name="Payer" table="payer">
> <id name="payerId" column="payer_id" type="java.lang.Long"/>
> <set name="eventPayers" inverse="true" cascade="save-update">
> <key column="payer_id"/>
> <one-to-many class="EventPayer"/>
> </set>
> </class>
> </hibernate-mapping>
> When I fetch the Payer.eventPayers collection, Hibernate generates this SQL:
> select eventpayer0_.payer_id as payer7_1_,
> eventpayer0_.event_id as event1_1_,
> eventpayer0_.event_id as event1_5_0_,
> eventpayer0_1_.payer_id as payer2_6_0_,
> eventpayer0_.event_type_id as event2_5_0_
> from event eventpayer0_
> inner join event_payer eventpayer0_1_
> on eventpayer0_.event_id=eventpayer0_1_.event_id
> where eventpayer0_.payer_id=?
> The problem is that there is no event.payer_id column; payer_id is in the child table, not the parent. It appears that specifying a discriminated subclass in <one-to-many> is the same as specifying the superclass, or that Hibernate is ignoring the subclass's <join> element. As far as I can tell, this leaves no way to resolve bidirectional associations where one end of the association is in a discriminated subclass, which seems like a perfectly reasonable thing to want to do.
> I also tried changing <key column="payer_id"/> to <key property-ref="payer"/> in the Payer class's <set> element, but got similar behavior in the form of a "property not found" error: Hibernate is either looking in the superclass's properties rather than the subclass's or is ignoring the list of properties in the <join> element.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Created: (HHH-3663) Request to add Joined inheritance strategy supported for versioning
by louie (JIRA)
Request to add Joined inheritance strategy supported for versioning
-------------------------------------------------------------------
Key: HHH-3663
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3663
Project: Hibernate Core
Issue Type: New Feature
Components: envers
Affects Versions: 3.3.1
Environment: Windows XP, jdk1.6
Reporter: louie
We have versioned entities with Joined inheritance strategy. The Envers throws the following exception:
[hibernatetool] An exception occurred while running exporter #2:hbm2ddl (Generates database schema)
[hibernatetool] To get the full stack trace run ant with -verbose
[hibernatetool] org.hibernate.MappingException: Joined inheritance strategy not supported for versioning!
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Error executing ant tasks
Embedded error: org.hibernate.MappingException: Joined inheritance strategy not supported for versioning!
[INFO] ------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Error executing ant tasks
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:499)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:478)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing ant tasks
at org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:114)
at org.apache.maven.plugin.antrun.AntRunMojo.execute(AntRunMojo.java:83)
at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558)
... 16 more
Caused by: org.hibernate.MappingException: Joined inheritance strategy not supported for versioning!
at org.hibernate.tool.ant.HibernateToolTask.reportException(HibernateToolTask.java:226)
at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:189)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:64)
at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:123)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:108)
... 19 more
Caused by: org.hibernate.MappingException: Joined inheritance strategy not supported for versioning!
at org.jboss.envers.configuration.metadata.VersionsMetadataGenerator.generateFirstPass(VersionsMetadataGenerator.java:307)
at org.jboss.envers.configuration.EntitiesConfigurator.configure(EntitiesConfigurator.java:84)
at org.jboss.envers.configuration.VersionsConfiguration.<init>(VersionsConfiguration.java:80)
at org.jboss.envers.configuration.VersionsConfiguration.getFor(VersionsConfiguration.java:93)
at org.jboss.envers.ant.JPAConfigurationTaskWithEnvers.doConfiguration(JPAConfigurationTaskWithEnvers.java:33)
at org.hibernate.tool.ant.ConfigurationTask.getConfiguration(ConfigurationTask.java:55)
at org.hibernate.tool.ant.HibernateToolTask.getConfiguration(HibernateToolTask.java:302)
at org.hibernate.tool.ant.Hbm2DDLExporterTask.createExporter(Hbm2DDLExporterTask.java:51)
at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java:39)
at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:186)
... 32 more
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 6 seconds
[INFO] Finished at: Tue Dec 16 13:42:44 PST 2008
[INFO] Final Memory: 15M/29M
[INFO] ------------------------------------------------------------------------
We would like to request to add the Envers support for the Joined inheritance strategy entities.
Thanks.
Louie Liu
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Created: (HHH-3661) Optimistic's locking version number is incorrectly applied to the Entity in some cases
by Juan F Cervera (JIRA)
Optimistic's locking version number is incorrectly applied to the Entity in some cases
--------------------------------------------------------------------------------------
Key: HHH-3661
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3661
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.3.1
Environment: Hibernate 3.3.1.GA and Informix 10
Reporter: Juan F Cervera
Hi I have found an issue using optimistic locking and I think it's probably a bug.
The situation is the following:
a) I use optimistic locking
b) I have a legacy database where the optimistic locking field is controlled by triggers, so I use generated="always" in the mapping file for the version field (I don't think this is related to the problem, but wanted to clarify)
c) The Entity has a <bag> collection that can be empty (null)
d) At some point the collection is changed to something else than null, in my case this is happening within the same transaction, after creating the Entity, but this doesn't seem to be required for the problem to happen.
The above scenario produces a StaleStateException.
For what I see Hibernate first inserts the new record, then it does an update because we have added the collection but it uses the wrong version number, which produces the exception.
After some debugging I have traced down the problem, as follows:
a) As there has been a change to the Entity, Hibernate calculates a new version number (even when I have generated="always". This is not normally a problem though as it's not written to the DB.)
b) When an Entity has a collection that changes from null to something else, Hibernate substitutes the normal collection for the appropriate Hibernate collection type, in my case a PersistentBag. Unfortunately, the substitution process doesn't stop just at the collection, it applies to all the dirty fields, including the version number to the new calculated in a)!! This means that the version number is out of sync with the DB, which will produce problems down the line.
See the following for details:
+ Line 112 at org.hibernate.event.def.WrapVisitor.processArrayOrNewCollection forces the substitution by not returning new persistentCollection
+ This gets propagates several layers until it reaches the boolean "substitute" in line 148 at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity
+ This variable enforces the substitution in the line 156, where the version number gets updated to a new value which doesn't exist yet in the database, as the record has not been updated with it yet.
c) When the update happens, Hibernate queries the Entity for it's version number because it's using optimistic locking, and as this has been updated in b) with a new value that doesn't match the record in the database nothing gets updated
See following for details:
+ The "previous" version number is retrieved in the line 96 at org.hibernate.action.EntityUpdateAction.execute
d) Hibernate checks how many records have been updated, in this case 0 as the version number was wrong. Then it interprets this as a StaleStateException
Unfortunately I don't know enough about Hibernate to be able to propose a working solution. I think the fact that a full update of the Entity, including the new calculated version number, is forced in step b) is the issue and that the version number should have been left as it was.
How many other scenarios, apart from changing a null collection to one with data, would produce substitute to be "true" I don't know, but I expect all those cases to produce problems with optimistic locking in the same way.
I have work around for system that use the DB to control the version numbers instead of Hibernate (normally through triggers). In these systems it's possible to set optimistic-lock="false" in the collection, which would prevent the version number changing for updates on that field, so the update on b) would be fine. Unfortunately, if some other property changes along with the null collection, the version number will change because of those other properties. So in order to be sure I don't have issues I have had to set optimistic-lock="false" in all components/properties/collections.
One more thing, I think this issue is probably the cause to the problem reported in HHH-2796, as the symptoms look similar.
Let me know if you have any questions.
Thanks
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Deleted: (HHH-3658) using c3p0 connection Informix7.2
by Gail Badner (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3658?page=c... ]
Gail Badner deleted HHH-3658:
-----------------------------
> using c3p0 connection Informix7.2
> ---------------------------------
>
> Key: HHH-3658
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3658
> Project: Hibernate Core
> Issue Type: Bug
> Environment: Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3 ,c3p0-0.9.12
> Reporter: jean jj
>
> Hi I am using Hibernate 3 with JDK1.5 and Informix 7.2 and driver version 2.21JC5 and c3p0-0.9.12
> INFO - Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
> INFO - C3P0 using driver: com.informix.jdbc.IfxDriver at URL: jdbc:informix-sqli://xxxxxx:xxxx/xx:INFORMIXSERVER=xxx
> INFO - Connection properties: {user=isuadmus, password=****}
> INFO - autocommit mode: false
> INFO - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@df452eda [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@2cdc0f6d [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hd3ogc7yh0nhwh9oik8b|871e65, idleConnectionTestPeriod -> 0, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@e45de01f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|ae1393, jdbcUrl -> jdbc:informix-sqli://140.127.191.1:8347/isuadmin:INFORMIXSERVER=sol8_tcp, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|dcb6b4, numHelperThreads -> 3 ]
> INFO - Database has transactions
> INFO - Database has transactions
> java.sql.SQLWarning: Database has transactions
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
> at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
> at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935)
> at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
> at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
> at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
> at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
> at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
> at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
> INFO - Database selected
> java.sql.SQLWarning: Database selected
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
> at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
> at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3941)
> at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
> at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
> at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
> at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
> at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
> at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
> INFO - Database server running in secondary mode.
> java.sql.SQLWarning: Database server running in secondary mode.
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
> at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
> at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3951)
> at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
> at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
> at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
> at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
> at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
> at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
> INFO - Database has transactions
> java.sql.SQLWarning: Database has transactions
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
> at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
> at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
> at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935)
> at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
> at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
> at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
> at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
> at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
> at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
> at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
> at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
> at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
> hibernate.cfg.xml
> <hibernate-configuration>
> <session-factory>
> <property name="dialect">
> org.hibernate.dialect.InformixDialect
> </property>
> <property name="connection.driver_class">
> com.informix.jdbc.IfxDriver
> </property>
> <property name="connection.url">
> jdbc:informix-sqli://xxxx:xxxx/xxxx:INFORMIXSERVER=xxxx
> </property>
> <property name="connection.username">xxxx</property>
> <property name="connection.password">xxxx</property>
> <property name="show_sql">true</property>
> <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
> <property name="hibernate.c3p0.min_size">5</property>
> <property name="hibernate.c3p0.max_size">20</property>
> <property name="hibernate.c3p0.acquire_increment">0</property>
> <property name="hibernate.c3p0.timeout">300</property>
> <property name="hibernate.c3p0.max_statements">0</property>
> <property name="hibernate.c3p0.idle_test_period">100</property>
> <mapping resource="xxxx.hbm.xml" />
> </session-factory>
> </hibernate-configuration>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Created: (HHH-3660) Allow for "on-delete" attribute on "one-to-one" mapping
by Eric Sirianni (JIRA)
Allow for "on-delete" attribute on "one-to-one" mapping
-------------------------------------------------------
Key: HHH-3660
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3660
Project: Hibernate Core
Issue Type: Improvement
Components: core
Affects Versions: 3.3.1
Reporter: Eric Sirianni
Currently, specifying the attribute on-delete="cascade" in the <key> element within a collection mapping indicates to hibernate that the delete will be automatically cascaded within the database (as opposed to hibernate executing the delete itself). In other words, the foreign key for the collection table was created with ON CASCADE DELETE behavior.
There is currently no way to specify the on-delete attribute for <one-to-one> mappings. This means that hibernate will need to execute delete statements for the child end of a one-to-one association instead of letting the database do the work.
Please enhance <one-to-one> mappings to have "on-delete" awareness.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months
[Hibernate-JIRA] Created: (HHH-3658) using c3p0 connection Informix7.2
by jean jj (JIRA)
using c3p0 connection Informix7.2
---------------------------------
Key: HHH-3658
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3658
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.3.0.GA
Environment: Informix7.2, jdk1.5, Informix Dialect Version 2.21JC5, Hibernate3.3 ,c3p0-0.9.12
Reporter: jean jj
Hi I am using Hibernate 3 with JDK1.5 and Informix 7.2 and driver version 2.21JC5 and c3p0-0.9.12
INFO - Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
INFO - C3P0 using driver: com.informix.jdbc.IfxDriver at URL: jdbc:informix-sqli://xxxxxx:xxxx/xx:INFORMIXSERVER=xxx
INFO - Connection properties: {user=isuadmus, password=****}
INFO - autocommit mode: false
INFO - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@df452eda [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@2cdc0f6d [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hd3ogc7yh0nhwh9oik8b|871e65, idleConnectionTestPeriod -> 0, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@e45de01f [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|ae1393, jdbcUrl -> jdbc:informix-sqli://140.127.191.1:8347/isuadmin:INFORMIXSERVER=sol8_tcp, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hd3ogc7yh0nhwh9oik8b|dcb6b4, numHelperThreads -> 3 ]
INFO - Database has transactions
INFO - Database has transactions
java.sql.SQLWarning: Database has transactions
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935)
at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO - Database selected
java.sql.SQLWarning: Database selected
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3941)
at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO - Database server running in secondary mode.
java.sql.SQLWarning: Database server running in secondary mode.
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3951)
at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO - Database has transactions
java.sql.SQLWarning: Database has transactions
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.addWarning(IfxSqliConnect.java:1817)
at com.informix.jdbc.IfxSqliConnect.setWarnings(IfxSqliConnect.java:3935)
at com.informix.jdbc.IfxSqliConnect.OpenDbInit(IfxSqliConnect.java:2591)
at com.informix.jdbc.IfxSqliConnect.setDatabaseOpen(IfxSqliConnect.java:2465)
at com.informix.jdbc.IfxSqli.callsetDatabaseOpen(IfxSqli.java:2496)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:1712)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1242)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:243)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
hibernate.cfg.xml
<hibernate-configuration>
<session-factory>
<property name="dialect">
org.hibernate.dialect.InformixDialect
</property>
<property name="connection.driver_class">
com.informix.jdbc.IfxDriver
</property>
<property name="connection.url">
jdbc:informix-sqli://xxxx:xxxx/xxxx:INFORMIXSERVER=xxxx
</property>
<property name="connection.username">xxxx</property>
<property name="connection.password">xxxx</property>
<property name="show_sql">true</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.acquire_increment">0</property>
<property name="hibernate.c3p0.timeout">300</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.idle_test_period">100</property>
<mapping resource="xxxx.hbm.xml" />
</session-factory>
</hibernate-configuration>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 6 months