You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tuscany.apache.org by "wangful (JIRA)" <tu...@ws.apache.org> on 2007/06/19 04:44:25 UTC

[jira] Created: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

DAS-RDB does not support Oracle or SqlServer well
-------------------------------------------------

                 Key: TUSCANY-1355
                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
             Project: Tuscany
          Issue Type: Bug
          Components: Java DAS RDB
    Affects Versions: Java-DAS-M2
         Environment: DAS-RDB to access the database of Oracle
            Reporter: wangful


I have used the following simple codes to use DAS to access an Oracle database.

		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
		String query = "select * from MYCUSTOMER";
		String query_result="";
		Connection conn = null;
	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();

		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

		conn = DriverManager.getConnection(url);
		conn.setAutoCommit(false);

                                           DAS das = DAS.FACTORY.createDAS(conn);

		Command readStores = das.createCommand(query);
		DataObject root = (DataObject)readStores.executeQuery();



		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
		
		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));

It will caused the following error: 

Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
	at TestDAS.main(TestDAS.java:47)

But the same code and same config will work well for  cloudscape database.

There are also some other problems for Oracle, seems DAS can't work for oracle.

Will someone look into this problem?

Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "wangful (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12514922 ] 

wangful commented on TUSCANY-1355:
----------------------------------

Hi,

 binary distribution at http://people.apache.org/~lresende/tuscany/das-beta1-distribution/  worked well for this problem.

Thanks.

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "Adriano Crestani (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508466 ] 

Adriano Crestani commented on TUSCANY-1355:
-------------------------------------------

Hi lizhantao,

When you mean "create command dynamically", you are saying you cannot know previously what your select will return, right?! If it is, there is no way to DAS to know which table each column on the ResultSet it belongs, since the Oracle JDBC Driver does not return the table's column. Though, it is not possible to use DAS on this case.

I also don't see how we could improve DAS to support this kind of situation.

Regards,
Adriano Crestani

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "wangful (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508717 ] 

wangful commented on TUSCANY-1355:
----------------------------------

I have co the latest codes and mvn them into jar, with this new jar:
if I didn't use the config file, I got the following error:
Exception in thread "main" java.lang.RuntimeException: Unable to obtain table information from JDBC. DAS configuration must specify ResultDescriptors
	at org.apache.tuscany.das.rdb.graphbuilder.impl.ResultMetadata.<init>(ResultMetadata.java:77)
	at org.apache.tuscany.das.rdb.graphbuilder.impl.GraphBuilderMetadata.<init>(GraphBuilderMetadata.java:64)
	at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.buildGraph(ReadCommandImpl.java:81)
	at org.apache.tuscany.das.rdb.impl.ReadCommandImpl.executeQuery(ReadCommandImpl.java:63)
	at TestDAS.main(TestDAS.java:61)

So I think this error message can tell me that, the new jar can work in my env.

But when I specify the config file,
DAS das = DAS.FACTORY.createDAS(Thread.currentThread().getContextClassLoader().getResourceAsStream("config.xml"), conn);
I got the following error:

Exception in thread "main" java.lang.UnsupportedOperationException
	at org.apache.tuscany.sdo.impl.DataObjectBase.getStaticType(DataObjectBase.java:363)
	at org.apache.tuscany.sdo.impl.DataObjectBase.eStaticClass(DataObjectBase.java:358)
	at org.apache.tuscany.sdo.impl.ExtensibleDataObjectImpl.eClass(ExtensibleDataObjectImpl.java:118)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.processObject(XMLHandler.java:2161)
	at org.eclipse.emf.ecore.xmi.impl.SAXXMLHandler.processObject(SAXXMLHandler.java:93)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObjectFromFeatureType(XMLHandler.java:1926)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObject(XMLHandler.java:1791)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleFeature(XMLHandler.java:1569)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createDocumentRoot(XMLHandler.java:1237)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObjectByType(XMLHandler.java:1165)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createTopObject(XMLHandler.java:1247)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.processElement(XMLHandler.java:883)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:866)
	at org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:627)
	at org.apache.tuscany.sdo.util.resource.SDOXMLResourceImpl$SDOXMLLoadImpl$XmlHandler.startElement(SDOXMLResourceImpl.java:362)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl$NSContentDispatcher.scanRootElementHook(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
	at javax.xml.parsers.SAXParser.parse(Unknown Source)
	at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(XMLLoadImpl.java:268)
	at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad(XMLResourceImpl.java:666)
	at org.apache.tuscany.sdo.util.resource.SDOXMLResourceImpl.doLoad(SDOXMLResourceImpl.java:538)
	at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.load(XMLResourceImpl.java:634)
	at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load(XMLDocumentImpl.java:259)
	at org.apache.tuscany.sdo.helper.XMLDocumentImpl.load(XMLDocumentImpl.java:232)
	at org.apache.tuscany.sdo.helper.XMLHelperImpl.load(XMLHelperImpl.java:85)
	at org.apache.tuscany.sdo.helper.XMLHelperImpl.load(XMLHelperImpl.java:79)
	at org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig(ConfigUtil.java:52)
	at org.apache.tuscany.das.rdb.impl.DASImpl.<init>(DASImpl.java:100)
	at org.apache.tuscany.das.rdb.impl.DASFactoryImpl.createDAS(DASFactoryImpl.java:39)
	at TestDAS.main(TestDAS.java:55)

And I don't think there is error in my config file, if I even use the sample config file as below, the error still come out:
<?xml version="1.0" encoding="ASCII"?>
<!--
  Licensed to the Apache Software Foundation (ASF) under one
  or more contributor license agreements.  See the NOTICE file
  distributed with this work for additional information
  regarding copyright ownership.  The ASF licenses this file
  to you under the Apache License, Version 2.0 (the
  "License"); you may not use this file except in compliance
  with the License.  You may obtain a copy of the License at

  http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing,
  software distributed under the License is distributed on an
  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  KIND, either express or implied.  See the License for the
  specific language governing permissions and limitations
  under the License.
 -->
 <Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd"> 
    
    <!--Uncomment below for derby test-->
	<ConnectionInfo>
		<ConnectionProperties
			driverClass="org.apache.derby.jdbc.EmbeddedDriver"
			databaseURL="jdbc:derby:target/dastest; create = true"
			loginTimeout="600000"/>
	</ConnectionInfo>
	
	<!--Uncomment below for db2 test-->
	<!--<ConnectionInfo dataSource="java:comp/env/jdbc/dastest"
				contextAvailable="false">
		<ConnectionProperties 
			dataSourceClass="COM.ibm.db2.jdbc.DB2DataSource"
			user="amita"
			password="14-174-58-79-82-202-237-108-121-203-238-10-54-180-181-42"
			key="193-155-248-97-234-56-100-241"
			databaseName="DASTEST"
			loginTimeout="600000">
		</ConnectionProperties>
	</ConnectionInfo>-->
		
	<!--Uncomment below for MySQL test-->
	<!--<ConnectionInfo dataSource="java:comp/env/jdbc/dastest"
				contextAvailable="false">
		<ConnectionProperties 
			dataSourceClass="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
			user="root"
			password="192-8-16-141-148-100-119-119"
			key="193-155-248-97-234-56-100-241"
			databaseName="DASTEST"
			loginTimeout="600000">
		</ConnectionProperties>
	</ConnectionInfo>-->
			
    <Command name="AllCustomers" SQL="select * from CUSTOMER" kind="Select"/>

    <Table tableName="CUSTOMER">
        <Column columnName="ID" primaryKey="true"/>
    </Table>
    
	<Command name="NamedCustomers" SQL="{call GETNAMEDCUSTOMERS(?,?)}" kind="procedure">		
		<Parameter direction="IN" index="1" columnType="commonj.sdo.String"/>
        <Parameter direction="OUT" index="2" columnType="commonj.sdo.IntObject"/>
	</Command>
	
</Config>

Regards.
Frank


> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Resolved: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
     [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amita Vadhavkar resolved TUSCANY-1355.
--------------------------------------

    Resolution: Fixed

Based on the last comment from wangful, marking this as resolved.

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>             Fix For: Java-DAS-Next
>
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "lizhantao (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508709 ] 

lizhantao commented on TUSCANY-1355:
------------------------------------

Hi,
yes, I want to call DAS.createCommand(sql)  method to implement a general query method.
I think that DAS is going on a wrong way from my viewpoint.
DAS can't  run on oracle successfully forever .
DAS should be a O-R mapping tool.here 'O' isn't POJO ,just but DataObject.
DAS shouldn't use ResultSetMetaData, but use configuration binding xsd and rdb  tightly like pojo.hbm.xml in hibernate.

Regards, 
lizhantao

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508457 ] 

Amita Vadhavkar commented on TUSCANY-1355:
------------------------------------------

Hi lizhantao , I just want to confirm that by saying "create command dymanically", what you are
trying is DAS.createCommand(sql) from the client. And in that case, yes, there is so far no support
to pass a ResultDescriptor to this command. Only when the Command is specified in Config, this is 
possible. We can surely consider this for the next release as an improvement.  But for the time being,
is it possible to have different commands (all those you intend for dynamic creation) in some Config files
to use with current release?

Regards,
Amita


> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "lizhantao (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508074 ] 

lizhantao commented on TUSCANY-1355:
------------------------------------

I meet this problem too.
I need a better solution than http://incubator.apache.org/tuscany/explicit-resultset-shape-definition.html
because I need  create command dynamicly.

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "Amita Vadhavkar (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12510173 ] 

Amita Vadhavkar commented on TUSCANY-1355:
------------------------------------------

This might be imcompatibility in SDO, not sure, will you please list here all the sdo and das jars
(exact with versions) you are using? 
Also, will you please check using RDB DAS beta1 binary distribution at http://people.apache.org/~lresende/tuscany/das-beta1-distribution/  instead of building it from scratch, please use all the same jars provided in there.

Regards

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "wangful (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12508118 ] 

wangful commented on TUSCANY-1355:
----------------------------------

Hi Adriano,

I have specified the config file as below:
<c:Config xmlns:c="http:///org.apache.tuscany.das.rdb/config.xsd">
	<Command name="AllCustomers" SQL="select * from MYCUSTOMER" kind="Select">
	<ResultDescriptor columnName="ID" tableName="MYCUSTOMER" columnType="commonj.sdo.Long"/>
	<ResultDescriptor columnName="Name" tableName="MYCUSTOMER" columnType="commonj.sdo.String"/>
	</Command>
	
	<Table tableName="MYCUSTOMER">
		<Column columnName="ID" primaryKey="true" />
		<Column columnName="NAME" />
	</Table>
	
</c:Config>

I have to add a prefix for the namespace, or it will not work. I have opened a defect for it.

This time, the orginal problem has been resolved. But 
DataObject root = (DataObject)readStores.executeQuery();  Can't get any rows from the database.

When executing the following statement:
DataObject cus1 = root.getDataObject("MYCUSTOMER[1]"); 

It will raise the following errors:
Exception in thread "main" org.eclipse.emf.common.util.BasicEList$BasicIndexOutOfBoundsException: index=0, size=0
	at org.eclipse.emf.common.util.BasicEList.get(BasicEList.java:512)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.get(DataObjectUtil.java:1959)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2104)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
	at org.apache.tuscany.sdo.impl.DataObjectImpl.getString(DataObjectImpl.java:416)
	at TestDAS.main(TestDAS.java:84)

But actally, there are 2 rows in the table, DAS can't get it.

Thanks for your help.

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org


[jira] Commented: (TUSCANY-1355) DAS-RDB does not support Oracle or SqlServer well

Posted by "Adriano Crestani (JIRA)" <tu...@ws.apache.org>.
    [ https://issues.apache.org/jira/browse/TUSCANY-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12506019 ] 

Adriano Crestani commented on TUSCANY-1355:
-------------------------------------------

Hi, 

DAS supports Oracle, but when on your code you create a DAS not specifying a config file, it, by default, tries to retrieve the tables' metadata using JDBC. However, Oracle JDBC Driver does not provide all metadata necessary to build the graph.

To solve this issue, you should define a resultset descriptor as explained on this page: http://incubator.apache.org/tuscany/explicit-resultset-shape-definition.html

> DAS-RDB does not support Oracle or SqlServer well
> -------------------------------------------------
>
>                 Key: TUSCANY-1355
>                 URL: https://issues.apache.org/jira/browse/TUSCANY-1355
>             Project: Tuscany
>          Issue Type: Bug
>          Components: Java DAS RDB
>    Affects Versions: Java-DAS-M2
>         Environment: DAS-RDB to access the database of Oracle
>            Reporter: wangful
>
> I have used the following simple codes to use DAS to access an Oracle database.
> 		//String url = "jdbc:db2j:D:/RAD6/runtimes/base_v6/cloudscape/DAS";
> 		String url = "jdbc:oracle:thin:wcs/wcs1@//raptor08:1521/g10";
> 		String query = "select * from MYCUSTOMER";
> 		String query_result="";
> 		Connection conn = null;
> 	//	Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> 		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> 		conn = DriverManager.getConnection(url);
> 		conn.setAutoCommit(false);
>                                            DAS das = DAS.FACTORY.createDAS(conn);
> 		Command readStores = das.createCommand(query);
> 		DataObject root = (DataObject)readStores.executeQuery();
> 		DataObject cus1 = root.getDataObject("MYCUSTOMER[1]");
> 		
> 		System.out.println(root.getInt("MYCUSTOMER[1]/ID"));
> 		System.out.println(root.getString("MYCUSTOMER[1]/NAME"));
> It will caused the following error: 
> Exception in thread "main" java.lang.IllegalArgumentException: Class 'DataGraphRoot' does not have a feature named 'MYCUSTOMER'
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getOpenFeature(DataObjectUtil.java:1804)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.getProperty(DataObjectUtil.java:2367)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getProperty(DataObjectImpl.java:1287)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataObjectUtil.java:2054)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUtil.java:2161)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.java:1940)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUtil.java:1860)
> 	at org.apache.tuscany.sdo.util.DataObjectUtil.get(DataObjectUtil.java:744)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.get(DataObjectImpl.java:216)
> 	at org.apache.tuscany.sdo.impl.DataObjectImpl.getDataObject(DataObjectImpl.java:326)
> 	at TestDAS.main(TestDAS.java:47)
> But the same code and same config will work well for  cloudscape database.
> There are also some other problems for Oracle, seems DAS can't work for oracle.
> Will someone look into this problem?
> Thanks.

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


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org