Thanks for the help, and sorry for the noise.
Randy Shoup wrote:
Thanks for the response.
The code in my LdapLoginModule is the same as the code I submitted as a patch to JBoss (to support using LDAP to get user/role information from Active Directory users/groups), and so I extend the JBoss UsernamePasswordLoginModule as the JBoss LdapLoginModule does.
Your response implies that I should expect 'unauthenticatedIdentity' to do what I want, though. So I will take a look to see if there is anything I have done to screw that up.
Scott M Stark wrote:
From: "Scott M Stark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: [JBoss-user] MBeans, local EJBs and Authentication
Date: Tue, 17 Dec 2002 15:33:45 -0800
Organization: JBoss Group, LLC
Reply-To: [EMAIL PROTECTED]
You are using your own LdapLoginModule. How is this recognizing
the unauthenticatedIdentity you are configuring? Its your login module
that has to support this.
xxxxxxxxxxxxxxxxxxxxxxxx
Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
----- Original Message ----- From: "Randy Shoup" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 16, 2002 3:22 PM
Subject: [JBoss-user] MBeans, local EJBs and Authentication
JBoss gurus --
I am using JBoss 3.0.4 - Tomcat 4.1.12 on Win2K. I want to get unauthenticated access to a local SLSB from an MBean, while still requiring authenticated access to my remote EJBs.
I am trying to add to my application a scheduled "batch" operation which does some periodic cleanup. The scheduling part was straightforward to set up, thanks to the docs and the list. However, I am having some trouble with the authentication part.
All of my remote session facades require authentication, with user/role information in an LDAP. The scheduled operation is a "system" operation, though, and so I would like to avoid requiring it to do any explicit authentication. I don't, for example, want to put a "system" or "internal" entry in the LDAP, which is intended to be just for real users. And I would like to avoid hard-coding any password anywhere.
I have done the following:
+ created a local SLSB which does the real work
+ added a scheduler MBean, which periodically calls the local SLSB
+ added an 'unauthenticatedIdentity' entry in the login-config.xml:
<application-policy name = "ime_ejb">
<authentication>
<login-module code = "com.tumbleweed.ime.ejb.security.jboss3.LdapLoginModule"
flag = "required">
...
<module-option name="unauthenticatedIdentity">system</module-option>
</login-module>
</authentication>
</application-policy>
15:05:43,446 ERROR [SecurityInterceptor] Authentication exception, principal=null
15:05:43,446 ERROR [LogInterceptor] EJBException, causedBy:
java.lang.SecurityException: Authentication exception, principal=null at org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java:173)
--__--__-- Message: 4 Date: Tue, 17 Dec 2002 18:55:57 -0500 (EST) From: Brett Sealey <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Using Apache web server - yes or no? Reply-To: [EMAIL PROTECTED] http://jetty.mortbay.com/jetty/doc/User80.html You want packet filtering anyway if you are security conscious. On Tue, 17 Dec 2002, Dan Christopherson wrote:Another thing to remember is that JBoss must run as root to listen on port 80 or 443. That would be something that security conscious people might not want to do on a public server.
-danch
Larry O wrote:
I would suggest another criteria. If your application is on an intranet
or private network and traffic is low, by all means omit apache.
However, many of us put apache on or outside a firewall, and keep our
application server safely inside. The fewer services running on the
exposed server, the better.
My 2 cents.
Larry
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Pete Beck
Sent: Tuesday, December 17, 2002 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Using Apache web server - yes or no?
Just to throw my 2 cents worth in,
My app uses mostly dynamic content and I have tried using apache as a
front end, tomcat 4 and Jetty.
In my tests, using apache as a front end added a significant latency to
serving the content from JBoss.
So I would say yes, you may get benefits on your static content if you
use apache, but you will also lose performance on your dynamic content.
In my app I dropped apache as a front end as I was getting noticeably
better performance with tomcat standalone.
Eventually I switched to using to Jetty as it is shipped by default with
JBoss now, and it seems snappier than tomcat.
A good deciding factor therefore seems to be the ratio of static vs.
dynamic content on your site.
On Tue, 2002-12-10 at 14:18, Joao Pedro Clemente wrote:
Andreas, please explain a little bit better where will we get more performance. I can be (and surely am) wrong in my reasoning, but the original message says explicitly "ONLY dynamic applications". So, you say apache should be used to serve images/html... as far as I know, that is static content. So, if you have NO static content, what will apache improve?
Regards,
Joao Clemente
-------------------------------------------------------
This sf.net email is sponsored by:
With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
--__--__-- Message: 5 Date: Wed, 18 Dec 2002 00:04:33 +0000 From: =?ISO-8859-1?B?Sm/jbw==?= Clemente <[EMAIL PROTECTED]> Subject: Re: [JBoss-user] Using Apache web server - yes or no? To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] On Tue, 17 Dec 2002 16:26:20 -0600 Dan Christopherson <[EMAIL PROTECTED]> wrote:Another thing to remember is that JBoss must run as root to listen =on=20port 80 or 443. That would be something that security conscious peo=ple=20might not want to do on a public server.
About that particular issue, what's the problem with setting port for=
warding (or whatever it's named)
=66rom 80 -> 8080 and from 443 -> whatever ?!?
That would enable to use jboss as a normal user.
(Think as this as a generic administration/security question, and not=
JBoss specific. I'm wondering what is the problem of this solution f=
or the issue of running whatever software as root.)
--=20
Jo=E3o Pedro Clemente - jpcl (at) rnl ist utl pt
" Why can't women put the toilet seat back up? "
--__--__--
Message: 6
From: "Joe Hung" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Tue, 17 Dec 2002 17:29:38 -0800
Subject: [JBoss-user] Fastest (and stable) way to turn existing EJBs into Web
Services?
Reply-To: [EMAIL PROTECTED]
...if I want to achieve it within the next 2 months?
1) Use JBoss with Axis (what version?)
2) Use JBoss.net (what version?)
3) Use 3rd party tools like GLUE.
Really needs the answer...anybody out there with web service deployment
experience?
Thanks in advance.
-joe
--__--__--
Message: 7
Date: Tue, 17 Dec 2002 17:45:01 -0800
Subject: Re: [JBoss-user] Fastest (and stable) way to turn existing EJBs into Web Services?
From: Matthew Hixson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
There were some guys at a SeaJUG meeting a while back from someplace that did this. For some reason the name Silverstream is coming to mind. If that's the right name it looks like they've been assimilated by Novell.
http://www.silverstream.com/Website/app/en_US/Home
-M@
On Tuesday, December 17, 2002, at 05:29 PM, Joe Hung wrote:
...if I want to achieve it within the next 2 months? 1) Use JBoss with Axis (what version?) 2) Use JBoss.net (what version?) 3) Use 3rd party tools like GLUE. Really needs the answer...anybody out there with web service deployment experience? Thanks in advance. -joe ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
--__--__--
Message: 8
From: "Joe Hung" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: [JBoss-user] Internationalization of EJB data
Date: Tue, 17 Dec 2002 18:04:06 -0800
Reply-To: [EMAIL PROTECTED]
there are several aspects of i18n. Java already makes it easy by doing utf8
internally. the problem usually is when you serialize the (utf8) data into
the DB and getting it out of DB. (and of course linguistic sorting).
if your db support utf-8 varchar (like an oracle) things might be easier.
otherwise you might have to do utf-8 serialization to/from your db (BMP) or
tweak the CMP mapping (CMP).
-joe
-----Original Message-----
From: Jordan Thomas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Internationalization of EJB data
Hi,
What is the best way to internationalize my entity bean data. My initial way
was to use a compound primary key but JBoss doesn't seem to like this. Is
there a "standard" or popular pattern for doing this? Any good articles?
thanks
Jordan
-------------------------------------------------------
This sf.net email is sponsored by:
With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel
http://hpc.devchannel.org/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
--__--__--
Message: 9
Date: Tue, 17 Dec 2002 21:22:23 -0500
From: Dave Smith <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Using Apache web server - yes or no?
Reply-To: [EMAIL PROTECTED]
Linux ..
echo 1 > /proc/sys/net/ipv4/ip_forward
ipchains -A input -p tcp -d 0.0.0.0/0 443 -j REDIRECT 8443
ipchains -A input -p tcp -d 0.0.0.0/0 80 -j REDIRECT 8080
Jo=E3o Clemente wrote:
On Tue, 17 Dec 2002 16:26:20 -0600 Dan Christopherson <[EMAIL PROTECTED]> wrote: =20Another thing to remember is that JBoss must run as root to listen on=20About that particular issue, what's the problem with setting port forwar=
port 80 or 443. That would be something that security conscious people=20
might not want to do on a public server.
=20
ding (or whatever it's named)from 80 -> 8080 and from 443 -> whatever ?!?That would enable to use jboss as a normal user.
(Think as this as a generic administration/security question, and not JB=
oss specific. I'm wondering what is the problem of this solution for the =
issue of running whatever software as root.)
=20
--__--__--
Message: 10
Date: Wed, 18 Dec 2002 11:33:34 +0800
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [JBoss-user] error in using pgsql 7.2
Reply-To: [EMAIL PROTECTED]
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2A646.3E299620
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
My version of JBoss is 3.0.2 running in Mandrake 8.2 . My steps are =
described below.Could somebody help me identify the error?Thanks very =
much.
=20
1. copy postgres-service.xml to $JBOSS_HOME/server/default/deploy
2. add a login module configuration as below to login-config.xml
=20
<application-policy name =3D "PostgresDbRealm">
<authentication>
<login-module code =3D =
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag =3D =
"required">
<module-option name =3D =
"principal">postgres</module-option>
<module-option name =3D "userName">postgres</module-option>
<module-option name =3D "password"></module-option>
<module-option name =3D =
"managedConnectionFactoryName">jboss.jca:service=3DLocalTxCM,name=3DPostg=
resDS</module-option>
</login-module>
</authentication>
</application-policy>
=20
3. copy my sample jar file to $JBOSS_HOME/server/default/deploy with =
jbosscmp-jdbc.xml modified as
<defaults>
<datasource>java:/DefaultDS</datasource>
<!-- datasource-mapping>Hypersonic SQL</datasource-mapping -->
<datasource-mapping>PostgreSQL 7.2</datasource-mapping>
<create-table>true</create-table>
<remove-table>true</remove-table>
</defaults>
=20
4. get the following error.(It works fine if I use the Hypersonic =
SQL).I've also tried the create table statement in my postgreSQL and it =
works ok.
=20
09:27:04,585 INFO [MainDeployer] Starting deployment of package: =
file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar
09:27:04,648 INFO [EjbModule] Creating
09:27:04,667 INFO [EjbModule] Deploying CustomerEJB
09:27:04,694 INFO [EjbModule] Created
09:27:04,695 INFO [EjbModule] Starting
09:27:04,876 WARN [ServiceController] Problem starting service =
jboss.j2ee:service=3DEJB,jndiName=3DCustomerHomeRemote
org.jboss.deployment.DeploymentException: Error while creating table; - =
nested throwable: (java.sql.SQLException: Wrong data type: INT4 in =
statement [CREATE TABLE CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT, =
FIRST_NAME TEXT, HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT =
PK_CUSTOMER PRIMARY KEY (ID))])
at =
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartComm=
and.java:175)
at =
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.=
java:84)
at =
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCSto=
reManager.java:457)
at =
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.ja=
va:369)
at =
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.j=
ava:198)
at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
at org.jboss.ejb.Container.invoke(Container.java:764)
at =
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
at =
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at =
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.=
java:967)
at $Proxy5.start(Unknown Source)
at =
org.jboss.system.ServiceController.start(ServiceController.java:396) =
=20
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at =
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)
at =
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
=20
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy71.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
at =
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at =
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)
at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at =
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)
at =
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
=20
at =
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.=
java:967)
at $Proxy5.start(Unknown Source)
at =
org.jboss.system.ServiceController.start(ServiceController.java:396) =
=20
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at =
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)
at =
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
=20
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy9.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
at =
org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
at =
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
at =
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at =
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)
at =
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
=20
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy4.deploy(Unknown Source)
at =
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentSca=
nner.java:427)
at =
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScann=
er.java:553)
at =
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doSc=
an(AbstractDeploymentScanner.java:212)
at =
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop=
(AbstractDeploymentScanner.java:225)
at =
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(=
AbstractDeploymentScanner.java:202)
Caused by: java.sql.SQLException: Wrong data type: INT4 in statement =
[CREATE TABLE CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT, FIRST_NAME =
TEXT, HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY =
KEY (ID))]
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Result.<init>(Result.java:175)
at =
org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
at =
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalS=
tatement.java:231)
at =
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartComm=
and.java:166)
... 52 more
09:27:04,888 INFO [EjbModule] Started
09:27:04,888 INFO [MainDeployer] Deployed package: =
file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar
09:27:04,891 ERROR [URLDeploymentScanner] MBeanException: Exception in =
MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
<none>
Incompletely deployed packages:
<none>
MBeans waiting for classes:
<none>
MBeans waiting for other MBeans:
[ObjectName: =
jboss.j2ee:service=3DEJB,jndiName=3DCustomerHomeRemote
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error =
while creating table; - nested throwable: (java.sql.SQLException: Wrong =
data type: INT4 in statement [CREATE TABLE CUSTOMER (ID INT4 NOT NULL, =
LAST_NAME TEXT, FIRST_NAME TEXT,
HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY =
KEY (ID))])]=20
------_=_NextPart_001_01C2A646.3E299620
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dgb2312">
<TITLE>=C8=FC=B0=D9=CD=FE=B5=DA77=C6=DA=B3=C9=B9=A6=B5=C4=CF=EE=C4=BF=B9=DC=
=C0=ED=BC=AF=D1=B5</TITLE>
<BASE=20
href=3Dhttp://www.cyberway-canada.com/pminew/INDEX.HTM>
<META http-equiv=3DContent-Language content=3Dzh-cn>
<META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR>
<META content=3DFrontPage.Editor.Document name=3DProgId>
<SCRIPT language=3DJavaScript type=3Dtext/JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init=3D=3Dtrue) with (navigator) {if =
((appName=3D=3D"Netscape")&&(parseInt(appVersion)=3D=3D4)) {
document.MM_pgW=3DinnerWidth; document.MM_pgH=3DinnerHeight; =
onresize=3DMM_reloadPage; }}
else if (innerWidth!=3Ddocument.MM_pgW || =
innerHeight!=3Ddocument.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</SCRIPT>
</HEAD>
<BODY topMargin=3D0>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w><FONT color=3D#0000ff><FONT =
size=3D2><SPAN=20
class=3D505023203-18122002>My version of JBoss is 3.0.2 running in =
Mandrake=20
8.2 . My steps are described below.Could somebody help me identify =
the=20
error?Thanks very much.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w><FONT =
color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D505023203-18122002> </SPAN></FONT></FONT></FONT></FONT></FON=
T></DIV>
<DIV><FONT><FONT><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w><FONT =
color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D505023203-18122002> </SPAN>1. copy postgres-service.xml to=20
$JBOSS_HOME/server/default/deploy<BR><SPAN=20
class=3D505023203-18122002> </SPAN>2. add a login module =
configuration as=20
below to login-config.xml</FONT></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff =
size=3D2> =20
<application-policy name =3D=20
"PostgresDbRealm"><BR> =20
<authentication><BR>  =
; =20
<login-module code =3D=20
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag =3D=20
"required"><BR> &=
nbsp; =20
<module-option name =3D=20
"principal">postgres</module-option><BR> =
=20
<module-option name =3D=20
"userName">postgres</module-option><BR> &=
nbsp; =20
<module-option name =3D=20
"password"></module-option><BR> &nb=
sp; =20
<module-option name =3D=20
"managedConnectionFactoryName">jboss.jca:service=3DLocalTxCM,name=3DPo=
stgresDS</module-option><BR> &nb=
sp; =20
</login-module><BR> =20
</authentication><BR> =20
</application-policy></FONT></DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff size=3D2>3. =
copy my sample jar file to=20
$JBOSS_HOME/server/default/deploy with jbosscmp-jdbc.xml modified=20
as<BR> <defaults><BR> =20
<datasource>java:/DefaultDS</datasource><BR>  =
; =20
<!-- datasource-mapping>Hypersonic SQL</datasource-mapping=20
--><BR> =
<datasource-mapping>PostgreSQL=20
7.2</datasource-mapping><BR> =20
<create-table>true</create-table><BR> =
=20
<remove-table>true</remove-table><BR> =20
</defaults><BR> <BR>4. get the following error.(It =
works fine=20
if I use the Hypersonic SQL).I've also tried the create table statement =
in my=20
postgreSQL and it works ok.</FONT></DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D=D0=C2=BC=9A=C3=F7=F3w color=3D#0000ff =
size=3D2>09:27:04,585 INFO [MainDeployer]=20
Starting deployment of package:=20
file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar<BR>09:27=
:04,648=20
INFO [EjbModule] Creating<BR>09:27:04,667 INFO [EjbModule] =
Deploying=20
CustomerEJB<BR>09:27:04,694 INFO [EjbModule] =
Created<BR>09:27:04,695=20
INFO [EjbModule] Starting<BR>09:27:04,876 WARN =
[ServiceController]=20
Problem starting service=20
jboss.j2ee:service=3DEJB,jndiName=3DCustomerHomeRemote<BR>org.jboss.deplo=
yment.DeploymentException:=20
Error while creating table; - nested throwable: (java.sql.SQLException: =
Wrong=20
data type: INT4 in statement [CREATE TABLE CUSTOMER (ID INT4 NOT NULL, =
LAST_NAME=20
TEXT, FIRST_NAME TEXT, HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT =
PK_CUSTOMER=20
PRIMARY KEY (ID))])<BR> at=20
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartComm=
and.java:175)<BR> =20
at=20
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.=
java:84)<BR> =20
at=20
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCSto=
reManager.java:457)<BR> =20
at=20
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.ja=
va:369)<BR> =20
at=20
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.j=
ava:198)<BR> =20
at=20
org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)<BR> &n=
bsp; =20
at=20
org.jboss.ejb.Container.invoke(Container.java:764)<BR> &=
nbsp; =20
at=20
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)<BR> =
=20
at=20
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)<BR>&=
nbsp; =20
at=20
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.=
java:967)<BR> =20
at $Proxy5.start(Unknown =
Source)<BR> =20
at=20
org.jboss.system.ServiceController.start(ServiceController.java:396) =
; =20
<BR> at=20
sun.reflect.GeneratedMethodAccessor7.invoke(Unknown=20
Source)<BR> at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<BR> =20
at=20
java.lang.reflect.Method.invoke(Method.java:324)<BR> &nb=
sp; =20
at=20
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)<BR> =20
at=20
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
; =20
<BR> at=20
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)<BR> =
=20
at $Proxy71.start(Unknown =
Source)<BR> =20
at=20
org.jboss.ejb.EjbModule.startService(EjbModule.java:430)<BR> &=
nbsp; =20
at=20
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)<=
BR> =20
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native=20
Method)<BR> at=20
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)<BR> =20
at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<BR> =20
at=20
java.lang.reflect.Method.invoke(Method.java:324)<BR> &nb=
sp; =20
at=20
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)<BR> =20
at=20
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
; =20
<BR> at=20
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.=
java:967)<BR> =20
at $Proxy5.start(Unknown =
Source)<BR> =20
at=20
org.jboss.system.ServiceController.start(ServiceController.java:396) =
; =20
<BR> at=20
sun.reflect.GeneratedMethodAccessor7.invoke(Unknown=20
Source)<BR> at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<BR> =20
at=20
java.lang.reflect.Method.invoke(Method.java:324)<BR> &nb=
sp; =20
at=20
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)<BR> =20
at=20
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
; =20
<BR> at=20
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)<BR> =
=20
at $Proxy9.start(Unknown =
Source)<BR> =20
at=20
org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)<BR> &nbs=
p; =20
at=20
org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)<BR> &=
nbsp; =20
at=20
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)<BR> =
=20
at=20
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)<BR> =
=20
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown=20
Source)<BR> at=20
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<BR> =20
at=20
java.lang.reflect.Method.invoke(Method.java:324)<BR> &nb=
sp; =20
at=20
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDis=
patcher.java:284)<BR> =20
at=20
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) =
; =20
<BR> at=20
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)<BR> =
=20
at $Proxy4.deploy(Unknown =
Source)<BR> =20
at=20
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentSca=
nner.java:427)<BR> =20
at=20
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScann=
er.java:553)<BR> =20
at=20
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doSc=
an(AbstractDeploymentScanner.java:212)<BR> &=
nbsp; =20
at=20
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop=
(AbstractDeploymentScanner.java:225)<BR> &nb=
sp; =20
at=20
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(=
AbstractDeploymentScanner.java:202)<BR> Caused=20
by: java.sql.SQLException: Wrong data type: INT4 in statement [CREATE =
TABLE=20
CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT, FIRST_NAME TEXT, =
HAS_GOOD_CREDIT=20
BOOLEAN NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY KEY=20
(ID))]<BR> at=20
org.hsqldb.Trace.getError(Trace.java:180)<BR> &nbs=
p; =20
at=20
org.hsqldb.Result.<init>(Result.java:175)<BR> &nbs=
p; =20
at=20
org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)<BR> &=
nbsp; =20
at=20
org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)<BR>  =
; =20
at=20
org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)<BR> &nb=
sp; =20
at=20
org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)<BR> &n=
bsp; =20
at=20
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalS=
tatement.java:231)<BR> =20
at=20
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartComm=
and.java:166)<BR> =20
... 52 more<BR> 09:27:04,888 INFO [EjbModule]=20
Started<BR> 09:27:04,888 INFO [MainDeployer] Deployed =
package:=20
file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar<BR> =
;09:27:04,891=20
ERROR [URLDeploymentScanner] MBeanException: Exception in MBean =
operation=20
'checkIncompleteDeployments()'<BR> Cause: Incomplete Deployment=20
listing:<BR> Packages waiting =
for a=20
deployer:<BR> =20
<none><BR> Incompletely =
deployed=20
packages:<BR> =20
<none><BR> MBeans =
waiting for=20
classes:<BR> =20
<none><BR> MBeans =
waiting for=20
other MBeans:<BR> [ObjectName: =
jboss.j2ee:service=3DEJB,jndiName=3DCustomerHomeRemote<BR> &nb=
sp; =20
state: FAILED<BR> I Depend=20
On:<BR> Depends On Me:=20
org.jboss.deployment.DeploymentException: Error while creating table; - =
nested=20
throwable: (java.sql.SQLException: Wrong data type: INT4 in statement =
[CREATE=20
TABLE CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT, FIRST_NAME=20
TEXT,<BR> HAS_GOOD_CREDIT =
BOOLEAN NOT=20
NULL, CONSTRAINT PK_CUSTOMER PRIMARY KEY (ID))])] =
</FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C2A646.3E299620--
--__--__--
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
End of JBoss-user Digest
-- -- Randy _________________________________________________________________ Randy Shoup (650)216-2038 Tumbleweed Communications Corporation [EMAIL PROTECTED] ------------------------------------------------------- This SF.NET email is sponsored by: Order your Holiday Geek Presents Now! Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated Soap, MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
