Denis,
Take a look at this message, it may help you. Specifically, you need to use
a db2.xml schema in your config/data-base-schemas directory, and refer to
this schema in your data-sources.xml file. I would also test out your
network configuration by using a jdbc client (netbeans, for example
Hello!
Can anyone describe in details a running configuration of the subject?
I try to deploy an application which works on Windows perfectly. But on
Linux Orion sometimes can't start up normally (it seems a deadlock),
sometimes it gives out errors like SQL10007N (DB2) etc.
I think the pr
Hi,
We use DB/2 with this configuration files , and runs OK.
We use the attached db2.xml (See attached file: db2.xml) where we can
tell Orion to use null="default null".
We also need to change the data-sources.xml and add the attribute schema
="database-schemas/db2.xml"
on-interest@orion Subject: JDBC Driver for
DB2/400
Hi ,
I am looking for JDBC driver which can be used in orion server for DB2/400
(i.e for AS/400). I tried to find on web but I was not able to find it. I am
looking for JDBC Driver for DB2 where DB2 is on AS400 and client is Windows
NT/2000. Any Help is appriciated.
Thanks
Ritesh Shah
I am also having great difficulty using the orion-generated finders
(findByXXX) with DB2... and I create the tables myself through the DB2 SQL
tool on NT. I have not found a solution, hopefully we can discover the
problem here!
Josh Motto
-Original Message-
From: [EMAIL PROTECTED
> Does orion really work with DB2 as a datasource? I'm still having
I suppose... but I haven't done much ejb/cmp with it, mostly servlets
and prepared statements.
> trouble with this. The DB won't accept the prepared SQL-statements for
> the finder-queries genereated by o
Hi guys,
I found this really cool bug dealing with Orion Server 1.5.2 and
IBM DB2's JDBC implementation. I don't know if it's
a) me (likely)
b) orion (perhaps)
c) ibm's jdbc implementation (wouldn't doubt it)
I BCC'ed a IBM dude, so for h
Hi,
I'm trying to get the news-example that comes with orion to work on a
linux machine using IBM DB2 (v7.1, Fixpack 4) as a data-source.
Deploying & auto-creating tables work just fine, but invoking the
application in a brwoser with "http://myhost:8080/news/"; results in
that command.
it's all off the top of my head, so verify directories and command
switches.
Of course, it wouldhelp if I understood whatever language the errors are
in, but I figure it's a decent guess ;)
Jeff
Sven Lüdtke wrote:
>
> Hi,
>
> I'm trying to set up orion usin
Hi,
I'm trying to set up orion using DB2 v7.1 as a data-source. The Databese
is running on a Linux-System. Orion can access the database from a
Windows NT System using the JDBC-Drivers provided by IBM.
When I try to setup Orion on the same Linux-machine the DB is running
on, using the
I'm running Orion with a db2 v7.1 database that only allows 5 simultaneous
connections
Sometimes, I get the an error that says: database agent could not be started
to service the request
When I look at my code, I can see that the exception is generated by a
finder method on an entity bean
(c
Hi Elhadi,
silly me must have missed that one. Thanks very much - everythings works
fine now.
Hartmut
-Ursprüngliche Nachricht-
Von: Elhadi barkat [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 18. Januar 2001 11:21
An: Orion-Interest
Betreff: RE: IBM DB2 database schema
take a
I thought I wanted to quickly share my unsubscribe experience so people knew
why the list gets those occassional flames.
First, on orionserver.com, they have a text field to put your email address
and hit either subscribe or unsubscribe. As far as I can tell, the
unsubscribe button actually does
temporarily and see if that helps.
regards
Johan Fredriksson
- Original Message -
From: "Elhadi barkat" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 11:26 AM
Subject: has anyone achieved to configure DB
Hi,
Under stress, one of my beans is causing deadlocks!!
I'm wondering if it is a connection pool problem or not
Does anyone of you configured DBConnectionPool succesfully with DB2
I have a maximum of 5 connections and I'm using this db configuation
file:
take a look at this message
http://www.mail-archive.com/orion-interest@orionserver.com/msg07615.html
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of hartmut wilms
Sent: jeudi, 18. janvier 2001 09:43
To: Orion-Interest
Subject: IBM DB2 database schema
Hello everyone,
has anybody created a DB2 database-schema? I copied oracle.xml and changed
some mappings. But I'm no DB2-dude, so I would really appreciate a working
DB2 schema.
I got some errors when auto-creating tables. Something must be wrong...
On Thu, 7 Dec 2000, Cosmin P wrote:
> I have DB2 ver 7.1 and orion 1.3.8.
>
> Does anyone have an example of a DB2 Database schema?
This is what I cooked up to test DB2. Seems to work ok, except for a
couple of points:
- No JDBC driver for DB2 that I'm aware of supports blob
I have DB2 ver 7.1 and orion 1.3.8.
Does anyone have an example of a DB2 Database
schema?Any advices? Suggestions? I'm a beginer. I run Orion CMP Primer
example with hsql and it's working fine. I need to test it with db2 and
more.
Thanks,
Cosmin
Russ White wrote:
>
> Hey folks,
> I really need an answer to this question because while I would love to use Orion
> I cannot risk moving my 100+ EJBs over to Orion until I can get this resolved. I
> am at a critical descission point here.
>
> The IBM DB2 JDBC drivers
er to Orion until I can get this
>resolved. I
>am at a critical descission point here.
>
>The IBM DB2 JDBC drivers do not allow SetNull(FLOAT). Instead you have to use
>setObject(null). I know this a bug in the JDBC driver, but there are work
>arounds.
>
>Here is how I do it
Hey folks,
I really need an answer to this question because while I would love to use Orion
I cannot risk moving my 100+ EJBs over to Orion until I can get this resolved. I
am at a critical descission point here.
The IBM DB2 JDBC drivers do not allow SetNull(FLOAT). Instead you have to use
I have CMP entity beans that can store null fields. I use DB2 and the DB2 jdbc
driver does not allow setNull(FLOAT) on FLOAT fields, but it does allow
setObject(null) on a FLOAT field. Which way does Orion do this? Is it
configurable? Can I implement my own JDBC accessor class for CMP?
I am
Has anyone got DB2 working with Orion ??
Depoloying an application with a DB2 DS under jdk1.2.2 causes a crash in
java.exe. Under 1.3 causes orion to crash:
java.lang.NoSuchFieldError: rsType
at COM.ibm.db2.jdbc.app.DB2Statement.SQLAllocStmt
What's wrong here?
Does anyone have an example
Hi There,
We've choosen IBM DB2 as a database server and Linux RedHat 6.2
and we're actually searching for an application server...
Have you experienced DB2 with Orionserver?
Thanks for any information
Have a nice day
H.
___
I have a problem with the auto-create-table feature of
Orion 1.0 and IBM DB2 7.1 Personal Edition on a Suse-Linux-Box.
Auto-deploying ic-ejb...
Auto-creating table: create table Event (id BIGINT not null primary key,
ort VARCHAR(255) null, titel VARCHAR(255) null)
Warning: Error creating
rion-Interest <[EMAIL PROTECTED]>
Kopie:
Thema:RE: Can't deploy example "atm" with datasource "db2"
> In the database-schemes the "type" is the Java-Class and the "name" is
the
> Column-Type in the database.
> So the entry for name should
> In the database-schemes the "type" is the Java-Class and the "name" is the
> Column-Type in the database.
> So the entry for name should be name="long varchar", but what is the entry
> for type ?
java.io.Serializable
-Joe Walnes
Hi Esa, Hi Joe !
Thank you for the quick reponse, but my question was not so exactly. Sorry.
I know database-schemes. The field "value" is generated for the serialized
"LogEntryBeans" from orion.
In the database-schemes the "type" is the Java-Class and the "name" is the
Column-Type in the datab
> How can I change the type-mapping from longvarbinary to
> longvarchar for the LogEntries ?
If you look in [orion-dir]/config/database-schemas you will find a bunch of
xml files with type-mappings for various databases. Copy one of these files
to db2.xml and edit it to reflect the appro
og (id varchar (255) not null,
value longvarbinary)
Warning: Error creating table: [IBM][CLI Driver][DB2/NT] SQL0204N "LONGVARBINARY" ist
ein nicht definierter Name. SQLSTATE=42704
done.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
How can I change the type-mapping from longvarbinary to longvarchar for the LogEntries
?
Matthias
32 matches
Mail list logo
