geotools-gt2-users

[Geotools-gt2-users] Failed to connect to the EPSG database ?

[Fabio L. L. <fab...@gm...>]

Hi people, I am using geotools 2.4, an error is occuring. The code tested
works well in JUNIT test, in stand alone mode. This error ocurrs when i cal=
l
the web service method, in the sun application server.

The message is: org.opengis.referencing. FactoryException: Failed to connec=
t
to the EPSG database.

Does anyone knows whats happening ? Thank's in advance.

Follows the stack trace:

org.opengis.referencing.FactoryException: Failed to connect to the EPSG
database.
        at
org.geotools.referencing.factory.epsg.DefaultFactory.createBackingStore(
DefaultFactory.java:480)
        at
org.geotools.referencing.factory.DeferredAuthorityFactory.getBackingStore(
DeferredAuthorityFactory.java:136)
        at
org.geotools.referencing.factory.BufferedAuthorityFactory.isAvailable(
BufferedAuthorityFactory.java:218)
        at
org.geotools.referencing.factory.DeferredAuthorityFactory.isAvailable(
DeferredAuthorityFactory.java:124)
        at org.geotools.factory.FactoryRegistry.isAvailable(
FactoryRegistry.java:530)
        at org.geotools.factory.FactoryRegistry.isAcceptable(
FactoryRegistry.java:389)
        at org.geotools.factory.FactoryRegistry$1.filter(
FactoryRegistry.java:146)
        at javax.imageio.spi.FilterIterator.advance(ServiceRegistry.java
:793)
        at javax.imageio.spi.FilterIterator.<init>(ServiceRegistry.java:787=
)
        at javax.imageio.spi.ServiceRegistry.getServiceProviders(
ServiceRegistry.java:491)
        at org.geotools.factory.FactoryRegistry.getServiceProviders(
FactoryRegistry.java:152)
        at org.geotools.referencing.FactoryFinder.getFactories(
FactoryFinder.java:196)
        at org.geotools.referencing.FactoryFinder.getCRSAuthorityFactories(
FactoryFinder.java:475)
        at org.geotools.referencing.DefaultAuthorityFactory.<init>(
DefaultAuthorityFactory.java:60)
        at org.geotools.referencing.DefaultAuthorityFactory.<init>(
DefaultAuthorityFactory.java:52)
        at org.geotools.referencing.CRS.getAuthorityFactory(CRS.java:149)
        at org.geotools.referencing.CRS.decode(CRS.java:343)
        at org.geotools.referencing.CRS.decode(CRS.java:279)
        at org.geotools.gml2.bindings.GMLAbstractGeometryTypeBinding.parse(
GMLAbstractGeometryTypeBinding.java:104)
        at org.geotools.xml.impl.ParseExecutor.visit(ParseExecutor.java:84)
        at org.geotools.xml.impl.BindingWalker$BindingExecutionChain.execut=
e
(BindingWalker.java:197)
        at org.geotools.xml.impl.BindingWalker.walk(BindingWalker.java:163)
        at org.geotools.xml.impl.ElementHandlerImpl.endElement(
ElementHandlerImpl.java:191)
        at org.geotools.xml.impl.ParserHandler.endElement(ParserHandler.jav=
a
:399)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
        at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(U=
nknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispat=
cher.dispatch(Unknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source=
)
        at org.geotools.xml.Parser.parse(Parser.java:184)
        at org.geotools.xml.Parser.parse(Parser.java:146)
        at webService.GisCatalogService.findGisService(Unknown Source)
        at webService.GisCatalogServiceIF_Tie.invoke_findGisService
(GisCatalogServiceIF_Tie.java:54)
        at webService.GisCatalogServiceIF_Tie.processingHook
(GisCatalogServiceIF_Tie.java:124)
        at com.sun.xml.rpc.server.StreamingHandler.handle(
StreamingHandler.java:333)
        at com.sun.xml.rpc.server.http.JAXRPCServletDelegate.doPost(
JAXRPCServletDelegate.java:448)
        at com.sun.enterprise.webservice.JAXRPCServlet.doPost(
JAXRPCServlet.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:767)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
        at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.jav=
a
:249)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
        at org.apache.catalina.security.SecurityUtil.execute(
SecurityUtil.java:282)
        at org.apache.catalina.security.SecurityUtil.doAsPrivilege(
SecurityUtil.java:165)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter=
(
ApplicationFilterChain.java:257)
        at org.apache.catalina.core.ApplicationFilterChain.access$000(
ApplicationFilterChain.java:55)
        at org.apache.catalina.core.ApplicationFilterChain$1.run(
ApplicationFilterChain.java:161)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
        at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:263)
        at org.apache.catalina.core.StandardPipeline.invoke(
StandardPipeline.java:551)
        at org.apache.catalina.core.StandardContextValve.invokeInternal(
StandardContextValve.java:225)
        at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:173)
        at org.apache.catalina.core.StandardPipeline.invoke(
StandardPipeline.java:551)
        at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:170)
        at org.apache.catalina.core.StandardPipeline.invoke(
StandardPipeline.java:551)
        at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:132)
        at org.apache.catalina.core.StandardPipeline.invoke(
StandardPipeline.java:551)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java
:933)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(
CoyoteAdapter.java:189)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess=
(
ProcessorTask.java:604)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(
ProcessorTask.java:475)
        at
com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(
ReadTask.java:371)
        at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(
ReadTask.java:264)
        at com.sun.enterprise.web.connector.grizzly.TaskBase.run(
TaskBase.java:281)
        at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(
WorkerThread.java:83)
Caused by: java.sql.SQLException: [unixODBC][Driver Manager]Data source nam=
e
not found, and no default driver specified
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(
JdbcOdbcConnection.java:323)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
        at sun.jdbc.odbc.ee.DataSource.getConnection(DataSource.java:65)
        at
org.geotools.referencing.factory.epsg.FactoryOnAccess.createBackingStore(
FactoryOnAccess.java:86)
        at
org.geotools.referencing.factory.epsg.DefaultFactory.createBackingStore0(
DefaultFactory.java:417)
        at
org.geotools.referencing.factory.epsg.DefaultFactory.createBackingStore(
DefaultFactory.java:473)
        ... 71 more


--=20
F=E1bio Luiz Leite J=FAnior

Re: [Geotools-gt2-users] Failed to connect to the EPSG database ?

[Martin D. <mar...@ge...>]

Fabio Luiz Leite a écrit :
> Hi people, I am using geotools 2.4, an error is occuring. The code 
> tested works well in JUNIT test, in stand alone mode. This error ocurrs 
> when i call the web service method, in the sun application server.

Do you have gt2-epsg-hsql.jar in your classpath?

	Martin

Re: [Geotools-gt2-users] Failed to connect to the EPSG database ?

[Fabio L. L. <fab...@gm...>]

Yes, I have. The gt2-epsg-hsql.jar and hsqldb-1.8.0.7.jar are in my
classpath.

On 3/27/07, Martin Desruisseaux <mar...@ge...> wrote:
>
> Fabio Luiz Leite a =E9crit :
> > Hi people, I am using geotools 2.4, an error is occuring. The code
> > tested works well in JUNIT test, in stand alone mode. This error ocurrs
> > when i call the web service method, in the sun application server.
>
> Do you have gt2-epsg-hsql.jar in your classpath?
>
>         Martin
>



--=20
F=E1bio Luiz Leite J=FAnior

Re: [Geotools-gt2-users] Failed to connect to the EPSG database ?

[Andrea A. <aa...@op...>]

Fabio Luiz Leite ha scritto:
> Hi people, I am using geotools 2.4, an error is occuring. The code 
> tested works well in JUNIT test, in stand alone mode. This error ocurrs 
> when i call the web service method, in the sun application server.
> 
> The message is: org.opengis.referencing. FactoryException: Failed to 
> connect to the EPSG database.
> 
> Does anyone knows whats happening ? Thank's in advance.

 From the stack trace it seems you have epsg-access too, which on a
unix platform won't work.
Remove it :-)
Cheers
Andrea

Re: [Geotools-gt2-users] Failed to connect to the EPSG database ?

[Fabio L. L. <fab...@gm...>]

Yes, Andrea. I remove the epsg-access and It works fine, Thank you !!!!

On 3/27/07, Andrea Aime <aa...@op...> wrote:
>
> Fabio Luiz Leite ha scritto:
> > Hi people, I am using geotools 2.4, an error is occuring. The code
> > tested works well in JUNIT test, in stand alone mode. This error ocurrs
> > when i call the web service method, in the sun application server.
> >
> > The message is: org.opengis.referencing. FactoryException: Failed to
> > connect to the EPSG database.
> >
> > Does anyone knows whats happening ? Thank's in advance.
>
> From the stack trace it seems you have epsg-access too, which on a
> unix platform won't work.
> Remove it :-)
> Cheers
> Andrea
>



--=20
F=E1bio Luiz Leite J=FAnior

Re: [Geotools-gt2-users] Failed to connect to the EPSG database ?

[Martin D. <mar...@ge...>]

Fabio Luiz Leite a écrit :
> Yes, Andrea. I remove the epsg-access and It works fine, Thank you !!!!

Created a JIRA task in order to take trace of this issue:

http://jira.codehaus.org/browse/GEOT-1211

	Martin