Use `LIMIT 1` at the end of the query instead of `TOP 1` (which isn&#39;t valid [sqlite syntax](http://www.sqlite.org/lang_select.html)).

You might also need to remove the `?` in `dueDate &lt; ?1`, but I don&#39;t know sqlite well enough to be sure.

I want the serialized XML output from my Java class to honor the ordering of the properties in the Java class.

It seems that JAXB orders alphabetically.

I can override this by using `@XmlType` with *propOrder* and specifying ALL of the properties, but I have a class with many properties and these are not yet finalized.

I read that specifying an empty *propOrder* would do it but it don&#39;t.

My example class:

	package test;

	import javax.xml.bind.annotation.XmlElement;
	import javax.xml.bind.annotation.XmlRootElement;
	import javax.xml.bind.annotation.XmlType;

	@XmlRootElement
	//@XmlType(propOrder={&quot;company&quot;, &quot;scheme&quot;, &quot;agreementNumber&quot;})
	@XmlType(propOrder={}) // makes no difference - still alphabetical in XML 
	public class CustomerPlan2 {

		private String company;
		private String scheme;
		private String agreementNumber;
	
		@XmlElement(name=&quot;Company&quot;)
		public String getCompany() {
			return company;
		}
		public void setCompany(String company) {
			this.company = company;
		}
	
		@XmlElement(name=&quot;Scheme&quot;)
		public String getScheme() {
			return scheme;
		}
		public void setScheme(String scheme) {
			this.scheme = scheme;
		}
	
		@XmlElement(name=&quot;AgreementNumber&quot;)
		public String getAgreementNumber() {
			return agreementNumber;
		}
		public void setAgreementNumber(String agreementNumber) {
			this.agreementNumber = agreementNumber;
		}
	}

My serialize code:

		CustomerPlan2 cp2 = new CustomerPlan2();
		
		cp2.setCompany(&quot;company&quot;);
		cp2.setScheme(&quot;scheme&quot;);
		cp2.setAgreementNumber(&quot;agreementnumber&quot;);
		JAXBContext context = JAXBContext.newInstance(CustomerPlan2.class);
		Marshaller marshaller = context.createMarshaller();

		marshaller.marshal(cp2, new FileWriter(&quot;C:\\temp\\out.xml&quot;));

Output:
  
		&lt;customerPlan2&gt;
		  &lt;AgreementNumber&gt;agreementnumber&lt;/AgreementNumber&gt; 
		  &lt;Company&gt;company&lt;/Company&gt; 
		  &lt;Scheme&gt;scheme&lt;/Scheme&gt; 
		&lt;/customerPlan2&gt;

I want my output to be (as the property order of my class):

		&lt;customerPlan2&gt;
		  &lt;Company&gt;company&lt;/Company&gt;
		  &lt;Scheme&gt;scheme&lt;/Scheme&gt; 
		  &lt;AgreementNumber&gt;agreementnumber&lt;/AgreementNumber&gt; 
		&lt;/customerPlan2&gt;

Thanks for any help on this.



JAXB and property ordering

Does anyone know if the heap size on Android phones is a constant value according to what is set in the OS version or if this is a setting which the phone producers can decide on?

Is the heap size proportional to the amount of RAM on the phone?

I&#39;ve only found articles where people say that the heap size of an application is 16M. However, these articles are a bit old. From what I see, as an example, heap sizes vary from around 20M up to 24M on one specific model. This phone has 768M of RAM.



Android heap size on different phones/devices and OS versions

I&#39;m trying to use the statement `SELECT TOP 1 * FROM tasks WHERE dueDate &lt; ?1 ORDER BY dueDate DESC` but SQLite says `near &quot;1&quot;: syntax error`. What&#39;s wrong?

SQLite - SELECT TOP syntax error

<p>I'm trying to use the statement <code>SELECT TOP 1 * FROM tasks WHERE dueDate &#x3C; ?1 ORDER BY dueDate DESC</code> but SQLite says <code>near "1": syntax error</code>. What's wrong?</p>


I need to fetch the first/top row of a table in a Sqlite database. 

But my program throws an SQLException &quot;Sqlite Syntax Error: Syntax error near &#39;1&#39; &quot; for the query that I am using:

    SELECT TOP 1 * 
    FROM SAMPLE_TABLE

That I guess is a syntax particularly for MS SQL SERVER and MS ACCESS. Right now I am using.

    SELECT *
    FROM SAMPLE_TABLE
    LIMIT 1

What is the best solution for this problem?

How to get first/top row of the table in Sqlite via Sql Query

 - What is it a BLOB?
 - How can I use it?
 - What are the differences between DBMS&#39;s BLOBs. I would like to save data using BLOBs into any DBMS and then read that BLOB with a library.



What is it exactly a BLOB in a DBMS context

Is there any way to search patterns in strings in C#?

Something like Sql LIKE would be very useful.



C# Version Of SQL LIKE

Lets say I have the table below.


I want to get all the friends, but I want the id 5 to be the first item in the list. I don&#39;t care about the order that I receive the rest of the items.

The desired query result will be:

    friends
    -------

    id    name

    5     nahum
    1     moshe
    2     haim
    3     yusuf
    4     gedalia
    6     dana
 

How can I do this?

using Mysql 5.1.x.

Thanks!

mysql SQL: specific item to be first and then to sort the rest of the items

I need to find out if a function exists in a database, so that I can drop it and create it again. It should basically be something like the following code that I use for stored procedures:


    IF EXISTS (
         SELECT  *
         FROM    dbo.sysobjects
         WHERE   id = OBJECT_ID(N&#39;[dbo].[SP_TEST]&#39;)
                 AND OBJECTPROPERTY(id, N&#39;IsProcedure&#39;) = 1 )


How to check if a function exists in a SQL database?

I&#39;m using the SQLite with Android, and I want to know the best way to get the generated id of the row I inserted.

A solution I think makes a search after include, but it doesn&#39;t look the best way.

Get generated id after insert

I am looking for sample code in which cursor adapter is used with sqlite?

Cursor adapter and sqlite example

I have a table:

    ref,type
    1,red
    2,red
    3,green
    4,blue
    5,black
    6,black

I want the result of a sqlite query to be:

    red,2
    green,1
    blue,1
    black,2

I think the hardest thing to do is find a question to match my problem?  Then I am sure the answer is around the corner....

:)

How can I count how many duplicates there are for each distinct value in sqlite?

I&#39;m just learning to use SQLite and I was curious if such is possible:

1. Encryption of the database file?

2. Password protect opening of the database?


PS. I know that there is this &quot;SQLite Encryption Extension (SEE).&quot;, but according to the documentation, &quot;The SEE is licensed software....&quot; and &quot;The cost of a perpetual source code license for SEE is US $2000.&quot;

Content Type	Original Author	Original Content on Stackoverflow
Question	ryyst	View Question on Stackoverflow
Solution 1 - Sql	moinudin	View Answer on Stackoverflow

SQLite - SELECT TOP syntax error

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Android heap size on different phones/devices and OS versions

JAXB and property ordering

Attributions