search

zengcheng / codesmith

Automatically exported from code.google.com/p/codesmith
0 stars 0 forks source link

does this support mysql #588

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently getting:

<Fault xmlns="http://schemas.microsoft.com/ws/2005/05/envelope/none">
<Code>
<Value>Receiver</Value>
<Subcode>
<Value 
xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation
/dispatcher">a:InternalServiceFault</Value>
</Subcode>
</Code>
<Reason>
<Text xml:lang="en-US">
could not execute query [ select bluebook0_.'bookid' as column1_15_, 
bluebook0_.'userid' as column2_15_, bluebook0_.'isPublished' as column3_15_, 
bluebook0_.'isPublic' as column4_15_, bluebook0_.'title' as column5_15_, 
bluebook0_.'description' as column6_15_, bluebook0_.'createdate' as 
column7_15_, bluebook0_.'tags' as column8_15_ from 'blue_books' bluebook0_ ] 
[SQL: select bluebook0_.'bookid' as column1_15_, bluebook0_.'userid' as 
column2_15_, bluebook0_.'isPublished' as column3_15_, bluebook0_.'isPublic' as 
column4_15_, bluebook0_.'title' as column5_15_, bluebook0_.'description' as 
column6_15_, bluebook0_.'createdate' as column7_15_, bluebook0_.'tags' as 
column8_15_ from 'blue_books' bluebook0_]
</Text>
</Reason>
<Detail>
<ExceptionDetail 
xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" 
xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<HelpLink i:nil="true"/>
<InnerException>
<HelpLink i:nil="true"/>
<InnerException i:nil="true"/>
<Message>
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near ''bookid' as column1_15_, 
bluebook0_.'userid' as column2_15_, bluebook0_.'isPubli' at line 1
</Message>
<StackTrace>
at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at 
MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& 
insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, 
Int32& affectedRows, Int32& insertedId) at 
MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at 
MySql.Data.MySqlClient.MySqlDataReader.NextResult() at 
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at 
MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior 
behavior) at 
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at 
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:line 247 at 
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, 
Boolean callable, RowSelection selection, ISessionImplementor session) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1349 at 
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters 
queryParameters, Boolean returnProxies) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 411 at 
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplemen
tor session, QueryParameters queryParameters, Boolean returnProxies) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 243 at 
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters 
queryParameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1694
</StackTrace>
<Type>MySql.Data.MySqlClient.MySqlException</Type>
</InnerException>
<Message>
could not execute query [ select bluebook0_.'bookid' as column1_15_, 
bluebook0_.'userid' as column2_15_, bluebook0_.'isPublished' as column3_15_, 
bluebook0_.'isPublic' as column4_15_, bluebook0_.'title' as column5_15_, 
bluebook0_.'description' as column6_15_, bluebook0_.'createdate' as 
column7_15_, bluebook0_.'tags' as column8_15_ from 'blue_books' bluebook0_ ] 
[SQL: select bluebook0_.'bookid' as column1_15_, bluebook0_.'userid' as 
column2_15_, bluebook0_.'isPublished' as column3_15_, bluebook0_.'isPublic' as 
column4_15_, bluebook0_.'title' as column5_15_, bluebook0_.'description' as 
column6_15_, bluebook0_.'createdate' as column7_15_, bluebook0_.'tags' as 
column8_15_ from 'blue_books' bluebook0_]
</Message>
<StackTrace>
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters 
queryParameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1703 at 
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, 
QueryParameters queryParameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1601 at 
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters 
queryParameters, ISet`1 querySpaces, IType[] resultTypes) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1591 at 
NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, 
QueryParameters queryParameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Hql\Ast\ANTLR\Loader\QueryLoader.cs:li
ne 300 at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor 
session, QueryParameters queryParameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Hql\Ast\ANTLR\QueryTranslatorImpl.cs:l
ine 108 at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters 
queryParameters, ISessionImplementor session, IList results) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Engine\Query\HQLQueryPlan.cs:line 78 
at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, 
QueryParameters queryParameters, IList results) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 645 at 
NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, 
QueryParameters parameters) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\AbstractSessionImpl.cs:line 92 
at NHibernate.Impl.ExpressionQueryImpl.List() in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\ExpressionQueryImpl.cs:line 60 
at NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression 
nhLinqExpression, IQuery query, NhLinqExpression nhQuery) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Linq\NhQueryProvider.cs:line 79 at 
NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression) in 
d:\CSharp\NH\NH\nhibernate\src\NHibernate\Linq\NhQueryProvider.cs:line 103 at 
Remotion.Data.Linq.QueryableBase`1.GetEnumerator() in :line 0 at 
Plinqo.NHibernate.Table`1.GetEnumerator() in 
D:\Code\CodeSmith\Experimental\PLINQO 
NHib\Templates\Source\Plinqo.NHibernate\Tables.cs:line 28 at 
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at 
System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at 
Rain.Service.BlueBooksService.GetAllBooks() in C:\Users\Lani L 
Adamson\RainCloud\Rain.Service\BlueBooksService.cs:line 29 at 
SyncInvokeGetAllBooks(Object , Object[] , Object[] ) at 
System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, 
Object[] inputs, Object[]& outputs) at 
System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& 
rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageR
pc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(Message
Rpc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageR
pc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(Message
Rpc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageR
pc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageR
pc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(Message
Rpc& rpc) at 
System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageR
pc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean 
isOperationContextSet)
</StackTrace>
<Type>NHibernate.Exceptions.GenericADOException</Type>
</ExceptionDetail>
</Detail>
</Fault>

Original issue reported on code.google.com by lladam...@gmail.com on 18 Jun 2011 at 10:52

GoogleCodeExporter commented 9 years ago 
Hello,

Our nHibernate templates support MySQL. Are you using the new PLINQO for 
nHibernate templates? Could you please check the templates against this version 
(http://community.codesmithtools.com/nightly/PLINQONHibernate/)? Also is this 
only happening on this table schema or does this happen as soon as you try 
anything during run time?

Original comment by bniemyjski on 28 Jun 2011 at 3:48