[Registry-dev] [jira] Commented: (REGISTRY-274) java.sql.SQLException: Failed to start database

[Krishantha Samaraweera (JIRA)]

    [ https://wso2.org/jira/browse/REGISTRY-274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16269#action_16269 ] 

Krishantha Samaraweera commented on REGISTRY-274:
-------------------------------------------------

Can you change the embedded connection URL to derby network client connection URL. And also change the driver name configuration to org.apache.derby.jdbc.ClientDriver.

After the modifications your derby configuration in registry.xml should be as follows.

<dbconfig name="derby-db">
    <url>jdbc:derby://localhost:1527//path/to/your/registrydb</url>
    <userName>userName</userName>
    <password>password</password>
    <driverName>org.apache.derby.jdbc.ClientDriver</driverName>
</dbconfig>

> java.sql.SQLException: Failed to start database
> -----------------------------------------------
>
>                 Key: REGISTRY-274
>                 URL: https://wso2.org/jira/browse/REGISTRY-274
>             Project: WSO2 Registry
>          Issue Type: Bug
>          Components: userManager
>    Affects Versions: 1.0
>         Environment: Solaris 10, Java 1.5.0_11, Apache Tomcat 6.0.14, Derby 10.3.2.1
>            Reporter: Patrick Podenski
>            Assignee: Chathura Ekanayake
>         Attachments: localhost.2008-04-17.log
>
>
> Following instructions for configuring derby database at <http://wso2.org/project/registry/1.0/docs/userguide.html>.
> When starting Tomcat, an exception occurs:
> Apr 17, 2008 9:23:44 AM org.apache.catalina.core.StandardContext loadOnStartup
> SEVERE: Servlet /wso2registry threw load() exception
> java.sql.SQLException: Failed to start database '/export/home/patp/WS02_With_Derby/registry_db', see the next exception for details.
> I have included the localhost log file as an attachment.
> This same error occurred when I tried this installation on Windows XP.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira