I am 99.99% sure that this is a privilege issue.
Does the user executing the procedure own it, or is it in another schema?
Larry
On 3/20/07, Hendry [EMAIL PROTECTED] wrote:
Just tried it, and it still produce the same error.
Regards,
Hendry
Clinton Begin wrote:
Try specifying the owning
Abator only uses the catalog and schema in the file names if you specify
them in your configuration. I don't know Postgres, but with SQL Server you
can leave the catalog out of the table configuration elements and specify
the default database name on the connection URL.
Jeff Butler
On
Larry,
Thanks for the response. I'll have a look at the example you have
suggested. I am using a date jdbc type for the date field as I only
need dates in the form -MM-dd rather than the extended datetime
format.
Here are some more interesting things to think about:
1) I can successfully
I use Postgres with Abator and don't have the db name in the
$TABLE_SqlMap.xml file names. Here's what one of my table elements
looks like:
table schema= tableName=SUGGESTION
domainObjectName=Suggestion
property name=useActualColumnNames value=false/
/table
The schema is then
Hi
It is a German Language character umlaut
here is more information about it
http://en.wikipedia.org/wiki/Germanic_umlaut
I try to change the database driver encoding, i am using DB2 on As400 as
database, and see if it works.
But the feature in ibatis to change encoding on DOM builder will be
On Mar 20, 2007, at 9:47 AM, Chris Lamey wrote:
I use Postgres with Abator and don't have the db name in the
$TABLE_SqlMap.xml file names. Here's what one of my table elements
looks like:
table schema= tableName=SUGGESTION
domainObjectName=Suggestion
property
The column is a DATE. I tried changing this to a DATETIME but the same
error occurred. Interestingly - I have other tables with a DATETIME
that work fine.
The only difference to take into account though is that all the datetime
columns are system generated where as the date field that is throwing
On Tue, 2007-03-20 at 10:06 -0500, Mark Volkmann wrote:
Postgres has a notion of a search path that is a list of schemas
that are searched to find databases.
I think I need to add my schema to the search path, but I don't know
how to do that.
Any ideas?
It's been a while since I used
On Mar 20, 2007, at 10:06 AM, Mark Volkmann wrote:
Postgres has a notion of a search path that is a list of schemas
that are searched to find databases.
I think I need to add my schema to the search path, but I don't
know how to do that.
Any ideas?
I'm making progress. I have some code
The issue is that you're specifying a postgres driver as a JBoss-wide
JNDI resource but the postgres jar isn't in the JBoss classpath.
Putting the jar in a war won't do because the JNDI resource is shared
among all apps.
You'll need to put it either in the server's lib dir or the top level
lib
Abator generates this in an SqlMap.xml file.
insert id=abatorgenerated_insert
parameterClass=com.savealot.xademo.model.Address
!--
WARNING - This element is automatically generated by Abator
for iBATIS, do not modify.
This element was generated on Tue Mar 20 11:15:50 CDT
On Tue, 20 Mar 2007, [EMAIL PROTECTED] wrote:
The only difference to take into account though is that all the datetime
columns are system generated where as the date field that is throwing
read errors has orginated from a form field. This field is correctly
inserted into the database but then
Hi Graeme,
From your earlier posts:
1. Local server, local DB works
2. Local server, remote DB works.
3. Remote server, remote DB fails.
- correct.
Without actually seeing the log/stacktrace, I wondering whether
1. It's the conversion from the DB to DATE or
2. Some parsing you're doing
Nope, the user owns it, and it is in the same schema. I've also tried
calling it using plain jdbc connection, and it works.
Regards,
Hendry
Larry Meadors wrote:
I am 99.99% sure that this is a privilege issue.
Does the user executing the procedure own it, or is it in another schema?
Larry
14 matches
Mail list logo