maven - Deploy on glassfish server : no suitable driver for jdbc:derby -
when try upload maven spring project uses jpa (i use derby) on server, receive error didn't find suitable driver jdbc:derby :
error occurred during deployment: exception while loading app : java.lang.illegalstateexception: containerbase.addchild: start: org.apache.catalina.lifecycleexception: org.springframework.beans.factory.beancreationexception: error creating bean name 'service' defined in servletcontext resource [/web-inf/applicationcontext.xml]: instantiation of bean failed; nested exception org.springframework.beans.beaninstantiationexception: not instantiate bean class [service.locationguide]: constructor threw exception; nested exception javax.persistence.persistenceexception: exception [eclipselink-4002] (eclipse persistence services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.databaseexception internal exception: java.sql.sqlexception: no suitable driver found jdbc:derby://xxx.xxx.xxx.xx:portnbr/leuvenspeaks;create=true error code: 0.
i used these dependecies jpa , derby
<dependency> <groupid>org.eclipse.persistence</groupid> <artifactid>org.eclipse.persistence.jpa</artifactid> <version>2.5.1</version> <scope>compile</scope> </dependency> <dependency> <groupid>org.apache.derby</groupid> <artifactid>derbyclient</artifactid> <version>10.10.2.0</version> </dependency> and persistence unit :
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"> <persistence-unit name="locationpu" transaction-type="resource_local"> <provider>org.eclipse.persistence.jpa.persistenceprovider</provider> <class>domain.location</class> <class>domain.story</class> <properties> <property name="javax.persistence.jdbc.url" value="jdbc:derby://xxx.xxx.xxx.xxx:portnbr/leuvenspeaks;create=true"/> <property name="javax.persistence.jdbc.user" value="xxxx"/> <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.clientdriver"/> <property name="javax.persistence.jdbc.password" value="xxxx"/> <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/> </properties> </persistence-unit> thanks in advance!!
put derby driver $glassfish_home\glassfish\domains\domain1\lib folder , restart server.
you can download derby driver here
Comments
Post a Comment