Re: Problem inserting

2013-04-17 Thread Dyre Tjeldvoll
On 04/16/13 01:46 PM, Alejandro Rodríguez González wrote: Basically, I insert using this code: public void insertInputs(SetInput ri) throws Exception { PreparedStatement psInsert = null; IteratorInput it = ri.iterator(); while

Re: Problem inserting

2013-04-17 Thread Alejandro Rodríguez González
Thanks Dyre! I will check all that you told me and see if I can fix the problem! Cheers On 17 April 2013 10:07, Dyre Tjeldvoll dyre.tjeldv...@oracle.com wrote: On 04/16/13 01:46 PM, Alejandro Rodríguez González wrote: Basically, I insert using this code: public void

Problem inserting

2013-04-16 Thread Alejandro Rodríguez González
Hello all, I've a problem with a very fool piece of code, but, I don't know why is not working. The thing is that I want to get some data from a SPARQL endpoint, and add it to the database. The idea is that the data from the endpoint can be updated from time to tome, so, I use set theory to see

Re: Problem inserting

2013-04-16 Thread John English
On 16/04/2013 14:46, Alejandro Rodríguez González wrote: Basically, I insert using this code: public void insertInputs(SetInput ri) throws Exception { [...snip...] Don't know if it's relevant, but have you checked what ri contains on entry? I had a stupid bug once along these

Re: Problem inserting

2013-04-16 Thread Alejandro Rodríguez González
Hi! Thanks John, I will take a look tomorrow to the code to see if this is the problem. Thanks! On 16 April 2013 19:36, John English john.fore...@gmail.com wrote: On 16/04/2013 14:46, Alejandro Rodríguez González wrote: Basically, I insert using this code: public void

RE: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-06 Thread Mamatha Kodigehalli Venkatesh
Message- From: Mamta Satoor [mailto:msat...@gmail.com] Sent: Wednesday, October 06, 2010 2:45 AM To: Derby Discussion Subject: Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0 Hi Mamatha, Like Lily mentioned, it will be very helpful to have a setup script

Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-06 Thread Kathey Marsden
On 10/6/2010 12:07 AM, Mamatha Kodigehalli Venkatesh wrote: Hello all, Below is the ddl for the table that I created using 10.5.3. When arecord is inserted into tidlrblt table trigger- gls_blt_trg will push a corresponding record into tidlggls table snip DDL Hi Mamatha, I am able to

Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-05 Thread Mamatha Kodigehalli Venkatesh
[mailto:kristian.waa...@oracle.com] Sent: Monday, October 04, 2010 3:48 PM To: Derby Discussion Cc: Mamatha Kodigehalli Venkatesh; avinash.b...@nsn.com Subject: Re: Problem inserting a record with derby 10.6.1.0 On 01.10.10 09:44, Mamatha Kodigehalli Venkatesh wrote: Hello all, I too upgraded

Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-05 Thread Lily Wei
: Tue, October 5, 2010 5:50:11 AM Subject: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0 Hello all, Currently I have my tables with data that was created using 10.5.3 version. Where I was able to perform all operations like select ,insert, update successfully. Now I

Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-05 Thread Lily Wei
from 10.5.3 - Problem inserting a record with derby 10.6.1.0 Hi Mamath: Before you do upgrade=true, were you doing a softupgrade? I just try upgrade from 10.5 to 10.6.2.1(the release candidate) with softupgrade. I did not see the Exception with my try. This is what I did: On 10.5

Re: Upgrade issue from 10.5.3 - Problem inserting a record with derby 10.6.1.0

2010-10-05 Thread Mamta Satoor
in 10.5? Do you have the definition of those trigger? i.e. the SQL statement. Thanks, Lily From: Lily Wei lily...@yahoo.com To: derby-user@db.apache.org Sent: Tue, October 5, 2010 10:16:54 AM Subject: Re: Upgrade issue from 10.5.3 - Problem inserting a record

Re: Problem inserting a record with derby 10.6.1.0

2010-10-04 Thread Kristian Waagan
On 01.10.10 09:44, Mamatha Kodigehalli Venkatesh wrote: Hello all, I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below exception When I tried to insert a record into the table using a prepared statement. java.sql.SQLException: Java exception:

Re: Problem inserting a record with derby 10.6.1.0

2010-10-04 Thread Kristian Waagan
: Problem inserting a record with derby 10.6.1.0 Hello all, I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below exception When I tried to insert a record into the table using a prepared statement. java.sql.SQLException: Java exception: 'org.apache.derby.iapi.sql.execute.Result

RE: Problem inserting a record with derby 10.6.1.0

2010-10-01 Thread Mamatha Kodigehalli Venkatesh
Hello all, I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below exception When I tried to insert a record into the table using a prepared statement. java.sql.SQLException: Java exception: 'org.apache.derby.iapi.sql.execute.Result

RE: Problem inserting a record with derby 10.6.1.0

2010-10-01 Thread Bhat, Avinash (NSN - IN/Bangalore)
...@db.apache.org; derby-user-...@db.apache.org Cc: Bhat, Avinash (NSN - IN/Bangalore); kristian.waa...@oracle.com; lily...@yahoo.com Subject: RE: Problem inserting a record with derby 10.6.1.0 Hello all, I too upgraded derby from 10.5.3.0 to 10.6.1.0, I am getting below exception When I tried to insert

Re: Problem Inserting Swedish Characters in Derby Database

2010-07-28 Thread Mark D. Johnson
Hi Kristian - Thank you for your help. Your suggestion was correct. After some Googling I found this page: http://illegalargumentexception.blogspot.com/2009/04/i18n-unicode-at-windows-command-prompt.html#charsets_pound which explains the problem I had. It turns out that the Windows command

Re: Problem Inserting Swedish Characters in Derby Database

2010-07-24 Thread Mark D. Johnson
Sorry, I forgot to mention this is with Derby 10.6.1.0 and JDK 1.6.0 update 20 on Windows 7 Professional 64-bit. Mark Johnson On 7/23/2010 10:35 PM, Mark D. Johnson wrote: Hi - I have run into a problem trying to insert the Swedish vowels Å, Ä and Ö into Varchar fields in a Derby

Problem Inserting Swedish Characters in Derby Database

2010-07-23 Thread Mark D. Johnson
Hi - I have run into a problem trying to insert the Swedish vowels Å, Ä and Ö into Varchar fields in a Derby database. I first noticed a problem with the capital Å using ij to do the insert. When I did a select on the field, the character Å was shown as a question mark. This is the only