[#DERBY-409] ClientDataSource setConnectionAttributes("create=true") fails with "An attempt was made to access a database, mydbcreate=true, which was not found."

Derby

ClientDataSource setConnectionAttributes("create=true") fails with "An attempt was made to access a database, mydbcreate=true, which was not found."

Created: 30/Jun/05 06:23 AM Updated: 11/Jul/06 11:53 PM

Return to search

Component/s:

JDBC

Affects Version/s:

10.1.1.0, 10.2.1.6

Fix Version/s:

10.1.2.1, 10.2.1.6

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
ConnectionAttributes.java	2005-06-30 06:25 AM	Kathey Marsden	2 kB
Derby409.patch	2005-07-12 10:18 PM	Philip Wilder	2 kB

Resolution Date:

30/Sep/05 01:53 AM

Description

« Hide

ClientDataSource setConnectionAttributes("create=true") fails with "An attempt was made to access a database, mydbcreate=true, which was not found." The method does not seem to insert a semicolon before the attributes.

run attached repro to produce the error below

$java ConnectionAttributes
embedded setConnectionAttributes
client setConnectionAttributes
org.apache.derby.client.am.DisconnectException: The application server rejected establishment of the connection. An attempt was made to access a database, mydbcreate=true, which was not found.
        at org.apache.derby.client.net.NetConnectionReply.parseRDBNFNRM(NetConnectionReply.java)
        at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(NetConnectionReply.java)
        at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(NetConnectionReply.java)
        at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(NetConnectionReply.java)
        at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(NetConnection.java)
        at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(NetConnection.java)
        at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(NetConnection.java)
        at org.apache.derby.client.net.NetConnection.flowConnect(NetConnection.java)
        at org.apache.derby.client.net.NetConnection.initialize(NetConnection.java)
        at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java)
        at org.apache.derby.jdbc.ClientDataSource.getConnection(ClientDataSource.java)
        at org.apache.derby.jdbc.ClientDataSource.getConnection(ClientDataSource.java)
        at ConnectionAttributes.main(ConnectionAttributes.java:28)
$

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#219256	Fri Jul 15 23:01:02 UTC 2005	djd	~~DERBY-409~~ This is a potential patch for the issue brought up in ~~DERBY-406~~ connectionAttributes will now default to null (aka no default) Patch contributed by Philip Wilder 050503w@acadiau.ca
				Files Changed
				MODIFY /incubator/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java MODIFY /incubator/derby/code/trunk/java/client/org/apache/derby/jdbc/ClientBaseDataSource.java

Repository	Revision	Date	User	Message
ASF	#219980	Thu Jul 21 01:52:49 UTC 2005	bandaram	Merge trunk change 209498 to 10.1 branch. ~~DERBY-406~~ - Sets the username to start with the default value ("APP") ~~DERBY-410~~ - Sets the server name to start with the default value ("localhost") ~~DERBY-409~~ - Adds a semi-colon in the connection class to avoid databasenames like myDBcreate=true resulting from no dividing semi-colon. Submitted by Satheesh Bandaram (satheesh@sourcery.org)
				Files Changed
				MODIFY /incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dataSourcePermissions_net.out MODIFY /incubator/derby/code/branches/10.1/java/client/org/apache/derby/jdbc/ClientBaseDataSource.java MODIFY /incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/derbynet/dataSourcePermissions_net.java MODIFY /incubator/derby/code/branches/10.1/java/client/org/apache/derby/client/am/Connection.java

Repository	Revision	Date	User	Message
ASF	#219981	Thu Jul 21 01:55:40 UTC 2005	bandaram	Port trunk change 219256 to 10.1 branch. ~~DERBY-409~~: This is a potential patch for the issue brought up in ~~DERBY-406~~ connectionAttributes will now default to null (aka no default) Ported to 10.1 by Satheesh Bandaram (satheesh@sourcery.org)
				Files Changed
				MODIFY /incubator/derby/code/branches/10.1/java/client/org/apache/derby/jdbc/ClientBaseDataSource.java MODIFY /incubator/derby/code/branches/10.1/java/client/org/apache/derby/client/am/Connection.java