SingleTon

May 9, 2008

I would like to know if a singleton Stored Procedures can be created in SQLCLR

Singleton Query With Same Results

Mar 8, 2008

hello friends..

i have the follow dmx query

SELECT FLATTENED

Predict([Sale],5) AS Suggestions

FROM [Ticket_Model]

NATURAL PREDICTION JOIN

(SELECT (SELECT '32135' AS [Product Id]) AS [Sale]) AS NewSale

Strange but if a change the Product Id for new suggestions i always get same results..

Using Dependency Network i see right results..

I know there is a way to filter null match or itemsets with no probability.

Any help?

Best

Robson

View 1 Replies View Related

Unspecified Error -2147467259 Using Singleton Pattern

Dec 5, 2007

Hello, we've developed an application that runs on AXIM X51, if it is an important to know.

The data layer handles the connection using the singleton pattern, a bit of code of this is:

(....)
Private Shared ceConnection As SqlCeConnection
(....)

Public Shared Function GetConnection() As SqlCeConnection
Try
If (ceConnection Is Nothing) Then
ceConnection = New SqlCeConnection(Me.connectionString)
End If

If (ceConnection.State = ConnectionState.Closed) Then
ceConnection.Open()
End If

Return ceConnection
Catch ex As Exception
Throw ex
End Try
End Function

(....)

So far nothing strange. We started experiencing problems when the end-users get an "Unspecified error" which later debugging it we got the href value inside the exception object is -2147467259 and nothing else. And if that wasn't enough I couldn't replicate the error in my pocket.

The only way I got the same error was removing the SD Card where the db is located at the same time the application was still open.

Does anybody experienced the same problem??? I researched about this kind of errors "when the device is just restored from the suspend mode" but with out luck.

Please, I really appreciate any help with this issue. Any comment will be more than welcome.

View 3 Replies View Related