hi,
i'm tryng to use .netTiers with my Oracle server i use this connection string:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=prio;Password=xx;
When I try to generate this error is returned
Error while execution Sql file. System.ArgumentException: The length of the value for key 'data source' exceeds limit of "128".
in System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
in System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
in System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
in System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
in System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
in System.Data.SqlClient.SqlConnection..ctor(String connectionString)
in MoM.Templates.CommonSqlCode.ExecuteSqlInFile(String pathToScriptFile, String connectionString) in c:\Users\riccardo.barbi\Documents\CodeSmith Generator\Samples\v6.0\Templates\Frameworks\NetTiers\TemplateLib\CommonSqlCode.cs:riga 5204
in _CodeSmith.NetTiers_cst.Go() in c:\Users\riccardo.barbi\Documents\CodeSmith Generator\Samples\v6.0\Templates\Frameworks\NetTiers\NetTiers.cst:riga 1914
And no SQL Command for stored procedures is generated
Please help me! tanks!
Hello,
You will need to turn off the property that auto executes the procedures on generation and have to execute the generated procedures manually.
Blake Niemyjski CodeSmith Tools, LLC. Software Development Engineer Blog: http://windowscoding.com/blogs/blake/ .NetTiers team | Visit http://www.nettiers.com
Thanks for your week answer,
But i've already try it.
The file procedures.sql is empty and when i execute it in a project i recive this error:
Is impossible to load the file or assembly 'ContrattiERegistrazioniDb.Data.SqlClient'
why sqlClient and not OracleClient?
tnks a lot
and if I correct the web.config file by replacyng sqlclient to OracleClient is returned this errors:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'PRIMO.REGISTRAZIONE_GET_LIST' must be declared
PL/SQL: Statement ignored
What schema provider did you configure when creating your oracle connection. Did you use the OracleSchemaProvider?
Yes i select oracleschemaprovider and i recive a good respinse by connetton
Test
I took a look and you need to set the ExecuteSql property to false in the templates. Also you need to run the generated procedures located in the ProjectName.SQL\procedures.sql file in SQL Plus or an Oracle IDE
Hi, when i disable ExecuteSql property, the procedures.sql file was empty, and i recive one errors about the XML file...
the errors:
System.Xml.XmlException:XML declaration is unexpected. The XML declaration must be the first node in the document and must not be preceded by white space. Riga 2, posizione 3.
in System.Xml.XmlTextReaderImpl.Throw(Exception e)
in System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
in System.Xml.XmlTextReaderImpl.ParsePI(StringBuilder piInDtdStringBuilder)
in System.Xml.XmlTextReaderImpl.ParseDocumentContent()
in System.Xml.XmlTextReaderImpl.Read()
in System.Xml.XPath.XPathDocument.LoadFromReader(XmlReader reader, XmlSpace space)
in System.Xml.XPath.XPathDocument..ctor(String uri, XmlSpace space)
in System.Xml.XPath.XPathDocument..ctor(String uri)
in _CodeSmith.NetTiers_cst.Go() in c:\Users\x\Documents\CodeSmith Generator\Samples\v6.0\Templates\Frameworks\NetTiers\NetTiers.cst:riga 1884
Generation complete. Execution time: 00:00:13.6153160
You can view current documentation @ http://docs.netTiers.com
Generated solution can be found here:
file:
I've installed on my machine the oracle 11.2g.
That error is being thrown because that generated procedures.xml file doesn't exist or is invalid. Is there any way you could send support a sample oracle schema that can reproduce this as well as your csp file and I'll try reproducing this under my oracle 11.2g vm.
this is my spfile, please keep me updated.
Could you please attach a create script or backup file. The .Ora file (www.fileinfo.com/.../ora) doesn't contain any schema information.
The same problem, please help. I am using Oracle 11g, my procedures.sql is empty,too.
Hey sophie,
Could you attach your csp file, as well as describe how many tables/views/stored procedures you are trying to generate against. I just committed a nightly build yesterday that fixed a bug with Oracle and have a vm set up for testing.
I have 18 tables, no view , and no stored procedure.
Where I can find my csp file?
I have tried your 'nightly builds' (R889) , but the 'procedures.sql ' still empty.
Here is my report.html
You would just need to click on the save button at the top of the property grid to save your settings to a csp.