noemi conde

Hi all,

I have a problem when I try to delete an Object "User" which has a collection of Objects "UsersRol", I cannot delete user because I obtain a DataIntegritiViolationException, (I suppose I'm not deleting on cascade, and I got this exception because, the objects related to user cannot exist in the database without user, but, this is the exact reason to delete all of them on cascade)

This code works fine with the operation merge, but I don't know, if I want to delete an object, this object needs to be loaded by hibernate or in the other hand It just need to set its id.
I also try to set the id's of the usersRol collection, but this is still not working

What is my problem ??? I cannot find it !!

Any idea is welcome, thanks in advance.

Here are my mappings:

<hibernate-mapping> <class name="User" table="USER" schema="SCHEMA1"> <id name="userId" type="int"> <column name="USER_ID" /> <generator class="identity" /> </id> .... <set name="userRols" inverse="true" cascade="all-delete-orphan" lazy="true"> <key> <column name="USER_ID" /> </key> <one-to-many class="UserRol" /> </set> </class> </hibernate-mapping> <hibernate-mapping> <class name="UserRol" table="USER_ROL" schema="SCHEMA1"> <id name="userRolId" type="int"> <column name="USER_ROL_ID" /> <generator class="identity" /> </id> <many-to-one name="rol" class="Rol" fetch="select"> <column name="ROL_ID" not-null="true" /> </many-to-one> <many-to-one name="user" class="User"> <column name="USER_ID" not-null="true" /> </many-to-one> </class> </hibernate-mapping>

when I try to delete an instance of user an sql - exception is thrown :

com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -532, SQLSTATE: 23504, SQLERRMC: SCHEMA1.USER_ROL.FK_USEROL_USER

This is the hibernate exception:

org.hibernate.exception.ConstraintViolationException: could not delete: [User#3]

And this is the first exception in the stacktrace:

Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1ab600f] to process 'after' execution for test: method [public void UserDaoTest.deleteTest()], instance [UserDaoTest@2fb002], exception [null]
org.springframework.dao.DataIntegrityViolationException: could not delete: [User#3]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [User#3]

And this is the code I try to execute:

@Test
public void deleteTest(){
User user = new User();
user.setUserId(3);
UserRol userRol1 = new UserRol();
userRol1.setUserRolId(10);
Set<UserRol> usersRol = new HashSet<UserRol>();
usersRol.add(userRol1);
userDao.remove(user);
Assert.assertTrue(true);
}

And this is the remove code:

public void remove(E entity) {
final String currentEntityName = getEntityName(entity);

if (LOG.isDebugEnabled()) {
LOG.debug("Removing entity {}", entity);
}

getHibernateTemplate().delete(currentEntityName, entity);
}

Hi ranchies !!!
I've got a problem dealing with composite primary keys in hibernate


Here is the code:


@Table(name = "TABLE_A", schema="SCHEM_A") public class Ejercicio implements java.io.Serializable { private TableAId id; @SuppressWarnings("serial") @Embeddable public class TableAId implements java.io.Serializable { @Column(name = "ID_TABLE_A", nullable=false) private Integer idTableA; @JoinColumn(name = "ID_COLUM_B") @ManyToOne private ColumnB idColumB; @JoinColumn(table="SCHEMA_B.TABLE_B", name = "ID_TABLE_B") @ManyToOne private TABLE_B idTableB;

We have a composite primary key with objects from two different schemas, and we don't know how to do the mapping.

The exception thrown when we try to execute this hql query: "Select A from Table_A" is

com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: TABLE_A0_.IDTABLE_A

Do you know what is the problem ???

Any idea is welcome, thanks in advance.

Thanks !!!

I'll try it now !

Hi all !

I've got a problem, one of my entities (A) has a composite primary key, this PK is composed by an Integer which identifies another entity (B) and two strings more, so the three of them identifies this entity (A), here is the problem, can I implement this using Hibernate ??? or I should have a surrogate key instead of this primary key, in that case I suppose I should have an Unique index, indexing all three fields in order to maintain the restrictions of a primary key in those fields.
My Daos should implement a GenericDao parameterized by the type of the Entity, and the type of the primary key, and my primary key don't have a type !!!

Can you help me ???

I found some examples using composite keys, but in all of them, the keys identifies different entities, so you can write another object with an @Embeddable annotation with all the keys, but I get lost because of these two strings, that they don't identify anything at all.

I think I should use the surrogate key option, am I correct ???

What do you think ? Any idea ?? I don't find something like this in google :S

Any idea is welcome,

Thanks in advance !!

Hello everyone!

I'm newie in GXT, here is my problem: I am trying to implement a paging grid that also use filters.
Here is the code:

PagingModelMemoryProxy proxy = new PagingModelMemoryProxy(TestData.getCompanies()); final PagingLoader<PagingLoadResult<ModelData>> loader = new BasePagingLoader<PagingLoadResult<ModelData>>(proxy); loader.setRemoteSort(true); listStore = new ListStore<Company>(loader); bottomToolBar = new PagingToolBar(10); bottomToolBar.bind(loader); loader.load(0, 10); grid = new Grid<Company>(listStore, cm); grid.getView().setForceFit(true); grid.setStyleAttribute("borderTop", "none"); grid.setWidth("100"); grid.setAutoExpandColumn("comercialName"); grid.setBorders(false); grid.setStripeRows(true); grid.setColumnLines(true); grid.setColumnReordering(true); grid.setAutoHeight(true);

where "TestData.getCompanies()" gets the data displayed in the grid, and "cm" is the ColumnModel with the configuration for the columns. That is working fine. My problem is that I have a combo to filter the grid. After select a value in the combo, I want to reload the whole grid, and shows only the results filtered. But I want to filter the whole set of data, and not only the data which is in the current page you are looking at. I don't know if I am explaining my situation well... But I would like to update also the number of pages showed.

For example, I have 3000 companies, 1500 of them are from "Italy" and the others 1500 are from "Poland". My grid shows a total of 300 pages. If I am watching one of the pages that only shows companies from "Poland" and I filter "Italy", that page of the grid is empty of data, and the count of pages is still 300 when it would have to reload and only shows 150 pages with the companies that are from "Italy".

I would be very grateful if somebody has any idea.

I suppose I need to extend "PagingModelMemoryProxy" to support filtering (by overriding the load method), but I don't know how to do it.
Is this what I have to do ?

Any idea is welcome,

Thanks in advance !!!

Hi,
It's already worked out, it was a mistake in the path ...
I didn't know maven recommend some kind of path to put the SQL scripts.

Hi all !

I'd like to drop and create tables, and also insert data into them by using the command mvn sql:execute, I did this before with a postgresql DBMS.

Nom I'm using a ORACLE DBMS, I have 3 diferent databases, and I want to execute the scripts of dropping and creating tables, so I have 3 different profiles in the pom.xml (each one for eache different dababase) when I run that command associate to each profile, the conexion runs ok, but it does not execute any SQL statement,

here the interesting parts of the pom.xml

<profiles> <profile> <id>profile1</id> <activation> <activeByDefault>false</activeByDefault> </activation> <properties> <!-- JDBC driver properties --> <jdbcDriver.groupId>oracle</jdbcDriver.groupId> <jdbcDriver.artifactId>ojdbc14</jdbcDriver.artifactId> <jdbcDriver.version>10.2.0.4</jdbcDriver.version> <jdbcDriver.className>oracle.jdbc.OracleDriver</jdbcDriver.className> <!-- Data source properties --> <dataSource.user>profile1</dataSource.user> <dataSource.password>profile1</dataSource.password> <dataSource.url>jdbc:oracle:thin:@localhost:1521:xe</dataSource.url> <dataSource.createTablesScript>scripts/PROFILE1_CREATE_TABLES.sql</dataSource.createTablesScript> </properties> </profile> [...] </profiles> [...] <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>sql-maven-plugin</artifactId> <version>1.3</version> <dependencies> <!-- specify the dependent jdbc driver here --> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc14</artifactId> <version>10.2.0.4</version> </dependency> </dependencies> <!-- common configuration shared by all executions --> <configuration> <driver>${jdbcDriver.className}</driver> <url>${dataSource.url}</url> <username>${dataSource.user}</username> <password>${dataSource.password}</password> <!-- You can comment out username/password configurations and have maven to look them up in your settings.xml using ${settingsKey} --> <settingsKey>sensibleKey</settingsKey> <!--all executions are ignored if -Dmaven.test.skip=true--> <skip>${maven.test.skip}</skip> <fileset> <basedir>${basedir}</basedir> <includes> <include>${dataSource.createTablesScript}</include> </includes> </fileset> </configuration> <executions> <execution> <id>create-schema</id> <phase>process-test-resources</phase> <goals> <goal>execute</goal> </goals> <configuration> <autocommit>true</autocommit> <srcFiles> <srcFile>${dataSource.url}</srcFile> </srcFiles> </configuration> </execution> </executions> </plugin>


and the result is:

[com.oracle:ojdbc14:jar:10.2.0.4:compile, org.apache.maven:maven-plugin-api:jar:2.0:runtime, org.apache.maven:maven-settings:jar:2.0:runtime, org.apache.maven:maven-model:jar:2.0:runtime, org.codehaus.plexus:plexus-utils:jar:1.0.4:runtime, org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-8:runtime, classworlds:classworlds:jar:1.1-alpha-2:runtime] for plugin: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main [DEBUG] Looking up mojo org.codehaus.mojo:sql-maven-plugin:1.3:execute in realm /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main - descRealmId=/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main [DEBUG] Looked up - org.codehaus.mojo.sql.SqlExecMojo@1bc16f0 - ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main, parent: ClassRealm[plexus.core, parent: null]] [DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute' with basic configurator --> [DEBUG] (f) autocommit = false [DEBUG] (s) delimiter = ; [DEBUG] (s) delimiterType = normal [DEBUG] (s) driver = oracle.jdbc.OracleDriver [DEBUG] (s) basedir = C:\Entorno\workspace\comun [DEBUG] (s) includes = [Ljava.lang.String;@1a9d1b [DEBUG] (f) fileset = org.codehaus.mojo.sql.Fileset@140984b [DEBUG] (s) keepFormat = false [DEBUG] (s) onError = abort [DEBUG] (s) password = profile1 [DEBUG] (f) settings = org.apache.maven.settings.Settings@1a8773c [DEBUG] (f) settingsKey = sensibleKey [DEBUG] (f) skip = false [DEBUG] (f) skipOnConnectionError = false [DEBUG] (s) url = jdbc:oracle:thin:@localhost:1521:xe [DEBUG] (s) username = profile1 [DEBUG] -- end configuration -- [INFO] [sql:execute] [DEBUG] Setting context classloader for plugin to: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main (instance is: ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main, parent: ClassRealm[plexus.core, parent: null]]) [DEBUG] connecting to jdbc:oracle:thin:@localhost:1521:xe [DEBUG] Committing transaction [INFO] 0 of 0 SQL statements executed successfully [DEBUG] disposing managed ClassRealm with id: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main [DEBUG] dissociating all components from managed ClassRealm with id: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESSFUL

does anybody know why the hell the scripts are not executed !!! this is driving me crazyyy !!!

any ideas ?? I got no ideas left to try !

Thanks so much !

Hi, thanks for your quick answer, i'm actually looking for this dependency in the whole workspace, but I think it doesn't exist, maybe I must add a new property in my pom.xml, but I'm not sure.

Do you remember what you did to solve this inconvenience ???
I have no ideas and I'm running out of time, and so much wasted whit this problem !

Thanks again !

Hi,

When I changed the parent artifactId
<parent> <groupId>org.gvsig</groupId> <artifactId>gvsig-base-pom</artifactId> <version>2.0-SNAPSHOT</version> </parent>
to:
<parent> <groupId>org.gvsig</groupId> <artifactId>gvsig-base-extension-pom</artifactId> <version>2.0-SNAPSHOT</version> </parent>
The pom.xml shows this error:
Project build error: For managed dependency jre:javaws:jar: system-scoped dependency must specify an absolute systemPath but is ${java.home}/lib/javaws.jar

and cannot import all the dependencies I have, does anybody knows why ???
any idea ???
please I need some help !!!

Thanks.

Hi,

I can see IModuleProvider.class when I do jar -tvf as you recomend, so I think the jar hasn't got any problem, any ideas left ??

It's so weird, I don't know why doesn't work !!!

and, by the way thanks !!!

Hi,

I've got an web application which use 2 jar libraries made myself, the problem is that one of them needs to reference the other one, and tomcat can't find it.
Both libraries are in WEB-INF/lib, I try to use urlclassloader to load these libraries, but it doesn't work, I don't know the problem, does anybody know ??? any idea ???

Please, I dont have any ideas left.

The code is:

Class plugin = Class.forName("com.myclass.MyClass"); IModuloProvider objeto = (IModuloProvider) plugin.newInstance();

MyClass is included in one of these jars in WEB-INF/lib,

This is the error :

java.lang.ClassNotFoundException: com.xxxx.xxxx.IModuloProvider It doesn't find at java.net.URLClassLoader$1.run(Unknown Source)

Thanks !!!

Hi,
finally I've just added the jar file instead of creating the library, and it works fine, thanks so much !!!

Hi,

To add the jar file to the classpath I've just added a library called "PostgreSQL JDBC Driver" and put the .jar file into it.
I'm using eclipse IDE, I thought this is the way to do it, I'm wrong ? Anything else to do it ?

Thanks so much!

Hi,

I'm developing an standalone application with spring + hibernate + swing, and maven.
I've got no problems when I run the junit test with maven, but when I try to run my application I've got a BeanCreationException.

Exception:
log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext). log4j:WARN Please initialize the log4j system properly. Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError at org.gvsig.myextension.view.myextension.<init>(myextension.java:42) at org.gvsig.myextension.view.myextension$3.run(myextension.java:276) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'archivoDao': Autowiring of methods failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void org.gvsig.myextension.model.util.dao.GenericDaoHibernate.setSessionFactory(org.hibernate.SessionFactory); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [myextension-spring-config.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [myextension-spring-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are: PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.postgresql.Driver] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:256) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:998) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) at org.gvsig.myextension.controller.Controller.<clinit>(Controller.java:22) ... 9 more Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void org.gvsig.myextension.model.util.dao.GenericDaoHibernate.setSessionFactory(org.hibernate.SessionFactory); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [myextension-spring-config.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [myextension-spring-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are: PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.postgresql.Driver] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:543) at org.springframework.beans.factory.annotation.InjectionMetadata.injectMethods(InjectionMetadata.java:117) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:253) ... 25 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [myextension-spring-config.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [myextension-spring-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are: PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.postgresql.Driver] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:499) ... 27 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [myextension-spring-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are: PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.postgresql.Driver] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1279) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) ... 42 more Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are: PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.postgresql.Driver] at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:104) at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1276) ... 53 more

bean datasource in spring-config:

<bean id="dataSource" class="org.springframework.jdbc.datasource.SingleConnectionDataSource" p:driverClassName="org.postgresql.Driver" p:url="jdbc:postgresql://localhost/myextension" p:username="postgresql" p:password="postgresql" />

and the code where the exception is thrown :

public class Controller { static { ApplicationContext context = new ClassPathXmlApplicationContext( new String[] {SPRING_CONFIG_FILE}); transactionManager = (PlatformTransactionManager) context .getBean("transactionManager"); bienInmuebleService = (BienInmuebleService) context.getBean("bienInmuebleService"); } private static PlatformTransactionManager transactionManager; private static BienInmuebleService bienInmuebleService;

And by the way, this class (Controller) is singleton,
Does anybody know what I'm doing wrong ?
Should I use another dataSource ? which one ?
Thanks!