[jira] Commented: (JUDDI-184) Derby db is not created correctly on initialization

["Kurt T Stam (JIRA)" <ju...@ws.apache.org>]

    [ https://issues.apache.org/jira/browse/JUDDI-184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12670984#action_12670984 ] 

Kurt T Stam commented on JUDDI-184:
-----------------------------------

now that juddi-183 is fixed and we have logging. Here is the trace

2009-02-05 21:10:51,022 ERROR [org.apache.juddi.registry.RegistryEngine] - Could not create jUDDI database Cannot create PoolableConnectionFactory (Java exception: ': java.lang.NullPointerException'.)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Java exception: ': java.lang.NullPointerException'.)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
        at org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
        at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
        at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1206)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1306)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1570)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1579)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1559)
        at java.lang.Thread.run(Thread.java:613)
Caused by: SQL Exception: Java exception: ': java.lang.NullPointerException'.
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
        at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        ... 23 more


> Derby db is not created correctly on initialization
> ---------------------------------------------------
>
>                 Key: JUDDI-184
>                 URL: https://issues.apache.org/jira/browse/JUDDI-184
>             Project: jUDDI
>          Issue Type: Bug
>    Affects Versions: 2.0rc6
>            Reporter: Kurt T Stam
>            Assignee: Kurt T Stam
>             Fix For: 2.0rc6
>
>
> When running juddi-tomcat out-of-the-box the derby database 
> 1. is called juddi-derby-test-db; which we should probably change to juddi-db
> 2. when the first statement is executed in the RegistryEngine on line 302
> CREATE TABLE BUSINESS_ENTITY
> (
>   BUSINESS_KEY VARCHAR(41) NOT NULL,
>   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
>   PUBLISHER_ID VARCHAR(20) NULL,
>   OPERATOR VARCHAR(255) NOT NULL,
>   LAST_UPDATE TIMESTAMP NOT NULL,
>   PRIMARY KEY (BUSINESS_KEY)
> )
> it throws the following exception:
> SQL Exception: Syntax error: Encountered "NULL" at line 5, column 28.
> So something is wrong when it goes to create the derby database.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.