You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2007/04/20 19:26:15 UTC
[jira] Created: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
--------------------------------------------------------------------------------------------
Key: DERBY-2576
URL: https://issues.apache.org/jira/browse/DERBY-2576
Project: Derby
Issue Type: Bug
Components: JDBC
Affects Versions: 10.3.0.0
Reporter: Myrna van Lunteren
Priority: Minor
After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: [jira] Commented: (DERBY-2576) setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by Myrna van Lunteren <m....@gmail.com>.
I don't off hand remember the details of this...Did you try adding the
test I had attached?
I'll look at this closer later.
Myrna
[jira] Updated: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2576:
--------------------------------------
Attachment: DERBY-2576_tst.diff
test for ConnectionPoolDataSource and XADataSource that doesn't work because of this bug
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden closed DERBY-2576.
---------------------------------
Resolution: Invalid
Closing this issue as invalid, committed test contributed by Myrna with revision 584930.
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff, DERBY-2576_tst_mod_diff.txt
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534984 ]
Myrna van Lunteren commented on DERBY-2576:
-------------------------------------------
The modified test passes for me...I agree, this can be closed as invalid.
The new test can be added, I think...Just not to be run with j2ME/JSR169 (XA datasource not supported).
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff, DERBY-2576_tst_mod_diff.txt
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534334 ]
Kathey Marsden commented on DERBY-2576:
---------------------------------------
I tried this small test with EbmeddedXADataSource and it seems to create the database fine.
Am I doing something wrong to reproduce?
import org.apache.derby.jdbc.EmbeddedXADataSource;
import java.sql.*;
import javax.sql.*;
public class SetCreateTest {
public static void main(String[] args) throws Exception {
EmbeddedXADataSource ds = new EmbeddedXADataSource();
ds.setDatabaseName("newdb");
ds.setCreateDatabase("create");
XAConnection xaConn = ds.getXAConnection();
Connection conn = xaConn.getConnection();
Statement stmt = conn.createStatement();
stmt.close();
conn.close();
}
}
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel John Debrunner updated DERBY-2576:
-----------------------------------------
Issue Type: Bug (was: Improvement)
I think this is a bug because these classes extend EmbeddedDataSource and thus inherit the behaviour of that class which includes the setCreateDatabase() method and its intended behavior.
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2576:
--------------------------------------
Issue Type: Improvement (was: Bug)
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Improvement
> Components: JDBC
> Affects Versions: 10.3.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden reassigned DERBY-2576:
-------------------------------------
Assignee: Kathey Marsden
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2576:
----------------------------------
I looked at the test and found that at the time the issue occurs, we have
connectionAttributes set to "shutdown=true"
shutdownDatabase = "shutdown"
and
createDatabase = "create"
If I clear connectionAttributes, and shutdown then the database will create properly and the test will get further but ultimately fails with an ArrayIndexOutOfBounds exception that I haven't investigated. Since setting all three of these is not supported and it works with createDatabase only set, I would like to close this issue as invalid. Is that ok?
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2576) setCreateDatabase does not work for
EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2576:
----------------------------------
Attachment: DERBY-2576_tst_mod_diff.txt
I modified the test to clear the bean properties before each case and also changed the getInterfaces() calls and comparison to use instanceof to avoid ArrayIndexOutOfBounds exception.
> setCreateDatabase does not work for EmbeddedXADataSource or EmbeddedConnectionPoolDataSource
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-2576
> URL: https://issues.apache.org/jira/browse/DERBY-2576
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Reporter: Myrna van Lunteren
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: DERBY-2576_tst.diff, DERBY-2576_tst_mod_diff.txt
>
>
> After implementing setCreateDatabase for ClientDataSource, and creating a test (see DERBY-2296) I realized there was no such test for XADataSource or ConnectionPoolDataSource.
> However, the test I created failed with Embedded, because the database does not get created. A database *does* get created using setConnectionAttributes(create=true).
> Also, setShutdownDatabase does work (tested in XADSAuthenticationTest and PoolDSAuthenticationTest).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.