How to insert Spatial data i.e POINT or POLYGON?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

How to insert Spatial data i.e POINT or POLYGON?

Shivananda Shiragavi



I would like to know that, How to write the xml file to insert the Spatial Data?


Currently I am using MySQL database server, Structure of table is as follows:




   ---------- id

   ---------- origin (POINT)

   ---------- name


My xml file is like:


<?xml version="1.0" encoding="UTF-8"?>


      <Table1  id="5" name="ABCD" origin="GeomFromText('POINT(0 0)')" />



When I am running my test case I am getting


org.dbunit.dataset.NoSuchColumnException: Table1.ORIGIN -  (Non-uppercase input column: origin) in ColumnNameToIndexes cache Table1. Note that the Table1's column names are NOT case sensitive.

                at org.dbunit.dataset.AbstractTableMetaData.getColumnIndex(

                at org.dbunit.operation.AbstractOperation.getOperationMetaData(

                at org.dbunit.operation.AbstractBatchOperation.execute(

                at org.dbunit.AbstractDatabaseTester.executeOperation(

                at org.dbunit.AbstractDatabaseTester.onSetup(

                at org.dbunit.DatabaseTestCase.setUp(

                at com.zd.test.TestDBUnit.setUp(

                at junit.framework.TestCase.runBare(

                at junit.framework.TestResult$1.protect(

                at junit.framework.TestResult.runProtected(



                at junit.framework.TestSuite.runTest(





                at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(

                at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(


                at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(


Please Help me out.




Shivananda Shiragavi




DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
dbunit-user mailing list
[hidden email]